Bricktop

Bricktop supports this item

Supported

This author's response time can be up to 2 business days.

177 comments found.

Hi Bricktop ,

Hope you are doing good :)

I have 1 question. I backup 2 database . The 1st 1 database is around 12MB and it is work as expected. The 2nd 1 has 80MB++. After backup,it will create 3 backup files:-

1. 2015-07-08-03-00-21_xxx-backup.zip.eXXGbM – 6MB 2. 2015-07-08-03-00-21_xxx-backup.zip – 13MB 3. 2015-07-08-03-00-21_xxx-backup.sql – 80MB

I checked the zip file , it is correct and can be extracted without any issue. It seems it cannot remove the other 2 files ? But the other smaller database has no issue. Any idea ? Thanks

If it works and you’re also using the CRON script, remember to add the same line to CRON script too.

Thanks for prompt reply, Bricktop. I can assure there is nothing wrong with your script.

It works now after I set the following. Thanks and have a nice day :)

ini_set(‘memory_limit’, ‘256M’); ini_set(‘max_execution_time’, 120);

Ah that’s great news, thanks for letting me know!

UPDATE PLEASE!

I appreciate all your work and support, but when was the last update? 2013? 2012? :(

Please provide updates for basic functionality improvements.

The script works as intended so I don’t see any need. If you would like to suggest improvements then I will take a look and implement them if I feel they’d be beneficial.

wzav

wzav Purchased

Hi,

is it supporting UTF-8 tables when importing? I think it has convert my chars to ”?” question marks. if it doesn’t, how do I set it up?

Thanks for the purchase. You need to add the following code to lines 270 and 801 of MySQL-backup.php.

mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET utf8");
mysql_query("SET SESSION collation_connection = 'utf8_unicode_ci'");
Or you can speak to your web host about changing the default charset to utf8, they will be able to guide you through this.

Hello,

I am having trouble using the software.
I must set up the cronjob to be backed up a MySQL database and exported to another.


MySQL “A” Download
MySQL “B” Upload> backup base


This should occur one time per day.

Hi, thanks for the purchase and message. The CRON job is for backup only, it cannot be set to automatically restore as well. I do have an UNSUPPORTED restore script for use with CRON but please note I do not offer any support for it. Contact me via my profile if you would like me to send you the file.

pre sale question: does work correctly for 500mb+ database?

Hi, yes assuming you set your PHP timeout limits appropriately there are no limts on the script itself.

Hello. Great script. Does this use MySQLi?

Hi, this was orginally written for standard MySQL but you should be able to easily edit it to work with MySQLi. Thanks.

Pre sale question: #1 how secure the login script? #2 I dont want to access phpmyadmin to delete a database after backup it. Is it possible? #3 How the restore work? Do I need established the same table structure?

Hi there.

1. As far as I know it’s secure!

2. The backup part of the script does not DROP databases, it’s simply a backup script, so you would need to delete databases manually after backup if that’s what you want to do, only the restore part of the script performs a DROP.

3. The restore function restores the structure as well as the data.

Hi there

I have edited the settings as instructed in the readme file and uploaded everything.

The quick backup and manual backup are working fine.

However, the CRON is throwing an error as follows:

Task "httpdocs/easy-mysql/cron-mysql-backup.php" completed with error in 3 seconds, output: <br /> <b>Parse error</b>: syntax error, unexpected ':', expecting '(' in <b>D:\Plesk\VHOSTS\############.com\httpdocs\easy-mysql\cron-mysql-backup.php</b> on line <b>377</b><br />

The code at line 377 is as follows:

if($zip->open($destination,$overwrite ? ZIPARCHIVE::OVERWRITE : ZIPARCHIVE::CREATE) !== true) {

Hi Bricktop

Thanks for your reply.

OK, let me do some research on this too, and I will get back to you.

Cheers ;)

HI again,

I have resolved the issue by using a third party provider called setcronjob.com.

The script executes just fine and the database is backup.

So this is a plesk issue.

I will contact plesk support and see what advice they can offer.

Great, thanks for letting me know.

please can i backup a local mysql db and restore or sychronise it with db online. or any suggestions to achieve this.

Hi it depends on who manages the online provider, for example if you could VPN to the online DB server you could do everything from one script but easiest way I guess would be to purchase another copy of this script and have one for local use and one for online use?

If I purchase two copies it will work for me. Please confirm

I’m sorry but without knowing your exact setup/configuration/requirements I wouldn’t be able to confirm that 2 copies will work for you. Why not buy one copy and try it first, if it works for you then buy a second copy.

Hi great script. Is there a limit to how large the database can be? I have backed up 3 individually and they work great but when I back up the larger one 350 megs it says tables completed but that is all. http://screencast.com/t/HVuBPhmM These are not the only tables on the db and also nothing appears in backup folder on server.

That’s strange, is there a PHP error log saved in the directory the script runs? That should help, maybe the permissions are set incorrectly and the script is unable to create the folder/backup file?

Hi there is no log saved. Is there away to activate that? It can’t be the permissions because some databases work. It’s the larger one that doesn’t.

Do you have the disk space available to save a database of that size? Have you tried incresing the PHP memory and timeout limits? Without an error on-screen, or in a log file, it’s very hard to say what is wrong, if PHP has an error it usually outputs that error either to screen or logfile, maybe your webhost will be able to assist in where the error log is?

b2wl

b2wl Purchased

Hello

I’m using the tool to backup a dozen MySQL-DBs and I have a couple of questions/feature requests:

  • At the moment, if a mail address is filled in, you get a mail for every backup taken, which is far too many mails (certainly for some important DBs that are backed up every hour). Is there no way to only send a mail in case of an error?
  • Similar, it would be good to be able to define an automatic purge per DB. Some DBs of less important sites might not need to be kept as long as others or in the other case, a large DB that is backed up every hour would mean a lot of required space if we keep it for longer periods (while these backups might only be required for shorter period as their content changes frequently). My suggestion: Put this purge-time per db in an additional array with the quick-backup specs.
  • At the moment, backup-files are plain downloadable for everyone that knows their name (OK, due to the filename-complexity this is less of a risk but still). It would be safer to limit their readability to the server itself using an .htaccess and have the system download the file through php (so the request comes from the server itself). This also allows to store backups in a folder that is not reachable from the outside.

Could you please consider these items and possibly implement them in an update?

Thanks in advance

Kind regards

B

Thank you for your purchase and constructive comments. I will look to include these requests into a future update.

b2wl

b2wl Purchased

Thanks for that, any view when a new update can be expected (as the last one dates 4 years ago)?

Hi there, I purchased your script some time ago and it is excellent.

Is it possible to automate the backup of separate tables in a database and then to be able to restore any one of them if required?

Thanks for your reply. That’s great news!

Could you give me some idea when the next update is scheduled for this script please?

Hi, I don’t know at this time, it’s kind of as and when I get the time really, sorry.

Actually, just had a quick look at this and looks to be very easy to achieve automated specific table backups by adding a line to the settings file. Please contact me via my profile and I’ll explain further.

Hi there again,

I messaged you earlier today regarding a new feature that could backup/restore separate tables.

This is an urgent feature that I would like to use so I wondered if I could commission you to make this amendment to the software/script sooner than having to wait for an update?

Sorry I don’t have the time at the moment but will try and get an update done soon.

Actually, just had a quick look at this and looks to be very easy to achieve automated specific table backups by adding a line to the settings file. Please contact me via my profile and I’ll explain further.

Hi there – presales question: Is it possible to pre-fill in the mysql information if i want to just be able to press “restore” for a given db? (I realise this leaves the db accessible for anyone w. the tool). Thank you :)

