国外服务器无法导入数据库可能存在的原因

之前博客数据库在国内 后来申请了个免费国外的空间就打算放到国外试试。但是数据库导入了几次都不成功。最后百度了 没有找到合适的解决办法

最终自己摸索到了问题

我这里拿WordPress数据库举例说明

譬如：下面这段

——————————————————————————

—
— 表的结构 `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个多月没发现问题。

做个记号 留个需要的同学用

总结：去掉中文注释 只导入数据库表和字段即可正常。国内服务器无须这样操作