A 4Mb database is not large.
Have you talked to your web hosting support ?
What you can do is cut your SQL file up into separate parts, At the moment it will be organised like:
Preamble
Save some settings
create table,
load table
create table,
load table
create table,
load table
create table,
load table
etc
Restore settings
Make multiple copies of the file
Go through the copies, slimming them down by deleting whole create tale, load table (insert) blocks. Keep the save/restore settings unchanged in all of them.
You can’t go wrong as long as SQL loads the stuff in the same order, but to start keep whole tables together, then load them in order.
Thread Starter
kevjon
(@kevjon)
I was actually referring to the xml export file rather than the sql. Just using the WP tools for export, and then the import, which refuses to accept xml files over 2MB.
That 2Mb limit is a PHP configuration thing, there are ways around this, some depend upon your hosting.
An easier solution is to evade the cause of the problem, rather than use XML files, use an SQL file instead. So get into your website hosting, run the database management application “phpmyadmin”, use it to EXPORT and then IMPORT an SQL file.
Hey there just reading the post, I would increase post_max and max upload size, this can be found in the php.ini file. If you are using multi site go to My sites/settings/network settings I believe/should be the last option in the settings.
Please let me know if this doesn’t work.
Thread Starter
kevjon
(@kevjon)
I seem to have opened a well known can of worms! Doing a web search turns up lots of info, much of it confusing, so I’ll drop this query now and look into it further.
Thanks for the various help!!
