Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How can we take a backup of a mysql table and how can we
restore it. ?

Answer Posted / kishore

mysqldump is an effective tool to backup MySQL database. It
creates a *.sql file with DROP table, CREATE table and
INSERT into sql-statements of the source database. To
restore the database, execute the *.sql file on destination
database.
Ex:
backup: # mysqldump -u root -p[root_password]
[database_name] > dumpfilename.sql

restore:# mysql -u root -p[root_password] [database_name] <
dumpfilename.sql

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is laravel an oop?

862


What is the use of pear in php?

942


Is php easy language to learn?

1009


What is csrf token and why it is required?

911


What is the correct and the most two common way to start and finish a php block of code?

895


How a constant is defined in a php script?

957


Do you know what is the differences between $a != $B and $a !== $B?

943


How to find the index of an element in an array php?

929


What are the rules in creating php variable?

971


Tell me what is the main difference between require() and require_once()?

920


What does $globals mean?

914


Which is better #define or enum?

909


What is php default argument?

957


How to join multiple strings into a single string?

904


How to track no of user logged in?

968