By stemaco on

I had trouble migrating a site from a sub-folder to the root and had to start the drupal install from scratch. I now can not restore it as my .mysql backup from the Backup and Migrate Module is 8MB and the module says the limit is 2 MB.

Is there any way around this?

Any help is much appreciated. Thank You.

(Upload a backup file created by this version of this module. For other database backups please use another tool for import. Max file size: 2 MB)

⋅ Categories: Drupal 6.x

Comments

vm’s picture

vm commented

incrase max file size in php.ini or investigate bigdump

Daniel J Wilcox - Blocked for personal attacks’s picture

Daniel J Wilcox - Blocked for personal attacks commented

Its much faster and more robust to use the command line

export a mysql database

mysqldump -u username -p password databasename > databasename.mysql

import a mysql database

mysql -u username -p password databasename < databasename.mysql

The problem with browser based solutions is you need to set the max file upload in php
Also you will get a time out in the browser with large files

Road Runner’s picture

Road Runner commented

If you're really hard up export the tables using backup & migrate but do it piecemeal. You can select the tables you want with each manual backup you perform. Will take a number of trials because when you don't know the size of tables you'll try to do too much at once.

1websitedesigner’s picture

1websitedesigner commented

If you select Compression: GZip when backing up the file, then Backup and Migrate can still cope with uploading it back again, this will in all likelihood reduce the file size to below the 2MB limit.

Hope this helps!

Martin

http://www.indigoextra.com/

ronan’s picture

ronan commented

If you have access to the MySQL command line client you can use that to import the backup. Backup and Migrate backups are just mysql command dumps, so you can import them with any MySQL tool (command line, phpMyAdmin etc.)

You can also upload the file to your files directory in backup_migrate/manual using FTP or ssh and it should be available under Manual Directory under destinations.

Or you can increase the upload_max_filesize and post_max_size in PHP on your server to something greater than 8mb, but you may want to ask your webhost about that.

------------------------------------
Ronan
Founder - NodeSquirrel - https://www.nodesquirrel.com/
Agency Tools Lead - Pantheon - https://www.pantheon.io/

mauryg’s picture

mauryg commented

I am working on a local site (WAMP) and the php.ini file parameters are set to 128M, but the Backup and Migrate Restore screen still says 'Max filesize is 2MB' and the restore doesn't work with a file created by Backup and Migrate from my remote server to my desktop. BTW phpmyadmin also shows an import limit of 2MB and I can avoid that by using a defined upload directory. But phpmyadmin won't recognize the Backup and Migrate file, even if I change the file extension from .mysql to .sql.

PROBLEM FIXED: I edited php.ini for memory_size and max_post_size, but I missed the upload_file_size. Now the limit is 128M and the restore operation appears to have worked perfectly. Thank you for a very useful module.