John Kim John Kim - 1 year ago 149
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 Source

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

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download