;".
The table which is returned contains SOMETIMES for SOME tables errors like:
Couldn't fix table with quick recovery: Found wrong number of deleted
records
and
Run recovery again without -q
What is the reason for that and how do i avoid it? I searched the Manual,
web and this list but co
Edwin,
check this link. Hope it will help you.
http://www.mysql.com/doc/en/Resetting_permissions.html
Best regards,
Mikhail.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 12, 2003 7:22 PM
Subject: How to recovery the r
Dear List.
This morning we made some changes in the user field of the mysql database,
we changes the root password there, after that we can not get access to
our mysql server with the new root password and with the old password
neither.
How can we do? Is there any procedures for recovery the
Greetings all.
I have a bit of a problem here, a database i'm administering was somehow corrupted,
and i'm unable to recover it in any way. Is there any way at all to recover a corrupt
InnoDB database? (I read on innodb.com that it is impossible, but hope it is not)
When I run a query from any
Hi group,
I have two mysql-Innodb server(4.0.13) with replication enabled in that.
server A > Server B
I have the database dump of server B. In server B, I have enabled the log-
bin, log-slave-update in server B.
In case of database crash, How can I restore the data from log file. I know
tha
4.0.14, I get a printout which tells the option is set to 4:
"
C:\mysql-4.0.13\mysql-4.0.13\client_debug>mysqld --console
030630 16:49:40 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log
. Still I am unable to start database server normally. Following is
the part of Err file:
030630 11:58:36 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 3895685648
InnoDB: Doing
L PROTECTED]>
Sent: Monday, June 02, 2003 8:05 PM
Subject: Re: DISASTER recovery...hopefully
> Doing more research...found a file called my.cnf. That appears to be the
> right file. It has the datadir in there. So if I just point the datadir
to
> the right place it will simply wake up
arber
-
From: Peter J. Milanese
To: ComCity
Cc: [EMAIL PROTECTED]
Sent: Monday, June 02, 2003 4:28 PM
Subject: Re: DISASTER recovery...hopefully
Should be no big deal..
Look in the mysql.server startup script..
There's a 'datadir=' line... set the path to the location of the d
Newbie doing disaster recovery...oh my.
I'm trying to do some diasaster recovery on a machine running mySQL. I
could use a little bit of help...even if its pointing me in the right
direction only...
I can see I have some .MYD, .MYI, and .frm files that look to be the
original database
te the bin-log if I don't have to. Are they important for
crash recovery (server crash) in general or for innoDB in particular
many thanks
Murad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Benoit,
- Original Message -
From: "Benoit St-Jean" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, March 21, 2003 4:54 AM
Subject: Stopping InnoDb recovery and fixed columns
> I recently had a bad experience with a "feature" of
> Inn
I recently had a bad experience with a "feature" of
InnoDb. Whenever the server crashes, on the next
startup InnoDb detects that the server ended
abnormally and performs a
repair/rollback/magic/whatever before allowing you to
connect to the server.
Unfortunately, I had to create an index on a 45
m
Would it be possible to share with me the name and location of this Hex
editor and also the Perl script as I am having the same problem where I have
lost my SQL data. Would
appreciate it greatly.
Michael Krassos
Network Specialist
University of Miami
Department of Telecommunications
---
Mailinglist
Subject: Re: Recovery in MySql
On 1/29/03 5:13 AM, "Inbal Ovadia" <[EMAIL PROTECTED]> wrote:
> Hi All,
> I have MySql on Windows.
> Today i had an electrical power interruption in the middle of working.
> The database remain not consistent and i could
On 1/29/03 5:13 AM, "Inbal Ovadia" <[EMAIL PROTECTED]> wrote:
> Hi All,
> I have MySql on Windows.
> Today i had an electrical power interruption in the middle of working.
> The database remain not consistent and i could not continue working with it.
>
>
Hello Inbal,
Wednesday, January 29, 2003, 4:13:24 PM, you wrote:
IO> Hi All,
IO> I have MySql on Windows.
IO> Today i had an electrical power interruption in the middle of working.
IO> The database remain not consistent and i could not continue working with it.
IO> Is there any
Hi All,
I have MySql on Windows.
Today i had an electrical power interruption in the middle of working.
The database remain not consistent and i could not continue working with it.
Is there any Recovery after crash mechanism in mySql?
Thanks, Inbal
-Original Message-
From: Martin Waite [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 28, 2002 3:19 AM
To: Manuel Villasante
Cc: '[EMAIL PROTECTED]'
Subject: Re: Recovery with binary logs.
Hi Manuel,
On Tue, 2002-11-26 at 21:38, Manuel Villasante wrote:
> Hi,
>
> I h
Hi Manuel,
On Tue, 2002-11-26 at 21:38, Manuel Villasante wrote:
> Hi,
>
> I have a few questions regarding recovery of a database using binary logs.
>
>
> 1) If you have a set of binary logs in your directory mylog-bin.001 to
> mylog-bin.nmp, is there an easy way to fi
Hi,
I have a few questions regarding recovery of a database using binary logs.
1) If you have a set of binary logs in your directory mylog-bin.001 to
mylog-bin.nmp, is there an easy way to find out which logs you need to run
since the last backup? In other words, when according to the
Massimo,
Friday, November 22, 2002, 2:59:38 PM, you wrote:
MB> I'd want to backup my database. Which is the best method between mysqldump and
copying the /usr/local/var directory?
For InnoDB tables take a look at InnoDB Hot Backup software (non-free). It is a must
to have on a production box. W
Dobrý den,
sexta-feira, 22 de novembro de 2002, 13:26:01, napsal jste:
JC> What is MYI and frm files?
The MySQL tables in case of "MyISAM tables" are separated in :
.frm - The struct (header) of table
.MYD - The DATA of table
.MYI - The Indexes of table
in case of InnoDB , only .frm exists , t
Dobrý den,
sexta-feira, 22 de novembro de 2002, 11:32:00, napsal jste:
MB> which is the command to restore from a dump??
if you use the InnoDB hot Backup tool the command is
ibbackup --restore
in case of InnoDB, of course...
In case of mysqldump , the command is
source file_dumped.sql; ( i
which is the command to restore from a dump??
-Messaggio originale-
Da: Dyego Souza do Carmo [mailto:[EMAIL PROTECTED]]
Inviato: venerdì 22 novembre 2002 14.23
A: Massimo Bandinelli
Cc: [EMAIL PROTECTED]
Oggetto: Re: Recovery
Dobrý den,
sexta-feira, 22 de novembro de 2002, 10:59:38
Dobrý den,
sexta-feira, 22 de novembro de 2002, 10:59:38, napsal jste:
MB> I'd want to backup my database. Which is the best method between mysqldump and
copying the /usr/local/var directory?
MB> Thanks, Massimo.
you use InnoDB ? the best and fast metod to backup your InnoDB
databases is usin
I'd want to backup my database. Which is the best method between mysqldump and copying
the /usr/local/var directory?
Thanks, Massimo.
Massimo Bandinelli
System Administrator
-
Register.it S.p.A. - Gruppo DADA
tel +39 199 REGIST (+39 199 734478)
fa
Michael, Jeremy,
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, November 13, 2002 9:21 PM
Subject: Re: mysqlhotcopy point-in-time recovery
> On Wed, Nov 13, 2002 at 01:18:18PM -0500, Micha
On Wed, Nov 13, 2002 at 01:18:18PM -0500, Michael T. Babcock wrote:
> Jeremy Zawodny wrote:
>
> >Well, it handles ISAM, MyISAM, and BDB (last I checked). So what
> >should it be called? mysql_isam_myisam_bdb_hotcopy?
> >
> >
>
> Heheh, point taken. It seems simply unfortunate that the progra
PM
To: Heikki Tuuri
Cc: [EMAIL PROTECTED]
Subject: Re: mysqlhotcopy point-in-time recovery
Heikki Tuuri wrote:
>you cannot use mysqlhotcopy to back up InnoDB type tables. Only the .frm
>files are in the database directory, while the data is in ibdata files.
>mysqlhotcopy does not co
Heikki Tuuri wrote:
you cannot use mysqlhotcopy to back up InnoDB type tables. Only the .frm
files are in the database directory, while the data is in ibdata files.
mysqlhotcopy does not copy ibdata files or ib_logfiles, and if it would do
that, the copies could be corrupt because of writes the d
Jing,
- Original Message -
From: ""Jannie Qu"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, November 11, 2002 8:03 PM
Subject: mysqlhotcopy point-in-time recovery
> Hi, all,
>
> sql, query.
>
> I use mysqlhotcopy to backup
Hi, all,
sql, query.
I use mysqlhotcopy to backup innodb tables and I tried to find how to
recovery database point-in-time with the help of binary log.
I had tried "mysqlbinlog --user-jqu --password=1234 Host-bin.[0-9]* | mysql"
without success.
Anyone of you know how to recover
Heikki Tuuri wrote:
log files are as important a part of a database as ibdata files.
Trust me, I know; they didn't get backed up I've realized too late
though ...
You can try using some dummy log files from another installation and set
force recovery to 6 to skip the log scan.
Michael,
- Original Message -
From: "Michael T. Babcock" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, November 07, 2002 4:36 PM
Subject: Re: InnoDB recovery
> Heikki Tuuri wrote:
>
>
Heikki Tuuri wrote:
if you have on tape old images of ibdata files and ib_logfile's, you can try
crash recovery from them, possibly using innodb_force_recovery=6.
Unfortunately, as mentionned, I only have the data files on tape, no log
files.
Are the data files 'dumpabl
Michael,
- Original Message -
From: ""Michael T. Babcock"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, November 05, 2002 6:00 PM
Subject: InnoDB recovery
> I have a table that accidentally had a query run on it that NULL'd a
&
I have one backup (back.sql) of 5 days ago and I don't start my database.
How can I do to recovery my backup in other database and to use old logs to
adjust my dataBase?
After install a new mysql and to create a new tableSpace Innodb, I can do
that?
regards
I have a table that accidentally had a query run on it that NULL'd a
certain field of the entire table. I have the data on old versions of
the binary table files from backup tapes, but have no idea how to get
this information out of those old binary table files. I unfortunately
don't have the
Hi.
I've got a major filcorruptionissue on my hands. RAID, bad scsi-cables
,Reiserfs for Linux 2.2 and a corrupt backup. That's not a good
combination.
I've managed to salvage a few tables with isamchk, but the most
important tables is missing it's .ISD file. The datafile. The only
files I've g
I recently posted about my corrupt table where no matter what options
I tried REPAIR TABLE and myisamchk would "recover" the table but in
the process reduce the size from 27,000 rows to just 1000. Not very
useful.
In the end I managed to get almost all my data back by using a hex
editor and a
Pada Fri, 26 Jul 2002 11:17:08 -0700
Troy Hakala <[EMAIL PROTECTED]> menulis :
> ok, i turns out I have lots of sleeping connections. This is because I'm
> using PHP's mysql_pconnect which opens persistent connections so the next
> connect (on the same process) will reuse the connection. this d
At 11:17 -0700 7/26/02, Troy Hakala wrote:
>ok, i turns out I have lots of sleeping connections. This is because
>I'm using PHP's mysql_pconnect which opens persistent connections so
>the next connect (on the same process) will reuse the connection.
>this does appear to improve performance over
The language is English (same as server) and the client is PHP.
I've never seen this problem even when maxing out the connections at the
default 100.
On Thursday, July 25, 2002, at 02:55 PM, Georg Richter wrote:
> On Thursday, 25. July 2002 18:48, Troy Hakala wrote:
> Hello,
>
>> I've been ru
ok, i turns out I have lots of sleeping connections. This is because I'm
using PHP's mysql_pconnect which opens persistent connections so the next
connect (on the same process) will reuse the connection. this does appear
to improve performance overall, which is good. but it seems to leave lots
I've been running MySQL for 2 years with no problems. Yesterday, I
increased the max_connections because I was getting "too many connections"
error. This morning, the server again reached its limit but it never
seemed to recover from it and constantly gave the "too many connections"
error. I
Hi!
> "Georg" == Georg Richter <[EMAIL PROTECTED]> writes:
Georg> On Friday, 21. June 2002 15:43, Stefano Incontri wrote:
Georg> Hi,
>>
>> I found the following problem, which I consider a bug, but maybe I'm
>> missing something to make it work correctly.
Georg> This is not a bug. Why do
On Friday, 21. June 2002 15:43, Stefano Incontri wrote:
Hi,
>
> I found the following problem, which I consider a bug, but maybe I'm
> missing something to make it work correctly.
This is not a bug. Why do you use a reserved word (LOAD) for an index name?!
Rename it and everything should be ok.
Thank you very much for your quick and accurate responses.
I tried to dump with the -Q (--quote-names) and it perfectly works.
I'm not completely sure I understood what Tod Harter meant in his mail,
because I set up an 'automated' backup process, and if I would ever need
to recov
On Friday 21 June 2002 09:54, Keith C. Ivey wrote:
> On 21 Jun 2002, at 15:43, Stefano Incontri wrote:
> > ERROR 1064: You have an error in your SQL syntax near 'Load (IL,Item_ID)
> > ) TYPE=MyISAM COMMENT='SCM Internal Loads table'' at line 12
>
> "LOAD" is a reserved word in MySQL, so you need b
Stefano,
Friday, June 21, 2002, 4:43:29 PM, you wrote:
SI> I found the following problem, which I consider a bug, but maybe I'm missing
something to make it work correctly.
SI> I'm using 'mysqldump' to backup our MySQL DB, and when I try to recover it on a
blank DB it gives syntax errors while
On 21 Jun 2002, at 15:43, Stefano Incontri wrote:
> ERROR 1064: You have an error in your SQL syntax near 'Load (IL,Item_ID)
> ) TYPE=MyISAM COMMENT='SCM Internal Loads table'' at line 12
"LOAD" is a reserved word in MySQL, so you need backticks around it.
Have you tried using the --quote-name
Dear All,
I found the following problem, which I consider a bug, but maybe I'm missing something
to make it work correctly.
I'm using 'mysqldump' to backup our MySQL DB, and when I try to recover it on a blank
DB it gives syntax errors while creating some table.
This is the Table structure wh
a telnet to mysql works :
www:~/MySQL# telnet localhost 3306
Trying 127.0.0.1...
Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.
2
4.0.2-alpha-debug9`VmEN7i,
Bad handshakeConnection closed by foreign host.
but still cant erase this password !
www:~/MySQL# /usr/bin/mys
Hi all,
It's urgent I upgrade my mysql server with some rpm that I found elsewhere
on the web
But when accessing db I was rehected.
Ii d like an easy way to recover my password or to put a blank pass like it
was !
see what I ve got !
www:~# mysql
ERROR 1045: Access denied for user: 'root@local
hi,
We can take backup for the subject above by two ways, One way is by
mysqldump ( Which I am using ..)
Now, I the second method
1. Shut down your MySQL database and make sure it shuts
down without errors.
2. Copy all your data files into a safe place.
system ("tar cfz $backupFile\-$szToday.tgz $siteDir");
-Original Message-
From: Gerald R. Jensen [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 9:49 PM
To: Chetan Lavti; [EMAIL PROTECTED]
Subject: Re: Script for Data base backup and recovery : Very essential
This has b
ed to ftp the resulting scripts to another server, you could add
code to the shell script to run ncftpput, etc.
Gerald Jensen
- Original Message -
From: "Chetan Lavti" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 12, 2002 11:16 PM
Subject: Script fo
hi,
Can anybody tell me how can I write script for MySQL backup and
recovery.( i am newbie as per script is cencern)
I am using Innodb table type and using all the default parameters
specified in the my.cnf file (my-large.cnf)
Looking for kind response..
Thanks and regards,
Chetan Lavti
John Hughes wrote:
> Please allow me to broaden this thread to include backup for mySQL
> users who have accounts with ISPs.
> In my case I have mySQL access on a Web server where I have NO access
> to the server-level options. What is my best option of making a
> backup of the database and tabl
able type on Linux7.1
> platform.
> > Now,for this database backup and recovery procedures are given as
> :
> >
> > 1. Taking 'binary' backup of the database.
> > 2. Using the mysqldump utility
> >
> > In the first method we do the following things
Thank you very much !!
I have a management screen, where I have two button namely "BACKUP" and
"RECOVERY". I am not able to find out, how this will be done(both BACKUP
and RECOVERY)?, when I click on the corresponding buttons and while
doing this if error occurs, ho
On Mon, Mar 04, 2002 at 10:05:50AM +0530, Chetan Lavti wrote:
>
> I am using MySQL 3.23.47 and InnoDB table type on Linux7.1 platform.
> Now,for this database backup and recovery procedures are given as :
>
> 1.Taking 'binary' backup of the database.
> 2.
hi,
I am using MySQL 3.23.47 and InnoDB table type on Linux7.1 platform.
Now,for this database backup and recovery procedures are given as :
1. Taking 'binary' backup of the database.
2. Using the mysqldump utility
In the first method we do the following things :
·
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 03, 2002 1:53 PM
To: Chetan Lavti
Subject: Re: RE: MySQL Backup and Recovery
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the
Having worked with Oracle, and MS SQL databases, the only "backup/recovery"
I usually deal with after the admins have their dumpdb run to a secondary
transaction database is tape backup of some form. Most of the sites I have
worked with however use 3 disk mirrors, and disk cloning
On Fri, Mar 01, 2002 at 09:26:36AM +0530, Chetan Lavti wrote:
>
> Hi,
>
> I am planning to have MySQL database backup and recovery from the
> web interface. Is it possible to do this. If yes, then what
> procedure I should follow. If anybody have any idea about this then
&g
Chetan,
Friday, March 01, 2002, 5:56:36 AM, you wrote:
CL> I am planning to have MySQL database backup and recovery from the web
CL> interface.
CL> Is it possible to do this. If yes, then what procedure I should follow.
Well, specify what exactly do you need - a backup procedure initi
Hi,
I am planning to have MySQL database backup and recovery from the web
interface.
Is it possible to do this. If yes, then what procedure I should follow.
If anybody have any idea about this then please, do help me. It's our
requirement.
Thanks and regards,
Chetan
Hi,
I am planning to have MySQL database backup and recovery from the web
interface.
Is it possible to do this. If yes, then what procedure I should follow.
If anybody have any idea about this then please, do help me. It's our
requirement.
Thanks and regards,
Chetan
of the data
IS> will be thrown away - is there any way to avoid this?
IS> bevore recovery: datafile: 4111857 byte - 1498 data sets
IS> after revovery: datafile: 1936768 byte - 759 data sets
IS> is there any way to keep the data inside without getting
IS> it thrown out? even
Hi there,
yesterday my mysql server (running under irix) has gone away
and took one table with it
so i tried to recover the data with isamchk -o table_name
unfortunalty during the recoveryprocess half of the data
will be thrown away - is there any way to avoid this?
bevore recovery: datafile
I'm facing an interesting data recovery challenge after a malicious hack
last week. It seems all the hacker did was log in to the machine and
"rm -rf /" and despite being assured backups were taken off-site daily it
seems that the only surviving full backup of the MySQL data files
Subject: A random occur problem. Error message: Couldn't fix table with
quick recovery: Found wrong number of deleted records. is reported when
trying to execute DELETE/DROP TABLE and then INSERT... SELECT statement
with thoursands of reocrds.
>Description:
Proble
Hi!
> "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes:
>> I will have to include a warning in the comments section of the MySQL
>> documentation to NOT CONVERT MySQL SYSTEM TABLES FROM myISAM TO INNODB TYPE!
I have now added a warning about this to the manual.
Regards,
Monty
Jeremy,
At 11:37 PM 11/2/01 -0800, you wrote:
>On Fri, Nov 02, 2001 at 11:17:37PM +0200, Heikki Tuuri wrote:
>>
>> I looked now what MySQL does when it calls lock_external at startup:
>> it initializes MySQL system tables like 'host' and 'user'. I assume
>> you have not converted MySQL system ta
On Fri, Nov 02, 2001 at 11:17:37PM +0200, Heikki Tuuri wrote:
>
> I looked now what MySQL does when it calls lock_external at startup:
> it initializes MySQL system tables like 'host' and 'user'. I assume
> you have not converted MySQL system tables to InnoDB format? That is
> not allowed. They
used the latest (2.23.44) RPMs from one of the mysql.com
>>>>mirrors. I don't think it's a download issue because the problem
>>>>originally occured with the 2.23.43 distribution.
>>>>
>>>>The crash occurs within seconds of starting mysqld-max
he mysql.com mirrors. I
>>>don't think it's a download issue because the problem originally
>>>occured with the 2.23.43 distribution.
>>>
>>>The crash occurs within seconds of starting mysqld-max so the server
>>>never really runs. I did read t
because the problem originally
>>occured with the 2.23.43 distribution.
>>
>>The crash occurs within seconds of starting mysqld-max so the server
>>never really runs. I did read the Forcing recovery section of the
>>manual and it suggests that I might have to reboot t
occured with the
>2.23.43 distribution.
>
>The crash occurs within seconds of starting mysqld-max so the server never
>really runs. I did read the Forcing recovery section of the manual and it
>suggests that I might have to reboot to clear some memory condition. I will
>give t
seconds of starting mysqld-max so the server never
really runs. I did read the Forcing recovery section of the manual and it
suggests that I might have to reboot to clear some memory condition. I will
give that a try.
Thanks,
Stephen
> Stephen,
>
> I resolved now with the mysql-max-3.23.44...tar
t; 0x8048111 _start + 33
>>
>> 3.23.44 has a new my.cnf parameter. You could try
>>
>> set-variable = innodb_force_recovery=2
>>
>> Does it now start to run? You can then try to dump your tables. See the
>> manual at http://www.innodb.com/ibman.html sec
ew my.cnf parameter. You could try
>
> set-variable = innodb_force_recovery=2
>
> Does it now start to run? You can then try to dump your tables. See the
> manual at http://www.innodb.com/ibman.html section 6.1 about forcing
> recovery.
>
> Regards,
>
> Heikki
> Innobase Oy
start to run? You can then try to dump your tables. See the
manual at http://www.innodb.com/ibman.html section 6.1 about forcing recovery.
Regards,
Heikki
Innobase Oy
-
Before posting, please check:
http://www.mysql.com
following message:
InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 212830477
011102 10:26:57 InnoDB: Started
mysqld got signal 11;
This could be because you hit a bug. It is als
aster is running a live 24x7
> service hence cannot stop the master without affecting uptime)?
Same answer. :-)
> 3. Related to (1), what's the best way to do recovery on BDB tables using
> the MySQL binary logs + BDB table snapshot + BDB logs? I've read the manual
> but
ter is running a live 24x7
service hence cannot stop the master without affecting uptime)?
3. Related to (1), what's the best way to do recovery on BDB tables using
the MySQL binary logs + BDB table snapshot + BDB logs? I've read the manual
but could not find such info :)
Thank
In the last episode (Oct 18), Terry Westry said:
> Good morning:
>
> My vendor (Campus Pipeline) directed me to your website to obtain some
> documentation, but they did not specify the title of the documentation
> to retrieve. I am to locate information on performing data
Good morning:
My vendor (Campus Pipeline) directed me to your website to obtain some
documentation, but they did not specify the title of the documentation
to retrieve. I am to locate information on performing data recovery
with update logs and repair scripts. Can you please direct me to the
I think that would work out for you.
Daniel
> Hi all,
>
> I'm wondering if there are any good documents. how-tos or faqs which
> illustrate backup and recovery plans/process for MySQL databases.
>
>
> Nick
>
>
>
>
> -
It seems that
> Mysql/InnoDB did not have enough time for shutting down properly
> because when the server restarted I had these messages in the error
> log of Mysql :
>
>InnoDB: Doing recovery: scanned up to log sequence number 52 663991808
>InnoDB: Doing recovery: scanned u
Bonjour,
I've rebooted my server with "sync;sync;reboot". It seems that
Mysql/InnoDB did not have enough time for shutting down properly
because when the server restarted I had these messages in the error
log of Mysql :
InnoDB: Doing recovery: scanned up
avid Bouw [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 17, 2001 6:17 PM
> To: [EMAIL PROTECTED]
> Subject: Hoping for Crash recovery Miracle
>
>
> Hi there,
>
> I would really appreciate any help someone can give on the following awful
> problem..
>
&
a: David Bouw [mailto:[EMAIL PROTECTED]]
> Sendt: 18. september 2001 01:53
> Til: [EMAIL PROTECTED]
> Kopi: [EMAIL PROTECTED]
> Emne: Fw: Hoping for Crash recovery Miracle
>
>
> Hi there,
>
> I would really appreciate any help someone can give on the
> following awful pro
Hi there,
I would really appreciate any help someone can give on the following awful problem..
I have been working all day on filling a table with data. (Small records..)
Because I have a table which I filled with some binary data someone asked me how big
this will get..
I looked at the di
Hi there,
I would really appreciate any help someone can give on the following awful problem..
I have been working all day on filling a table with data. (Small records..)
Because I have a table which I filled with some binary data someone asked me how big
this will get..
I looked at the direc
On Wed, Sep 12, 2001 at 09:35:37PM -0500, adam wrote:
>
> I got an idea and thought i would ask around about a recovery plan
> about databases? Currently all i do is dump the databases on to a
> share on an NT box thru a SMB share from the RH 7.1 Linux DB
> server. The NT box is
In the last episode (Sep 12), adam said:
> I got an idea and thought i would ask around about a recovery plan
> about databases? Currently all i do is dump the databases on to a
> share on an NT box thru a SMB share from the RH 7.1 Linux DB server.
> The NT box is a Compaq CL185
I got an idea and thought i would ask around about a recovery plan about
databases? Currently all i do is dump the databases on to a share on an
NT box thru a SMB share from the RH 7.1 Linux DB server. The NT box is a
Compaq CL1850 which is 2 Compaq 1850 server with a shared SCSI array.
The NT
101 - 200 of 238 matches
Mail list logo
