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.

Trying to restore large mySQL database

Discussion in 'General Discussion' started by thehostrack, Aug 1, 2007.

  1. thehostrack

    thehostrack Member

    Joined:
    Aug 11, 2003
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    Hello,

    We are trying to restore a very large database from a backup drive on one of our servers (the database is around 3GB). We run the command:

    mysql databasename < /path/to/backup/database.sql

    but after the database gets around 1500MB loaded in we get a software error "Software caused connection abort." What is causing this? Is their a limit set somewhere?

    Also now phpMyAdmin is giving us this error when we try and access it:

    Warning: session_write_close() [function.session-write-close]: write failed: No space left on device (28) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 44

    Warning: session_write_close() [function.session-write-close]: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 44

    Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php:44) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 101

    Any help PLEASE!

    THANKS!
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,447
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    This should work:

    mysql -u username_username -p username_databasename < /path/to/backup/database.sql
     
  3. thehostrack

    thehostrack Member

    Joined:
    Aug 11, 2003
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    That still doesn't stop the software error...
     
  4. encryption

    encryption Well-Known Member

    Joined:
    Jun 24, 2005
    Messages:
    72
    Likes Received:
    0
    Trophy Points:
    6
    your TMP dir is full. empty it. See the last response in this thread - http://forums.cpanel.net/showthread.php?t=69255

     
    #4 encryption, Aug 1, 2007
    Last edited: Aug 1, 2007
  5. thehostrack

    thehostrack Member

    Joined:
    Aug 11, 2003
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    I finally got the command to run but once the database loads around 1700MB in the entire server goes CRAZY. Is this because the tmp directory is filling up? If I reboot the server everything returns to normal,but my database has not bee restored.

    Please advise anyone!

    THANKS!!
     
Loading...

Share This Page