+ Reply to Thread
Results 1 to 3 of 3

Thread: MySQL - Server has gone away

  1. #1
    Junior Member
    Join Date
    Mar 2009
    Posts
    1

    Default MySQL - Server has gone away

    I am getting a 'Server has gone away error' when trying to restore a large
    database or table through PHPAdmin or other similar programs (17meg file). This is usually due to the max_allowed_packet being set too low. Apparantly it's set to 16m on the Steadfast server, which should be good enough, but still have problems.

    Anyone know how I can do this from the Steadfast shell account. This is just an sql dump.

    Thanks

  2. #2
    Member
    Join Date
    Jan 2008
    Posts
    36

    Default

    Can you split the file into two parts and upload each separately?

  3. #3
    Moderator
    Join Date
    Mar 2007
    Location
    Southern California
    Posts
    150

    Default

    mysql -h servername -u dbusername -p databasename < backupname.sql
    All the best,
    ManagerJosh
    Gaming Hosting Director of
    SimGames.net, Owned and Operated by Steadfast Networks

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts