Download & Extend

Restored Dbase but Site not changed!

Project:Backup and Migrate
Version:7.x-2.4
Component:Miscellaneous
Category:bug report
Priority:major
Assigned:surfin_murf
Status:closed (works as designed)

Issue Summary

I'm using Backup and Migrage for the first time. I've backed up my live D7 site to Download as a .zip file .. no problems.
I've created a new local Dbase and a clean install of D7 on my localhost server ... no problems.
I ran 'Restore' in the new local site, selecting the downloaded 'zip file and it appears to have worked, i.e. the local Dbase is now fully populated with tables with the correct prefix and matching the tables of the live site and the content of the tables appears to be OK.

BUT ... my local site is exactly the same, ie. a basic clean Drupal 7 site, with Core Modules plus the manually installed Backup and Migrate module.

Why isn't my local clean site now picking up the Dbase structure & data?

Comments

#1

I have exactly the same issue.
Used compression and none, only FireFox and PHP.ini memory limits are ok. The DB gets restored fine, but the site is basic and no content shows up from the old site. i.e.: no theme settings, no content created, nothing!! Using Backup and Migrate version 7.x-2.4 & Drupal 7.17

#2

Category:support request» bug report
Priority:normal» major

This module used to work fine in D6, but doesn't seem to be ready for D7. I restored my site manually.

#3

I, too, have exactly the same issue.

However I created another test enviroment (exactly the same setup but on another pc) and the restore works perfectly every time.

I wonder if its something to do with different versions of mysql?

Vako: How do you go about restoring your site manually?

#4

I finally got to the bottom of my issue....

The restore from my hosted environment utilised the table prefix (dr_) so when I restored the file it created all the tables exactly as you would expect(!) all named with the prefix dr_ leaving my original tables (without the prefix) intact and thus showing the original content.

A quick change to the settings.php file to add this and, as if by magic, the content changed to the restored version!

#5

Good that you found this issue (or bug maybe?) hopefully the maintainer of this module will take it into consideration for the next release. I am surprised that it hasn't been a major issue until now, perhaps nobody restores or moves their D7 site yet? :)

#6

To restore the site manually:

on the old server:

  1. Copy the Sites folder and any other changes you have made
  2. Export the DB within myPHPAdmin

on the new server:

  1. Install D7 on the new domain
  2. Import the DB in myPHPAdmin
  3. Copy the files over

#7

I have exactly the same problem - I cannot use this module in D7 to migrate from localhost to a remote server. It needs to over-write existing tables retaining the same table name rather than generate new tables with a suffix to each name.

The documentation could do with a note to mention that it is still necessary to manually upload images and other files - all Backup & Migrate seems to do is backup database tables.

The name of this module is misleading - it is useful to help with migration but not the complete answer - give us a module with database backup, files saving & restore and a list of modules that need to be installed and we might have a migration module!

Thanks

#8

Status:active» closed (works as designed)

Backup and Migrate does not add the table prefixes, those are (likely) added by your host. If you want to run a local version of your site you'll need to make sure the db prefixes match in your settings.php.

Files/code backup is supported with the Backup and Migrate Files module and that functionality will be built into the upcoming 3.x branch.