How do I create a MYSQL dumpfile?
Applies to: Grid System
NOTE: These instructions are for our system, where the database server is not localhost, as it is for many other webhosts.
To create a MYSQL dumpfile, get a shell prompt with telnet or ssh, login, and then type this all on 1 single line:
mysqldump -h DBSERVER -u DBUSER -p DBNAME > DBNAME.sql
substituting DBSERVER with the database server name, DBUSER with your MySQL username, and DBNAME with your database name.
You will then be prompted for your database password.
If you don't specify the database server name, then an empty .sql dump file is created.
14174/0%Last update: 2010-10-03 13:14
Author: FAQ Admin
You can comment this FAQ