Problems restoring from sql

  • Hi. I’m having a problem restoring part of a database, and I wonder if you could help:

    The sad tale: We had free hosting from a friend. The friend left her job, and then, eventually the host went under. We lost our blog. We restored from a six month old backup (all we had).

    When we managed to get in touch with the server’s new owner, he very kindly exported the mysql database to a sql file and let us have it. Awesome.

    But when I go in through phpmyadmin to upload the old database (I figured I’d export the new entries, replace the database with the one we’d lost, then use wordpresses import functionality to get the recent entries back in) I get the following error. Any ideas?

    Error

    SQL query:

    /*!40000 ALTER TABLE wp_comments DISABLE KEYS */;

    MySQL said: Documentation
    #2006 – MySQL server has gone away

    Help!?

    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)

  • If your old database file is quite large, the server may be timing out.
    If that is the case try this https://www.ozerov.de/bigdump.php

    By the way, if you load the database, you don’t need to do a WP import – all the import does is load the database, which you will already have done.

    If your database is from an earlier version of WP and you are running the latest now, WP will do a database upgrade when you finally get the database loaded in mySQL.

    Hi,

    It seems that there is an issue with the server services when you try to restore large database. You can provide your database backup to the hosting service provider to restore it.

    Thanks,

    Shane G.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Problems restoring from sql’ is closed to new replies.