Categories




PreviousNext
Backup and recovery in MySQL     1 Up
 Send mail Views:1031
Belongs to : Mysql
Share share with orkut

MySQL is packed with many of utilities which simplifies the back-up and recovey.
BACK-UP:
The Utility used for Back-up any of database in mysql is ---'mysqldump'.We can make back-up even for single table
The following command is used for back-up:
> mysqldump -u [username] -p -h [hostname] [database-name (or) database-name.table-name] > [backup-file].sql

eg: > mysqldump -u root -p -h localhost db1.ta1 > db1.sql

RECOVERY:

The following command is used for Recovery:
> mysql -u [username] -p -h [hostname] [database-name (or) database-name.table-name] < [backup-file].sql

eg: > mysql -u root -p -h localhost db1.ta1 < db1.sql



By - Selva, On - 2008-03-12
Send This
PreviousNext

User Comments

1) superb
Name: neveMail: nevetha.nevetha2........Added: 2010-07-28

2) pls send tamil love kavithai
Name: rajkumarMail: rajkumar6.22.902........Added: 2010-07-24

3) unakaga uyirayum taruven yendraye....ippoluthu enakul alugiren ketkiratha......
Name: malaMail: ........Added: 2010-07-21

4) plz tamil sms kavithai send me more
Name: sabariMail: anishkhans........Added: 2010-06-29

5) a true love
Name: kokilasolomonMail: buelahepsiba........Added: 2010-06-19

6) PLS SENT ME TAMIL LOVE KAVIDHAI
Name: KAVIMail: ........Added: 2010-06-16

7) good recipe
Name: shanthiMail: shanthi........Added: 2010-05-22

8) Nice recipe
Name: sudhaMail: sudha........Added: 2010-05-22

9) please send tamil kadhal kavithai
Name: vikramMail: vikramvikram82........Added: 2010-04-13

10) Sarugugal kalaiyamal..saptam eluppamal.. kaiyyil sikkiya vannattu poochi, kanamal ponathu pol, kaiyyil ottiya vannangalai, en nenjil un nyabanggal..
Name: kartikMail: AltitudeSky........Added: 2010-04-03


Add NEW Feedback:

Name :     Email :

 Website Monitoring Service by 100pulse
Web hosting by Hiox India
Privacy Policy Terms and Conditions