Okay, panic over. I recursively stripped the ACLs and things are working.
Next time I drop a table from phpMyAdmin, I'll carefully read the little thing
that pops up saying I'm about to drop an entire database... :-( One gets so
yea, whatever to warning notifiers...)
Thanks to all who sent
I accidentally dropped a crucial database. My only backup is via Apple's Time
Machine.
First, I stopped mysqld and copied (via tar) the database in question from the
backup. Restarted, but drat -- most of the tables were apparently using
innodb's ibdata1 file, as only the MyISAM tables showed
Am 09.01.2013 16:33, schrieb Jan Steinman:
I accidentally dropped a crucial database. My only backup is via Apple's Time
Machine.
First, I stopped mysqld and copied (via tar) the database in question from
the backup. Restarted, but drat -- most of the tables were apparently using
Hi,
It is not very surprising that the database cannot recover from a Time Machine
backup. This generally applies to any software that is running at the moment
the backup is taken. The InnoDB is especially sensitive to taking what is
called a 'dirty' backup because it has a cache. You
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 offline mysql files what i need to do after
copying
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 offline
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 have taken:
1. Created a new empty database - NEWDB
2. individually restored all tables using the restore
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 have taken:
Dear Sir,
I have 8 mb total SQL database, i'm currently using mysql version:
4.1.11-debian.
Our database uses latin5 character set and collate: latin5_turkish_ci
And now... how can i restore this database without problem; previous mysql
version?
previous mysql version is: 4.0.25-standart
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
snip
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
hai,
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
I could use some help with restoring a backup.
I have a backup file, generated using the mysqldump command. This file is
approximately one gigabyte in size. I use the following command to restore this backup
file:
mysql -u root DevDBs New.all.aca
When the command is finished executing, I
Hi,
I used the command similar to the following to dump out both the structure and
contents of my database:
mysqldump -F -u root --opt tradingdata c:tradingdatadump.sql
I got an error half way through restoring the database into another test database
using the following command:
mysql -u
At 18:01 +0100 7/30/03, Gilbert Wu wrote:
Hi,
I used the command similar to the following to dump out both the
structure and contents of my database:
mysqldump -F -u root --opt tradingdata c:tradingdatadump.sql
I got an error half way through restoring the database into another
test database
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
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
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
18 matches
Mail list logo