Chris Simmons

Brian,
Wish you would have contacted me in the support forum. There is an option in WPBackItUp to generate a single script that can be used in place of all the SQL files. Just need to turn it on and then can import the entire database with one file. We separate them out for each table because some databases are just too large to put in a single SQL file but we have an option to also generate the single file. Its easy to find because we use the .db extension vs .sql.

Sorry you had such a bad experience but next time reach out to these support forums and ask for help. Most of us plugin authors watch them and are happy to help.

Take Care
Chris

MisterR,
We use a unique backup prefix because there are a number of updates performed on the imported database just prior to bringing it online. Examples are customers migrating their site to a new domain or changing the table prefix. All of these type updates are performed on the tables with the unique prefix and then when all updates have been completed successfully, we rename the tables. If any of these steps cannot be performed then WPBackItUp will leave the original database as is. We know this causes some challenges for customers that want to perform manual restores but we decided that we would err on the side of safety.

Sorry it caused you difficulties, next time reach out to support. We are always available for questions and happy to help.

chris

Yes WPBackItUp Lite(free) will backup all the tables in your database. They will be contained in the main zip file. When the backup is complete just download that file to your PC and take a look. They will all be there.

Chris

Thijs,
I understand you don’t like the price of the premium plugin but 1 star/crap seems a little unfair? If the backup did not work then please share your experience but if your issue is only with pricing for the premium plugin then would appreciate it if you would consider updating your review.

Thanks Thijs
Chris

This is one of our most requested features so we are actively working on it now. I have the cloud storage engine slated for the 1.12.7 release which should be available this(3rd) quarter. With this release I will include either S3 or dropbox. Which would you like to see first S3 or dropbox? I actually have S3 pretty close but suspect dropbox will be more desired. Once this feature is added we will be able to add cloud storage providers fairly easily.

We are putting the finishing touched on 1.12.6 now and should release it in the next week or two. In 1.12.6 we will remove the table prefix restriction so you will be able to restore your site to any table prefix, not just the one your original site was using. This is also one of our most requested features so we wanted to get it out this summer.

Thanks!
Chris

master412160,
The current release does not yet have this feature. Please open a support ticket and someone from my support team will send you a link to a pre-release version of WPBackItUp that does this.

http://www.wpbackitup.com/support/

I would post it here but we like to make sure everyone installing a pre-release version is having a good experience.

Thanks
Chris

There is already an option for a single zip file. Take a look in settings. This option is fairly memory intensive so it may not work for you. Really just depends on your host and site size. If the setting is on the backup will attempt to stick all the zip files in a single zip. If it cant then the backup wont fail but WPBackItUp will just turn off the setting so it doesn’t keep trying on ever backup.

You can also change the Batch Size option for databases to a much larger number like 100000. This would tell WPBackItUp to export 100,000 rows to each SQL file so at least then you would only have 1 SQL file for every table. Not ideal but hopefully better. Give that a try and let me know if it helps. If the backup fails on Db export then your database is just too large and an export would likely fail even on a export using a MySQL tool.

Lastly, the single SQL file is possible for a small site and sounds like a good idea. As I said before, we separated it into multiple files because large sites would just timeout on the DB export. But adding the single SQL file as an option like single zip file backup is a good idea. May not work if your site is too big but you could at least try.

Lemme see what I can do. Will post something here after I review.

Chris