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

What are procedures in mysql? Explain

977

Is mysql a free database?

938

What is horizontally scalable?

982

What is mysql57?

918

How to escape special characters in sql statements?

976

What is a mysql model?

950

What is a csv table?

1001

How do I rename a table in mysql?

976

Is sql similar to mysql?

888

How do I run mysql on a mac?

968

How do I delete a row in mysql?

967

What is 'mysqld'?

944

How do I copy a table in mysql?

944

how can you test for null values in a database? : Mysql dba

938

What is a simple query?

904