
Video and Audio], Broadcasting and podcasting Broadcast 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

multimedia card

Brodcast On the Net - streaming video, streaming audio, video conferencing, audio
Broadcast On the Net. If you are running a search for video conferencing and are looking for audio streaming or video streaminng and web conferenceing then you have come to the proper place. You can find many of the finest sites with the best conferencing services. Even find video studios or maybe the video talent to produce your program, no matter what you are looking for you can see the best streaming media here.
Brodcast On the Net - streaming video, streaming audio, video conferencing, audio

The Internet is the largest library on earth containing billions and billions of pages of information. A simple search for multimedia card will produce thousands of results. What do you do with all this information? If you want to keep a record of the best multimedia card websites (using this as an example) then follow these simple steps:

If you wish to bookmark more than one site on multimedia card then it might pay you to create a folder called multimedia card in which relevant bookmarks can be stored. Just select Add to Favorites in your browser, the select New Folder and name it multimedia card.

Broadcast On the Net Index

Main Menu
Broadcast On the Net
Site Map

Affiliate Ads, Links, news, etc.

News for 17-Feb-25

Source: BBC News - Home
Arctic heatwave could break records

Source: BBC News - Home
Obama's snowman phobia

Source: BBC News - Home
Crash survivor: 'I put my seatbelt on'

Source: BBC News - Home
George North: World Rugby wants more information from RFU over 'non-compliance'

Source: BBC News - Home
David Moyes: Manchester United's great traditions have gone says Sunderland boss

Source: BBC News - Home
Your pictures

Source: BBC News - Home
May Christmas message urges unity after Brexit vote

Source: BBC News - Home
Steam baths and brandy

Source: BBC News - Home
British passenger missing from Queen Mary 2 liner

Source: BBC News - Home
Is Nigeria's 'plastic rice' actually real?

Links
Links
Links

Internet Meetings MD Meetings Real Time Media On The Net