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.

mysql backup problem,

Discussion in 'General Discussion' started by mohit, Jan 17, 2007.

  1. mohit

    mohit Well-Known Member

    Joined:
    Jul 12, 2005
    Messages:
    553
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Sticky On Internet
    hi,
    one of our client moved hissite to his own dedicated server.
    everything is smoother since he moved but his Databases are not backing up properly.
    DB is 50MB+ in non compressed form

    everytime they download a db backup from cpanel or generate from mysqldump the backup is not complete.

    Only two or three insert queries are coming corresponding to each table and rest all data is ignored in backup file.

    If they backup from phpmyadmin, then whole table gets backed up properly.
    Same DB works fine on old machine which has MySQL version 4.0.27-standard

    DB is live and being updated frequently and then but we don't have a way to get the backup working.

    Dual Xeon with 4GB RAM
    WHM 10.8.0 cPanel 10.9.0-C117
    RedHat Enterprise 4 i686
    MySQL version 4.1.21-standard

    any experts advice ?

    thanx,
    mohit
     
  2. Nhojohl

    Nhojohl Well-Known Member

    Joined:
    Nov 28, 2006
    Messages:
    101
    Likes Received:
    0
    Trophy Points:
    16
    There might be a limit on how much you can download at a time... Try something like this...

    To repair every table on your server.
    Code:
    mysqlcheck -Aao --auto-repair -u root --password=[B]ROOTPASS[/B]

    Backup the DB to his public_html (You can use root as the user if you don't have his.)
    Code:
    /usr/bin/mysqldump --host="localhost" --user="[B]DBUSER[/B]" --password="[B]DBPASS[/B]" --opt "[B]DBNAME[/B]" 2>&1 >"/home/[B]USERLOC[/B]/public_html/backup.sql"
     
  3. mohit

    mohit Well-Known Member

    Joined:
    Jul 12, 2005
    Messages:
    553
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Sticky On Internet
    hi,
    thanks for suggestion but this all have already been tried, doing table repairs some time causes problem by corrupting our tables.

    mysqldump create a 42MB file but it doesn't have all records for most tables.


    See ya,
    mohit
     
Loading...

Share This Page