MySQL Forums
Forum List  »  PHP

Re: Encoding problem...
Posted by: Ted Ashton
Date: August 02, 2010 06:10PM

Hello again,

I've just been reviewing my problem, and it seems I wasn't correct when I said the data was preserved when viewed via phpMyAdmin - so much data and so many scrambled letters...

So it would seem my encoding issues are introduced during the export/import process. As outlined in my initial post, This is the process I have been using:

/usr/local/mysql/bin/mysqldump -u"${LOCAL_DB_USER}" -p"${LOCAL_DB_PASS}" "${LOCAL_DB_DATABASE}" | gzip > "${LOCAL_DB_GZIP}"

and upload the resulting file via scp to the live server, where I import it to the live database with:

/usr/bin/mysql -u ${REMOTE_DB_USER} -p${REMOTE_DB_PASS} ${REMOTE_DB_DATABASE} < ${SQL_FILE};

I read somewhere:

http://nathan.rambeck.org/blog/1-preventing-encoding-issues-mysqldump

that this may be a problem as the file passes through the operating system which may not support utf8. Hence I have followed the suggestion in the above link and used the --default-character-set=utf8 and --result-file= switches in the dump and -default-character-set=utf8 in the import. This however, still results in my problems.

Any pointers would be very much appreciated.

C

Options: ReplyQuote


Subject
Written By
Posted
July 30, 2010 07:04AM
July 30, 2010 07:43AM
August 01, 2010 02:33PM
August 04, 2010 02:53PM
August 04, 2010 02:59PM
August 02, 2010 11:52AM
Re: Encoding problem...
August 02, 2010 06:10PM
August 02, 2010 08:42PM
August 05, 2010 12:30AM
August 05, 2010 12:33AM
August 05, 2010 12:35AM
August 05, 2010 12:37AM
August 05, 2010 08:43AM
August 06, 2010 02:17PM
August 06, 2010 11:01PM
August 08, 2010 04:01PM
August 08, 2010 06:16PM
August 05, 2010 12:40AM
September 01, 2010 12:53PM
September 01, 2010 10:50PM


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.