How to use MySQL 5 Part 5: Backup Data |
||||||||||||
This article and tutorial describes and demonstrates how you can:
-
[ click here ] Backup data using the MYSQLDUMP command
The MySQL MYSQLDUMP command is how you can save information in databases and tables. It is the primary way of backing up information in your mysql database.
MYSQLDUMP SYNTAX
Steps To Save Data using the |
Visual Demonstration |
|---|---|
|
Syntax:
mysqldump -umyuserame -pmypassword mydatabase >mybackupfilename.sql
" The mysqldump client is a backup program originally written by Igor Romanenko. It can be used to dump a database or a collection of databases for backup or transfer to another SQL server (not necessarily a MySQL server). The dump typically contains SQL statements to create the table, populate it, or both. ... "
[ return to top ]












