Find Sporting Goods on eBay
Video and Audio], Broadcasting and podcasting Real Time Media On The Net

[description], Story, any other text you want to use.

Backing Up And Restoring Your MySQL Database

 by: Vinu Thomas

If you've been using MySQL database to store your important data, it is imperative that you make a backup of your data to prevent any loss of data. This article shows you how to backup and restore data in your MySQL database. This process can also be used if you have to move your data to a new server.

Backing up your database

The quickest and easiest way to backup and restore your database would be to use MySQLDump. If you've got shell or telnet access to your server, you can backup MySQL data by issuing the mysqldump command. The syntax for the command is as follows.

mysqldump -u [uname] -p [pass] [dbname] > [backupfile.sql] [uname] - this is your database username [pass]- this is the password for your database [dbname] - the name of your database [backupfile.sql] - the filename for your database backup

To backup your database 'Customers' with the username 'sadmin' and password 'pass21' to a file custback.sql, you would issue the command

mysqldump -u sadmin -p pass21 Customers > custback.sql

Issuing this command will backup the database to custback.sql. This file can be copied to a safe location or a backup media and stored. For more information on MySQLDump, you can check out : http://www.mysql.com/doc/en/mysqldump.html

Restoring your database

If you have to re-build your database from scratch, you can easily restore the mysqldump file by issuing the following command. This method will not work if the tables already exist in your database.

mysql - u sadmin -p pass21 Customers < custback.sql

If you need to restore existing databases, you'll need to use MySQLImport. The syntax for mysqlimport is

mysqlimport [options] database textfile1

To restore your previously created custback.sql dump back to your Customers Database, you'd issue

mysqlimport -u sadmin -p pass21 Customers custback.sql

For more information on MySQLImport, you can check out : http://www.mysql.com/doc/en/mysqlimport.html

About The Author

Vinu Thomas is a consultant on Webdesign and Internet Technologies. His website is http://www.vinuthomas.com. You can discuss about this article or any PHP/MYSQL related issues in our Discussion Forums: http://www.vinuthomas.com/forum2.html


modem cable

Real Time Media On The Net
This is one of the best resources for information on Real Time Media On The Net you can possibly find. Follow our links to find more information on Real Time Media On The Net. We hope that we have all of the Real Time Media On The Net details that you could need.
Real Time Media On The Net

Shopping online for modem cable offers lots of benefits that you won't find shopping in a modem cable store or catalogue. For example, the Internet is always open - seven days a week, 24 hours a day.

Many modem cable bargains can only be found online. Shopping on the Internet is no less safe than shopping in a store or by mail. Keep the following tips in mind to help ensure that your modem cable shopping experience is a safe one.

Main Menu
Real Time Media On The Net
Site Map

Affiliate Ads, Links, news, etc.

News for 14-Nov-26

Source: BBC News - Home
Gorging on love

Source: BBC News - Home
Your pictures

Source: BBC News - Home
All heart

Source: BBC News - Home
Preserving Mali's rural life

Source: BBC News - Home
The longest kiss

Source: BBC News - Home
Libyan hijacker arrested in Malta

Source: BBC News - Home
Peter Frankopan: This year in history

Source: BBC News - Home
Syria: 'Moment of relief' for Aleppo children

Source: BBC News - Home
How phones changed the imagery of the American campaign

Source: BBC News - Home
500 years later


Links
Links
Links
Google

Broadcast On the Net | Law Meet | Broadcast On the Net | medical mailings
Copyright © 2005. Name of Site here. Last Updated: Saturday, 14-Nov-2026 00:07:56 MST.
Talk On The Net   RX Right!   Fantasy Football Update