Best Way To Move Sql From One Server To Another?

[dchakrab]

As some of you may know, server 19's been having some annoying problems, and Joe said he'd be happy to move users over to another server. He also said specifically to not use the DirectAdmin backup utility, since this might replicate the problem on the new server, but to manually do the changeover instead.

Unfortunately, I can't get my SQL database moved. I tried doing a dump (exporting everything) and then running that code in the SQL field on my new server, but i got this error in the middle:

SQL query:

CREATE TABLE `civicrm_acl_group` (
`id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`domain_id` int( 10 ) unsigned NOT NULL default '0',
`is_active` tinyint( 4 ) default '1',
`title` varchar( 64 ) default NULL ,
PRIMARY KEY ( `id` ) ,
KEY `FKEY_domain_id` ( `domain_id` ) ,
CONSTRAINT `0_282` FOREIGN KEY ( `domain_id` ) REFERENCES `civicrm_domain` ( `id` )
) TYPE = InnoDB

MySQL said: Documentation
#1005 - Can't create table './daveayanch_Nirman/civicrm_acl_group.frm' (errno: 150)

This is strange, since it created the other tables fine.

My sites are Drupal / CivicSpace, so moving my databases is a priority. Ideas? Suggestions?

I posted a helpdesk ticket but was advised by Ryan to use DirectAdmin's backup utility. I pointed out that Joe specifically said not to do this in the forums, and haven't heard back from them on this yet. I'm wondering if I should try it anyway?

Otherwise, how else can I move that database?

Thanks for any help / suggestions,

Dave.

[c]

Break up the script to serate out the erant part. Then go back with just that part and try and fix it. there may be more pieces like this. I am suspicious of the INNOdb table type and the foreign key though . It may that you don't have permissions for this table type ( not likiely though.)