error uploading backup database to new server

  • following the very easy instructions in the codex, i have managed to backup my wordpress database, however the file seems to be too big! I was hoping that someone could please help me figure out what to do about it. It won’t upload. I am sad without my wordpress working.

    This is the error I get:
    Error

    There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

    ERROR: Unknown Punctuation String @ 5
    STR: />
    SQL:
    <b>Fatal error</b>: Allowed memory size of 8388608 bytes exhausted (tried to allocate 268 bytes) in <b>/home/spyweb1/confixx/html/user/phpMyAdmin/libraries/export/sql.php</b> on line <b>513</b>

    SQL query:

    <b>Fatal error</b>: Allowed memory size of 8388608 bytes exhausted (tried to allocate 268 bytes) in <b>…</b> on line <b>513</b>

    MySQL said: Documentation
    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘
    <b>Fatal error</b>: Allowed memory size of 8388608 bytes exhausted (trie’ at line 1

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

  • Are you backing up manually or with the wordpress backup plugin? That will help us determine part of the problem.

    If you aren’t using the plugin, I recommend you do so. It makes life so much easier.

    https://www.skippy.net/blog/category/wordpress/plugins/wp-db-backup/

    Thread Starter dylan

    (@dylan)

    Its too late to use the plugin now, I’m sorry to say. I’m working with a text file, a .sql file, and its all that remains of my databse.

    This is what I thought I would do:

    open the file in a text editor
    delete the tables that dont really need to be uploaded again
    (i forgot to exclude them from the backup)

    could anyone point me towards a regular expression (and a text editor) that will allow me to do this:

    “find any line that contains a certain string and delete that line”

    It would save me hours. Thanks.

    Moderator James Huff

    (@macmanx)

    Dylan, it looks like you’re running into your host’s upload maximum. If you contact your hosting provider, they would be happy to restore the database for you.

    If you want to manually restore the database, use a text editor from the following list and copy/paste the DB contents into phpmyadmin’s “SQL” tab.

    https://codex.www.ads-software.com/Glossary#Text_editor

    Thread Starter dylan

    (@dylan)

    I ended up using a text editor to do the upload in parts. Thanks for your help.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘error uploading backup database to new server’ is closed to new replies.