The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

cpanel transfer corrupts mysql

Discussion in 'General Discussion' started by Secret Agent, Jun 8, 2005.

  1. Secret Agent

    Secret Agent Guest

    I transferred many accounts from one server to another. Both with 4.0x MySQL.

    The databases get corrupt and no tables found

    What's up with this nonsense?

    I used WHM's transfer feature

    This happened a few times before and its very destructive to the end user who does not have a backup
     
  2. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    So, you should log a ticket with cPanel or through your license provider and have cPanel investigate. They cannot fix things if you don't tell them about it and give them access to find out what has gone wrong. Or have you already done that?
     
  3. Secret Agent

    Secret Agent Guest

    Ok, can anyone duplicate this at least?
     
  4. Secret Agent

    Secret Agent Guest

    This is a serious matter. This has happened to well over two or so dozen clients now
    ALL on 4.1 (both old / new server) and it either corrupts the database or just does not even transfer.

    Stopping mysql during the transfer doesn't help as it fails all in all and both servers having 4.11 standard, messed up a nice portition of the databases.

    I know for sure others can duplicate this, the question is how to work around this other than ssh?

    Thanks for your input in advance
     
  5. casey

    casey Well-Known Member

    Joined:
    Jan 17, 2003
    Messages:
    2,303
    Likes Received:
    0
    Trophy Points:
    36
    Location:
    If there is trouble, it will find me
    Drop

    Code:
    [mysqldump]
    default-character-set=binary
    into /etc/my.cnf and see if that fixes it.
     
Loading...

Share This Page