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

How can I remotely connect to mysql database?

859

What's new in mysql 8?

936

What is a left join mysql?

846

Where is the mysql database stored?

870

What can I do with mysql?

858

Is mysql running ubuntu?

912

How do I free up space in mysql?

854

What is difference between function and procedure in mysql?

880

What is the role of a limit in a mysql query?

947

What is the default port for MySQL Server?

1012

Can not connect to mysql server 10060?

861

Does mysql use tcp or udp?

874

How can I create table in mysql?

956

Write a query to count the number of rows of a table in mysql.

887

How do I run mysql?

918