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 Code:
<?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.
Nice idea! can you choose wich tables you would like to backup?
10-11-12
seanrom
Re: Auto MySQL database backup
Quote:
Originally Posted by Exonize
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
10-11-12
Raz0rDot
Re: Auto MySQL database backup
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
10-11-12
sidney023
Re: Auto MySQL database backup
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.
11-11-12
Joopie
Quote:
Originally Posted by 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.4Ontopic: Really nice.
Read the FAQ
11-11-12
seanrom
Re: Auto MySQL database backup
Quote:
Originally Posted by 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.
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 Code:
<?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
11-11-12
Eronisch
Re: Auto MySQL database backup
Thanks, i was looking for this ;)
11-11-12
Slynan
Re: Auto MySQL database backup
It stops at the "items" table.
11-11-12
JayNZ
Re: Auto MySQL database backup
Quote:
Originally Posted by Slynan
It stops at the "items" table.
Are you getting out of memory?
11-11-12
Kiggo99
Re: Auto MySQL database backup
Quote:
Originally Posted by Slynan
It stops at the "items" table.
Same here stopped at items table ;/
11-11-12
leenster
Re: Auto MySQL database backup
If this relies on php then the script will time out on bigger databases.
