MySQL 4 to MySQL 5
Posted on 2013-06-02
I am being forced to convert an application from MySQL 4 to 5.
I thought it would be pretty simple. The problem I've run into is size.
The full database dumped into a sql file is 324MB. The MAXIMUM I am allows to import into the MySQL 5 created database is about 49 MB.
First question, is there a way to increase that? I'm guessing it's a server parameter & that the host (1 & 1 will not allow increasing it.
So I considered breaking it into pieces. There are tw individual tables that are themselves over 49MB. One is 115 MB & ones is 80.
I think I can selectively export the needed data in chunks under 49 MB each, I already did the biggest one; 18 MB in a csv file.
The real question is if I do the 4 or 5 largest tables individually, is there an easy way to export all the others in one "chunk"? There are a total of 64 tables, of course I understand I can do them one by one. I mean the 57 or 58 that I can lump together.
I am using phpmysql to to the exports / imports.