MySql 4.1.x to 4.0.x backup conversion?
Posted: Sat Nov 25, 2006 11:27 am
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
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