Skip to content

Back_Up_SQL

Jump to bottom
Akkarinage edited this page Nov 5, 2016 · 1 revision

Home

Getting Started

Configure your Server

Customization

Setup the Client

Misc Databases

Third-Party Software

Clone this wiki locally

title: Back Up SQL permalink: /Back_Up_SQL/

Creating A Backup

Issue this command from a Unix terminal:

For single database:

   mysqldump -u (username) -p database_name > database_name.sql

For multiple database: (one output)

   mysqldump -u (username) -p --databases database_name_1 database_name_2 > 2_databases.sql

All databases:

   mysqldump -u root -p --all-databases > all_databases.sql