Database Import and Export Problems

I copied and pasted the search database from the data directory of my mysql database at home, and then pasted it to the mysql data DIRECTORY on my friend's computer. When viewing the table, the system prompts: The table does not exist! How can this problem be solved ??

I copied and pasted the search database from the data directory of my mysql database at home, and then pasted it to the mysql data DIRECTORY on my friend's computer.

When viewing the table, the system prompts: The table does not exist!

How can this problem be solved ??

Reply content:

I copied and pasted the search database from the data directory of my mysql database at home, and then pasted it to the mysql data DIRECTORY on my friend's computer.

When viewing the table, the system prompts: The table does not exist!

How can this problem be solved ??

If the version on both sides is the same as the installation and configuration environment, you can. before copying, MYSQL on both sides must be stopped. Note: All files in data must be copied.

Try to fix the database. If you do not know if the row does not work, or manually create a table before overwriting the file.
A lot of information is stored in several system libraries, which is why copying files is useless. Therefore, you need to import and export data, and mysql provides this tool mysql_dump instead of file replication.