rizzir Posted January 24, 2007 Share Posted January 24, 2007 Hi All, I restored my live store to another site. Performed full backup of SQL Database Copied and uploaded the catalog files Restore the database from Backup All up and running OK Fine. Only error i noticed is that Currency symbol is missing and it has "?" symbol instead of "£" symbol. I checked and updated the currency settings but problem is still there. Any ideas what is causing this problem. thanks Link to comment Share on other sites More sharing options...
kgt Posted January 24, 2007 Share Posted January 24, 2007 It has to do with a difference of character sets. Your database is stored as one character set, and the backup file was stored in another. Contributions Discount Coupon Codes Donations Link to comment Share on other sites More sharing options...
rizzir Posted January 24, 2007 Author Share Posted January 24, 2007 It has to do with a difference of character sets. Your database is stored as one character set, and the backup file was stored in another. Thank Kgt for fast reply. Any idea what character set should i be using when performing restore thanks. Link to comment Share on other sites More sharing options...
rizzir Posted January 24, 2007 Author Share Posted January 24, 2007 Thank Kgt for fast reply. Any idea what character set should i be using when performing restore thanks. Thanks for your help. I found the answer character set client utf8 (Global value) latin1 character set connection utf8 (Global value) latin1 character set database latin1 character set results utf8 (Global value) latin1 character set server latin1 character set system utf8 character sets dir /usr/share/mysql/charsets/ collation connection utf8_unicode_ci (Global value) latin1_swedish_ci collation database latin1_swedish_ci collation server latin1_swedish_ci It all works fine now. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.