折腾:
【已解决】备份导出本地Wordpress数据库用于迁移到在线网站
之后,需要先去:在线服务器中按照全新的WordPress
把本地的:
wordpress-4.9.7.zip
![](https://www.crifan.com/files/pic/uploads/2021/05/c7a5e8bfb5f44a2aa9cb7fb392e52e6a.jpg)
用Filezilla通过SFTP上传上去:
![](https://www.crifan.com/files/pic/uploads/2021/05/9a2ce9ab50534ddd8f7bf5fc086aed5a.jpg)
然后上去解压并确保WordPress解压后的文件是在根目录:
![](https://www.crifan.com/files/pic/uploads/2021/05/0aea9adbd6a8437a87c78b507b1dbe30.jpg)
然后再去页面中安装:
结果又自动跳转到:
换成:
记错了,去搜:
wordpress 安装
zh-cn:安装 WordPress « WordPress Codex
https://codex.wordpress.org/zh-cn:安装_WordPress
需要先创建数据库
所以去:
结果打不开:
![](https://www.crifan.com/files/pic/uploads/2021/05/21f3b02111414589ada45ee3ebdc95c1.jpg)
终于想起来了:
此处是由于安装了虚拟主机xxx.com的域名
然后之前的能默认打开的
phpMyAdmin
等地址,都打不开了
那去把之前的phpMyAdmin目录,整个拷贝过来,看看能否使用
然后去看到是之前default中才有phpMyAdmin等内容:
![](https://www.crifan.com/files/pic/uploads/2021/05/52c3ba3c08dd4cb488784e90adb7f20b.jpg)
[root@izj6cefkuu3496m71s907xz default]# tree -L 1 . . ├── index.html ├── ocp.php ├── phpinfo.php ├── phpMyAdmin └── prober.php 1 directory, 4 files [root@izj6cefkuu3496m71s907xz default]# pwd /data/wwwroot/default
然后去拷贝到新建的tools文件夹下:
[root@izj6cefkuu3496m71s907xz www.xxx.com ]# cp /data/wwwroot/default/p phpinfo.php phpMyAdmin/ prober.php [root@izj6cefkuu3496m71s907xz www.xxx.com ]# cp /data/wwwroot/default/phpMyAdmin/ tools/ cp: omitting directory ‘/data/wwwroot/default/phpMyAdmin/’ [root@izj6cefkuu3496m71s907xz www.xxx.com ]# cp -r /data/wwwroot/default/phpMyAdmin/ tools/phpMyAdmin
然后就有了:
![](https://www.crifan.com/files/pic/uploads/2021/05/9987c37534c14aebb77f63e5bb268e40.jpg)
然后再去访问:
(试了半天,终于可以访问了)
去新建mysql数据库
![](https://www.crifan.com/files/pic/uploads/2021/05/9c60713d31634f2aafc2a32be5e2d98e.jpg)
www.xxx.com / localhost | phpMyAdmin 4.8.2
![](https://www.crifan.com/files/pic/uploads/2021/05/7a69094926c84d05bcfafb6476ca0ffe.jpg)
xxx
utf8mb4_general_ci
![](https://www.crifan.com/files/pic/uploads/2021/05/3d183dc38f384ffa853e755e7cc3b309.jpg)
然后再去创建用户
![](https://www.crifan.com/files/pic/uploads/2021/05/f1a5bc16f0b440e3aaffcb310d045bc0.jpg)
用户名:xxx
密码:Lee560710
![](https://www.crifan.com/files/pic/uploads/2021/05/24b8efedeff0447f985d5f8e96d7a014.jpg)
![](https://www.crifan.com/files/pic/uploads/2021/05/912a174ef72649ae91d5e7fead540c49.jpg)
![](https://www.crifan.com/files/pic/uploads/2021/05/af20543f2d79469d93f8f3865dd2425e.jpg)
![](https://www.crifan.com/files/pic/uploads/2021/05/c5b9ac8802c0493ea437bb0620345c0c.jpg)
![](https://www.crifan.com/files/pic/uploads/2021/05/66d7dc908f81452fb1f3dc76941129ef.jpg)
从wp-config-sample.php 拷贝出:wp-config.php
修改配置:
![](https://www.crifan.com/files/pic/uploads/2021/05/df4f5a4a3a034301894b3145da986d68.jpg)
其中:
打开:
拷贝返回的数据:
![](https://www.crifan.com/files/pic/uploads/2021/05/cacfde2274574cdc94d083c64b4a6391.jpg)
![](https://www.crifan.com/files/pic/uploads/2021/05/d2b096718757418281ae6bb9ab163a87.jpg)
然后把修改好的wp-config.php上传到服务器中:
去访问:
以安装
结果https有问题,又没打开
去试试:
也不行,还是会自动跳转到:
最后终于可以打开:
![](https://www.crifan.com/files/pic/uploads/2021/05/e4e96e7c57a74afaad863a8d9a7c463d.jpg)
后来过了几天,再去打开:
会自动转到https,且由于是没有安装过,所以会自动跳转到:
![](https://www.crifan.com/files/pic/uploads/2021/05/119270229a06438b97285c9d83f35195.jpg)
那就可以去安装了。
![](https://www.crifan.com/files/pic/uploads/2021/05/59feec20b27f48128ae36e1a0a8093a5.jpg)
![](https://www.crifan.com/files/pic/uploads/2021/05/51768fed0fa14772ab187b4ac1f823fe.jpg)
然后去登陆:
![](https://www.crifan.com/files/pic/uploads/2021/05/2087a48793c24d3583981f5d961c4b88.jpg)
![](https://www.crifan.com/files/pic/uploads/2021/05/f7be972a824947e596e5e7cbaf2eda4e.jpg)
【记录】在线WordPress中用插件All in One WP Migration实现迁移到在线环境网站搬家