I have an old server backup with MySQL data files in /var/lib/mysql and I need to access the data inside of one of the databases inside that directory. I unfortunately don't have any SQL-dumps of the database. only these files.
The backed up files is from a MySQL-server with version 5.0.51a and the current server has the version 5.1.49.
I tried the obvious, stopping the MySQL-server, copying (while preserving permissions) the database directory from my/backup/folder/databasename to /var/lib/mysql/databasename and starting the MySQL-server again. That created the databases but they where empty.
How can I extract the data?
(I'm running the server on a Debian system)