|
|
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 ]
|
|
|
| Highlighted Products |
|
|
Email Pack
BitDaddys Corp.
$39.95
More Info
Buy Now!
|
|
Email conversion and action pack. Get all of our powerful email utilities for one very low price! more ... |
|
|
|
|
ThunderStor
BitDaddys Corp.
$10
More Info
Free Trial
Buy Now!
|
|
ThunderStor offers the user a simple, fast and effective method to extract ThunderBird Mail from the mail box files to individual standard email message files. |
|
|
|
|
|
|
|
CSV2DG
BitDaddys Corp.
$10.00
More Info
Free Trial
Buy Now!
|
|
Create, Edit, Import and Display CSV ( Comma Separated Values) files in an easy to use Data Grid with the ability to print, launch Excel or even launch a custom application. This application allows for quick edit and display of csv data in a format that allows for easy viewing, sorting and printing. You can also customize the apparent program name, company name, report title and visible options more... |
|
|
|
|
|
|
|
PopTransAct
BitDaddys Corp.
$19.95
More Info
Free Trial
Buy Now!
|
|
POP3 Email Transfers and Actions. Extract, Archive Save and Merge Attachments. Archive and forward Messages from any POP3 Account, even gmail! more ... |
|
|
|
|
|
|
|
|
|
|
emlBridge
BitDaddys Corp.
$12.00
More Info
Free Trial
Buy Now!
|
|
Import eml Files into nearly any Email Client. With emlBridge you can import rfc822 standard text email files into programs like Outlook, Thunderbird and Outlook Express more ... |
|
|
|
