Posts Tagged ‘backup

How to Backup a MySQL Database With mysqldump
mysqldump -u userNameWithPrivileges -p databaseName > outputFileName.sql
How to Restore a mysqldump Backup
mysql -u userNameWithPrivileges -p database < outputFileName.sql
* Replace “userNameWithPrivileges” with the username of a MySQL account that can read/write to the database being backed up / restored.

Most of the instructions for mirroring a directory with Rsync involve mirroring the data to a different server. You can also use Rsync to sync or mirror a directory on the same computer as the source directory.
Here is an example command on how to mirror two directories locally. In this example, /home/apache/public_html is the source [...]


About this blog

This blog is about technology related topics. It will primarily contain problems and solutions to IT problems that I encounter on a day-to-day basis. In addition interesting things I come across either on or off the internet will be posted here as well. I will also include step-by-step tutorials to common tasks people may need to do with their computers.

Web Hosting Discount

    Get the first month for only $0.01 using coupon code HGCOUPONBLOG. No contracts, cancel anytime.

Revolutionary One Time Password Device

Add to Technorati Favorites