Solved

MySQL 4 to MySQL 5

Posted on 2013-06-02
2
272 Views
Last Modified: 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.

Thanks
0
Comment
Question by:Richard Korts
2 Comments
 
LVL 11

Accepted Solution

by:
SANDY_SK earned 500 total points
ID: 39214707
Hi rkorts,

49MB is actually too small for it to stop, in fact i have restored dumps which are in GBs in mysql 5

what you can do is check in the my.ini file and change the value of the variable  max_allowed_packet to something like 500 MB like shown below. (This is possible if you have direct access to the mysql server)

max_allowed_packet=500M

when you are changing this value make sure you have stopped the mysql service and then restart it.

also try restoring it using the mysqldump command rather than phpmysql.
0
 

Author Comment

by:Richard Korts
ID: 39214724
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
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
mysql ide 10 44
mysql between clause 2 32
mysql update statement 3 30
Restore of mysql database from .SQL file - using Coldfusion 5 41
Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikipedia.org/wiki/PHP  Very powerful.  But a…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question