Hi, I have problem with my MySQL database. After reinstall, I thought it's gonna be enough to move just the contents of "mysql/data" to the new installation. However, some tables doesn't work anymore and phpmyadmin says just "in use" or that it doesn't exist.. Is there any way to fix it?? Please! Thanks!
Probably. If the bundled manual version corresponds with the mysql version, then it was from 5.0.19 to 5.0.25.
While reinstalling, I usually download the latest version.
Make sure the data directory, all sub directories and files have the SAME user and group permission as the mysql program. It sounds like you probably make a copy and your copy took on the permissions of the user that made the copy instead of retaining the olf permissions. So when mysql tries to access the databases it can't as it doesn't have permission to access those files or directories.
I've reinstalled Windows but done all the actions on the same account - same username, same password (if you mean that).
It seems that only MyISAM tables are still working.
I bet you forgot to copy the ibdata files and ib_log files. That is where the actual data for INNODB tables is stored. The directories for the INNODB tables just contain the FRM files and don't contain any of the actual data.
So if you didn't copy those ib files you have lost all of the data.
I thought I did. Anyway, I've copied them again from backup and seems hopefully to wok. Thanks!
Could you please tell me more (or point to somewhere) about the mysql storage system? Are the MyISAM tables stored in the db folder and InnoDB in the IB files? Why the difference? Thanks!