471,073 Members | 1,394 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

MySQL export/import problem

Hi all,

I have installed MySQL on my Linux Mandrake 10 workstation; I didn't
change any default values (except for the user-accounts). I used a CMS to
create a website which I want to upload to my hosting provider.

When I export my database (using PHPMyAdmin) from my workstation to a
local file and then on the server (again using PHPMyAdmin) I import the
database from the local file, some characters are 'fucked up'.

My local install is MySQL 4.1.2-alpha-standard (from Mandrake RPM) and it
seems that the default character set is utf8 with collation
utf8_general_ci. But some columns in my tables (even within other
databases) use collation latin1_swedish_ci (strange..).

The server install is MySQL 4.0.15. Using mysqladmin with the 'variables'
command, I found out that variable 'character_set' has value 'latin1' and
the variable 'character_sets' has value:

latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos
german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia
hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5

The 'convert_character_set' variable seems to have no value.

I tried creating a database on the server using mysqladmin with the
--default-character-set=utf8, but that also doesn't help. (it doesn't give
any error message, but utf8 is not listed in the 'character_sets' variable)

Does anyone know how to solve this problem?

Much thanks in advance!

Jul 23 '05 #1
1 2592
Martin Herrman wrote:
Does anyone know how to solve this problem?

See my response on your crossposting on comp.databases.

Short answer: you should use the same version of MySQL in development
as you use in production.

Bill K.
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Damien | last post: by
11 posts views Thread by Mike MacSween | last post: by
4 posts views Thread by news | last post: by
7 posts views Thread by phillip.s.powell | last post: by
10 posts views Thread by Simon | last post: by
7 posts views Thread by Randy | last post: by
1 post views Thread by contact.amarender | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.