467,211 Members | 1,220 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,211 developers. It's quick & easy.

Problem with accent Import to MySQL/Linux from MySQL Windows

Hi,

I've been asked to transfert a database from a webhoster to another. I think
the database is on a windows box but I'm not 100% shure. The webhoster says
it provides combined hosting on NT/Linux Servers.
After exporting the database with phpMyAdmin I tried to import it to a Linux
server with the mysql>source file.sql command via a ssh access (the file is
40 Mbytes so phpMyAdmin is useless). Everything seemed ok but all accented
characters ( ...) and some other special characters were replaced by
"?". I search the net and find somewhere that file from windows might need
to be convert to utf8 before importing them so I tried to convert the file
with iconv then re-import the file. Once again everything seemed to work
fine. The accent problem was solve but another one showed-up. The database
stores some html code where accent and special characters are represented in
their html form like this è or č for "", now all these have
been replaced by other characters like instead of é. When I import
the files(not in utf8) to a windows machine with mysql>source file.sql
command, everything is normal.

Any ideas how to solve this ?

Thanks,
Dae
Sep 4 '05 #1
  • viewed: 3532
Share:
3 Replies
Problem Solved...


"Daedalus.OS" <ar**************@videotron.ca> wrote in message
news:NZ*********************@weber.videotron.net.. .
Hi,

I've been asked to transfert a database from a webhoster to another. I
think the database is on a windows box but I'm not 100% shure. The
webhoster says it provides combined hosting on NT/Linux Servers.
After exporting the database with phpMyAdmin I tried to import it to a
Linux server with the mysql>source file.sql command via a ssh access (the
file is 40 Mbytes so phpMyAdmin is useless). Everything seemed ok but all
accented characters ( ...) and some other special characters were
replaced by "?". I search the net and find somewhere that file from
windows might need to be convert to utf8 before importing them so I tried
to convert the file with iconv then re-import the file. Once again
everything seemed to work fine. The accent problem was solve but another
one showed-up. The database stores some html code where accent and special
characters are represented in their html form like this &egrave; or č
for "", now all these have been replaced by other characters like
instead of &eacute;. When I import the files(not in utf8) to a windows
machine with mysql>source file.sql command, everything is normal.

Any ideas how to solve this ?

Thanks,
Dae

Sep 5 '05 #2
On Mon, 5 Sep 2005 18:01:26 -0400, "Daedalus.OS"
<ar**************@videotron.ca> wrote:
Problem Solved...


Please tell us - for the archives...
--
Locate your Mobile phone: <http://www.bizorg.co.uk/news.html>
Great gifts: <http://www.ThisBritain.com/ASOS_popup.html>
Sep 6 '05 #3

"David Quinton" <us****************@REMOVETHISBITbizorg.co.uk> wrote in
message news:me********************************@4ax.com...
On Mon, 5 Sep 2005 18:01:26 -0400, "Daedalus.OS"
<ar**************@videotron.ca> wrote:
Problem Solved...

Please tell us - for the archives...


Finally it wasn't MySQL but apache. After some verification I noticed that
internally the database was perfect. Apache was set with DefaultCharset
utf-8. we changed it to iso8859-1 and the problem was solved.
Locate your Mobile phone: <http://www.bizorg.co.uk/news.html>
Great gifts: <http://www.ThisBritain.com/ASOS_popup.html>

Sep 6 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Abby | last post: by
reply views Thread by Bruce Davis | last post: by
2 posts views Thread by Gurpreet Sachdeva | last post: by
reply views Thread by adrian GREEMAN | last post: by
7 posts views Thread by phillip.s.powell@gmail.com | last post: by
5 posts views Thread by Eric Smith | last post: by
Atli
6 posts views Thread by Atli | last post: by
2 posts views Thread by dmstn | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.