[CentOS] mysql 4 > 5 export import issue
Tom Brown
tom at ng23.netMon Nov 3 09:40:06 UTC 2008
- Previous message: [CentOS] rpm spec question
- Next message: [CentOS] Can I upgrade CentOS 3.9 to 4 with apt/yum
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> The characters look binary, so this might be a problem of conversion > latin1 -> utf8 or vice versa. > > Try dumping with: > > mysqldump --default-character-set=binary ... >/path/to/dumpfile > > And loading the dump with: > > mysql --default-character-set=binary ... >/path/to/dumpfile > > Let us know if that works. > > HTH, > thanks for all the suggestions - in the end i opted for rsyncing the datafiles for this db and for me this worked fine. Not the 'correct' way but one that worked OK at the time. thanks
- Previous message: [CentOS] rpm spec question
- Next message: [CentOS] Can I upgrade CentOS 3.9 to 4 with apt/yum
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the CentOS mailing list