cat backup.sql | mysql -umyname -pmypass mydbname .... (как указать таблицы table1 table2)
  • In the framework shown, no way. The SQL dump is just a bunch of consecutive queries for the MySQL server. And these queries are not tied to the tables by the word “absolutely”, and at the stage of their execution it is already too late. The simplest solution is to deploy the dump to a temporary database and then move only the necessary tables to the worker. This is the case if there are already tables and data in the database, and only some of them need to be updated. Otherwise, just deploy the entire backup, and then delete the excess. Of course, all this in the event that it is not possible to influence the CREATION of the dump - it is then easier to eliminate unnecessary tables. - Akina
  • Thanks for the idea from the temporary database! So probably I will. - user240413

0