Starting a temporary MySQL instance for table/DB recovery
In this example we assume a restored backup of mysql’s datadir exists at /mnt/restore/mysql. mysqld –port=3307 –socket=/mnt/restore/mysql/tmp.sock –datadir=/mnt/restore/mysql –pid-file=/mnt/restore/mysql/tmp.pid –user=mysql If the backups are ‘dirty’ and innoDB corruption won’t let it start, you can try –innodb-force-recovery=N if needed (start with N = 1 and go up to 4 as neccesary). If the instance was part […]