Unable to correctly export/import zen cart MySQL data file
I use 1and1 as my hosting provider to host my zen-cart shop. I have recently upgraded to SQL5.0 and wanting to move all my old data from my MySQL4.0 to the new 5.0 database. I have Chinese, Japanese and English in my data file. I have tried to export the .sql file in different language setting such as UTF-8, ISO. But I am still getting scrambled char everywhere. UTF-8 should support all my Chinese and Japanese char. I rememeber when loading any of my zen shop pages, the browser will always use UTF-8 and it work fine to display. I have ring 1and1 many times, their tech staff is very friendly but don't seem to make to problem go away.
They advised me to alter database with the following SQL syntax
ALTER DATABASE db_name
CHARACTER SET utf8
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci
I have try to run that but return 1046 error so no luck either. All I want to do is to move all data from my old MySQL datafile to the new one without showing any ??? and unknow charaters. If someone had ever experiance that issue, could you be so kind and let me know the solution to this. I would be so thankful.
Thank you in advance! Zen Cart forum rocks!!!
By stefanoxjx in forum General Questions
Last Post: 5 May 2010, 10:49 AM
By maperr55 in forum General Questions
Last Post: 26 Sep 2007, 02:28 AM
By jeffmic in forum Setting Up Categories, Products, Attributes
Last Post: 17 Sep 2006, 11:25 PM
Content and Graphics Copyright (c) 2003 - 2013 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC