Am 18.06.2012 13:25, schrieb a bv:
> I have a mysql database , which tables are archived and i remove some
> files (montly data, .frm .MYD, .MYI) from the servers disk to an
> external storage. And i also drop or flush these tables from
> phpmyadmin. If i need to
>
> look and query these offlin
The db format is in "innodb"
On Dec 17, 2007 5:38 PM, To Glace <[EMAIL PROTECTED]> wrote:
> Hello,
>
> A database which has been deleted need to be restored.
> There is no .sql dump file.
> All we have is the .frm, .myi and .myd files from
> /var/lib/mysql/DATABASENAME.
>
> Here are the steps I h
if I have to put in one line, then just taka a copy (zip, gzip, tar or
whatever) of your old mysql data directory, like /usr/local/mysql/data, and
then restore it into your new data directory under 4.1.x, and this should be
fine assuming you have taken care of other things, also please refer to the
>
>
> i have written a bat file in which the data databackup has been taken in
> sql
>
> it runs automatically every 1 hour and sends a automatically through email
>
> now at the other end i have to manually restore the database can any one
> give me the codes to restore the database automatically
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/).
Note that mysqlhotcopy fails
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 troub
