how to continue import sql file with remaining data using command line process?

Question

I have sql file which size is 2.36GB, after importing 500 MB data, my system is shutdown due to power supply die, how can i continue after 500 MB data, is there any solution?

I used this command:-

mysql -uroot -p client_data < C:/Users/uradeshk/Desktop/client_data.sql

What do you mean by power problem? Did the power supply die or are your resources used up? — Mad Dog Tannen
– Mad Dog Tannen, Commented Jul 29, 2014 at 10:49

Mad Dog Tannen · Accepted Answer · 2014-07-29 10:59:58Z

1

As far as i know, you have to restart. Since its a import of a sql file, you have to take the entire file.

Clear the table you inserted 500 MB into, unless it has DROP , CREATE statement in the file, then it will drop the table before it creates a new one.

TRUNCATE client_data;

mysql -uroot -p client_data < C:/Users/uradeshk/Desktop/client_data.sql

answered Jul 29, 2014 at 10:59

Mad Dog Tannen

7,2505 gold badges34 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to continue import sql file with remaining data using command line process?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related