HostPapa Knowledge Base

To move your Drupal site to your new HostPapa account, simply complete the following steps:

Export your MySQL data from your old web host

1. Log into your previous host’s phpMyAdmin.
2. Select your WordPress data, then select “Export”
3. Select all tables and export them.

You will now have a SQL query that you can run on your new database.

For more information on exporting databases, please watch our helpful tutorial here:
http://www.hostpapasupport.com/tutorials/demos/phpmyadmin-voice/phpma-export.html

Import your MySQL data to your HostPapa account

1. Log in to your HostPapa dashboard: https://www.hostpapa.com/dashboard/
2. Click on My cPanel. If you have more than one domain associated with your HostPapa account, click on the appropriate domain link, then enter your cPanel password if required.
3. Click on MySQL databases
4. Create a database.
5. Create a username
6. Add the username to the database.
7. Log into your new database’s phpMyAdmin and Import the new database.

For more information on the above steps, please watch our helpful tutorials here:

Creating a MySQL database in cPanel:
http://www.hostpapasupport.com/tutorials/demos/cpanel-x3-voice/cpanel-x3-createmysql.html

Importing databases and tables with phpMyAdmin:
http://www.hostpapasupport.com/tutorials/demos/phpmyadmin-voice/phpma-import.html

You have now successfully moved your data!

Now for the files:

Download and Upload

1. Use an FTP client to download ALL files from your old hosting company’s server to a location on your local desktop.
2. Again using FTP, Then upload your Drupal installation files and folders to the public_html folder on your HostPapa account.
3. If needed, edit the file in [drupal home]/sites/default/settings.php and edit at the section which asks for the database, location, username and password. You CAN enter the password either encrypted or not encrypted.
4. Using your FTP client, chmod your “files” folder so that it is writeable (chmod to 777)
5. Double check your .htaccess and [drupal home] /sites/default/settings.php and make changes in case they are needed.

Here’s some video tutorial help:

Using FTP: http://www.hostpapasupport.com/tutorials/Tutorials_FTP.shtml
Drupal: http://www.hostpapasupport.com/tutorials/Tutorials_Drupal.shtml