Database Problem

[ACiD]

Hello There,

I'm trying to import C-C's database into my server. I tried doing it with phpmyadmin (didn't work), bigdump (didn't work), SSH ( tryed it 7 times, it worked on the 8 time) But I get this error:

ERROR 1064 (42000) at line 1004: 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 '722,'',1206314148)

I talked with Phantom and he told me to increase max_allowed_packet in mysql. I did that through SSH and I still got that error yet again. Do you guys have any resolution? I would appreicate it.

Thanks.

ACiD Reviewed by ACiD on 25th Jun 2009. Database Problem Hello There, I'm trying to import C-C's database into my server. I tried doing it with phpmyadmin (didn't work), bigdump (didn't work), SSH ( tryed it 7 times, it worked on the 8 time) But I get this error: I talked with Phantom and he told me to increase max_allowed_packet in mysql. I did that through SSH and I still got that error yet again. Do you guys have any resolution? I would appreicate it. <3 Thanks. Rating: 5

[JointRolla420]

Had this problem before when i tried importing another sites backup, if you turn off EXTENDED INSERTS when exporting the backup from phpmyadmin it will not do that.

[Loget]

Try doing this, make sure you have MySQL 5!:

#mysql --user -p
mysql> use database;
mysql>source ./db.sql
mysql>quit

[AoN]

Your database is Corrupt surely 100%, i have the same prob before!

[ACiD]

I highly doubt it's corrupted, Phantom had the same problem.

[r0ck]

doesn't sound corrupt whats that sql in that line and also one before and after??

[ACiD]

I fixed the problem, I split it the files, used bigdump and import it .

[r0ck]

ok i knew it wasnt corrupt

[Hx]

lol same forgot to post soz