How to use MySQL 5.0 to backup data!

Main Menu

Home

.net Network Security

Flash

Fireworks

PHP

DB/C

Java

Email File Extensions

EML email file extension

MSG email file extension

TNEF email file extension

TXT email file extension

HTML email file extension

Java Script

OISV - Organization of Independant Software Vendors - Charter Member

Recommended Links

Find good sites at

Web Master:

Keith Birchfield

	MySQL Data Backup Tool BitDaddys Corp. $12 More Info Free Trial Buy Now!
Automatic Daily MySQL Database backups. Powerful Backup Rotations. more ...

MySQL Tutorials Table Of Contents

Part 1: Start MySQL and Create Databases and Tables (Create)

Part 2: Add Data (Insert and Replace)

Part 3: Show Data (Select)

Part 4: Delete Data (Delete and Drop)

Part 5: Backup Data (Dump)

How to use C# and MySQL Connector/Net

How to use MySQL 5 Part 5: Backup Data
(greatly simplified)

This article and tutorial describes and demonstrates how you can:

[ click here ] Backup data using the MYSQLDUMP command

What is the MySQL 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

How do I backup data in MySQL 5 using the mysqldump command?

Steps To Save Data using the MySQL MYSQLDUMP Command	Visual Demonstration
Open the Command Line utility by Clicking on 'Start' and 'Run' and typing 'CMD' and pressing 'ok' Type 'mysqldump' Type -u and your username '-uusername' Type -p and your password '-ppassword' Type your database name 'mydatabase' Type a greater-than sign to put the results in to a file '>' Type the name of the file to put the results in 'mybackupfile.sql'

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

more info...

[ return to top ]

How to use MySQL 5 Part 5: Backup Data (greatly simplified)

MYSQLDUMP SYNTAX

How to use MySQL 5 Part 5: Backup Data
(greatly simplified)