Results 1 to 3 of 3
Thread: move db from linux to windows
-
01-03-2007, 12:21 PM #1WHT Addict
- Join Date
- Nov 2006
- Posts
- 153
move db from linux to windows
i want to move my db to windows server so
i backup db using (in linux server)
HTML Code:mysqldump -u root -p123 zode > backup/b_zode.sql
when i restored db using (in windows server)
mysql -u root -p123 zode < backup/b_zode.sql
characters are bad (like Æ € or A1/2)
how can i solve this problem ?
-
01-03-2007, 12:36 PM #2Junior Guru Wannabe
- Join Date
- Jun 2004
- Posts
- 36
hmm i did a few times of moving db from linux to windows and vice versa, never run into bad chars.
can you try opening your b_zode.sql using a wordpad in windows?
Are the chars there scrambled with a bunch of weird characters?- Increase your imagination dramatically but still learning more knowledge.
-
01-03-2007, 01:40 PM #3Web Hosting Guru
- Join Date
- Jan 2007
- Posts
- 254
The problem here seems to be with encoding. What language is your Windows server in? Try to do the following(on WinXP it's like this):
Start->Settings->Control Panel->Regional and Language Options->Languages->Details->Advanced-> at the Compatibility Configuration sections check the Extend support of advanced text services to all programs checkbox -> Ok&reboot
If this doesn't work you may try to move the DB directly from the Linux server to the Windows one without dumping it and copying to the Windows server. Execute this on the Linux server:
Code:mysqldump -uroot -p123 zode | mysql -hIP_OF_THE_WINSERVER -uroot -p123 zode
Server Surgeon George
http://www.serversurgeon.com
Linux, BSD and Windows Administration Services
Toll Free US 877-378-7436 International +1-213-291-9191