Copy database to another server
vippy - December 5, 2008 - 05:20
Hello,
I recently changed hosting company and i am trying to copy the database to the new server. Problem is that, the software i use to do this, gives the error "table blocks without primary key" and stops copying the database. Do you know a way to overcome this?
Thanks in advance
"the software i use to do
"the software i use to do this"
how about more details?
The software is navicat 8.
The software is navicat 8.
A possible easy way
(1) Download your database from your old site to your local computer.
(2) Install a new Drupal installation onto the new webserver using the same Drupal version you had previsiously on the old webserver.
(3) Using your website's control panel, replace the new installation's database with your database from your old site. This means that you would first need to rename your old database file on your local computer to the exact same name of the database file of the new installation before you upload (replace) the the new installation's database.
Sam
I did that. Problem is i
I did that. Problem is i cannot use phpadmin either, the restore backup also stops because of the fact that several drupal tables do not have a primary key. E.g. tables blocks, filters, flood do not have a primary key.
Backup and Migrate
Sounds like the original backup of the drupal database was incorrect or incomplete.
This is an excellent module which may help. Download and install it on the old host and the new host. It will allow you to backup the entire Drupal database, and then restore it to the new host.
http://drupalmodules.com/module/backup-and-migrate
I installed the module and
I installed the module and it seems to work perfectly!!! Thanks a million!!!