Home / server / Questions / 233535
Accepted
dynamic
Asked: 2011-02-10 12:59:32 +0800 CST

difference between mysql and mysqldump

  • 772

I am going to importi a database.. (db.sql)

I will use something like: 

mysql -u root -p db < db.sql

Can you tell me what the difference is between this and mysqldump?

Thanks

linux mysql

2 Answers

  1. Best Answer

    mysqldump is the export tool with which you would create the file to import, e.g.

    mysqldump -u root -p db > db-export.sql

    The resulting file will consist largely of SQL CREATE statements, followed by INSERT statements.

    mysql is the interactive MySQL client, which will also happily take a file full of SQL on stdin and carry out those queries -- in this case, importing the exported dump.

    • 5

  2. mysqldump is for export/backup databases:

    mysqldump -u root -p db > db.sql
    • 1