Interesting. Usually innodb corruption is the result of hardware failure; it
looks from the log like you need to recover your database, and remove the
existing data at the filesystem level, then re-import.
How to get data out of a corrupted innodb is here:
http://dev.mysql.com/doc/refman/5.0/en/
I didn't notice that there was a **LOT** more junk dumped into the log:
100104 16:43:47 mysqld started
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
100104 16:43:49 InnoDB: Database was not shut down normally!
InnoDB: Starting
mysql-5.0.77-4.el5_4.1 on RHEL 5.4
At some point, mysqld died. When i try to restart, mysqld.log says:
;InnoDB: End of
page dump
100104 16:31:14 InnoDB: Page checksum 1575996416, prior-to-4.0.14-form
checksum 1371122432
InnoDB: stored checks
On Mon, Jan 4, 2010 at 10:40 AM, Arthur Fuller wrote:
> The ProductPackages table is what is known as an associate table, and is
> used to implement a many-to-many relationship. You only need it if a given
> product can be in multiple packages. If not, then you can eliminate the
> associative tabl
Hi
Can anyone confirm if there are any connection time out values I can specify
in my application (ASP (VBScript) for the MySQL ODBC connection.
Cheers
Neil
>-Original Message-
>From: Edward S.P. Leong [mailto:edward...@ita.org.mo]
>Sent: Sunday, January 03, 2010 2:13 AM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Dear Jerry,
>
>Sorry...
>I just visit www.php.net...
>BUT I don't quite understanding the online manual:
>http://www.php.net/man
>Dear Jerry,
>
>Would you mind to tell me how to update ( what tool/editor ) all of your
>php source code for using with your new version of php and mysql ?
>
[JS] If I had one, I would do it. I've been using an editor named Textpad for
a very, very long time but despite its many features I wouldn
The ProductPackages table is what is known as an associate table, and is
used to implement a many-to-many relationship. You only need it if a given
product can be in multiple packages. If not, then you can eliminate the
associative table and just add a PackageID column to the Products table.
There
2010/1/3 Ashley Sheridan :
> On Sun, 2010-01-03 at 15:10 +0800, Edward S.P. Leong wrote:
>
>> Dear All,
>>
>> If the OS is Windows 2003 64Bit (IIS)...
>> So, which php package must download and how to config it for running
>> with IIS ?
>> Due to I don't quite the online manual:
>> http://www.php.n
Hello,
I'm working on an application for my bachelor thesis.
I'm having a performance problem with a SQL-Query in MySQL5.
I hoped someone can easily enlighten me in this issue.
The schema:
CREATE TABLE IF NOT EXISTS `athletes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`last_name`
I am certified Dba, the book is all you need for the examwell 8 years
experience help as well. What I mean is that
On 4 jan 2010 10:20, wrote:
Hi Machiel,
First of all, obligatory disclaimer: Until 2007, I was in charge of the
MySQL certification exams. I'm also co-author of the book I'm a
Hi Machiel,
1) the best resource for the exam is/was the Cerification Study Guide and it
is all you need to pass the exam but
2) the exam changed recently (no more from Vue) so that the Guide could be
useless
I am not telling you that being certified this way makes sense only for some
corpor
Hi Machiel,
First of all, obligatory disclaimer: Until 2007, I was in charge of the
MySQL certification exams. I'm also co-author of the book I'm about to
recommend, but I receive no sales royalties. All of which means that I'm
biased and my knowledge may be a bit rusty, but hopefully still
13 matches
Mail list logo
