Converting newer database Mysql file to older version ?

[rome2ng]

Heya guys,

it's is very important.

i have a host, that is still down , i guess, they are using 4.1.19-standard, given with the cpanel and etc.

but the trouble comes when i am fedup with the previous host and decide to move to a more reliable host. unfortunately , they are using 4.0.27-standard.

I face a problem when i cannot upload my new sql data files, there. it say version not same.

MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 10

But even if i removed that, it give me this,

MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `wp_categories` VALUES (1, 'Past@Blogspot', 'pastbl

it's a wordpress code.


anything i can do ?

 

[Noobie]

if you want, you can send me the .sql and i can try and clean it. It's probably something really small. I encountered the same thing with an sql dump from 4.1 to 4.0 and the issue was something minor.

 

[rome2ng]

heya shoei,

i have send you the files.

thks, pls help me with that.

 

[Noobie]

I replied.

Sent another version too, should be better

 

[rome2ng]

thks shoei,

he fixed it up pretty fast.

rep added

 

[Noobie]

cool thanx

 

[adam_uk]

for future reference in phpmyadmin there is export options for different options all the way back to mysql 3.0

 

[Noobie]

http://www.namepros.com/programming/225134-some-differences-when-using-mysql-4-a.html

 

[rome2ng]

thks shoei for the update, i will keep that in mind