Forums / Upgrading from 1.2 to 1.3.x / How do I upgrade my database without losing non-latin characters?

How do I upgrade my database without losing non-latin characters?

Locked

Views: 2,697

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
29 Jan 2008, 7:16 AM
#1
yano avatar

yano

New Zenner

Join Date:
Jun 2007
Posts:
2
Plugin Contributions:
0

How do I upgrade my database without losing non-latin characters?

Is there any particular procedure in the upgrading process that keeps me from losing those characters?

29 Jan 2008, 5:10 PM
#2
absolute avatar

absolute

Totally Zenned

Join Date:
May 2005
Location:
Bath, Somerset
Posts:
1,054
Plugin Contributions:
2

Re: How do I upgrade my database without losing non-latin characters?

If you upgrade using the zc_install database upgrade, you shouldn't loose any data.

However, ensure a full backup is taken!

Just to be safe, I normally take a backup and tar it, so it can't be damaged or lost. Then erplicate your database, so you ahve 2 identical versions. Then run the update scripts on the second one. If all is OK, then point your store at this new updated version. If it all goes wrong, then delete this one, and start again!

The SQL scripts for upgrading can also be found in the zc_install folder under zc_install/sql/

None of the SQL statements should affect your character sets, as they are only concerned with the tables, columns, and indexes.

Absolute

Back, after a 4 year absence! Did you miss me?
Absolute Web Solutions Ltd
Interested in our work? Take a look at one of our sites - The Tech Store