mysqldump -d -uusername -ppassword databasename --no-data --skip-opt >

how to take mysql database structure backup

Question Posted / sandeep

Answer Posted / sandeep

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is difference between mysqli and pdo?

1001

What are enums used for in mysql?

1047

What is difference between mysql and mysqli?

980

How to escape special characters in sql statements?

1004

Can mysql function return a table?

1140

What is mysql database server?

1017

What is indexing in mysql?

1018

What is innodb mysql?

1154

Which is best pdo or mysqli?

970

Is mysql a scripting language?

962

What is mysqli_select_db?

1011

SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?

1069

Can mysql and mariadb coexist?

1165

What is a procedure example?

980

What is unsigned int in mysql?

985