Results 1 to 7 of 7
  1. #1

    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?

  2. #2
    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.

  3. #3
    Quote Originally Posted by Chris E View Post
    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.
    Nope. Both servers are running mysql 4.

  4. #4
    You have to repair/optimize the database on the old server and re-do it.

  5. #5
    Join Date
    Oct 2003
    Location
    Hanoi
    Posts
    4,309
    Any error if you try to export database first? Just for testing

  6. #6
    Quote Originally Posted by gate2vn View Post
    Any error if you try to export database first? Just for testing
    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.

  7. #7
    Join Date
    Mar 2008
    Location
    kolkata, India
    Posts
    102
    Take a separate database backup before transfer and then try to transfer accounts only after removing those database which had an error.
    Sysfirm
    So you think your server is secure?
    Try our security Service
    With SysFirm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •