469,609 Members | 2,206 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,609 developers. It's quick & easy.

mysql backup and restore for 4.1.x


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;

mysqldump -uUSER -pDBNAME > /path/backup.sql

and restore;

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

is this correct for me?

OR

mysqldump --default-character-set=latin5 -uUSER -pDBNAME >
/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

Apr 16 '06 #1
0 1590

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by James | last post: by
1 post views Thread by Jerry T | last post: by
2 posts views Thread by Thomas Bartkus | last post: by
4 posts views Thread by news | last post: by
4 posts views Thread by wzhao6898 | last post: by
7 posts views Thread by phillip.s.powell | last post: by
3 posts views Thread by deepstar | last post: by
4 posts views Thread by Bootstrap Bill | last post: by
15 posts views Thread by Jerry Yang | last post: by
reply views Thread by Solution2021 | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.