By bzsim on

Hopefully someone can explain this to me in "dummy" language :)

I am trying to go from development to production. I have a Drupal installation through GoDaddy at dev.mysubdomain.com, and now I want the content I created there (nodes, etc) to copy over to my Drupal installation on the live site. I went to PHPmyadmin for my development site and exported the two tables (information schema and my database). I then went to my Live site PHPmyadmin and went to import and selected the SQL file that was produced. It took a long time and I finally got an error saying "Access denied" and something about the information_schema. So I tried the export again and this time did not select the information schema table, only my database. Again when I imported I got an error about access denied. I'm sure I'm doing something wrong. The passwords to both databases are the same, but the names are different. Is that the problem? Do I need to do something in settings.php? I'm a front-end person so this back-end stuff is Greek to me :)

⋅ Categories: Drupal 7.x

Comments

nevets’s picture

nevets commented

Have you looked at the migrate module?

bzsim’s picture

bzsim commented

That sounded like it was for migrating into Drupal from another system like Wordpress. I am going from Drupal 7 on dev to Drupal 7 on live.

I feel like I am just missing something simple in the settings.php file. Something is conflicting with passwords. I read in a post that the database names and passwords should match, but GoDaddy automatically names my databases so that won't work.

nevets’s picture

nevets commented

Can you edit settings.php to have to correct database name, user name and password?

Patroclas’s picture

Patroclas commented

The Backup & Migrate module is what was meant.

First get your live site working with a plain Drupal install
Install and enable B&M on your dev site and the live site.
Take a backup on the dev site using B&M
Check that all modules are present on the live site, and any files (such as images) are in corresponding folders on each site
Run B&M on the live site and import the file you got from your dev site backup. It should not matter if the database names are different.

castroarguello’s picture

castroarguello commented

You should not import the 'information_schema' database.
That database contains system information and you will not be allowed to modify it in the shared hosting server.

http://dev.mysql.com/doc/refman/5.0/en/information-schema.html