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

[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]

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

[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

[Gavo]

Just ask the host to run the command


mysql youruser_database < /home/youruser/database.sql

The shell window can be closed and the import will carry on