Page 1 of 1

MySql 4.1.x to 4.0.x backup conversion?

Posted: Sat Nov 25, 2006 11:27 am
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

Posted: Sat Nov 25, 2006 5:21 pm
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.

Posted: Sun Nov 26, 2006 4:25 pm
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