Skip to content

Instantly share code, notes, and snippets.

@nshores

nshores/mysql_fix_db.sh

Created June 30, 2018 21:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nshores/8deeb0dd63930ea956634401cab898fa to your computer and use it in GitHub Desktop.
Save nshores/8deeb0dd63930ea956634401cab898fa to your computer and use it in GitHub Desktop.
Download ZIP
fix_mysql_db
Raw
mysql_fix_db.sh
#!/bin/bash
#Backup databases
echo Backing up databases
sudo mysql -Ns -e"SHOW DATABASES" > ~/db_list.txt
mkdir ~/db_backup/
cat ~/db_list.txt | while read i
echo Backing up $i
do sudo mysqldump "$i" > ~/db_backup/"$i".sql
done
#Remove MYSQL Db Files
echo Removing Database files
sudo rm -rf `ls -d /var/lib/mysql/* | grep -v "/var/lib/mysql/mysql"`
#Restore databases
sudo mysql < ~/db_backup/.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment