Sometimes, taking a few minutes to do a simple thing will save you a headache down the road.  Like changing the oil in your car, or brushing your teeth every night, or automatically backing up your databases.
The development server that I mess around on has recently accumulated a lot of data that I really don’t [...]

• Comments

The info is available everywhere but for those who want it spoon fed into their eager mouths here goes:
To dump a database to an optimized sql file and then tar/gz compress the file:
> mysqldump –opt database > database.sql
> tar -czvf database.tar.gz database.sql
To export a database from the local mysql server to a remote mysql server:
> [...]

• Comments