Migrate Drupal’s Website Database to Production Server(Web Server)

Article i found that was posted on : http://groups.drupal.org/user/66522

It helped me i was wondering it could help others so here it goes!

Mysql data migration to production Server via FTP
Mysql data migration to production Server via FTP

After numerous trial and error, I think I’ve gotten this process down fairly well migrating a local WAMP site to a live server.

  1. In WAMP, go to phpmyadmin find your database -> click on privileges -> then add an additional username and password with “granted all privileges” on localhost server for that database
  2. On your live webserver create a MySQL database with the same name as your localhost database
    -add the same new username and password as in step 1
    -associate the new username and “grant all privileges” for the new database
  3. Check consistency of clean URLs (I’ve done this a few times the WRONG way)
    -if your WAMP ocalhost site has clean URLs enabled – make sure to DISABLE CLEAN URLS, just for now
  4. Go back to WAMP localhost site phpmyadmin -> select the database you’re migrating -> click the export tab -> highlight “sql file” and click go
  5. FTP transfer the latest version of Drupal Core -> FTP transfer your WAMP /sites folder into the fresh install /sites folder on the webserver, overwriting everything inside the /sites on the webserver.
  6. On the live webserver, go into phpmyadmin -> select the database your created in step 2 -> click the import tab -> browse to find the exported WAMP sql file in your computer -> click go

That should be it! Since the WAMP and webserver databases have the same name, same username and password with all privileges, there is no need to alter the settings.php file.

Advertisements

One thought on “Migrate Drupal’s Website Database to Production Server(Web Server)

  1. My brother suggested I would possibly like this blog.
    He was entirely right. This post truly made my day.
    You can not believe simply how a lot time I had spent for this information!
    Thank you!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s