以前的博客放在A空间上,后来备份,通过phpmyadmin导出sql文件现在换到B空间上,建好数据库之后,通过phpmyadmin导入sql文件(500k),结果出错Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/export.php:190) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/ob.lib.php on line 83Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/export.php:190) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_http.inc.php on line 22Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/export.php:190) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/header_http.inc.php on line 23Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/export.php:190) in /usr/local/cpanel/base/3rdparty/phpMy[...] MySQL 返回: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<br />
<b>Warning</b>: Cannot modify header information - headers already sent ' at line 1
如果导入在A空间早期备份的sql文件,结果没事,就是最后一次备份的sql文件不行。
<b>Warning</b>: Cannot modify header information - headers already sent ' at line 1
如果导入在A空间早期备份的sql文件,结果没事,就是最后一次备份的sql文件不行。
可以先试一半,没问题则说明后一半有问题,然后再分为两半一直找到第一次错误,把语句贴出来看一下。
就是最近备份的sql文件导入不行,换以前备份的sql文件导入则没有问题,网站我没动过,就是在后台添加文章,奇怪了