Topic: MYSQL Help

[Steve]

I have a database from a 4.1 server i need to move to a 4.0 server....but im getting syntax errors. Is there an easy fix? And no, upgrading the server isnt an option

[Perspective]

how are you trying to move it? Restoring the 4.0 with the 4.1 logs?

[Steve]

i exported the db from 4.1 and im trying to import it onto the new server which is 4.0

[Perspective]

Ah i see. what type of errors are you getting?

[Mike]

Upgrade to MySQL 5

[ober]

Did you specify an export compatibility?

[Steve]

Upgrade to MySQL 5

not an option

Ah i see. what type of errors are you getting?

"syntax error on blah blah compoenent_time blah blah read the fucking manual". I can re-create it if needed.

Did you specify an export compatibility?

ill be honest, im not even sure what that means. I'm using phpmyadmin.

[hans]

like ober said,

try using mysqldump to do the backup.

something like (piped to some sort of file):
>mysqldump --compatible=mysql40 <dbname> -u <username> -p

[Steve]

i dont have root access, just phpmyadmin access.

[Steve]

DOH! phpmyadmin has a "compatability mode" option for sql 4.0......dammit. thnx guys your ideas helped me find that

[ober]

Yeah... I meant using phpmyadmin.  I figured you didn't have root access.

[Steve]

Its running super slow now, i cant figure out why but thats going to take me some time to see how the new db looks vs the old. something tells me compatiability came at a cost.

[hans]

Indexes maybe?

[Steve]

Explain plz. I'm a little slow with some things i never messed with before lol

[ober]

You can assign a specific field to be an index, so it can sort and categorize easier.  If you look at the "structure" tab of phpmyadmin, you should see the option in several places.