mysqldump -d -uusername -ppassword databasename

how to take mysql database structure backup

Question Posted / sonali

Answer Posted / sonali

mysqldump -d -uusername -ppassword databasename > backupfile.sql

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can we write procedure in mysql?

921

How to make a column bigger and delete unique from table.

957

What are the different data types in mysql?

919

How is oracle different from mysql?

1011

What does do in mysql?

868

How do I run mysql from command line?

1037

What is data directory in mysql?

975

How to convert character strings to dates?

1075

What is mysqli_select_db?

961

How do I view mysql logs?

884

How do we delete a row in a table?

987

What language is used in mysql?

987

What is a crosstab query?

951

What is the default port for MySQL Server?

1065

How do you say mysql?

892