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.

Problem backuping DBs

Discussion in 'General Discussion' started by tangowebs, Nov 29, 2007.

  1. tangowebs

    tangowebs Well-Known Member

    Joined:
    Oct 12, 2004
    Messages:
    93
    Likes Received:
    0
    Trophy Points:
    0
    I tried to transfer a hole account from 1 server to another but some DBs where incomplete.
    I made a individual backup for the DB but when I try to restore it from backup icon at cpanel continues creating it incomplete.

    Any idea how to restore a individual DB backup into my site?
     
  2. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    How large is your database? You may want to dump them manually and restore that way at the new location to be sure its complete. You may also have some wildly ridiculous sized fields that might toss an error on restore that you aren't seeing.
     
  3. tangowebs

    tangowebs Well-Known Member

    Joined:
    Oct 12, 2004
    Messages:
    93
    Likes Received:
    0
    Trophy Points:
    0
    The DB has some kbs... is a vbulletin site.... not big deal....
     
  4. BlueZebra

    BlueZebra Well-Known Member

    Joined:
    Apr 27, 2006
    Messages:
    48
    Likes Received:
    0
    Trophy Points:
    6
    try it manually from the shell and see if it is restorable
    To take dump
    #mysqldump db_name > db_name.sql
    To restore
    #mysql db_name < db_name.sql
    Also check if the versions of MySQL on both servers are the same
     
Loading...

Share This Page