MySql 4.1.x to 4.0.x backup conversion?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
mckooter
Forum Commoner
Posts: 26
Joined: Fri Jul 28, 2006 10:02 pm

MySql 4.1.x to 4.0.x backup conversion?

Post by mckooter »

My current shared hosting provider uses mysql 4.1.7, I recently started working for a small webhost company and they have 4.0.27,

I get free hosting now, and would really rather not continue to pay, and here is my dilemma

the website I am converting is a 40MB sql file, and in export then reimport there are many errors, I am using a script called bigdump to import the file pieces at a time because of its size and impossibility to just upload via phpmyadmin

is there a way, or easy search and replaces that I could process on the sql file (if i can even get it to open in an editor) to convert from 4.1.x to 4.0.x,

this seems to be my largest problem, and is bothering me as I dont think its really possible, (im sure its possible but ridiculously hard)

thanks

chris
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

If you set up a local copy of 4.1.27 or greater you can import it. Then export it again using a more compatible form. mysqldump supports choosing compatibility settings in the outgoing SQL commands.
mckooter
Forum Commoner
Posts: 26
Joined: Fri Jul 28, 2006 10:02 pm

Post by mckooter »

thanks so much, i have a server machine here, should be easy enough, if this works ill be mucho excited

another quick question on my 50mb (larger than i thought) sql file, does anyone know a good editor that can handle this? my dreamweaver has a heart attack everytime i open it
Post Reply