John and Dan-
would have to see your constraint statement preferably the CREATE TABLE
statement to make any kind of intelligent assessment here..
Martin Gainty
__
Disclaimer and confidentiality note
Everything in this e-mail and any attachments rel
[EMAIL PROTECTED] mysqldump -u jpaulo -paivalf -h 200.18.142.98 genweb
-- MySQL dump 10.11
--
-- Host: 200.18.142.98Database: genweb
-- --
-- Server version 4.0.18-log
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+
In the last episode (Jul 26), John Nietzsche said:
> i am in need to migrate a database between two mysql server. The
> server source is running mysql 4.0.18-log, the destination server is
> running mysql 5.0.51a-log.
>
> I dumped the database (in the server source) using mysqldump utility.
> The
At 09:14 AM 7/26/2008, you wrote:
At 5:52p -0400 on Fri, 25 Jul 2008, mos wrote:
[Adding index to memory table silently loses data]
First thing, what version are you using?
MySQL 5.0.24a on Windows XP Pro with 3gb RAM. The server is on the same
machine as the client since I'm the only one usi
At 5:52p -0400 on Fri, 25 Jul 2008, mos wrote:
[Adding index to memory table silently loses data]
First thing, what version are you using?
Second thing, although it would still be broken, did you read the MySQL
docs to make sure that the Memory table type supports the index *type*
you attempted t
Dear friends,
i am in need to migrate a database between two mysql server. The
server source is running mysql 4.0.18-log, the destination server is
running mysql 5.0.51a-log.
I dumped the database (in the server source) using mysqldump utility.
The command i issued in de source sever was:
robigo$
You can also set the bulk_insert_buffer_size=, based
on available RAM.
This would improve bulk insert on myisam tables.
regards
anandkl
On 7/26/08, mos <[EMAIL PROTECTED]> wrote:
>
> At 06:46 PM 7/25/2008, you wrote:
>
>> List,
>>
>> I am bulk inserting a huge amount of data into a MyISAM table
