How would you backup and restore a big MySQL database? What
are the advantages of the approach which you have taken
over the others?
Answer Posted / kalai
mysqldump -uuser -ppassword databasename >filename
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How do I transfer data from one database to another in mysql?
explain GROUPBY & HAVING clause with examples.
Can't connect mysql server on localhost?
How to enter Characters as HEX Numbers?
What is query log in mysql?
What are the advantages of mysql in comparison to oracle?
Restore database (or database table) from backup.
Which datatype is used for email in mysql?
i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?
What is the difference between mysql_fetch_array() and ysql_fetch_object() ?
What is a table schema?
How do I start mysql in ubuntu?
How can I create a database in mysql?
What is a longblob?
I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?