mysql backup and restore for 4.1.x

Posted by newman on April 16, 2006, 12:22 am

Please log in for more thread options

Dear all,

I have mysql 4.1.11 on my current server, i need my database restore
another
server.. (another server mysql version is 4.1.11 same.)

And now... I just created new my database to new server following
command:

CREATE DATABASE dbname DEFAULT CHARACTER SET latin5 COLLATE
latin5_turkish_ci;

because our database and tables uses latin5 and turkish_ci collation.

How can i get correct backup and restore for this character sets?
example;

show/hide quoted text

and restore;

mysql -uUSER -pDBNAME < /path/backup.sql

is this correct for me?

OR

show/hide quoted text
/path/backup.sql

and restore;

mysql --default-character-set=latin5 -uUSER -pDBNAME <
/path/backup.sql

some peoples suggest me --default-character-set= variable for mysql
4.1.x
backups and restore, is this correct? also if we backup database
--default-character-set option, restore command is same option will
need to
use?

Which method is good for me? if someone can help me for this, i'm
pretty
happy.

Thanks for all, and sorry for very bad english.

--
newman
------------------------------------------------------------------------
newman's Profile: http://www.dbtalk.net/m168
View this thread: http://www.dbtalk.net/t299922