> > Its not recommended to just `cp' your data directory for use
> > later. You should always dump the database with mysqldump.
>
> Eh?
>
> If you know what you're doing, there's nothing unsafe about it and it
> is WAY faster than using mysqldump.
You're absolutely right.. but try telling that to a client :-)
Most people that ask me to setup a backup system for them want to be able to
see/touch/feel their data in ascii format so they're certain its all
there.... <shrug>
If that's the case you can use a utility I wrote in perl that dumps
databases into a nice directory tree... http://www.mswanson.com/mybackup or
under the contributed section of the mysql website.
-Marc-
#/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/#
#Marc Swanson | \|||/ #
#MSwanson Consulting | /o o\ #
#Phone: (603)868-1721 |-ooo----O----ooo-#
#Fax: (603)868-1730 | Solutions in: #
#[EMAIL PROTECTED] | 'PHP 'Perl #
# | 'SQL 'C++ #
# | 'HTML 'Sh/Csh#
# http://www.mswanson.com | 'Javascript #
#/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/#
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php