Backup MySQL DB

On Tue, 15 Jul 2003 10:55:07 +0000, Frank wrote:

> For a small DB is it oK just to copy the DB to another location ?

for any size DB why not dump the database to a file using mysqldump or use mysql-hotcopy?

example:
mysqldump databaseName > file.sql
(you will probably need the -u and -p options, and maybe the -h option.
Also consider the --add-drop-table option)

example 2:
mysqldump -host my.database.host.com -u username -p --add-drop-table \
databaseName > dumpfile.sql
(note the backslash indicating that the statement is really one line)

It seems like this is probably safer than copying the binary data files if
only because you don;t have to worry about shutting down the server or
munging the data files.

i've never used mysql-hotcopy, so I can't comment on it.

--
Jeffrey D. Silverman | jeffrey AT jhu DOT edu
Johns Hopkins University | Baltimore, MD
Website | http://www.wse.jhu.edu/newtnotes/