I don't know if I'm phrasing my question correctly.

What I do know is I'm so effing sick of having to use the phpmyadmin interface to export multiple SQL files because phpmyadmin on my host only allows 2Mbyte uploads.

For some screwed up reason my host (GoDaddy. . . go figure) does not support compressed file uploads. . .

So I have to export 4 separate files from my local development environment and upload each separately to the live site, it's driving me nuts and there isn't even any content in the site yet.

Backup and Migrate works great but the backup files created will be useless for the purposes of restoring anything since they're over the 2MB threshhold.

So I'm wondering if there's any plans to implement a feature that'll allow me to set the file size max to 2MB and have the module handle exporting the tables until that limit is reach and then increment the file number and make another. . .

Make sense?

Comments

picardo’s picture

picardo commented

You can increase the upload_max_filesize, memory_limit and post_max_size in the php.ini configuration file. All of these three settings limit the maximum size of data that can be submitted and handled by PHP. post_max_size and memory_limit need to be larger than upload_max_filesize.

There are several workarounds if your upload is too big or your hosting provider is unwilling to change the settings:

* Look at the $cfg['UploadDir'] feature. This allows one to upload a file to the server via scp, ftp, or your favorite file transfer method. PhpMyAdmin is then able to import the files from the temporary directory.
* Using a utility (such as BigDump) to split the files before uploading.
* If you have shell (command line) access, use MySQL to import the files directly. You can do this by issuing the "source" command from within MySQL: source filename.sql.

ronan’s picture

ronan commented
Status: Active » Closed (won't fix)

Closing this in to clean up old tickets. Please reopen if it's still applicable.