Showing posts with label website. Show all posts
Showing posts with label website. Show all posts

Monday, March 30, 2009

Backup your SQL Database using SSH

I just found out about this very easy, efficient and incredibly fast way to back up SQL databases. Instead of trying to back up each table/database one by one into separate .sql or .zip files, I just access my web server using SSH via PUTTY and just use the following structure to dump each database into my root in .dump format:

mysqldump -h [hostname] -u [username] -p[password] [databasename] > [outputfile]

EXAMPLE:
mysqldump -hdbxxx.perfora.net -udbo1xxxxxx -pxxxxxx dbxxxxxxxx >OutputFile.dump

Later on when it is time to recover or move my database to another new Database or SQL Server, I just do the opposite using mysql instead of mysqldump:

mysql -h dbxx.perfora.net -u dboxxxxxxxx -p dbxxxxxxxx < dump_file.sql
Enter password:
mysql>

Tuesday, March 24, 2009

Letters & Documents

Did you ever find yourself trying to type up a professional letter to follow up that big job interview, or struggling to find things to say in response to that hefty bonus you received from your boss? Whatever the situation is, it is always best if you answered them professionally in writing.

When I was looking for a sample letter on the internet, I found this website:

http://insiderreports.com/resources/library/searchletters.asp?Query=old&qu=thank+you&FreeText=&RankBase=&pg=4&QType=w&SubjCatID=&prvbtn=-1&docsfnd=yes

Most of the letters are free, and with hundreds to choose from, you would be surprised to see some interesting ones among those.