MySQL Database

ID #364

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.


Last update: 2010-10-03 13:14
Author: FAQ Admin
Revision: 1.2

Digg it! Share on Facebook Print this record Send FAQ to a friend Show this as PDF file
Please rate this FAQ:

Average rating: 2.25 (8 Votes)

completely useless 1 2 3 4 5 most valuable

You can comment this FAQ