How can I enable the newly created mysql table to be used when published to the server without prompting that the table does not exist. ------ Solution ------------------ if all tables of the MYISAM type are copied in the past, it is also possible ------ solution ------------------ it is recommended that you do not directly copy the packaging method to prevent exceptions, I have encountered several table drop issues in the mysql database.
How to make the newly created mysql table still available when published to the server without prompting that the table does not exist.
------ Solution --------------------
If all the tables are MYISAM tables, you can copy them.
------ Solution --------------------
Discussion
To prevent accidents, it is recommended that you do not copy and package the table directly. I have lost the table several times, even if all your tables are myisam, this is not recommended, there is too much data in the site table. Sometimes we forget to ignore tables in special formats, which will lead to irreparable losses. generally, enterprise data copying uses shell command lines. Of course there are other methods.
Copy: mysqldump-u username-p password database name> backup name. SQL
Restore: mysql-u username-p password ......
