Step by step move drupal from localhost to drupal hosting : From Localhost to Online

Sorry for late post, I have to attend a meeting for three days. Held by my office. Yesterday I get rest and today I’m ready to write. I hope you don’t mind 🙂

Before we continue I just want remind you steps that we have done as follows :

  1. Setting Domain : cover step by step guide pointing domain to hosting company.
  2. Setting Add On Domain : how to set add on domain in cpanel.

Lets continue the rest.

Upload Drupal

Get ftp client like coreftp, filezilla and upload your drupal files to your hosting account.

Step by step move drupal from localhost to drupal hosting : upload files

Wait for while, get tea, coffee or soft drink until process finish.

First Access

Open browser and type address :

http://batikweb.com

Site off-line

The site is currently not available due to technical problems. Please try again later. Thank you for your understanding.


If you are the maintainer of this site, please check your database settings in the settings.php file and ensure that your hosting provider’s database server is running. For more help, see the handbook, or contact your hosting provider.

The mysql error was: Access denied for user ‘root’@’localhost’ (using password: YES).

This is normal view as I upload old configuration file.

Open settings.php file (located in C:\wamp\www\drupal\sites\default)  and edit appropriate entry.

$db_url = ‘mysql://xxxxx_drupal:YqpN1}+!&)m@@localhost/xxxxx_drupal’;
$db_prefix = ”;
$base_url = ‘http://batikweb.com’;  // NO trailing slash!

Reupload the file.

Export Database File

Open phpmyadmin (localhost) and click on the name database you want to export.

In this case I click drupal.

Step by step move drupal from localhost to drupal hosting : backup drupal database

New page open,click on Export link.  (make sure current database is set to drupal)

Step by step move drupal from localhost to drupal hosting : export drupal db

Scroll down, let the setting as default. Check on “Save as file” section and click Go.

Step by step move drupal from localhost to drupal hosting : save as file db backup of drupal

Save the file and click OK.

make sure the name is ended with sql

Import Drupal Database File

Login to cpanel at drupal hosting and click phpmyadmin under Databases section.

import drupal db cpanel

Click Import link and choose file.

import drupal db cpanel : select file

Click Browse, locate the file and click GO.

When import process executed successfully You’ll see this message.

Import has been successfully finished, 76 queries executed.

Drupal website ready to serve.

In case you want to move to vps then you might want to consider this provider.