mysqldump --no-data --databases <dbname>

how to take mysql database structure backup

Question Posted / anil alpati

Answer Posted / anil alpati

mysqldump --no-data --databases <dbname> > structurebackup.sql

Is This Answer Correct ?

4 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is the maximum number of records in mysql table?

911

What do you mean by % and _ in the LIKE statement?

982

What is the maximum connection pool size?

961

What is information_schema in mysql?

982

Why do we use the mysql database server?

1034

How much does mysql cost?

903

Why to use char instead of varchar in the database?

1172

What is difference between mysql mysqli and pdo?

929

What are the advantages of mysql?

983

What is MySQL?

992

What is a longblob?

939

How do I update a variable in mysql?

933

What's the difference between mysql and sql server?

977

How to decrement dates by 1 in mysql?

996

Explain the storage engines in mysql?

988