Can I still import mysql tables if my sql dump includes information_schema database?

Question

I exported everything using phpmyadmin and now I can't import my databases anymore because I get errors on the information_schema.

Is it possible to choose what tables in the dump file to import?

Answer 1

Short answer: no.

PHPMyAdmin does not support table selection on import.

The easiest way to solve this issue is to export only the necessary tables. But if that is not possible, you can always manually remove the unnecessary tables with a text editor.

Answer 2

PHPMyAdmin's export just creates SQL file. Delete queries you want to omit and run the import