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

Spending most of the day optimizing a page that (when I began) took 8.6 seconds to execute. Using some basic profiling techniques helped tremendously in not wasting my time and efforts attempting to optimize a portion of code that won’t yield appreciable gains.
The time intensive code for applications I write generally fall into either [...]

• Comments