Technology Insights

Using mysqldump to Backup MySQL Databases and Restoring with mysql

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

bash

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