MYSQL Error while Import via MYSQL Dumper (Error

[desibreaker]

hekko, i'm getting mysql error while i'm trying to import my mysql databse via mysqldumper.



can anyone help please?

desibreaker Reviewed by desibreaker on 24th Jul 2011. MYSQL Error while Import via MYSQL Dumper (Error hekko, i'm getting mysql error while i'm trying to import my mysql databse via mysqldumper. http://i.imgur.com/A4ICE.png can anyone help please? Rating: 5

[Lock Down]

Remove it drom the dump. It should restore ok.

Or you can try in the configuration > general section to set Error Handling while restoring to continue and log errors

[gfxguru]

Remove it drom the dump. It should restore ok.

Umm... ... i didn't understand what that meant.. can you explain that more..

i am having the same prob

[Lock Down]

Umm... ... i didn't understand what that meant.. can you explain that more..

i am having the same prob

The line in error is a comment line and not needed. Remove that line from the actual sql file or set mysqlDumper to ignore errors and continue.

[NewEraCracker]

Cpanel SQL backup file?

Restored via ssh with

mysql -u username -p database_name < filename.sql

[gfxguru]

i am also having the same problem with mysqldumper..

[DoctorX]

Did you export the database previously using MYSQL dump?
You should export and import by the same script so that it works without problems.
Also, you can use NEC solution.

[gfxguru]

Did you export the database previously using MYSQL dump?
You should export and import by the same script so that it works without problems.
Also, you can use NEC solution.

actually i took backup from ssh....but now restoring it via mysqldumper... but getting that error.

bigdump failed to restore.. timeout.

db size around 4gb

[DoctorX]

Then restore it via ssh, it won't take too much time ( around 20-30 min )

[gfxguru]

Then restore it via ssh, it won't take too much time ( around 20-30 min )

actually the new host is a shared server cpanel, so i dont have any ssh access... thats the only problem