By Akrotiri on

Hi,

I'm practicing backing-up and restoring my site in case problems arise in future but, unfortunately, am having difficulty. I'm backing up from a live production server and restoring to a test server running XAMPP.

1) I've tried my hosts myphpadmin to export the database but can't import the three files back into myphpadmin on the test server. Two of the files are very very small and simply don't appear. The third large file fails with this message:

Error
SQL Query
table structure for table 'drupal access'
Drop table if exists 'drupal access'
My SQL said:
#1046 - no database selected

2) I've tried the backup and migrate module and the backup and restore seem to go smoothly but I see no changes whatsoever on my newly installed drupal test site. Where are my menus? Where is the theme? Where is all my content?

3) I've used ftp to copy all the core files from the production server to the test server but still I see no changes on the my newly installed drupal test site (other than my modules have clearly copied across and can be selected). But where's the content and why isn't the site looking like it should?

I've trawled the internet, followed countless guides on this site and others, but can't seem to restore my site on a test server as it looks on the production server. does anyone know where I'm going wrong?

⋅ Categories: Drupal 6.x

Comments

Akrotiri’s picture

Akrotiri commented

Hi,

I have more information and seem to be going in the right direction but need help sorting this out.

The database tables in my fresh Drupal 6 installation on my test server (the server I'm trying to restore to) have normal names such as "access", "acl", "acl_node" etc.

The database tables on my production server (set up by my host) have the same names but prefixed with "drupal_". So they are "drupal_access", "drupal_acl", "drupal_acl_node" etc. This is the database I'm trying to restore on the test server.

So, it seems to me that the installation on my test server might be looking for the non-prefixed table names, but I want it to look for the "drupal_" prefixed table names.

How do I point Drupal at the prefixed tabled names?

Or, how do I easily change the table names in mySQL to remove the prefix? And should I have to?

Thanks.