• I’m trying to restore a backup database that has somehow become corrupted. However, my hosting company has a 2 meg limit and it times me out when I try to upload my 12 to 32 meg sql file. Is there another way of doing this?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    Cut the file up into pieces, upload each one separately.

    Alternatively, if you’re using phpMyAdmin to upload it, it should be capable of accepting ZIP or GZipped files…

    Thread Starter autobengal

    (@autobengal)

    I just tried Winrar but I’m getting this error:
    There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
    —-BEGIN CUT—-

    When you “cut it up” you need to be sure you’re “cutting” in the right places – it’s not arbitrary. Usually, between sections of the SQL file, there’s a row of stars or hashmarks (I can’t remember which, it’s been a while since I’ve looked to do this) – you’ll want to do it by section like that. Otherwise, you’re going to leave them open-ended and have errors like this.

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

The topic ‘Restoring database’ is closed to new replies.