Problem moving an account

[aquagerbil]

I have an account on one server I am trying to move to another. It has about 340 DB's. When I move it, many come over blank, but they are not blank on the source server. I have tried the GUI and the /scripts/ option.

Any idea how I can move this customer's 340ish database's correctly?

 

[lijeeshsd]

If you have shell access to both the servers, then a simple shell script can do this job.

 

[aquagerbil]

I do have root shell access to both servers. I did the /scripts/package /scripts/restore options. I also did a mysql rsync of the 340 DB's. The trouble comes in if I do a mysqldump of the mysql and then import into the new server, it gets a lot of crap entries as the source mysql has grants for many many accounts.

Any more specific about the script you would use?

 

[nicklas]

compare on both servers if the /etc/my.cnf is different, maybe you force the import of the Db's in utf and on old server they might other format.

 

[Miraenda]

Is one machine using a different MySQL version that the other? If the old server is MySQL 4.1 and the new is 5.0 or 5.1, then you will have issues with moving the databases. You could upgrade MySQL on the source machine before doing the move first if that's the case or downgrade MySQL on the destination machine. Depending on whether this is the case (the MySQL version) and whether you have other accounts on both machines already that might be impacted, the better option would be to upgrade the old machine to the same MySQL as the new machine over downgrading MySQL on the new machine.

 

[cPanelDon]

I have an account on one server I am trying to move to another. It has about 340 DB's. When I move it, many come over blank, but they are not blank on the source server. I have tried the GUI and the /scripts/ option.

Any idea how I can move this customer's 340ish database's correctly?

I do have root shell access to both servers. I did the /scripts/package /scripts/restore options. I also did a mysql rsync of the 340 DB's. The trouble comes in if I do a mysqldump of the mysql and then import into the new server, it gets a lot of crap entries as the source mysql has grants for many many accounts.

Any more specific about the script you would use?

If you've not already tried this, I recommend examining one or more full account backups to see if they are packaged successfully without loss of data from MySQL. Using the script "/scripts/pkgacct" generate a fresh backup of a cPanel account that contain MySQL databases, then manually extract the backup that was generated (e.g., "tar -xzvf $archive"). After extracting the archive contents, locate the directory named "mysql" and manually inspect the MySQL database dumps; using the SQL dumps, import each into a new database, checking to see how they compare with the original database.

Do not use "rsync" in attempt to synchronize the MySQL data directory between two servers.