Help

Troubleshooting Problems

Can Excel2MySQL connect remotely?

Yes. Excel2MySQL can access MySQL databases on a local machine, network machine OR on remote host provider servers. It depends on your provider, but in the case of HostGator for example, you have to add your local ip address to an "allow-access list" which you can do yourself through your account cpanel. Then you can access your MySQL database through standard tcpip port 3306.  Simply specify your server ip address for the hostname. Keep in mind that your remote ip address may change from time to time and you will have to add the new ip address to the access list.  HostGator and other quality hosts should provide a simple webpage that displays your remote ip address if you don’t know it… http://www.hostgator.com/ip. Here is Hostgator’s excellently documented remote MySQL connection page. Please check with your host provider to find similar tools.

Still having trouble connecting

There are many possible causes for failed connection errors like “2003 – Can’t connect to MySQL server”. Sometimes, your connection can be blocked by your firewall, so make sure your MySQL port is open. Sometimes you need to remove the default anonymous user account in your MySQL server, otherwise attempting to connect to localhost may fail for other user accounts. Some MySQL configurations fail to connect with localhost, but port 127.0.0.1 will work instead.  Please let us know if you have a problem, We’d like to help.

Row size too large

If you get the following error message: "Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126."

Solution: This error means that you have an unusually large row size in your spreadsheet, which exceeds MySQL Innodb limits.  If you can't eliminate extraneous data or columns, then try using Myisam instead of Innodb.  Myisam supports a larger row size than Innodb.

Authentication plugin 'mysql_old_password' is not supported

Authentication with old (insecure) passwords is not supported.
For more information, lookup Password Hashing in latest MySQL manual.

The mysql userid you are using for access to your database is using the older much less secure password protection. Excel2MySQL client does not allow a connection to be made to databases using the old password format as it is less secure. I assume your service provider has since upgraded your MySQL server version and now supports the newer style password. If so, one quick and easy solution is to simply create a new MySQL user and password. The new userid's password will be of the newer style and you can use that userid and password in Excel2MySQL.

There are other solutions that I have not tried myself that you can find on http://stackoverflow.com , just search for mysql_old_password.

How to import all Excel files in a folder?

Excel2MySQL has a command line interface (aka Batch mode) for this when you need to import many files. You don't need to be a programmer, but it does help. Simply read the documentation and follow the example.

You can upload many Excel files and even use Windows Task Scheduler to automate the upload on a daily, weekly or hourly basis.

MySQL insert fail: Incorrect string value: '\xF0\x9F\x98...

You are attempting to insert data that contains 4 byte character codes like emoji characters. As of version 2.6.7, Excel2MySQL supports inserting emoji characters by creating tables with utf8mb4_unicode_ci collation. If you get this error, be sure to can change your table collation to utf8mb4 OR allow Excel2MySQL to create the table for you. Your MySQL server must be version 5.5.3 or greater. Otherwise, Excel2MySQL will revert to utf8 format which does not support emojis.