MySQL Forums
Forum List  »  Backup

mysql backup and restore for 4.1.x ????
Posted by: orhan sevki
Date: April 15, 2006 11:06PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql backup and restore for 4.1.x ????
7214
April 15, 2006 11:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.