I had to reset my dedicated server, so i backuped the whole /var/lib/mysql directory (stored in OVH Backup Storage).
Today on my clean dedicated, i reinstalled mariadb and so putted the whole /var/lib/mysql directory of the backup into /var/lib/mysql (the new). I just copied the databases directories (i also have other files like ibdata etc.).
But the MariaDB files don't load, so i tried running the following:
mysqlcheck -u root -p --auto-repair --all-databases
And i get tons of Table "..." doesn't exists, while i copied the database directory.
So i gave a run copying the ibdata file, and mariadb wasn't starting anymore.
Do anyone have a solution for copying my MariaDB databases?
I also chowned the directory
I see pretty much everywhere peoples talking about a .ibd file needed, while backuping that file wasn't displayed and not saved. As i said i use MariaDB and i also have an ibdata file.