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
]
To: mysql@lists.mysql.com
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
with
restoring the database to that point, and updating the rest by hand,
but I'm having problems doing so.
Some tutorials that I've read (such as this one
http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/2/
) say that I should do the following:
___
/usr/local
(through mysqldump) was about fifteen days ago. I'm fine with
restoring the database to that point, and updating the rest by hand,
but I'm having problems doing so.
Some tutorials that I've read (such as this one
http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-
MySQL-Database/2
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, but
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 do
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
Pattishall 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 our programmers decided
: 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 newest (minus the massive delete
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
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
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
)
To: [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
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
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, compress the file
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
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 had a mysql instance. The
/usr/local
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
On 3/15/04, 7:50:39 AM, mt m [EMAIL PROTECTED] wrote regarding restoring
a database from tape:
Hi
]
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 using multiple tablepsace), will that
be a problem?
Thanks
Raza
When restoring a backup, the binlog will record all of the backup's
commands (create tables and insert into's). Would it therefore be a good
idea to flush the logs before a restore and then flush the logs immediately
after so that the restoration log can be deleted (or ignored)?
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:
Hoping
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.
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
23 matches
Mail list logo