wordpress數(shù)據(jù)庫(kù)轉(zhuǎn)移

背景：

Wordpress安裝時(shí)數(shù)據(jù)庫(kù)指定不正確，導(dǎo)致網(wǎng)站上的數(shù)據(jù)都放到了mysql這個(gè)系統(tǒng)庫(kù)中。

mysql> show tables from mysql;

+---------------------------+

| Tables_in_mysql           |

+---------------------------+

| columns_priv              |

| db                        |

| event                     |

| func                      |

| general_log               |

| help_category             |

| help_keyword              |

| help_relation             |

| help_topic                |

| host                      |

| ndb_binlog_index          |

| plugin                    |

| proc                      |

| procs_priv                |

| servers                   |

| slow_log                  |

| tables_priv               |

| time_zone                 |

| time_zone_leap_second     |

| time_zone_name            |

| time_zone_transition      |

| time_zone_transition_type |

| user                      |

| wp_commentmeta            |

| wp_comments               |

| wp_links                  |

| wp_options                |

| wp_postmeta               |

| wp_posts                  |

| wp_term_relationships     |

| wp_term_taxonomy          |

| wp_termmeta               |

| wp_terms                  |

| wp_usermeta               |

| wp_users                  |

+---------------------------+

而mysql庫(kù)中放的mysql數(shù)據(jù)庫(kù)自身的數(shù)據(jù)，所以我們希望把網(wǎng)站的數(shù)據(jù)重新放到wordpress庫(kù)。 

思路：

首先將mysql庫(kù)中屬于wordpress的數(shù)據(jù)備份到/back/mysql下，再把備份的數(shù)據(jù)恢復(fù)到wordpress庫(kù)中。 

操作：

第一步：寫(xiě)一個(gè)備份腳本

[root@localhost mysql]# cat wp_backup.sh

for tname in ` mysql -uroot -p'dong' -e "use mysql;show tables like 'wp_%'"|grep -iv tables`

do

tname_all="$tname_all $tname"

done

#echo $tname_all

mysqldump -uroot -p'dong' mysql $tname_all >/backup/mysql/wp_all_back.sql

第二步：驗(yàn)證腳本的正確性后，執(zhí)行腳本

第三步：將備份的數(shù)據(jù)恢復(fù)到wordpress庫(kù)中

第五步：驗(yàn)證結(jié)果

mysql> show tables from wordpress ;

+-----------------------+

| Tables_in_wordpress   |

+-----------------------+

| wp_commentmeta        |

| wp_comments           |

| wp_links              |

| wp_options            |

| wp_postmeta           |

| wp_posts              |

| wp_term_relationships |

| wp_term_taxonomy      |

| wp_termmeta           |

| wp_terms              |

| wp_usermeta           |

| wp_users              |

+-----------------------+

12 rows in set (0.00 sec)

第六步：修改wordpress連接的庫(kù)

最后網(wǎng)站也運(yùn)行正常，結(jié)束。

更多博客請(qǐng)?jiān)L問(wèn)：www.ayard.com.cn