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 [...]

• View 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 [...]

• View Comments