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

How can an index be declared in mysql?

0 Answers  

What are the limitations of mysql?

0 Answers  

What is unsigned int in mysql?

0 Answers  

What is max connections in mysql?

0 Answers  

What are the 5 r's of managing behaviors?

0 Answers  




What are the similarities between a function and a procedure?

0 Answers  

What ascii 31?

0 Answers  

What is a scalar function?

0 Answers  

The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?

4 Answers   Afixi, GE,

How To see all the tables from a database of mysql server.

0 Answers  

What is blob and text in mysql?

0 Answers  

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

0 Answers  

For more MySQL Interview Questions Click Here
Categories