Case: I backed up my Moodle site from Bluehost (the SQL database, moodledata, and moodle code) and wanted to set up my site in a new hosting account with Godaddy. Uploading the data and code is easily done in the File Manager. However, to upload the database, you do the following
First, create a database with a database name, username, and passwords on the Godaddy hosting plan. Then, go to phpMyAdmin and click on the L. hand side to select that database. Then click Import at the top of the window, find the file on the computer and upload. The key is that unlike the data and code that are uploaded directly, the database must be created and then the contents imported into the new database.
In Godaddy, use the application MySQL Database Wizard to create the database.
It’s best to keep the database name, username, and password of your new database (on Godaddy) the same as the old database credentials so that you don’t have to update the config.php file to change them in there.
