Import your Access database to MySql, Even if a direct access to your MySQL database is denied.
If you need to import your Access database to a Mysql database to use it in your web site you may find a big problem if your hosting provider doesn’t allow Remote connection to his MySQL servers (which is common), but you can always use Access-PHP-MySQL-Magic to overcome such restrictions.
Access-to-MySQL allows you to store your Access database in a PHP script:
By running the PHP script generated from your existing ms access db, you will be able to Import your Access database to MySQL much faster then any other odbc connection. By using Access-to-MySQL you can make the conversion manually or schedule your conversion tasks to be performed automatically.
Backup your MySql database:
Access-to-MySQL stores your MySQL database structure and / or records in a single PHP file or SQL script , by running the PHP file once in your Web site, you can restore your Mysql database. Easily whenever you need. The program supports scheduling of the storing process to be performed automatically. so using Access-to-MySQL you can automatically carry out the backup of the specified database daily, weekly, monthly or once on the established time.
Dump your Access database
Access-to-MySQL creates a text file from your Access db containing the SQL script necessary to recreate your Access database whenever you need. You can also dump your current MySQL database or backup your database from MySQL to a php backup script of your exiting database for restoring your db should server trouble ever arise or for piece of mind that you can backup your own database with ease.