1.上传版本解压
上传data_wkz.tar.gz wwwroot.tar.gz到根目录
解压文件data_wkz.tar.gz 到/data目录
tar xvf data_wkz.tar.gz -C /data
解压文件wwwroot.tar.gz 到/www/wwwroot目录
tar xvf wwwroot.tar.gz -C/www/wwwroot
解压命命令
cd /
tar xvf data_wkz.tar.gz -C /data 注意有的服务器没有data 自己建一个
tar xvf wwwroot.tar.gz -C/www/wwwroot
2.宝塔设置数据库密码 123456
登入数据库
mysql -uroot -p123456
创建数据库
CREATE DATABASE IF NOT EXISTS all_plat_dc DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
CREATE DATABASE IF NOT EXISTS backend DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
CREATE DATABASE IF NOT EXISTS game_config_dc DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE IF NOT EXISTS game_xy_1 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE IF NOT EXISTS game_xy_2 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE IF NOT EXISTS gamelog_xy_1 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE IF NOT EXISTS gamelog_xy_2 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE IF NOT EXISTS gamelog_xy_1000005 DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
CREATE DATABASE IF NOT EXISTS gamelog_xy_dc DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE IF NOT EXISTS gameweb DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE IF NOT EXISTS gameweblog_xy DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE IF NOT EXISTS listserver_config_tlh5 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE IF NOT EXISTS one_plat_xy_dc DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
CREATE DATABASE IF NOT EXISTS payment DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE IF NOT EXISTS user DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
quit 退出
导入数据库文件
cd /data/data_wkz/sjk
mysql -uroot -p123456 --default-character-set=utf8 all_plat_dc < all_plat_dc.sql
mysql -uroot -p123456 --default-character-set=utf8 backend < backend.sql
mysql -uroot -p123456 --default-character-set=utf8 game_config_dc < game_config_dc.sql
mysql -uroot -p123456 --default-character-set=utf8 game_xy_1 < game_xy_1.sql
mysql -uroot -p123456 --default-character-set=utf8 game_xy_2 < game_xy_2.sql
mysql -uroot -p123456 --default-character-set=utf8 gamelog_xy_1 < gamelog_xy_1.sql
mysql -uroot -p123456 --default-character-set=utf8 gamelog_xy_2 < gamelog_xy_2.sql
mysql -uroot -p123456 --default-character-set=utf8 gamelog_xy_1000005 < gamelog_xy_1000005.sql
mysql -uroot -p123456 --default-character-set=utf8 gamelog_xy_dc < gamelog_xy_dc.sql
mysql -uroot -p123456 --default-character-set=utf8 gameweb < gameweb.sql
mysql -uroot -p123456 --default-character-set=utf8 gameweblog_xy < gameweblog_xy.sql
mysql -uroot -p123456 --default-character-set=utf8 listserver_config_tlh5 < listserver_config_tlh5.sql
mysql -uroot -p123456 --default-character-set=utf8 one_plat_xy_dc < one_plat_xy_dc.sql
mysql -uroot -p123456 --default-character-set=utf8 payment < payment.sql
mysql -uroot -p123456 --default-character-set=utf8 user < user.sql
等待导入数据库
导入完毕 检查导入情况 没有问题 如果导入失败里面是没有表的