How to replace existing tables when importing phpmyadmin?

Question

PHP

Hello!

In general, at work on denwere, I changed the project, added columns to the database, redid the file structure, but did not finish everything and took the files home. And in order not to copy tables separately, I copied the entire local database, along with system tables, like `performance_schema`.

I came home and actually phpmyadmin refuses to import the database, saying that the plates already exist that you can understand.

But how then to import, is it possible to somehow ignore matches?

Ps I was thinking through a notepad just to cut out the unnecessary from the dump, so there is so much to cut out that it's easier to shoot yourself

Answer 1

Well, you have the entire working database, what prevents you from creating a new, clean database and importing it into it? Or import into MySql Workbench

Answer 2

1. You need to remove a normal backup of a specific database, without system ones.
2. Instead of Denwer, they now use OpenServer and XAMPP.