FlySpeed DB Migrate to MySQL
Frequently Asked Questions
How can I connect to my source MySQL, Firebird or PostgreSQL database?
A: First, I recommend you to choose ODBC connection type on the second step of the Wizard to achieve maximum transfer speed, to extract full information about your database structure and to avoid various problems you may have while working through the OLE DB Provider for ODBC.
To get connected to your source database through ODBC, you should install an appropriate ODBC driver for your database. Below are the links where you can download latest versions of ODBC drivers for your database:
- MySQL: http://dev.mysql.com/downloads/connector/odbc/
- PostgreSQL: http://pgfoundry.org/projects/psqlodbc/
- Firebird: http://www.firebirdsql.org/ or http://www.ibphoenix.com/
What MS Access database objects will be transferred to MySQL (Tables, Relations, Queries, Reports, Views)?
A: Tables and Relations will be transferred fine with the FlySpeed DB Migrate tool.
But not all of MS Access objects might be transferred to MySQL in principle. MS Access combines the database storage facility, the development environment and the end-user interface to work with data. MySQL is only a database server, so there is no place to store Forms and Reports. To get this functionality, you may use any development environment like Delphi, Visual Studio, etc.; also you may use MS Access with your Forms and Reports as the end-user interface for your MySQL database.
The analogue of MS Access Queries in MySQL are Views, but they could not be transferred automatically, because the syntax of SELECT statements in MS Access and MySQL is different. We have plans to implement the conversion of MS Access Queries to Views automatically in the future versions. Also please note that Queries with parameters could not be converted to MySQL Views.
I have an Access database that has an OLE object field used to store JPEG pictures. I want to convert JPEG pictures into the MySQL table as Binary Data. Is it possible to perform such conversion with the help of your tool?
A: Yes, our tool allows extraction of JPEG and BMP pictures from OLE object fields. You should set the "Extract pictures (BMP, JPG) from MS Access OLE Object fields" option on the Step 11 "Data Copy Options" of the Wizard to enable this feature.
I have about 50 tables in my source SQL Server database and I need to synchronize their data with the same MySQL tables every week. Can I automate this process?
A: Yes, you can use the Data Import Projects for this purpose. Click the "Save Data Import Project" button on the Step 8 to save your current settings to a file. Next time, simply click the "Load Data Import Project" button on the Step 1 to restore your settings.
My source database contains data in Greek character set. I want to migrate to MySQL 5.1 and want to use UTF8 to store my data. How can I do it?
A: You should set the "Default character set for MySQL tables" option to "utf8" on the Step 7 and the "Database character set" option for the source database to "Greek" on the Step 11 of the Wizard.
Why cannot I connect to my local MySQL Server?
A: There are several reasons why you cannot connect to the local database. If during the connection you get the error "Can't connect to MySQL server on 'localhost' (10061)", then probably MySQL server is installed incorrectly or the service (usually with the name "mysql") is not running. To check if the service is launched, open "Control Panel" -> "Administrative Tools" -> "Services" and find the MySQL service. If you cannot find this service, you should try to reinstall MySQL. In case you find it, run it with the Start button or use Start item in the context menu. If you get the error "Access denied for user 'root'@'localhost' (using password: YES)", then check if you enter the password for the root user correctly in case you change it during installation. If you installed MySQL with default values, you should use the user name root with the blank password and port 3306 to connect to the server.
(More info ...)
Why cannot I connect to a remote MySQL server?
A: There could be several possible reasons that prevent you from successful connection to remote database. If the error message says "Can't connect to MySQL server on ‘some host' (10061)" then probably you should check the correctness of port and host name you've entered and also if the remote server is run. It often happens that the port through which the connection is set with MySQL server (normally, it's 3306) is closed for the security reasons by local firewall, corporate firewall or remote server firewall. The remote server port can also be closed by ISP, or TCP/IP protocol support is disabled on MySQL server. Please check this with your system administrator or ISP.
If the error message says "Access denied for user: firstname.lastname@example.org" or "Host not allowed to connect to server", then the reason is that the user doesn't have permission to access the database.
When I try to connect to a database, I get the following message: "Access denied for user: email@example.com". Why does it happen?
A: MySQL server uses client's login ('myuser' in your case) and the name of the host which it tries to set the connection from ('myhost.mydomain' in your case) for the client authentication. In your case the reason is that your 'myuser' user from the 'myhost.mydomain' host doesn't have permissions to access your MySQL server. It's quite possible that you successfully connected to your database with the same login and password in your PHP scripts or with the help of phpMyAdmin, but in this case MySQL server recognizes you as the 'myuser' user from the 'localhost' host who has the necessary permissions and allows you the access.
To solve this problem you should grant the necessary permissions to user myuser@ myhost.mydomain. You can do this with the help of phpMyAdmin or with the following SQL commands:
/*!50003 CREATE USER ‘myuser’@ ‘myhost.mydomain’*/; GRANT ALL PRIVILEGES ON *.* TO ‘myuser’@ ‘myhost.mydomain’ IDENTIFIED BY 'user_password';
I'm trying to connect to a remote MySQL database, but I receive only the "Host not allowed to connect to server" message. What can the reason be?
A: This error occurs because you don't have a permission to connect to remote MySQL server from your host. Please contact your database administrator or, if you have access to MySQL server with grant privilege, you can use the GRANT statement to add a new user. For example, the following command will give full access from your host to the user:
/*!50003 CREATE USER 'user'@'user_host'*/; GRANT ALL PRIVILEGES ON *.* TO 'user'@'user_host' IDENTIFIED BY ' user_password ';
I receive the following error message: "Server is gone away" when try to import data on the last step of the Wizard. What can the reason be?
A: The most probable reason of this problem is that the tool sends a query to the server that is too large. If mysqld receives a packet that is too large, it assumes that something has gone wrong with the client and closes the connection. To solve this problem you can lower the value of the "Records in block" option on the step 11 of the Wizard or increase the query limit by setting the server's max_allowed_packet variable, which has a default value of 1MB.