Results 1 to 7 of 7
Thread: whm transfer database problem
-
03-14-2008, 05:55 PM #1Web Hosting Guru
- Join Date
- Oct 2006
- Posts
- 337
whm transfer database problem
I am trying to transfer accounts between servers by using whm transfer (with root password) and all the accounts that had databases are missing tables.
So for some reason the transfer does not transfer databases fully, it does not matter with the size of them not all tables are getting transferred over.
Is there any solution for this?
-
03-14-2008, 06:59 PM #2Web Hosting Master
- Join Date
- Dec 2005
- Posts
- 3,110
By any chance are your two servers running different MySQL versions? e.g. Old Server MySQL 4x and New Server MySQL 5x?
It "should" be OK that way round, however if the versions are the oposite way round that could cause some problems since the structure is slightly different in MySQL 5 compared to v4.
-
03-14-2008, 07:19 PM #3Web Hosting Guru
- Join Date
- Oct 2006
- Posts
- 337
-
03-14-2008, 11:04 PM #4Web Host
- Join Date
- Jun 2002
- Posts
- 1,798
You have to repair/optimize the database on the old server and re-do it.
-
03-15-2008, 12:24 AM #5Temporarily Suspended
- Join Date
- Oct 2003
- Location
- Hanoi
- Posts
- 4,309
Any error if you try to export database first? Just for testing
-
03-15-2008, 02:56 PM #6Web Host
- Join Date
- Jun 2002
- Posts
- 1,798
The exporting is the error.
The database won't back up because there is a corrupt table in it. But it can never hurt to try backing it up through phpmyadmin first. BTW, there might be more on the server not being backed up. But cpanel was supposed to have fixed that a year ago by adding a line in the backup script to repair databases before backing them up.Last edited by page-zone; 03-15-2008 at 03:00 PM.
-
03-17-2008, 08:52 AM #7WHT Addict
- Join Date
- Mar 2008
- Location
- kolkata, India
- Posts
- 102