how to take mysql database structure backup

Answer Posted / sandeep

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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I create a database in mysql workbench?

604


What is mysql primary key?

682


How do you concatenate strings in mysql?

677


What is a transaction? Describe mysql transaction properties.

747


How to see the create table statement of an existing table?

777


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

664


How do I rename a table in mysql workbench?

668


What is horizontally scalable?

686


What is the password of mysql?

666


What is processlist in mysql?

691


Is mysql open source?

641


How to set the time zone for MySQL to particular country time?

2912


How to change a password for an existing user via mysqladmin?

727


How many columns can a table have?

644


How can I remotely connect to mysql database?

652