Used by
MySQL 5.7 - x64
Open Server - the last
heidisql

Completed export.
Reboot the server.
I went to the database, and instead of some tables, there appeared views with the names of the tables.

  1. From BD1 (located in FOLDER 1 ) I export BD1
  2. In DB2 (located in FOLDER 2 ) I import from the * .sql file from item 1

I attach the screen.
Left shows BD1 after export.
The right shows BD2 after import.

Question.
What is the reason?

enter image description here

enter image description here

When a new view is added to the BD1 for the "trg_01_test_log" table, everything works enter image description here

  • In perplexity. Export does not affect the database in any way. This is not an import, it only reads. - Akina
  • @Akina Added a question. Attached the screen. Quote: "Left shows BD1 after export. Right shows BD2 after import." - koverflow
  • @Mike supplemented the question. Attached the screen. Quote: "Left shows BD1 after export. Right shows BD2 after import." - koverflow
  • And try to create a normal view in any database. heidisql will also write "tablespace is missing" next to it? If this is not the case, then you need to find out where that tablespace where the tables were uploaded. - Mike
  • @Mike created. see the question - koverflow

0