![mysql](https://skayal.com/wp-content/uploads/2020/02/kisspng-mysql-database-web-development-computer-icons-mysql-5b2cc2f3399385.0469886115296601472359.png)
30
Nov
* Take dump of all databases:
# mysqldump --skip-lock-tables -A > alldb.sql
*
* Check where MySQL keeps its files(in my case it's /var/lib/mysql/):
# mysql -NBe "SELECT @@datadir"
* /var/lib/mysql/
*
* Stop MySQL
# mysqladmin shut
*
* Move old MySQL files to safe place
# mv /var/lib/mysql /var/lib/mysql.old
*
* Create new system database
# mkdir /var/lib/mysql
* # sudo apt-get install mysql-server
*
* Start MySQL
# /etc/init.d/mysql start
*
* Restore the dump
# mysql < alldb.sql