RawSushi's Tech Journal
My online tech scrapbook where I keep my notes in case I need to look them up later
Monday, June 11, 2012
MySQL: Dumping a DB with Create DB Statement
Use the -B option e.g.
mysqldump -u username -p -B --result-file=filename.sql dbname
Note: You may run into this "gotcha" while restoring:
http://rstechjournal.blogspot.sg/2012/05/mysql-gotcha-after-restoring-database.html
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment