jonathan ngcode + culture

After you have used MySQL to dump your database, FTP that dump file to an accessible directory on your server.

Once you have uploaded the dump file to your account here, make your way back to command line and get ready to import the file!

Now to import the dump file into MySQL, use the following command at your shell prompt:

# USER is your MySQL username
# DBSERVER is your database servername, not always required
# dbname is your database name# dbname.sql is the dump file you are importing
# -p will prompt for your password

mysql -u USER -p -h DBSERVER dbname < dbname.sql  

If your preferences are properly set, the same thing can be accomplished with:

mysql < dbname.sql

Enjoy!

Tags: database, mysql

This entry was posted on Tuesday, March 4th, 2008 at 1:30 pm and is filed under technology. You can follow any comments to this entry through the RSS 2.0 feed. You can leave a comment, or trackback from your own site.