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...

  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

Use mysqldump to create a copy of the database?

Question Posted / guest

Answers were Sorted based on User's Feedback



Use mysqldump to create a copy of the database?..

Answer / guest

mysqldump -h mysqlhost -u username -p mydatabasename >
dbdump.sql

Is This Answer Correct ?    1 Yes 0 No

Use mysqldump to create a copy of the database?..

Answer / sandeep jain

mysqldump database_name > database_name.sql

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

What is cast in mysql?

0 Answers  

What are the steps involved in query processing?

0 Answers  

Explain what is mysql?

0 Answers  

what if you really want to store the timestamp data, such as the publication date of the article?

2 Answers  

Is mysql a scripting language?

0 Answers  

The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id

2 Answers  

What is a string in mysql?

0 Answers  

What is mysql enterprise edition?

0 Answers  

What is the difference between mysql and oracle?

0 Answers  

What is row?

0 Answers  

Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

0 Answers  

What is difference b/w composit key n primary key and forigion key?

4 Answers  

For more MySQL Interview Questions Click Here
Categories