MySQL Database issues
How to make a locally created MySQL table available for publishing to the server without prompting for information that the table does not exist.
------Solution--------------------
If it's all a MYISAM type of table, the copy used to be possible.
------Solution--------------------
Explore
In order to prevent accidents, it is best not to directly copy the packaging of this method, I have encountered several drops of the table, even if all your tables are MyISAM, it is not recommended to do so, the site table data too much. Sometimes really forget to ignore some of the characteristic format of the table, so that will cause irreparable loss, general enterprise data copy, are used shell command line way. There are other ways, of course.
Copy: Mysqldump-u user name-p password database name > backup name. sql
Recovery: Mysql-u user name-P secret ...
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
