hi,

i have website runs with php and mysql 4.0.27 now,

and i want to move the website to another server,

but the mysql version of the new server is 4.1,


i try many method to import the .sql,

but it always be scrambled...ect,


my server is with cpanel,can anyone tell me how can i import it well?


thanks a lot.

I am fairly sure that a MySQL 4.0.x dump will import into a 4.1.x (and later) dump just fine.

If you were going, for instance, from MySQL 5.x to MySQL 4.x, then you would need to dump in compatibility mode, but going up a version shouldn't cause any problems.

What do you mean when you say it's scrambled?

Kevin

hi,

my character is not englisg,some website is chinese and some are japan,

when i import it and i open it from phpmyadmin,

the words can not been show correctly.


some body told me when i open the mysql,

i should set the MySQL connection collation,

but i am not sure which one is right for me and is it set it from phpmyadmin is ok,

so,i always import failed.


thanks a lot.

Can you use command prompt? If you can all it takes is two commands.

If not, insure that the collation for new database is the same as the old one, also for the tables and text fields.

When you transfer use files, not copy/paste.

Peace,