Home Backend Development PHP Tutorial WordPress搬家方法及乱码的解决办法

WordPress搬家方法及乱码的解决办法

Jun 13, 2016 pm 12:57 PM
nbsp phpmyadmin unicode wordpress

WordPress搬家方法及乱码的解决方法
前段时间,我的博客备案就被取消了,由于平时比较忙,也没有去管。突然有一天空间商那边显示备案审查,让我重新备案,我才意识到终于要搬空间了。提交工单让空间商备份数据,自己下载了就没管了,今天刚好有空,所以搞了个国外空间把博客搬到了国外了。
搬家的过程非常简单,只需要三步:
1、在原空间打包备份好程序和数据库,让人狗血的是空间商直接复制打包了MYsql的数据库文件,并非导出的.sql文件,无奈只能自己重新手动去导出数据库了(这里有点杯具,后面说)
2、在新空间绑定已解析好的域名,将程序上传上去并解压到空间根目录下。登陆空间数据库管理,将备份好的数据库通过phpmyadmin导入。
3、用editpuls打开根目录下的wp-config.php,修改里面的数据库配置信息:数据库名、数据库密码。
搬家就完成了。
这里说一个狗血的事,我完成了上面的搬家步骤后,打开一看,内容全乱码的。我就知道编码出了问题,初步估计是PHPMYADMIN导出导入时编码不一致造成的。
原空间的phpmyadmin是老版本的,貌似是2.9的,而新空间则是新版的,导出前没有在原空间的phpmyadmin里将编码整理一下,所以出现了乱码的情况。
具体操作步骤为:登陆原空间的phpmyadmin,登陆后在右上角一个【操作】按钮,点击该按钮拉到最下面,你会看到一个整理,这里有一个下拉框,将编码拉到最下面,即:utf8_unicode_ci,点击旁边的执行,然后再去导出数据库,重新导入到新空间的数据库里,刷新,乱码不见了。
 
 
------解决方案--------------------
这么简单啊 

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Nordhold: Fusion System, Explained
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Mandragora: Whispers Of The Witch Tree - How To Unlock The Grappling Hook
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial
1665
14
PHP Tutorial
1269
29
C# Tutorial
1249
24
How to adjust the wordpress article list How to adjust the wordpress article list Apr 20, 2025 am 10:48 AM

There are four ways to adjust the WordPress article list: use theme options, use plugins (such as Post Types Order, WP Post List, Boxy Stuff), use code (add settings in the functions.php file), or modify the WordPress database directly.

How to build a website for wordpress host How to build a website for wordpress host Apr 20, 2025 am 11:12 AM

To build a website using WordPress hosting, you need to: select a reliable hosting provider. Buy a domain name. Set up a WordPress hosting account. Select a topic. Add pages and articles. Install the plug-in. Customize your website. Publish your website.

How to change the head image of the wordpress theme How to change the head image of the wordpress theme Apr 20, 2025 am 10:00 AM

A step-by-step guide to replacing a header image of WordPress: Log in to the WordPress dashboard and navigate to Appearance >Theme. Select the topic you want to edit and click Customize. Open the Theme Options panel and look for the Site Header or Header Image options. Click the Select Image button and upload a new head image. Crop the image and click Save and Crop. Click the Save and Publish button to update the changes.

How to import the source code of wordpress How to import the source code of wordpress Apr 20, 2025 am 11:24 AM

Importing WordPress source code requires the following steps: Create a sub-theme for theme modification. Import the source code and overwrite the files in the sub-topic. Activate the sub-theme to make it effective. Test the changes to make sure everything works.

How to view the front-end of WordPress How to view the front-end of WordPress Apr 20, 2025 am 10:30 AM

You can view the WordPress front-end by logging into the dashboard and switching to the View Sites tab; automate the viewing process with a headless browser; installing the WordPress plugin to preview the front-end within the dashboard; viewing the front-end via a local URL (if WordPress is set locally).

What are the plugins for wordpress blocking ip What are the plugins for wordpress blocking ip Apr 20, 2025 am 08:27 AM

WordPress IP blocking plugin selection is crucial. The following types can be considered: based on .htaccess: efficient, but complex operation; database operation: flexible, but low efficiency; firewall: high security performance, but complex configuration; self-written: highest control, but requires more technical level.

How to cancel the editing date of wordpress How to cancel the editing date of wordpress Apr 20, 2025 am 10:54 AM

WordPress editing dates can be canceled in three ways: 1. Install the Enable Post Date Disable plug-in; 2. Add code in the functions.php file; 3. Manually edit the post_modified column in the wp_posts table.

How to write a header of a wordpress How to write a header of a wordpress Apr 20, 2025 pm 12:09 PM

The steps to create a custom header in WordPress are as follows: Edit the theme file "header.php". Add your website name and description. Create a navigation menu. Add a search bar. Save changes and view your custom header.

See all articles