Dedecms Backup database from MYSQL5 to MYSQL4

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

As a webmaster, presumably back up the data is a regular and must do, if you are veteran, then there is no need to look down, this article only for the introduction of the Brothers service. The open source protagonist of this time is dedecms.

Dedecms is really a good open source system, it should be a lot of webmaster favor it. When it comes to backing up a database, it's more feasible and simpler.

This time to talk about how to backup from MySQL5 to MYSQL4, generally we are backing up the database are from low-level to advanced, why make a high-level to low-level? Haha, there is no absolute, there must be someone need, I was one of them.

Usually backup MySQL database, the idea is phpMyAdmin, yes, this tool can really achieve, but this time is to from MySQL5 to MYSQL4, but not so spirit, and face to back up the data database, it is not a good choice (general limit 2M). Dedecms backstage for us to design a backup database function, powerful and simple. How to use it, now one by one ways to:

First in the background –> system Management –> database backup

Then click Choose All, select the mysql3.x/4.0.x version, and check the backup table structure information.

Just talking about the backup database, the next is to explain how to recover, please be patient and then look down:

Most people back up the database in order to transplant the whole station to another space, presumably you are no exception. So how do you recover? Good question, haha.

In fact, it is very simple, step-by-step:

Install a new DEDECMS system in the new space (remember to choose the same code, otherwise garbled I can not be responsible for it)

This is a very important step in/dede/backup_data find the TXT file at the beginning of tables_struct, then open it with Notepad or editplus, and then find default Charset=utf8 or default CHARSET=GBK, remove them all. Otherwise the consequences are quite serious.

The/dede/backup_data directory of the backup database file FTP uploaded to the appropriate directory.

Into the newly installed system background –> System Management –> Database restore, select all backup files, and check the restore table structure letter, and then click Start source data can be restored.

After the restore, log back in the background and generate HTML.

Haha, I hope you can make a smooth backup.

Article Source Address: http://www.4studio.cn/blog/?p=279