problem has 2 gigs. This
being the only difference, I can only guess that it is the source of the
problem. The table is very large that I am dealing with - the physical
size is just over 1 gig. My only guess would be perhaps it is trying to
do a CREATE TABLE before the DROP completes.
David
the logs
is the table which it attempts to create already exists, therefore from
that point on the replication stops. We can't understand why suddenly
the DROP TABLE doesn't get replicated.
Does anyone have any experience with such a problem?
Thanks.
Davi
o smoothly.
David Piasecki
Software Engineer
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 11:45 PM
To: [EMAIL PROTECTED]
Subject: Re: MySQL InnoDB startup problem
David,
did you upgrade from a very old version of MySQL to .49? The sortin
any experience with this sort of problem? Thanks.
David Piasecki
Software Engineer
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To re
db1.table1 WHERE date < (predefined
date);
Is something like this possible, or am I barking up the wrong tree?
Thanks.
David Piasecki
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://l
ble - each contains approximately 20
columns, one auto-increment field, and one index.
Hoping someone has some insight into this matter... BTW, both servers
are on the same private network, literally being right next to each
other, so I know it's not a network issue.
RTFM...
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html
#Date_and_time_functions
SELECT DATE_FORMAT(datefield,'%j') FROM table ....
David Piasecki
Software Engineer
Netvolution.com, Inc.
http://www.netvolution.com
548 South Spring Street, Suite 814, Los
either a hardware or
operating system problem. The server has been rebooted numerous times
with the same end result.
Has anyone else had similar problems? Any ideas?
David Piasecki
-
Before posting, please check:
http
Run the following query:
SHOW VARIABLES LIKE 'have_%';
You should see something like this:
+---+---+
| Variable_name | Value |
+---+---+
| have_bdb | NO|
| have_gemini | NO|
| have_innodb | YES |
| have_isam | YES |
| have_raid | NO
