samedi 25 juin 2016

How to restore MySQL databases from database files?

Our MySQL on Ubuntu 15.04 stopped working after we moved the computer to a new location and kept giving the missing socket file error. We couldn't really fix it after trying sudo apt-get install -f and there was an error about mysql-server-5.6 being corrupted. So after a lot of trail and error I was able to remove mysql-server-5.6 following commands here : http://askubuntu.com/questions/172514/how-do-i-uninstall-mysqli sudo apt-get remove --purge mysql-server mysql-client mysql-common sudo apt-get autoremove sudo apt-get autoclean sudo rm -rf /var/lib/mysql sudo rm -rf /etc/mysql Afterwards, I reinstalled mysql server by: sudo apt-get install mysql-client mysql-server Then when I tried mysql -u root -p and inside mysql, I couldn't see any previous databases.. I now realized that I've removed the /etc/mysql/my.cnf file from the system and my understanding is that mysql doesn't know where the databases files are and they haven't been loaded into the databases yet. I should also mention that, the /etc/mysql/my.cnf file is basically empty with these two lines: !includedir /etc/mysql/conf.d/ !includedir /etc/mysql/mysql.conf.d/ I have .sql files for each database from a previous logical backup in February. The issue is that I don't know if there were any updates between the February backup and now (as I'm new to manage this database). I also have the path to a directory (let's call it a B directory) that contains what I believe the database files as many directories names match the database names. And in this B directory, many directories seem to be modified after February so it's very likely there were updates. I understand I could use the following command to restore the February backup. mysql -u username -p database_name < file.sql But I'm wondering if there is any possibility to bring those updated database files back to life to MySQL. If so, how to do this? I'm guessing I need to somehow restore the previous /etc/mysql/my.cnf file.. but not sure what are required lines to put from this list I found: http://www.fromdual.com/mysql-configuration-file-sample I'm not very familiar with MySQL backup and I'm still reading about mysqldump and what it does. I'm wondering if I can use the February .sql files and somehow apply it to the latest mysql database files??? Hopefully this and the title are clear.. Thanks so much for the help!

Aucun commentaire:

Enregistrer un commentaire