views:

89

answers:

1

After a reinstall, all of the old data still shows inside the MySQL/data folder, but is not actually loaded into the database.

Is there any way to have MySQL scan it's data folder and / or reimport the old folders it has from its previous install?

[Some data was changed after the last backup / export - partially my fault - so I would rather it recognize the folders rather than reimporting the SQL files.]

+1  A: 

If the data is in the correct folder, it will be visible in MySQL, or you will get errors when the server starts. Check /var/log/messages and your MySQL error log (as defined in your config).

If you don't get any errors and can't see the data, it's likely that the data path in my.cnf is pointing to a different folder.

Andy
You were right about the issue, although the path to the data folder is actually set in "my.ini". my.cnf does not exist (searched the whole hard drive), and I'm not sure what log file you refer to. But no matter... it works. Thanks.
SamGoody
No problem. `my.ini` is the Windows version of `my.cnf` - MySQL is used far more often on Linux based systems, so I made the assumption with no OS info in the question. Your log file is defined in your config's `ErrorLog` directive. Worth an upvote perhaps? :)
Andy