Answer / guest

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

Answer / sandeep jain

mysqldump database_name > database_name.sql

What different Stored Objects are supported in MySQL?

1 Answers  

---

How can you do the fine tunning?

3 Answers   ACC,

---

How can you move the master database

0 Answers   IBM,

---

What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

0 Answers  

---

What is mysql used for?

0 Answers  

---

How you can create a trigger in mysql?

0 Answers  

---

How many ways we can retrieve the date in result set of mysql using php?

0 Answers  

---

What is full form of xampp?

0 Answers  

---

Differentiate between FLOAT and DOUBLE?

1 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 simple query?

0 Answers  

---

Does adding an index lock a table?

0 Answers  

---