How to Import Large Database to MySQL
Posted on 2011-03-23
Have a large Access database to transition to MySQL. Have written VBA code to write the SQL statements (CREATE then INSERT) for all tables and records being converted. Problem is the file size. If all data is in a single file, the .sql file is 177 meg. If I split into 57 separate tables, the largest is still 67 meg.
I'm testing locally on WAMP server. The MySQL import will only allow 2K (that's K, not Meg) files.
How can I change the MySQL import file size limit? Does MySQL, in general, have a limit on the file size or number of records that can be imported?