Gossamer Forum
Home : Products : Others : MySQLMan :

SQL Dump... backup?

Quote Reply
SQL Dump... backup?
** Disclaimer: From a MySQL novice.

QUESTION
We want to use MySQLMan as a manual backup utility, using SQL Dump.
Comments? Is this a reasonable solution [we have 50 tables]?

QUESTION
Is there a "doc" available explaining these oprions:
CREATE TABLE statements and INSERT statements ?

Shoud I be concerned with the above options, or could we simply do a "dump to screen" and save the file?

QUESTION
Should we need to Restore from the above dump file, how would we do that?

Thanks.
Quote Reply
Re: [jmueller] SQL Dump... backup? In reply to
Yes, using the SQL DUMP function will allow you to backup your data and schema in one operation.

With regards to the rest of your questions, yea, go to:

http://www.mysql.com

there are TONS of documents and tutorials for you to read, or buy a MySQL book.
========================================
Buh Bye!

Cheers,
Me