Importing A WordPress Database In Pieces??

yes, just save and import each table

so where you have you currently have your database, go into phpmyadmin, and go into each table (one at a time) and click custom, then select whichever compression you are happy with, and also select “add drop table” statement.

Do this for each table until the whole database has been taken out.

That way posts and postmeta are taken separately, so chances are it’ll go in.

If you don’t have a database in your target, create one, and then simply import each table back in.

So extract the current database that I have, the use the import tool in myphpadmin for each table, one at a time?.

Yes, you can do all the extracts at one time, but you extract each table rather than the whole database, they just save to your pc.

Then do all the imports in one go

Just out of curiosity, are you getting the error in phpmyadmin that goes something like “database size too large” etc? And then it gives you a max upload size? If so, that is something that you can change if you have access to your apache/php settings.

If not, you can ask your host to do it for you. Some may refuse, but the ones that do will import the database for you.

Also, 500 MB database is really quite large. Is this normal for your site? Look through your tables and try to find which one is taking up the bulk of that. I just had an issue where my WP_Options table had tons of _transient_ entries and a bunch more from NexGen Gallery that were basically trash, old data that didnt expire / delete properly and kept building up. I removed literally 900,000 records (650 MB worth of data) and my database went from being 670 MB to 20 MB.

Alright so I only have the .sql file on my computer, it used to be on a server but is no longer, it was just backed up and deleted from the original server.

Is there a program in windows that will allow me to extract the tables?. And when it is all extracted, do I just upload the tables if I am alowed to select multiple files from the Import tool?.

I think that the size is so big because of image uploads or something?, I seriously have no idea. If you have a tutorial on removing those records please show me!! (if that is what’s causing it). Of course the database size is 50mb’s when not raw but zipped.

Ok, so can you just tell us what the error you’re getting when you try to upload it is?

If you can give us the exact message.

Well, I thought I would try and create a new blog, install Adminer, then try and upload it that way. The error message I got from that plugin gave me this:
Too big POST data. Reduce the data or increase the “post_max_size” configuration directive.

I will try using myphpadmin tommorow though, but I am sure it’s going to say something similar. The file is 58.4 mb’s, and I have it in .bz2 format which Godaddy’s myphpadmin works good with. Will keep you guys up to date, let me know what you guys think on the error message above if possible and thanks in advance!.