RE: Restoring database from hotcopy

[Jens Vonderheide]

Hi Travis,

 I have the database files, now how do I put them back into mysql?

mysqlhotcopy simply copies the data files to another directory. To restore
them, terminate the mysql server and then copy the files back to the mysql
data directory (e.g. /var/lib/mysql/db name).
Note that mysqlhotcopy fails to backup all data if you use table handlers
that use different files to store the data (like InnoDB does).

Jens


-
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

RE: Restoring database from hotcopy

[Rick Emery]

Do have the files actual files?  Or do you have text files which were create
from MYSQLDUMP?

-Original Message-
From: Travis Farmer [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 3:04 PM
To: [EMAIL PROTECTED]
Subject: Restoring database from hotcopy


If it's not too much trouble this is slightly urgent.

~Travis

I have the database files, now how do I put them back into mysql?

Restore table doesn't seem to work.

Thanks in advance,
~Travis


_
Send and receive Hotmail on your mobile device: http://mobile.msn.com


-
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

-
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