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?
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)
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 ...