Hi. On Sat, Sep 29, 2001 at 05:27:40PM -0500, [EMAIL PROTECTED] wrote: > I recently lost my main drive (linux), but I was mirroring nightly the > contents of all my directories to another drive using mirrordir. > > I'm a bit of a mysql newbie...can anyone tell me (first) where in the > directory structure of linux mysql databases usually put themselves by > default.
That depends on the installation. /var/lib/mysql is a common place. If you know one of your database names, e.g. "midget", you can search for it with find /path/to/mirrordrive -type d -name "midget" > and (second) if I can somehow copy or restore the data on a new > box? Simply copy it over with "cp -a" (as root). Then you should do first a check of the tables (with CHECK TABLE or the command (my-)isamchk), to be sure that the back-up is consistent. Bye, Benjamin. -- [EMAIL PROTECTED] --------------------------------------------------------------------- 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