how to take mysql database structure backup

Answer Posted / sonali

mysqldump -d -uusername -ppassword databasename > backupfile.sql

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the non-standard sql commands supported by 'mysql'?

513


Can you tell what are various ways to create an index?

465


How do I kill a mysql connection?

476


How can we convert between Unix & MySQL timestamps?

468


How we get sum of column.

509






How do you know the version of your mysql server?

556


Can we write pl sql mysql?

506


What is mysqli procedural?

527


In which language mysql has been written?

874


What is the datatype of image in mysql?

495


Is mysql relational database?

475


What are the 5 r's of managing behaviors?

621


How do I start mysql client?

518


What is pdo in php mysql?

504


What port is mysql running on?

480