Use mysqldump to create a copy of the database?

Answer Posted / sandeep jain

mysqldump database_name > database_name.sql

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does uninstalling mysql delete database?

490


How to calculate expressions with sql statements?

490


What are federated tables?

599


What is the usage of "i-am-a-dummy" flag in mysql?

665


Why do we use the mysql database server?

530






How you can create a trigger in mysql?

546


Why mongodb is faster than mysql?

467


What is strict mode in mysql?

477


How to escape special characters in sql statements?

525


What is index length in mysql?

486


write a command to view the content of the table

492


How to represent ENUMs and SETs internally?

637


I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.

3435


How to insert dynamic values in mysql using php?

537


How to make a copy values from one column to another in mysql?

558