Support » Fixing WordPress » Backing up a large database

  • Hi,

    Im sure this problem has been addressed before but cant seem to find the answer.

    I have just transferred my blog http://ryanshamus.com from one server to another. The database is 2.8 meg and the max upload for the db is 2.0 meg.

    Can anyone please advise me on how I can upload my database so I can restore the posts.

    Many Thanks

Viewing 7 replies - 1 through 7 (of 7 total)
  • Do you have access to your original database?
    Just import the database into the new one (not importing through wordpress) and then alter your wp-config.php if need be.

    I use MySQL Administrator to handle my backups. I connect to the db externally of course (some host does not allow this… contact them to be sure) From there I run a backup… and then restart the administrator and connect to the NEW database server…. and then run a restore and viola! 🙂

    Gotta admit that I’d upload the db to your webspace and get your host to import it. They should have access to do it from the command line. Importing large databases in via a web interface is always a cause for trouble.

    Theapparatus is right. That’s the best option, just make sure you upload it above the “public_html” directory (so it’s not accessible through http).

    Another option is to export/import the tables one by one, creating smaller files. If a table is still too big, you can split it in chunks – check carefully the export page in phpMyAdmin to understand all options.

    Thread Starter ryanshamus

    (@ryanshamus)

    Hi Guys,

    Thanks for all your responses. Can you take a look at http://ryanshamus.com as there is an error coming up on the site now.

    Also http://ryanshamus.com/wp-admin is giving errors.

    Im not sure what to do.

    We have imported the database but there is something wrong with either the template or the database.

    Is there anyone who I could pay a small fee to sort this out for me please?

    Many Thanks

    You’re missing a plugin. Whatever wp_cr_emailed was used for.

    I know what is your main problem and how to solve it. CR is stands for Comment Relish. And if you have use this plugin, just deactivate it. Then, see the result.

    Or for another hard way, just deactivate all of your plugin, and try to activate one by one to see which plugin is the cause of the plugin.

    Good Luck.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Backing up a large database’ is closed to new replies.