Hi, with some modifications to the script it would be possible but not as the script stands in stock form. I will look into this when I get some spare time and let you know.

Not working in my windows wamp server. Mozilla browser get crashed while backup process. List backup gets below error. “Warning: opendir(backups/1/,backups/1/) [function.opendir]: The system cannot find the file specified. (code: 2) in C:\appserv\www\easy-mysql-backup-restore\mysql-backup.php on line 411”

Looks like a path error in the settings file. Not sure if it’s a typo but you have a , in your backup folder path.

nothing changed in $settings[‘backupfolder’] = ‘backups’; line. While backup big database browser alway crashing. For small databases getting this error “Deprecated: Function ereg_replace() is deprecated in C:\appserv\www\easy-mysql-backup-restore\mysql-backup.php on line 325”

Hi, I have a problem with a database 112 mb to backup. I am not working on a shared hosting.

I setup my server setting with .user.ini to: max_input_vars = 3000 max_execution_time = 360 memory_limit = 256M upload_max_filesize = 120M post_max_size = 128M max_input_time = 3600

My phpinfo.php shows the following values: max_execution_time 360 max_file_uploads 20 max_input_nesting_level 64 64 max_input_time 3600 max_input_vars 3000 memory_limit 256M

PHP Version 5.6.27

I read all your comments and modified my settings and you said more than one time, that the tool should work, it is not limited.

But I ever get this error: Fatal error: Out of memory (allocated 94896128) (tried to allocate 89973596 bytes) in /xxxxxxxl/cron-mysql-backup.php on line 150

What can I do. I modified max_execution_time to 3600, memory_limit to 512M.

Best Regards Reiner

Hi there, this is definitely a memory limit error relating to your PHP installation. Have you tried adding the memory_limit setting to the script itself, and not your php.ini file?

Yes I did. I have a 8 GB Linux Server and setup the server memory down to 16 tasks (after restart server I have 512 MB memory limit) and the script is running with the same error. And I have other php scripts, backup server script a.s.o and these are working with our memory_limit settings.

islander

islander Purchased

I am looking for a database backup solution, but I have a few doubts regarding this program.

First, there is no Index file in the main folder, so anyone can go to http://www.firegrid.co.uk/scripts/mysql-backup/ and see everything.

Next, they can fully browse the databases directory, doesn’t seem to secure?

Hi, it’s up to you to secure the directory as necessary. You can use .htaccess, a blank .html file or many other methods to secure to meet your needs.

islander

islander Purchased

I am receiving an error in manual backups:
Warning: Missing argument 8 for backup(), called in /home/user/public_html/backup/mysql-backup.php on line 223 and defined in /home/user/public_html/backup/mysql-backup.php on line 265

Any help resolving?

by
by
by
by
by
by