t; <[EMAIL PROTECTED]>
To:
Sent: Wednesday, March 08, 2006 1:17 PM
Subject: Restoring a database from a complete MySQL dump
I have a MySQL 4.1.x installation. It was upgraded to MySQL 5.0.x and then
downgraded again, back to 4.1.14. I took a complete dump of all
databases/tables into a .sql file,
I have a MySQL 4.1.x installation. It was upgraded to MySQL 5.0.x and then
downgraded again, back to 4.1.14. I took a complete dump of all
databases/tables into a .sql file, and now I would like to restore just
specific databases or tables from it.
Is this possible without restoring everything or
Thank you *SO* much, Shawn. Doing it manually did the trick.
I'm sure you know how frustrating this can be. I really, really
appreciate your help. Whew!
best,
Matt
On 5/25/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> You can try doing the same steps, but break it down so that you d
One more note for anyone else who runs into this problem: before
running the source command, I dropped the database, recreated it, and
then ran the mysqldump file into the empty database.
Matt
> On 5/25/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> > You can try doing the same steps, b
matt g <[EMAIL PROTECTED]> wrote on 05/25/2005 12:45:22 PM:
> While updating a record in a database, I inadvertantly forgot a
> "where" statement; so instead of changing just one record, I changed
> all 900 records in the database.
>
> I've been trying to figure out how to fix this. My latest ba
While updating a record in a database, I inadvertantly forgot a
"where" statement; so instead of changing just one record, I changed
all 900 records in the database.
I've been trying to figure out how to fix this. My latest backup
(through mysqldump) was about fifteen days ago. I'm fine with
res
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
http://www.friendster.com
> -Original Message-
> From: Jeff McKeon [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 18, 2005 11:31 AM
> To: mysql@lists.mysql.com
> Subject: Restoring a database from binlogs
>
> Hey all,
>
> I've got a big problem. Seems one of
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 have however is rep
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
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 when
necessary?
William K. Jones
Chief, Database Systems Branch, DCSS, CIT
[EMAIL
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 <
Hi,
Recently we EOLed a machine that had a mysql instance. The /usr/local/mysql
dir was backed up to tape before EOLing.
Having now installed a new machine, we need to copy the old database from
tape to the new machine.
Mysql has been successfully installed on the new machine.
To install the d
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
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 backing up the database to tape 2 times a day. At noon and at 5pm,
both are full backups.
23 matches
Mail list logo
