Solved

MySQL 4 to MySQL 5

Posted on 2013-06-02
2
268 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now