'()' problem at mysqldumping

[hanpedro]

'()' problem at mysqldumping

My box is centos 5.5 and mysql version is 5.0.28.

I backuped my data with this command:

mysqldump -uroot -p --default-character-set=euckr mydb > mydb.sql

But when I tried to restore mydb.sql, I got an error message where '()' is in '()' as the under-mentioned.

INSERT  IGNORE INTO `g4_visit` (`vi_id`, `vi_ip`, `vi_date`, `vi_time`, `vi_referer`, `vi_agent`) VALUES (344748,(test.rstd.sd),........),(.....

Is it possible to change outside '()' to other character for avoiding this problem?

[dalecosp]

Looks like you need some sort of quotes around those values.

There are several mysqldump options regarding quotes; I've never had an issue like this, so we might hope for someone who has to answer and tell you if you need to call mysqldump with some other options 🙂