Use mysqldump to create a copy of the database?




Answers were Sorted based on User's Feedback



Use mysqldump to create a copy of the database?..

Answer / guest

mysqldump -h mysqlhost -u username -p mydatabasename >
dbdump.sql

Is This Answer Correct ?    1 Yes 0 No

Use mysqldump to create a copy of the database?..

Answer / sandeep jain

mysqldump database_name > database_name.sql

Is This Answer Correct ?    0 Yes 0 No

Post New Answer




More MySQL Interview Questions

What is a crosstab query?

0 Answers  


What are different types of queries?

0 Answers  


How do you change a password for an existing user via mysqladmin?

2 Answers  


Is mariadb better than mysql?

0 Answers  


Can you tell which of the following where clauses is faster?

0 Answers  






What does mysqli_fetch_assoc do?

0 Answers  


at first i'm using datediff('d', a.due_date, current_date); but it takes too long to get the result but how can i subtract the current_date - a.due_date and still get the same result like when i use datediff? thank you

1 Answers  


What is trigger in mysql?

0 Answers  


How do I switch users in mysql?

0 Answers  


Query to select passwords from a table having a column "Password" Whose length is b/w 8 &15 and having 'A' as the first character in the password irrespective of case.

3 Answers  


How do I exit mysql?

0 Answers  


Does uninstalling mysql delete database?

0 Answers  






Categories