之前博客数据库在国内 后来申请了个免费国外的空间就打算放到国外试试。但是数据库导入了几次都不成功。最后百度了 没有找到合适的解决办法
最终自己摸索到了问题
我这里拿
数据库举例说明譬如:下面这段
——————————————————————————
—
— 表的结构 `wp_ap_watermark`
—
CREATE TABLE IF NOT EXISTS `wp_ap_watermark` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`wm_type` tinyint(3) NOT NULL DEFAULT '0',
`wm_position` tinyint(3) NOT NULL DEFAULT '9',
`wm_font` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
`wm_text` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
`wm_size` smallint(5) DEFAULT '16',
`wm_color` varchar(100) COLLATE utf8_unicode_ci DEFAULT '#ffffff',
`x_adjustment` smallint(5) DEFAULT '0',
`y_adjustment` smallint(5) DEFAULT '0',
`transparency` smallint(5) DEFAULT '80',
`upload_image` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
`upload_image_url` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
`min_width` smallint(5) DEFAULT '150',
`min_height` smallint(5) DEFAULT '150',
`jpeg_quality` smallint(5) DEFAULT '90',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
—
— 转存表中的数据 `wp_ap_watermark`
—
INSERT INTO `wp_ap_watermark` (`id`, `name`, `wm_type`, `wm_position`, `wm_font`, `wm_text`, `wm_size`, `wm_color`, `x_adjustment`, `y_adjustment`, `transparency`, `upload_image`, `upload_image_url`, `min_width`, `min_height`, `jpeg_quality`) VALUES
(1, 'Default Watermark', 1, 9, '', 'http://blog.gycq.net', 16, '#ffffff', 0, 0, 80, '/home/ftp/s/suiyua11/wwwroot/wp-content/plugins/wp-autopost-pro/watermark/uploads/watermark.png', 'http://blog.gycq.net/wp-content/plugins/wp-autopost-pro/watermark/uploads/watermark.png', 150, 150, 90);
——————————————————————————
正常情况下是没有问题的,但可能是因为国外服务器无法读取中文 我把
—
— 表的结构 `wp_ap_watermark`
—
—
— 转存表中的数据 `wp_ap_watermark`
—
去掉 只复制
CREATE TABLE IF NOT EXISTS `wp_ap_watermark` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`wm_type` tinyint(3) NOT NULL DEFAULT '0',
`wm_position` tinyint(3) NOT NULL DEFAULT '9',
`wm_font` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
`wm_text` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
`wm_size` smallint(5) DEFAULT '16',
`wm_color` varchar(100) COLLATE utf8_unicode_ci DEFAULT '#ffffff',
`x_adjustment` smallint(5) DEFAULT '0',
`y_adjustment` smallint(5) DEFAULT '0',
`transparency` smallint(5) DEFAULT '80',
`upload_image` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
`upload_image_url` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
`min_width` smallint(5) DEFAULT '150',
`min_height` smallint(5) DEFAULT '150',
`jpeg_quality` smallint(5) DEFAULT '90',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;
INSERT
INTO `wp_ap_watermark` (`id`, `name`, `wm_type`, `wm_position`,
`wm_font`, `wm_text`, `wm_size`, `wm_color`, `x_adjustment`,
`y_adjustment`, `transparency`, `upload_image`, `upload_image_url`,
`min_width`, `min_height`, `jpeg_quality`) VALUES
(1, 'Default
Watermark', 1, 9, '', 'http://blog.gycq.net', 16, '#ffffff', 0, 0,
80,
'/home/ftp/s/suiyua11/wwwroot/wp-content/plugins/wp-autopost-pro/watermark/uploads/watermark.png',
'http://blog.gycq.net/wp-content/plugins/wp-autopost-pro/watermark/uploads/watermark.png',
150, 150, 90);
手动导入即可正常
就这样我一段一段的手动复制 sql查询导入 然后进入phpmyadmin查看表和字段全部正常 博客运行1个多月没发现问题。
做个记号 留个需要的同学用
总结:去掉中文注释 只导入数据库表和字段即可正常。国内服务器无须这样操作
无法评论吗