• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

restore my sql with tis 620

my sql dump how ca i dump mysql database but the encoding charector should be Tis620 and when I restore back the character should be tis620
0
teera
Asked:
teera
  • 3
  • 2
1 Solution
 
Kim RyanIT ConsultantCommented:
What version of MySQL? The default is to dump both table definitions plus data. Within the table definition, the character encoding will be recorded, so it should just work. Have you given it a try?
0
 
teeraAuthor Commented:
MySQL 4.0.20 this is the sorce

and Server version: 4.1.20 is the destination


0
 
Kim RyanIT ConsultantCommented:
Should be fine with this version
0
 
teeraAuthor Commented:
How can I know the encoding of database in MySQL 4.0.20  be cause i can not see in
phpmyadnin like MySQL 4.1.20
0
 
Kim RyanIT ConsultantCommented:
If you look at the 'create table' statements in the mysqldump file, they should define an encoding for each table.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now