How to transfer my Drupal from one host to another?
Transferring your Drupal application includes copying your files and database and modifying the settings.php file in the sites/default folder after the transfer is completed.
Download your website files via FTP and export your database using a tool such as phpMyAdmin.
The most important setting which should be modified in settings.php is:
db_url – the MySQL details for your Drupal; the format you should follow is mysql://username:password@localhost/databasename, e.g. :
$db_url = ‘mysql://user_drpl1:password@localhost/user_drpl1’;
Make sure that the RewriteBase rule in the .htaccess file is correct. For example, if your Drupal is placed in your account’s main public_html folder, the RewriteBase rule should be:
RewriteBase /