How To Move Your MySQL Database to Web Hosting
If you use a website engine such as WordPress, phpBB or Drupal, the information on these sites is stored in a database, with the most popular database known as MySQL. If you plan to move to a different web host, you can move your database to a new one on the other host to make setup easier.
Instructions
Difficulty:
Step 1
Type "mysqldump -Qq -hDBSERVER -uUSERNAME -p DATABASE_NAME > backup.sql" into the terminal, where "DBSERVER" is your server's name, "USERNAME" is your username and "DATABASE_NAME" is the name of the database you want to move. Press "Enter."
Step 2
Connect to your web host using the FTP client, then upload the SQL database to the host.
Step 3
Type "mysql -hDBSERVER -uUSERNAME -p DATABASE_NAME < backup.sql" into the terminal window, where "DBSERVER" is the name of your web host server, "USERNAME" is the username for your web host's server and "DATABASE_NAME" is the name of the database you set up. Press "Enter."
References
Article Written By Jay Darrington
Jay Darrington has been a freelance writer since 2006, specializing in technology. He has published on several online blogs, including iTech24, iPhoneland and Tech101. He holds a Bachelor of Arts in communication technology from California State University.