how to dump all databases for backup. Backup file is sql commands to recreate all db's.



how to dump all databases for backup. Backup file is sql commands to recreate all db's...

Answer / Jyoti Kumari

mysqldump --all-databases > backup.sql

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How to load data files into tables with 'mysqlimport'?

1 Answers  


How many ways we can we find the current date using MySQL?

3 Answers  


How to create a new view in mysql?

1 Answers  


Explain advantages of MyISAM over InnoDB?

1 Answers  


How can we change the data type of a column of a table?

1 Answers  


In the below example, how many String Objects are created? String s1="I am Java Expert"; String s2="I am C Expert"; String s3="I am Java Expert";

1 Answers  


How to start mysql server?

1 Answers  


date funciton

2 Answers  


Is mysql an oracle product?

1 Answers  


What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()?

2 Answers  


How do I rename a table in mysql?

1 Answers  


How can an index be declared in mysql?

1 Answers  


Categories