Menu
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.
974
To dump entire databases, do not name any tables following db_name , or use the --databases or --all-databases option. To see a list of the options your version of mysqldump supports, issue the command mysqldump --help .
The mysqldump tool is located in the root/bin directory of the MySQL installation directory.
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
98
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
