Auto Backup for MySQL (the old name is MySQL Auto Backup), is a powerful Windows program that makes it easy to schedule the backing up and restoring of your remote and local MySQL databases. It's easy to back up one or many databases, and restore them to the same server, or to any server.
Auto Backup for MySQL uses reliable TCP/IP protocol to back up and restore your MySQL databases. It's easy to back up MySQL databases, tables and views to SQL or PHP files. And it's easy to export MySQL tables and views to comma-delimited CSV, XML, HTML, and text files.
Auto Backup for MySQL works as a stand-alone utility, and does not require any additional software. It's not necessary to have MySQL installed on your local computer to perform backups or restores.
The program's wizards make it easy to back up and restore your databases. Simply specify the SQL/PHP/GZIP file names and locations, and set up a schedule. Auto Backup for MySQL will automatically perform the backup and restore work unattended. You can also run the program manually, any time you'd like. You can even run Auto Backup for MySQL as a Windows Service. This way, you do not need to log in Windows for backup and restore.
Auto Backup for MySQL can back up MySQL databases to the other server or to the other database; you can schedule the backing up of one or many MySQL databases from a remote or local server to the other remote or local server via TCP/IP protocol, using the same or different database names. In addition, the program can back up all newly-created databases and tables on the MySQL server, automatically.
All MySQL character sets are supported, including UTF8, UCS2, LATIN1 and more. The program supports all store engines and table types, including InnoDB, MyISAM, BDB and more. All MySQL field types are supported, including BLOB, TEXT, DECIMAL and more. The software can even back up records that contain image fields.
The program includes all of the advanced features that you'd expect in a professional backup program: It can create new folder names using date/time information for storing the backup files every time. It can automatically delete older backup archives based upon dates or the number of backups that you wish to keep. Both compression protocol and SSL protocol are supported. You can limit the maximum size of each task log file.
More features in the program include compression of backup files, the ability to restore databases from SQL/GZIP files, high-speed backup and restore, speed improvements, the ability to run as a Windows Service, support for unlimited size databases (larger than 100GB), and the ability to schedule database restores.
Auto Backup for MySQL Professional Edition 3.2 runs under Windows NT, 2000, XP, 2003, Vista, 2008 and later and supports MySQL from 3.23 to the latest version. The program works with MySQL Server running on Windows, MacOS, UNIX/Linux, and all operating systems.
You can visit our web site to get more information about the program.
http://www.swordsky.com
The program has an easily customized task wizard, which allows you to create a new task to backup or restore.
The following tasks can be created by the task wizard:
Backup:
Backup MySQL databases to SQL or PHP files
Backup one or many MySQL database(s) from a remote or local source server to the local SQL or PHP file(s) via TCP/IP protocol (Use SAME database names).
Backup MySQL databases to the other server
Backup one or many MySQL database(s) from a remote or local source server to the other remote or local server via TCP/IP protocol (Use SAME database names).
Backup one MySQL database to the other database
Backup the selected tables from a single MySQL database to the other database on the different or same server via TCP/IP protocol (Choose ANY database name).
Restore:
Restore MySQL databases from SQL and GZIP files
Restore your MySQL databases from the SQL and GZIP files via TCP/IP protocol (Use SAME database names).
Restore MySQL databases from the other server
Restore your MySQL databases from the other server via TCP/IP protocol (Use SAME database names).
Restore one MySQL database from the other database
Restore one MySQL database from the other database via TCP/IP protocol (Choose ANY database name).
Accessories:
Export MySQL tables and views to CSV/XML/HTML/TEXT files
Export your MySQL tables and views to CSV/XML/HTML/TEXT files via TCP/IP protocol.
Execute MySQL script
Execute MySQL script via TCP/IP protocol.
You can customize the scheduler so that the program would automatically make the backup from the MySQL databases daily, weekly, monthly, any special date or time interval.
After creating a task, you can control the task to start, stop and run immediately.
After installing the program, you can allow it auto run when the current Windows user log in. It will place an icon into the system tray after the user log in. It will work for the MySQL database backup automatically as an agent. If you wish to run the program as a Windows Service, please purchase the full version program of Professional Edition at our web site:
http://www.swordsky.com
Main features
An easy-to-use task wizard.
Unlimited size databases (larger than 100GB) supported.
Compress the backup SQL files.
High speed backup databases.
Use buffer mode to speed up the process of a task.
Manage all backup files and create a restore task from a backup item.
Work as a Windows Service on Windows NT, 2000, XP, 2003, Vista, 2008 and later.
MySQL from 3.23 to the latest version supported.
All MySQL character sets supported. (for example, UTF8, GBK, BIG5 and all character sets)
All MySQL storage engines and table types supported. (for example, InnoDB, MyISAM, HEAP and all)
All MySQL field types supported. (for example, BLOB, VARCHAR, DECIMAL and all field types)
Backup all newly-created databases and tables on the MySQL server automatically.
Backup database and table structure, records, index, views, stored procedures, triggers, functions, events supported.
Each file contains all databases or a selected database or a selected table.
User-defined the backup file name.
Create a new folder and named it after DATE_TIME every time for storing the backup files.
Auto delete the backup files if they are more than user-defined days old.
Auto delete the oldest backup files when more than user-defined backup copies.
Create a new user-defined database to storing tables when backup a database to the other.
Powerful schedule restore MySQL databases function.
Manually, daily, weekly, monthly, any special date or time interval to run a task.
Windows NT, 2000, XP, 2003, Vista, 2008 and later supported.
Compression protocol and SSL protocol supported.
Powerful task log manager.
Auto run when Windows user log in.
User-defined date and time format.
Disable shutdown/log off/suspend when a task running.
Limit the maximum size of each task log file.
Product Information
Web Site: http://www.swordsky.com
Support E-mail: support@swordsky.com
Purchase the software on-line at: http://www.swordsky.com/purchase.html