how to take mysql database structure backup

Answer Posted / sandeep

mysqldump -d -uusername -ppassword databasename --no-data
--skip-opt > /tmp/databasename.sql

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of database engines available in mysql?

477


How to use sum function in where clause in mysql?

449


What are the difference between mongodb and mysql?

656


Is mysql a distributed database?

474


What is csv?

519






What are programming functions?

492


How do I delete a table in mysql workbench?

545


What is the data type for image?

617


Does mysql use tcp or udp?

527


What are the difference between and myisam and innodb?

520


what is the default port for mysql server? : Mysql dba

561


How do I quit mysql?

490


How to enter Characters as HEX Numbers?

551


What is the return type of mysqli_query?

467


What is int unsigned?

502