<div>
To SANDY_SK<br />
<br />
Thanks; I found that if I used gzip I could zip the 118 MB (largest table) to 20 MB.<br />
<br />
So I'll just load it in a few pieces.<br />
<br />
Thanks
</div>


To SANDY_SK

Thanks; I found that if I used gzip I could zip the 118 MB (largest table) to 20 MB.

So I'll just load it in a few pieces.

Thanks

<div>
<div class="content wysiwyg-content">
I am being forced to convert an application from MySQL 4 to 5.<br />
<br />
I thought it would be pretty simple. The problem I've run into is size.<br />
<br />
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.<br />
<br />
First question, is there a way to increase that? I'm guessing it's a server parameter &amp;&nbsp;that the host (1 &amp;&nbsp;1 will not allow increasing it.<br />
<br />
So I considered breaking it into pieces. There are tw individual tables that are themselves over 49MB. One is 115 MB &amp;&nbsp;ones is 80.<br />
<br />
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.<br />
<br />
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 &quot;chunk&quot;? 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.<br />
<br />
I am using phpmysql to to the exports / imports.<br />
<br />
Thanks
</div>
</div>


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.

Thanks

MySQL 4 to MySQL 5

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.