My SSD got corrupted. I made a clone of it on an HDD and I have access to all original files from
I want to import
that_database back, but I can't.
What I've tried already
Copying the database files themselves
I tried to copy the raw files, and it didn't work:
show tables works, but queries end with
that_database.TableName does not exist.
Copying the entire
One of the
sys databases are corrupted. After the files were copied, I tried to restart the server and it cannot start.
$ sudo service mysql start Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details. $ systemctl status mysql.service ● mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Mon 2018-04-23 13:50:01 EEST; 2s ago Process: 23954 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid (code=exited, status=1/FAILURE) Process: 23945 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS) Main PID: 22245 (code=exited, status=0/SUCCESS) apr 23 13:50:01 notebook systemd: mysql.service: Service hold-off time over, scheduling restart. apr 23 13:50:01 notebook systemd: mysql.service: Scheduled restart job, restart counter is at 5. apr 23 13:50:01 notebook systemd: Stopped MySQL Community Server. apr 23 13:50:01 notebook systemd: mysql.service: Start request repeated too quickly. apr 23 13:50:01 notebook systemd: mysql.service: Failed with result 'exit-code'. apr 23 13:50:01 notebook systemd: Failed to start MySQL Community Server.
How can I recover this database?