John Kim John Kim - 1 month ago 20
MySQL Question

MySQL dump inside mysql console

Is there SQL command where you can do MySQL dump inside the MySQL console?

I tried mysqldump but it does not work...

I'm trying to output into SQL file.

Answer

You cannot run mysqldump within a MySQL console since mysqldump is an external command like the mysql console.

Exit the console and use the mysqldump command as follows:

mysqldump -u username -p -h hostname (or ip address) databasename > sqlfilename

It will ask for password.

More details of mysqldump can be found at http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html