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.
Subject
Views
Written By
Posted
mysql backup and restore for 4.1.x ????
7294
April 15, 2006 11:06PM
3275
April 16, 2006 06:53PM
2725
April 20, 2006 11:56AM
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.