Where did all the data go in mysql?

Question

MySQL

All with the upcoming!
I haven’t had time to drink yet, but the situation is as follows.
There was a database ;
the password was changed ; the
content manager stuffed goods;
I rebooted the server ;
the site did not rise with an error in accessing the database ; the new
password does not work; /mysql/mytable - and apparently nothing new was stored there, that is, the data hung in another place (for example, in memory, which is strange) now launched sbin/mysqld --innodb_log_file_size=5242880 --innodb_force_recovery=6 but the result is no longer I hope I did it wrong? where could the data be stored? Why did this happen and what to do next?
Upd Error 7 began to appear on the alter request - it is impossible to rename the file #sql-c1a_22a8.MYI to the table name.MYI errno: 2 - no such file or directory
Restarted mysql server and everything is as described above. I see that these files contain the data I need, but I don’t know what to rename, and it’s not clear whether all the data is there

Answer 1

For the future: backup at least with the help of mysqldump.

Answer 2

cat /etc/my.cnf | grep datadir
cat /etc/fstab
may have been mounted in "datadir" (or several levels above) the screw that died
ADD:
if the
innodb-file-per-table = 1 parameter is not set
and all tables were actually stored in innodb, then only the table structure is stored in the directory with the name of the database
; all table data in innodb is in one file ${datadir}/ibdata1