We do my mysql database transplant, move from one server below. The operating system is Red Hat Linux
View system status
> show status
2. View the current process
> show processlist
There is no problem, but all the tables are only read-only, and they begin to be a problem with user permission settings. It is no problem.
Finally, I think that we are copying the table file directly, it must be related to Linux system privileges, and the results are like this. I really didn't think it was true. After we change system permissions, the database is normal.
The above little experience, but I feel worth a record.
