mysqldump -d -uusername -ppassword databasename --no-data --skip-opt >

how to take mysql database structure backup

Question Posted / sandeep

Answer Posted / sandeep

mysqldump -d -uusername -ppassword databasename --no-data
--skip-opt > /tmp/databasename.sql

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you create a primary key?

939

How to display top 10 rows in mysql?

987

How to write after insert event update trigger on the same table in mysql?

912

What is different between sql and mysql?

956

How do I connect to mysql database?

976

How can you take the backup and restore a mysql database using php?

914

Explain % and _ inside like statement?

958

What is pdo in mysql?

876

How to check server status with 'mysqladmin'?

1091

How can you export the table as an xml file in mysql?

842

What sql does mysql use?

878

How to write optimized query in mysql?

945

What is mysql shell?

917

How to determine the location of the data directory?

913

How to get a list of all tables in a database?

1006