创建数据库并导入sql文件再替换表中的域名为指定值

一、mysql 新建数据库并导入sql文件

1.新建数据库
UTF8: CREATE DATABASE aoqshop-com DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci；
utf8mb4 :CREATE DATABASE db DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci；
GBK: create database test2 DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;

2.选择db

use db;

3.导入

source /web/html/sql/db.sql;

二、mysql替换表中某字段的某值

UPDATE wp_options SET option_value = REPLACE (option_value, 'eemshop.com', 'gufshop.com' );
修改wp_options表中option_value字段的eemshop.com修改为gufshop.com

常用数据库添加方法

CREATE DATABASE hwlshop-com DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

use database;

source /web/html/sql/shenhe1/eemshop200512.sql;
UPDATE wp_options SET option_value = REPLACE (option_value, 'eemshop.com', 'hwlshop.com' );

source /web/html/sql/shenhe2/qoashop200622.sql;
UPDATE wp_options SET option_value = REPLACE (option_value, 'qoashop.com', 'hwlshop.com' );

source /web/html/sql/shenhe3/qftshop200512.sql;
UPDATE wp_options SET option_value = REPLACE (option_value, 'qftshop.com', 'hwlshop.com' );