bahattab
27-01-2009, 09:58 AM
Backup MySQL databases with a scheduler by
MySQL Dump Timer
Publisher's Description:
MySQL Dump Timer - The MySQL Dump Timer is intended to backup MySQL databases and tables periodically (MySQL Dump).
It also allows the transfer of a MySQL database (http://mysql-dump-timer.dirk-richter-softwaredevelopment.qarchive.org/#) and MySQL tables between different MySQL servers (= MySQL Backup AND MySQL Restore).
* Firewalls will not block the access to the MySQL database: A small PHP script which has to be copied to the webserver encapsulates (and encrypts) the access to the MySQL database.
* For every MySQL server different profiles can be defined.
* After every MySQL backup /MySQL dump it is possible to restore or transfer the MySQL tables to another MySQL server.
* (For examle: MySql databases from local computers can be transfered to remote servers in the internet
(http://mysql-dump-timer.dirk-richter-softwaredevelopment.qarchive.org/#) and vice versa.)
* A scheduler can be customized to determine the MySQL databases and tables to be backup /dump -ed (and transferred / restore -d).
* Even if runtime limitations (timeouts) for scripts set by the providers you have no problems to backup MySQL databases or restore
* MySQl databases because the data will be transferred compressed in parts of 100 KB - 5 MB packet size.
* The data can be transferred compressed (gzip) and encryped (blowfish or SSL) between client and server.
If you backup MySQL databases (MySQL dump) the dumpfiles are stored compressed (gz-file).
Backup MySQL and Restore MySQL databases with DumpTimer
http://www.atyafonline.com/vb/imgcache/1413.pngYou looking for a solution
http://www.atyafonline.com/vb/imgcache/1414.png How to backup a MySQL database?
http://www.atyafonline.com/vb/imgcache/1415.png (http://www.richtsoft.com/mod.php?theme=richtsoft&theme=richtsoft&mod=webpage&op=view&wid=18)
MySQL Backup with DumpTimer (http://www.richtsoft.com/mod.php?theme=richtsoft&theme=richtsoft&mod=webpage&op=view&wid=18)
http://www.atyafonline.com/vb/imgcache/1414.png how to restore a MySQL database?
http://www.atyafonline.com/vb/imgcache/1414.png how to copy a MySQL databases from a local network to a remote server in the Web?
http://www.atyafonline.com/vb/imgcache/1413.pngWe present the solution!
The DumpTimer is intended to backup MySQL databases and tables periodically. It also allows the transfer of a MySQL database and MySQL tables between different MySQL servers (Restore MySQL).
Backup MySQL database on local servers? » YES «
Restore MySQL databases on local servers? » YES «
Backup MySQL databases on remote servers? » YES «
Restore MySQL databases on remote servers? » YES «
Copy MySQL tables from a local database to a remote database and vice versa? » YES « Task Scheduler? » YES «
Encrypted transfer? » YES «
blowfish Compressed transfer? » YES «
gzip SSL support? » YES «
Proxy support? » YES «
Database limitations (database size, location)? » NO limitations «
Problems if database behind firewalls? » NO problems «
Can be started as a Windows service? » YES «,the PRO version
Windows 95/98/ME or Windows NT 4.0/2000/XP compatible? » YES «
http://www.atyafonline.com/vb/imgcache/1413.pngDetails!
http://www.atyafonline.com/vb/imgcache/1414.png Firewalls will not block the access to the MySQL database because a small PHP script which has to be copied to the webserver encapsulates (and encrypts) the access to the MySQL database.
http://www.atyafonline.com/vb/imgcache/1414.png Even if runtime limitations (timeouts) for scripts set by the providers you have no problems to backup MySQL databases or restore MySQl databases because the data will be transferred compressed in parts of 100 KB - 5 MB packet size.
http://www.atyafonline.com/vb/imgcache/1414.png For every MySQL server different profiles can be defined.
http://www.atyafonline.com/vb/imgcache/1414.png A scheduler can be customized to determine the MySQL databases and tables to be backup /dump -ed (and transferred / restore -d).
http://www.atyafonline.com/vb/imgcache/1414.png After every MySQL backup /MySQL dump it is possible to restore or transfer the MySQL tables directly to another MySQL server.
For example, you can transfer MySql databases from local computers to remote servers in the internet.
http://www.atyafonline.com/vb/imgcache/1414.png The data can be transferred compressed (gzip) and encryped (blowfish or SSL) between client and server. If you backup MySQL databases (MySQL dump) the dumpfiles are stored compressed (gz-file).
http://www.atyafonline.com/vb/imgcache/1414.png To access MySQL databases on local servers it is also possible to use the MySQL API library “libmysql.dll”.
http://www.atyafonline.com/vb/imgcache/1413.pngRequirements
http://www.atyafonline.com/vb/imgcache/1414.pngClient: Windows 95/98/ME or Windows NT 4.0/2000/XP
http://www.atyafonline.com/vb/imgcache/1414.pngWebserver: PHP 3/4 (with mCrypt und zLib-library - only if you want to encrypt and compress data)
http://www.atyafonline.com/vb/imgcache/1414.pngDatabase drivers (DAO,ODBC,etc) are not required.
Mainwindow
Next to the main-window there are 3 dialogs, where you can configure your access to the database and the options for the scheduler:
Main window (http://www.richtsoft.com/mod.php?theme=richtsoft&theme=richtsoft&mod=webpage&op=view&wid=18#main)
Definition of MySQl-profiles (http://www.richtsoft.com/mod.php?theme=richtsoft&theme=richtsoft&mod=webpage&op=view&wid=18#mysql)
Setup of the backup-scheduler (http://www.richtsoft.com/mod.php?theme=richtsoft&theme=richtsoft&mod=webpage&op=view&wid=18#backup)
Restore dialog to restore sql- or backup files. (http://www.richtsoft.com/mod.php?theme=richtsoft&theme=richtsoft&mod=webpage&op=view&wid=18#restore)
Main Window
http://www.atyafonline.com/vb/imgcache/1415.png
With the DumpTimer you can execute instant backups of databases/tables or can setup a schedule of backup (and restore) times. Definition of MySQL - Profiles You can setup the access to different MySql-Servers or different databases
http://www.atyafonline.com/vb/imgcache/1416.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/mysql1.gif%27%29)
http://www.atyafonline.com/vb/imgcache/1417.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/mysql2.gif%27%29)
You can access the database via the MySql - API - Library *libmysql.dll* or via a special PHP-Script If you use the PHP-Script, you have to copy it on your webserver.
http://www.atyafonline.com/vb/imgcache/1418.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/mysql3.gif%27%29)
http://www.atyafonline.com/vb/imgcache/1419.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/mysql5.gif%27%29)
The script will test the configuration of your webserver Insert your MySql user data and then save your configuration. Setup of the backup-scheduler In this dialog the databases, tables, the time and the location can be configured.
http://www.atyafonline.com/vb/imgcache/1420.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/backup1.gif%27%29)
http://www.atyafonline.com/vb/imgcache/1421.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/backup2.gif%27%29)
Select the MySql-Profile with the databases you want to back up Select the tables, which you want to backup.
http://www.atyafonline.com/vb/imgcache/1422.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/backup3.gif%27%29)
http://www.atyafonline.com/vb/imgcache/1423.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/backup4.gif%27%29)
There are different options to configure the DUMP-backup-file Setup of the backup-scheduler
http://www.atyafonline.com/vb/imgcache/1424.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/backup5.gif%27%29)
http://www.atyafonline.com/vb/imgcache/1425.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/backup6.gif%27%29)
You can set how many copies of backups should be kept before they were deleted. If you want to transere a table after the backup into an other database sou can configure it here. Restore dialog to restore sql- or backup files Ether you can restore tables from backups you have made with the DumpTimer oder from SQL-Dump-Files.
http://www.atyafonline.com/vb/imgcache/1426.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/restore1.gif%27%29)
http://www.atyafonline.com/vb/imgcache/1427.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/restore2.gif%27%29)
Select the type of restore If you restore tables from a SQL-file, select the file. The content of the file will be listed.
http://www.richtsoft.com/
MySQL Dump Timer
Publisher's Description:
MySQL Dump Timer - The MySQL Dump Timer is intended to backup MySQL databases and tables periodically (MySQL Dump).
It also allows the transfer of a MySQL database (http://mysql-dump-timer.dirk-richter-softwaredevelopment.qarchive.org/#) and MySQL tables between different MySQL servers (= MySQL Backup AND MySQL Restore).
* Firewalls will not block the access to the MySQL database: A small PHP script which has to be copied to the webserver encapsulates (and encrypts) the access to the MySQL database.
* For every MySQL server different profiles can be defined.
* After every MySQL backup /MySQL dump it is possible to restore or transfer the MySQL tables to another MySQL server.
* (For examle: MySql databases from local computers can be transfered to remote servers in the internet
(http://mysql-dump-timer.dirk-richter-softwaredevelopment.qarchive.org/#) and vice versa.)
* A scheduler can be customized to determine the MySQL databases and tables to be backup /dump -ed (and transferred / restore -d).
* Even if runtime limitations (timeouts) for scripts set by the providers you have no problems to backup MySQL databases or restore
* MySQl databases because the data will be transferred compressed in parts of 100 KB - 5 MB packet size.
* The data can be transferred compressed (gzip) and encryped (blowfish or SSL) between client and server.
If you backup MySQL databases (MySQL dump) the dumpfiles are stored compressed (gz-file).
Backup MySQL and Restore MySQL databases with DumpTimer
http://www.atyafonline.com/vb/imgcache/1413.pngYou looking for a solution
http://www.atyafonline.com/vb/imgcache/1414.png How to backup a MySQL database?
http://www.atyafonline.com/vb/imgcache/1415.png (http://www.richtsoft.com/mod.php?theme=richtsoft&theme=richtsoft&mod=webpage&op=view&wid=18)
MySQL Backup with DumpTimer (http://www.richtsoft.com/mod.php?theme=richtsoft&theme=richtsoft&mod=webpage&op=view&wid=18)
http://www.atyafonline.com/vb/imgcache/1414.png how to restore a MySQL database?
http://www.atyafonline.com/vb/imgcache/1414.png how to copy a MySQL databases from a local network to a remote server in the Web?
http://www.atyafonline.com/vb/imgcache/1413.pngWe present the solution!
The DumpTimer is intended to backup MySQL databases and tables periodically. It also allows the transfer of a MySQL database and MySQL tables between different MySQL servers (Restore MySQL).
Backup MySQL database on local servers? » YES «
Restore MySQL databases on local servers? » YES «
Backup MySQL databases on remote servers? » YES «
Restore MySQL databases on remote servers? » YES «
Copy MySQL tables from a local database to a remote database and vice versa? » YES « Task Scheduler? » YES «
Encrypted transfer? » YES «
blowfish Compressed transfer? » YES «
gzip SSL support? » YES «
Proxy support? » YES «
Database limitations (database size, location)? » NO limitations «
Problems if database behind firewalls? » NO problems «
Can be started as a Windows service? » YES «,the PRO version
Windows 95/98/ME or Windows NT 4.0/2000/XP compatible? » YES «
http://www.atyafonline.com/vb/imgcache/1413.pngDetails!
http://www.atyafonline.com/vb/imgcache/1414.png Firewalls will not block the access to the MySQL database because a small PHP script which has to be copied to the webserver encapsulates (and encrypts) the access to the MySQL database.
http://www.atyafonline.com/vb/imgcache/1414.png Even if runtime limitations (timeouts) for scripts set by the providers you have no problems to backup MySQL databases or restore MySQl databases because the data will be transferred compressed in parts of 100 KB - 5 MB packet size.
http://www.atyafonline.com/vb/imgcache/1414.png For every MySQL server different profiles can be defined.
http://www.atyafonline.com/vb/imgcache/1414.png A scheduler can be customized to determine the MySQL databases and tables to be backup /dump -ed (and transferred / restore -d).
http://www.atyafonline.com/vb/imgcache/1414.png After every MySQL backup /MySQL dump it is possible to restore or transfer the MySQL tables directly to another MySQL server.
For example, you can transfer MySql databases from local computers to remote servers in the internet.
http://www.atyafonline.com/vb/imgcache/1414.png The data can be transferred compressed (gzip) and encryped (blowfish or SSL) between client and server. If you backup MySQL databases (MySQL dump) the dumpfiles are stored compressed (gz-file).
http://www.atyafonline.com/vb/imgcache/1414.png To access MySQL databases on local servers it is also possible to use the MySQL API library “libmysql.dll”.
http://www.atyafonline.com/vb/imgcache/1413.pngRequirements
http://www.atyafonline.com/vb/imgcache/1414.pngClient: Windows 95/98/ME or Windows NT 4.0/2000/XP
http://www.atyafonline.com/vb/imgcache/1414.pngWebserver: PHP 3/4 (with mCrypt und zLib-library - only if you want to encrypt and compress data)
http://www.atyafonline.com/vb/imgcache/1414.pngDatabase drivers (DAO,ODBC,etc) are not required.
Mainwindow
Next to the main-window there are 3 dialogs, where you can configure your access to the database and the options for the scheduler:
Main window (http://www.richtsoft.com/mod.php?theme=richtsoft&theme=richtsoft&mod=webpage&op=view&wid=18#main)
Definition of MySQl-profiles (http://www.richtsoft.com/mod.php?theme=richtsoft&theme=richtsoft&mod=webpage&op=view&wid=18#mysql)
Setup of the backup-scheduler (http://www.richtsoft.com/mod.php?theme=richtsoft&theme=richtsoft&mod=webpage&op=view&wid=18#backup)
Restore dialog to restore sql- or backup files. (http://www.richtsoft.com/mod.php?theme=richtsoft&theme=richtsoft&mod=webpage&op=view&wid=18#restore)
Main Window
http://www.atyafonline.com/vb/imgcache/1415.png
With the DumpTimer you can execute instant backups of databases/tables or can setup a schedule of backup (and restore) times. Definition of MySQL - Profiles You can setup the access to different MySql-Servers or different databases
http://www.atyafonline.com/vb/imgcache/1416.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/mysql1.gif%27%29)
http://www.atyafonline.com/vb/imgcache/1417.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/mysql2.gif%27%29)
You can access the database via the MySql - API - Library *libmysql.dll* or via a special PHP-Script If you use the PHP-Script, you have to copy it on your webserver.
http://www.atyafonline.com/vb/imgcache/1418.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/mysql3.gif%27%29)
http://www.atyafonline.com/vb/imgcache/1419.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/mysql5.gif%27%29)
The script will test the configuration of your webserver Insert your MySql user data and then save your configuration. Setup of the backup-scheduler In this dialog the databases, tables, the time and the location can be configured.
http://www.atyafonline.com/vb/imgcache/1420.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/backup1.gif%27%29)
http://www.atyafonline.com/vb/imgcache/1421.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/backup2.gif%27%29)
Select the MySql-Profile with the databases you want to back up Select the tables, which you want to backup.
http://www.atyafonline.com/vb/imgcache/1422.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/backup3.gif%27%29)
http://www.atyafonline.com/vb/imgcache/1423.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/backup4.gif%27%29)
There are different options to configure the DUMP-backup-file Setup of the backup-scheduler
http://www.atyafonline.com/vb/imgcache/1424.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/backup5.gif%27%29)
http://www.atyafonline.com/vb/imgcache/1425.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/backup6.gif%27%29)
You can set how many copies of backups should be kept before they were deleted. If you want to transere a table after the backup into an other database sou can configure it here. Restore dialog to restore sql- or backup files Ether you can restore tables from backups you have made with the DumpTimer oder from SQL-Dump-Files.
http://www.atyafonline.com/vb/imgcache/1426.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/restore1.gif%27%29)
http://www.atyafonline.com/vb/imgcache/1427.png (http://javascript%3cb%3e%3c/b%3E:PopupFenster%28%27themes/richtsoft/images/restore2.gif%27%29)
Select the type of restore If you restore tables from a SQL-file, select the file. The content of the file will be listed.
http://www.richtsoft.com/