O
O
Optimus2016-09-30 18:51:42
linux
Optimus, 2016-09-30 18:51:42

Where to dig when hanging when importing a database?

After command

mysql -u username -p -h localhost newdb < olddb.sql

A password was requested, and after entering the password, this picture is already an hour old:
33fc8b2ce74840faae6e11b8aba58c17.png
At the same time, the database weighs only 1.4 GB?
What can be done to diagnose the problem?
var/log/mysql.log is empty

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Vladimir, 2016-09-30
Pyan @marrk2

open another ssh session,
run mysqladmin pr, or if the first one doesn't work, then in the mysql console, the show processlist command;
there will be the status of current requests, etc. if the dump is being filled for a long time, you will see something like INSERT VALUES blah blah blah

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question