Shulou(Shulou.com)06/01 Report--

During the import of mysqldump, cheap (disabled) hands are pressed to ctrl+alt+z.

Causes this process to be terminated (paused) because ps-ef | grep mysql is executed when the viewing process is executed. And then you can see the progress.

Mysql-uroot-p

I guess the process has been suspended.

After the ctrl+c finishes the process, go to the console and query the imported table, which is also stuck.

View innodb_trx,innodb_waits,innodb_wait_locks

There's nothing wrong with the three forms.

Check the error log, which causes the following image to report an error.

The questions are shown in the figure:

Wow, it exploded in an instant.

Then look up the method on the Internet:

All are rebuilt after deleting the table: innodb_table_stats

Here are the steps:

1.

Use mysql

Mysql > show create table innodb_index_stats

ERROR1146 (42S02): Table'mysql.innodb_index_stats'doesn'texist

Delete the damaged table:

Drop table innodb_index_stats

2 rm drop the file under the mysql directory

Rebuilding tables: here comes the problem: where is the table creation sql?

Find /-name mysql_system_tables.sql

After finding the sql script, vi finds the corresponding sql-- > to build the table.

3 you may fail to build a table. Check whether there are any residual files in the mysql directory after the drop table, and if there is a rm drop. Rebuild the table

It can be done after the table is built successfully.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.