Can't Restore Large 3.7 Database

  • by
  • on 01.07.09
  • creampiesca.com
  • edit
  • For some reason, my large database (288MB) cannot be restored via SSH. I had no problems backing up and restoring via SSH in the past. Don't know if this has to do with the upgrade I've done with vB, or my server itself timing out. The SSH commands go something like:

    mysqldump -e -quick --add-drop-table --add-locks --lock-tables -hlocalhost -uUser -pPW domain_db gzip - > backup.sql.gz

    And then:

    zcat backup.sql.gz mysql -hlocalhost -uUSER -pPW domain_db

    Within phpAdmin I noticed the database freezing at table #106. When the freeze occurs, my entire dedicated server is slowed down, and it's a Dual Core Opteron 2212 w/ 2 GB RAM server with only a few sites hosted on it. I'm using MySQL 5.x

    Any help?


  • Thanks for the suggestion, vTec.

    Went back to my old server and checked the database for errors and repair, and I got this message:

    forum_db.threadread repair warning Number of rows changed from 16752 to 16750

    I'm going to backup then restore once again and see if that works.


  • My database is about the same size and I've done it many times in the past. Although I don't use Gzip, but usually do a straight restore from an uncompressed file. Below is the restore command I use

    mysql -u user -p dbname < {path}/backup.sql







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about Can't Restore Large 3.7 Database , Please add it free.