November, 2008

...now browsing by month

 

MYSQL Backup Quickie

Saturday, November 22nd, 2008

Okay, due to timing I will be adding very quick tutorials/notes for myself.  Selfish I know, but it could prove to be of use to starters as well.

If you have your SSH handy + access to working with your database, run the following command to backup your database.

mysqldump -username -password databaseName > nameoffile.sql

So, for example - if you have a root account with the password Password and a database named MyDB and you wanted to call the backup MyDBBackup.sql and save the file into your /home/username directory.

mysqldump -root -p MyDB > /home/username/MyDBBackup.sql

Lack of Posts Lately

Saturday, November 22nd, 2008

Greetings all,

I apologize lately for the lack of posts.  It seems as though RadNet in Radford, VA offers a very poor service in terms of wireless Internet service.  Hopefully once they get their stuff together (or if I change providers), I”ll be able to post more often.