我想把windows中mysql的数据导入到linux下面,导入导出是不报错的,在window下的web应用程序运行正常,当导入数据到linux下后,运行程序总是报错,出错信息如下
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: 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 '' at line 1
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1027)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3361)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3295)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1852)mysql在windows中信息是
mysql> show variables like "character_set%";
| Variable_name  | Value
| character_set  | latin1                                                                    |
| character_sets | latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 uji
s dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 est
onia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
2 rows in set (0.00 sec)mysql> \s
--------------
mysql  Ver 12.22 Distrib 4.0.18, for Win95/Win98 (i32)Connection id:          881
Current database:       snto
Current user:           root@localhost
SSL:                    Not in use
Server version:         4.0.18-nt
Protocol version:       10
Connection:             localhost via TCP/IP
Client characterset:    latin1
Server characterset:    latin1
TCP port:               3306
Uptime:                 11 days 19 hours 5 min 50 secThreads: 2  Questions: 42658  Slow queries: 3  Opens: 4727  Flush tables: 1  Ope
n tables: 0  Queries per second avg: 0.042mysql linux中的配置如下
[root@wqweb mysql]# mysql -u root -p sss
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -AWelcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 25 to server version: 4.1.12Type 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> \s
--------------
mysql  Ver 14.7 Distrib 4.1.12, for redhat-linux-gnu (i386) using readline 4.3Connection id:          25
Current database:       snto
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         4.1.12
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:            /var/lib/mysql/mysql.sock
Uptime:                 18 days 1 hour 18 min 19 secThreads: 1  Questions: 11978  Slow queries: 0  Opens: 10  Flush tables: 7  Open
tables: 10  Queries per second avg: 0.008
--------------mysql> show variables like "character_set%";
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | latin1                     |
| character_set_connection | latin1                     |
| character_set_database   | latin1                     |
| character_set_results    | latin1                     |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
7 rows in set (0.00 sec)
请问这种问题如何解决