Dear All,
While migrating from MySQL 4.0 to MySQL 4.1, I found that the database
could not be loaded in 4.1 because MySQL 4.1 uses a reserved keyword "div"
that was not "reserved" in 4.0.
Is there anyway to get around the issue?
Thanks in advance.
Manoj
--
MySQL General Mailing List
F
I think it's not fair to expect the list to reply with the kind of
information you have provided.
Are these tables indexed et all? What indices are you using? Have you tried
to see what "explain" tell you about the plan the optimizer will use to
execute the query?
Rest assured, you surely stand a
mysqldump is your friend.
Manoj
- Original Message -
From: "Rob Agar" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, August 02, 2005 8:53 AM
Subject: export data as sql inserts
> hi list
>
> I was just wondering - does anyone have or know of a sql or php script
> for exporting a table's data
Greetings,
I am trying to get a feel of how MySQL would handle certain types of
situation, mainly concerning the usage of indices.
Say I have two exactly identical table structures namely table A & B.
For table A, I just have one composite primary key on (Code, Date1 &
Date2).
Fo
A quick google search revealed the following link:
http://bugs.mysql.com/bug.php?id=3139
Looks like it's one of those things related with Windoze! hence I would
start by checking if the OS is updated with latest patches.
HTH
Manoj
- Original Message -
From: "Nirmal Shah" <[EMAIL PROT
Greeting,
Is there any comprehensive documentation on "show Innodb status" command? I
found the mysql help page a bit short and the whole exercise has left me with
many questions unanswered hence any tips from pratical experience that would
help in Innodb performance tuning would be greatly app
Greetings,
I took a dump of (pretty chunk) database, the output is close to 45G. I
am trying to reload this dump file onto a development server but it's
taking long time to load the database. Is their a faster way to load the
data in? I am using plain and simple mysql < dump.sql syntax on
PM
Subject: Re: MySQL 4.015 Vs MySQL 4.1.x
> Hi,
>
> I'm thinking too about switching to MySQL 4.1.x and if it better to user
> file per table.
>
> How much tables and data have you in your db? And which performance you
have?
>
>
> Best Regards,
> Rafal
>
&
Dear All,
I am using MySQL 4.0.15 on a Linux (RH9) for the past 18 months. All my
tables are InnoDB and tend to be extremely large in nature (running in
couple of millions, actually the ibdata files now stand at 40GB's).
Typically, the database has fewer connections but those who connect use th
Please note though - If you are using VC 6 (as the subjec tline says) then
please read the FAQ of msql++ since it says that the library works with 7.1
onwards.
- Original Message -
From: "Philippe Poelvoorde" <[EMAIL PROTECTED]>
To:
Sent: Monday, April 18, 2005 6:04 PM
Subject: Re: Vi
om: [EMAIL PROTECTED]
To: ManojW
Cc: MySQL List
Sent: Thursday, April 07, 2005 11:44 PM
Subject: Re: Question on Composite Index
"ManojW" <[EMAIL PROTECTED]> wrote on 04/06/2005 10:09:31 PM:
> Dear All,
> Just to get a better understanding of how indices
MySQL supports Stored procedures from version 5.0 onwards...for more
information see
http://dev.mysql.com/doc/mysql/en/stored-procedures.html
Rgds
Manoj
- Original Message -
From: "Winanjaya" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, April 12, 2005 2:23 PM
Subject: NewBie how to create s
Dear All,
Just to get a better understanding of how indices work in MySQL - If I
have a Innodb table with a composite primary key (fld1,fld2,fld3,fld4,fld5),
then my understanding is that MySQL optimizes just the leftmost primary key
(fld1 in this case).
Hence a query like select * from tbl1 w
13 matches
Mail list logo
