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 python similar to php?

1023


What Is a Persistent Cookie?

1034


What are php data types?

978


Explain the installation of PHP on UNIX systems?

1105


What is the best website to learn php?

982


Tell me what type of operation is needed when passing values through a form or an url?

960


How to enable error reporting in php?

1059


What is PHP's configuration file called?

1179


iam mca post graduate in 2010 not getting job in JAVA so iam looking for carear in php as market demand is high so it is best option to try for php or not

1853


How to initiate a session in php?

1214


What is the use of header() function in PHP? What the Limitation of HEADER()?

1042


What does php exit do?

1031


Explain the changes in php versions?

975


Which is better php praogramming or cad/cam scope wise and also salaray wise?

2012


Explain about switch statement in PHP?

1015