MySQL Forums
Forum List  »  Newbie

Re: Advise to a noob
Posted by: Phillip Ward
Date: August 21, 2014 05:04AM

Quote

#mysql -u root -p db_name > db_name.sql instead of

#mysqldump -u root -p db_name > db_name.sql
Ignoring for a second that the leading '#' would make these into comments and so, strictly speaking, wouldn't do anything at all ... :-)

mysqldump would write a recoverable form of the database into the file, db_name.sql.
mysql, the command-line interface to the MySQL DBMS, would let you run any SQL commands you like and write the output of those commands to the file, db_name.sql.

In both cases, the original content of the file would be destroyed.
(Hint: Now might be a good time to take another mysqldump backup!).

Regards, Phill W.

Options: ReplyQuote


Subject
Written By
Posted
August 20, 2014 10:53PM
August 21, 2014 01:15AM
August 21, 2014 01:48AM
Re: Advise to a noob
August 21, 2014 05:04AM
August 21, 2014 05:33AM
August 22, 2014 05:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.