It can be useful on a Linux server to sort all of the files in a directory by date. Sometimes you may want to backup files older than a certain date or you may just want to see what is in a directory and what date those files were created. Use the information below to list all of the files in a directory sorted by date.

Read the rest of this entry »

Dump MySQL database: Use the below mysqldump command syntax to dump a single database from a MySQL

mysqldump -u root -ppassword database_name > database_staging-04-14-2008.sql

Dump One Table from a MySQL DB: The below syntax will dump one MySQL table including the SQL syntax needed to drop that table if it already exists in the database you eventually restore it to.

Read the rest of this entry »