Categories
Linux UNIX

MySQL – Backup & Restore A Database

Dump all databases mysqldump -u <USERNAME> -p<PASSWORD> –all-databases > alldatabases.sql Dump Multiple/Specific Databases mysqldump -u <USERNAME> -p<PASSWORD> -databases db_name1 [db_name2 …] > alldatabases.sql Dump (Backup) A Single Database mysqldump -u <USERNAME> -p<PASSWORD> <DATABASE_NAME> > <DATABASE_NAME>.sql Restore A Single Database mysql -u <USERNAME> -p<PASSWORD> <DATABASE_NAME> < <DATABASE_NAME>.sql

Categories
Code Linux UNIX

rsync

Everyone backs up their data. The problem I ran into is that I have 2TB’s of data to backup, and I couldn’t find a cloud based solution that uploaded my data fast enough. So, I went to plan B. As you can tell by the title of this blog, I am going to use rsync. […]

Categories
Internet MAC Technology

Backup Address Book on MAC

Most of us have joined the icloud extravaganza and are now dependent on Apple not losing our data. Just imagine how upset you would be if you all of a sudden lost all your contacts. I personally am running OSX Lion 10.7.2 and I’m going to show you a simple way to backup your Address […]

Categories
MAC

Local Time Machine Backups

Have you noticed that you’ve lost a good portion of your hard drive space ever sense you upgraded to OSX Lion? This may be due to a Time Machine feature that now does local backups when your Time Machine hard drive is not connected. Why would Apple do this?By creating local snapshots/bakups allows the user […]