Auto MySQL database backup

[seanrom]

Hello guys,
I want to release something that I just made.
Haven't used much time on it but what it does is basiclly; Makes a .sql file of your database every (user defined) minutes, default is 360 minutes (6 hours).

Its coded in PHP and is a console application so it works with Linux, Windows and Mac (all OS that supports PHP)

If I get enough supporters I will make a version, that I will put more development time in. I was thinking about FTP upload support, multipile databases, Remote Sockets etc.

F.A.Q

Spoiler:

What does this do?
AutoBackup remotly downloads your MySQL database and stores it into a .sql file every (user defined) minutes.

The application wont start?
Make sure to have set the right php.exe (default is C:\xampp\php\php.exe)

What OS's does this work on?
Every OS that supports PHP.

Is there a limit on how big my database can be?
No, there is not a limit.

Can you choose wich tables you would like to backup?
No, you can choose what tables you would like to ignore (not include) in the backup.
You can set it in AutoBackup.php variable $mysql_ignore. Seperate them by comma (,)
Example: chatlogs,table1,table2 and so on.
I recommed to just remove completely useless tables like chatlogs cus it takes a lot of space and is not really needed!

How do i find my PHP folder?
1. Create a page called phpinfo.php or test.php or whatever you want to call it
2. Put this code in:

<?php
phpinfo();
?>

3. Click Ctrl + F in your browser and search for Loaded Configuration File
4. Copy that (Example: C:\xampp\php\php.ini)
5. Replace php.ini with php.exp
6. Thats your correct folder, open up AutoBackup.bat and replace the default with yours.

Images:




Download here

Please rep++ and like!! :)

[MentaL]

[PatrickDE93]

Great that is cool.
Thank you Oleaa.

[Exonize]

Nice idea! can you choose wich tables you would like to backup?

[seanrom]

Nice idea! can you choose wich tables you would like to backup?

No, you can choose what tables you would like to ignore (not include) in the backup.
You can set it in AutoBackup.php variable $mysql_ignore. Seperate them by comma (,)
Example: chatlogs,table1,table2 and so on.
I recommed to just remove completely useless tables like chatlogs cus it takes a lot of space and is not really needed!

Updated F.A.Q

[Raz0rDot]

Seems awesome. Now I know what to use for my sites to back up the databases! Hoping you'll create an FTP version though, as it'd make my site backups alot easier.

Great job mate! :D

[sidney023]

When i open it it says: The system could not find the path specified, press any key to continue.
When i press a key the progam closes. Help me plz!
I use IIS7 with PHP version 5.4
Ontopic: Really nice.

[Joopie]

When i open it it says: The system could not find the path specified, press any key to continue.When i press a key the progam closes. Help me plz!I use IIS7 with PHP version 5.4Ontopic: Really nice.

Read the FAQ

[seanrom]

When i open it it says: The system could not find the path specified, press any key to continue.
When i press a key the progam closes. Help me plz!
I use IIS7 with PHP version 5.4
Ontopic: Really nice.

I reefer to the F.A.Q

The application wont start?
Make sure to have set the right php.exe (default is C:\xampp\php\php.exe)

So whereever your php path is for IIS thats where your php.exe is located.
I have no experience with IIS I only use Linux for web servers.

So open AutoBackup.bat and replace C:\xampp\php\php.exe with where your php.exe is loacted!

A small tutorial how to find your php directory.
1. Create a page called phpinfo.php or test.php or whatever you want to call it
2. Put this code in:

<?php
phpinfo();
?>

3. Click Ctrl + F in your browser and search for Loaded Configuration File
4. Copy that (Example: C:\xampp\php\php.ini)
5. Replace php.ini with php.exe
Thats it

[Eronisch]

Thanks, i was looking for this ;)

[Slynan]

It stops at the "items" table.

[JayNZ]

It stops at the "items" table.

Are you getting out of memory?

[Kiggo99]

It stops at the "items" table.

Same here stopped at items table ;/

[leenster]

If this relies on php then the script will time out on bigger databases.

PHP: set_time_limit - Manual

[hedapepa]

you could not make the climb database directly to a ftp server

sorry my english i from venezuela

[Ddos Attack]

Awesome release! Thanks!

[Makarov]

Cron job for CM$.

[seanrom]

Cron job for CM$.

That would make the load time to long when its acctuly going to backup, if your database is 200MB it will take ages to load up the website for that 1 poor user.

Also I forgot the set_time_limit, Its updated now.

[Matthew]

There's already programs to do this. But using a terrible language like PHP to do anything large like this will never scale properly with huge databases. And if it does work with large databases, It's gonna be hella slow. Nice try, though.

[seanrom]

There's already programs to do this. But using a terrible language like PHP to do anything large like this will never scale properly with huge databases. And if it does work with large databases, It's gonna be hella slow. Nice try, though.

It works, its better than nothing, plus this is opensource so everyone can see that its has no exploits or some random shit that deletes your database.

So if PHP is so terrible I would like to see you release something better and faster in another language.

[FullmetalPride]

I have been searching for this for hours.

You can't imagine my excitement and cheers when I saw you post this.

There's already programs to do this. But using a terrible language like PHP to do anything large like this will never scale properly with huge databases. And if it does work with large databases, It's gonna be hella slow. Nice try, though.

Please release your method then, since you're so high and mighty this morning.


jks Matthew is the only guy I like to hear criticism from.

[Armo]

Really nice, thanks.

[FullmetalPride]

Fix.zip

Fix for IIS users, who use a different path.

NOTE: You MAY need to edit "AutoBackup.bat". Open it in Notepad, CTL+F, type "cd v5.3" and edit it to your correct PHP version. We use PHP V5.3, but if you're using 5.4, you'll need to change it to "cd v5.4".

[Matthew]

It works, its better than nothing, plus this is opensource so everyone can see that its has no exploits or some random shit that deletes your database.

So if PHP is so terrible I would like to see you release something better and faster in another language.

PHP: a fractal of bad design - fuzzy notepad

^ Why PHP is bad.

As for releasing, why do I need too? Oracle them selves have released official tools to do this job on both Windows and *nix. I'm not bashing your work, I'm just saying put to practical use, this is a bad idea. It won't scale with large databases, PHP is slow and terrible. If you release your work, you might win over the 13 year olds who have no idea about programming and how things scale, that's fine. But there's going to be critics and skeptics. Me being one of them.

[seanrom]

PHP: a fractal of bad design - fuzzy notepad

^ Why PHP is bad.

As for releasing, why do I need too? Oracle them selves have released official tools to do this job on both Windows and *nix. I'm not bashing your work, I'm just saying put to practical use, this is a bad idea. It won't scale with large databases, PHP is slow and terrible.

W/E

I gotta agree that PHP dosent make sence sometimes, things that are not supose to work acctuly works.
PHP works great for me and I hope it always will :)

[Joopie]

PHP: a fractal of bad design - fuzzy notepad

^ Why PHP is bad.

As for releasing, why do I need too? Oracle them selves have released official tools to do this job on both Windows and *nix. I'm not bashing your work, I'm just saying put to practical use, this is a bad idea. It won't scale with large databases, PHP is slow and terrible. If you release your work, you might win over the 13 year olds who have no idea about programming and how things scale, that's fine. But there's going to be critics and skeptics. Me being one of them.

Well, that article has some points I agree with.
However it's flexible and easy to understand and (in my opinion) a good way to introduce in other languages.

But you have to understand that PHP is designed for "WEB DEVELOPMENT" and not to write programmes with it, like database backups or servers.


And, take a look at this wiki page...
HipHop for PHP - Wikipedia, the free encyclopedia ...