Shulou(Shulou.com)05/31 Report--

The main content of this article is to explain "how to upgrade mysql3 to mysql5 when garbled". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "mysql3 upgrade to mysql5 garbled how to do" it!

Environment:

1. The old library is mysql3.23, and the new library is mysql-5.1.33-win32.msi. The database name is www.cxinbao.com

two。 My local phone is xpsp2.

First install the 3.23 database locally. Package the database on the server directly to the local server under the data directory. Copy to the data directory where the local database is located. The same version. Or. 4.1 or below can directly copy the catalog. those below 4.1 should be transferred to 4.1 or above. Cannot be copied directly. Character set issues will be involved. Can only be exported with mysqldump. And then import.

How to solve the problem of garbled code when upgrading from mysql3 to mysql5

1. After installation, 3.23. Then cmd enters the bin directory where the database is located. Then run the export database as a sql file

Mysqldump-uroot-p--default-character-set=gbkwww.cxinbao.com > cxinbao.sql

two。 Then delete the table under the original library. Run again. Import the sql just exported into the library.

Mysql-uroot-p--default-character-set=latin1-fwww.cxinbao.com

3. Then import the database you just imported. Then export to sql

Mysqldump-uroot-p--default-character-set=latin1www.cxinbao.com > cxinbao.sql

4. Stop the 3.23 mysql server in the service. Then install mysql5.1 database. Code with utf-8 and copy the cxinbao.sql under the mysql3.23 database bin directory to the mysql5.1 database bin directory. Backup, and then use cmd to change to the bin directory where mysql5 is located. Running

Mysql-uroot-p--default-character-set=gbk-fcxinbaonew

In this way, the cxinbaonew database is the database you successfully transferred. The library should be built in advance.

At this point, I believe that everyone on the "mysql3 upgrade to mysql5 garbled how to do" have a deeper understanding, might as well to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.