Resolve the problem of importing database "DROP TABLE IF EXISTS' WP_COMMENTMETA '"

A netizen raised a question tonight when he moved the website data from the Western Digital Virtual Host to the ECS, he built a pagoda panel, but when importing the database, he encountered the error of "DROP TABLE IF EXISTS' WP_COMMENTMETA '". It can be seen that the wp_commentmeta data table fails or the import is incomplete.

At present, Lao Zuo is ready to adopt new methods to solve his problems. I asked him what method he used to import the database, and he told me that it was imported with phpmyadmin. I felt that the package was lost due to the jam during the import process, and the imported database was not complete. So the database was duplicated when he continued the transmission again, so this problem occurred.

Lao Zuo plans to adopt two solutions. The first one is to try to clean up the database and upload it again using phpmyadmin. Next, I plan to import it using the MySQL command. But luckily, a database of nearly 8M was the first way to upload it. Maybe my network is not as stuck as his.

In this way, the problem will be solved.