You should be able to pull each table (create + inserts) out into a stand
alone file
table1.sql
table2.sql
etc...
and then you can restore table by table.
This might be harder depending on the size of your database tables. If you
have a million rows, chances
are your .sql file is huge and it
Jeff McKeon wrote:
Hey all,
I've got a big problem. Seems one of our programmers decided to write a
script that deletes all records from a log table older than 3 months.
Problem is, we need old data from this log to reconcile our customer
accounts.
Our backups only go back 2 weeks. What I do h
-
> From: Dathan Pattishall [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 18, 2005 2:16 PM
> To: Jeff McKeon; mysql@lists.mysql.com
> Subject: RE: Restoring a database from binlogs
>
>
> Dump the binarylogs into a text file greping all the log data
> in order of oldest to
Dump the binarylogs into a text file greping all the log data in order
of oldest to newest (minus the massive delete). Then reply the events
backinto mysql
Mysqlbinlog |grep [your tablename] > BIGSQLFILE.sql
mysql -uroot < BIGSQLFILE.sql
DVP
Dathan Vance Pattishall http://www.friend
You shutdown the server and copy the files back.
Jones, William (NIH/CIT) wrote:
I am evaluating mysql for use at our organization. One thing I have not
been able to determine from the documentation is -- once I've taken a backup
via mysqlhotcopy, how do I restore the database from that backup whe
Tim Cutts <[EMAIL PROTECTED]> wrote:
>
> On 16 Mar 2004, at 09:06, Victor Pendleton wrote:
>
>> If the directory structure is the same and the snapshot is consistent
>> then
>> the answer is yes. If you do not want to purchase a commercial
>> utility, one
>> method is to schedule mysqldump, com
On 16 Mar 2004, at 09:06, Victor Pendleton wrote:
If the directory structure is the same and the snapshot is consistent
then
the answer is yes. If you do not want to purchase a commercial
utility, one
method is to schedule mysqldump, compress the file and then backup
that file
up.
What commerci
: [EMAIL PROTECTED]
Cc: Cc:
Sent: 3/15/04 4:52 PM
Subject: RE: restoring a database from tape
Victor,
Will this not work for Innodb tables? If my backup also includes
system tablespaces and .ibd files ( we using multiple tablepsace), will
that be a problem?
Thanks
Raza
-Original Message
CTED]>
To: <[EMAIL PROTECTED]>
Cc: "Cc:" <[EMAIL PROTECTED]>
Sent: Monday, March 15, 2004 5:52 PM
Subject: RE: restoring a database from tape
> Victor,
> Will this not work for Innodb tables? If my backup also includes
system tablespaces and .ibd files ( we u
To: mt m
Cc: [EMAIL PROTECTED]
Subject: Re: restoring a database from tape
If the table types are all MyISAM and you took a consistent backup the
answer is most likely yes.
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<&l
If the table types are all MyISAM and you took a consistent backup the
answer is most likely yes.
>> Original Message <<
On 3/15/04, 7:50:39 AM, mt m <[EMAIL PROTECTED]> wrote regarding restoring
a database from tape:
> Hi,
> Recently we EOLed a machine that h
Whith Unix it is:
mysql database < logfile.
Pete Kuczynski wrote:
> I can't seem to find any documentation on how to set this up an a
> windowz box.
>
> Can anyone help?
>
> Pete
>
> Gerald Clark wrote:
>
>> Run your transaction log against the restored database.
>>
>> Pete Kuczynski wrote:
I can't seem to find any documentation on how to set this up an a
windowz box.
Can anyone help?
Pete
Gerald Clark wrote:
>
> Run your transaction log against the restored database.
>
> Pete Kuczynski wrote:
>
> > Hoping someone can point me in the right direction.
> >
> > I have Nusphere Mys
Run your transaction log against the restored database.
Pete Kuczynski wrote:
> Hoping someone can point me in the right direction.
>
> I have Nusphere Mysql database in production [using mysql/PHP/apache, no
> perl]. The database has 1 table, 20 columns, with 3500 entries and
> growing.
> I am
14 matches
Mail list logo
