whts this error??i am getting while importing database

[anuragblr]

hi
i am getting this error when i am importing my database by bigdump

Stopped at the line 3017.
At this place the current query includes more than 300 dump lines. That can happen if your dump file was created by some tool which doesn't place a semicolon followed by a linebreak at the end of each query, or if your dump contains extended inserts

whts this error can any one tell me...

thanks

 

[loki]

your SQL dump contains queries that are too long for the
importing tool. If you can make another SQL dump file, try disabling the
"extended inserts" option.

 

[anuragblr]

hi
when i am trying to export new sql dump by disabling extended inserts its taking backup of few bytes

 

[Xman]

use mysqldumper and set it to log errors and continue under options

 

[Xman]

it supports extended quotes

 

[anuragblr]

can u tell me where i should cofigure mysql dumper for database username and passw and database

helllo can any one help me....

 

[xmsax]

Why not directly do this via SSH? since you are a web hosting compagny... maybe i'm wrong but you should be able to do simple task like this without problem.

 

[anuragblr]

no this is not the case i just wanna learn hw to use it ..i can do it by ssh

 

[xmsax]

From: http://underhost.us/forums/tutorial...ase-via-ssh-upload-sql-database-via-root.html


Restoring from FILENAME.mysql is a three step process:

Drop the database

mysqladmin -u USERNAME -p drop DATABASE

Recreate the database

mysqladmin -u USERNAME -p create DATABASE

Import the backup data

mysql -u USERNAME -p DATABASE < FILENAME.mysql