Restore MySQL Database from FileSystem Backup

Always backup your  MySQL database with mysqldump but if you didn’t you can restore it from file system.

If your backup include the /var/lib/mysql directory, if so then you should be able to restore the database. Each database is contained in a separate subdirectory off /var/lib/mysql, so look for one named with the name of your database (WordPress or any other). To restore it, shutdown the mysql server first

sudo /etc/init.d/mysql stop

Copy the backup-ed directory into the same location on your new server, then restart mysql server

sudo /etc/init.d/mysql start

Note:- that its much better to take actual database dumps using the mysqldump command than to rely on this method. so for the future, you should schedule something like this:

mysqldump -h host -u user -ppassword --databases database1 database2 > myfile.dump

 


Troubleshooting an iPad That Keeps Asking For Your Password iTunes, Exchange or any

Are you having a problem where your iPad keeps asking you for a password? If you haven’t set up a passcode for your iPad but it keeps asking you for the iTunes password or sometimes exchange or any other email account password. This issue commonly occurs after an app download or update was interrupted, keeping the iPad from fully downloading the latest version of the app, and it is usually easy to solve.
Continue reading…