mysqldump -uusername -ppassword databasename --no-data

how to take mysql database structure backup

Question Posted / rupa bagherwal

Answer Posted / rupa bagherwal

mysqldump -uusername -ppassword databasename --no-data >
backupfilename.sql

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to execute mysql query in php?

908

What is a scalar function?

988

How to list or view all databases from the mysql server.

919

What is the maximum no of columns a table can have?

906

How to create a new table in mysql?

1040

What is schema in mysql?

892

What is memory table in mysql?

937

What is auto increment in mysql?

957

Which is better mysql or mssql?

919

Create table employee (eno int(2),ename varchar(10)) ?

1001

Explain the difference between mysql_fetch_array(), mysql_fetch_object()?

936

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

1002

How do you rename a table in mysql?

1018

Does mysql use sql?

878

Which is faster innodb or myisam?

1024