mysqldump --opt -u root -p database > dumpfile.sql
Yes, opt is on by default on newer versions of MySQL but not on older versions. I use it anyway, just in case. Saves a lot of time later.
I'm really glad I read this as my old server is running a pre-historic version of MySQL that was commonly used around the time when the Egyptians (or was it Marsians?) build the great pyramids.
What does --opt do btw, and how does it save time later?
