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