about libmygis

[z z]

Hi Jeremy Cole,
  I downloaded the source code about libmygis and compiled it on linux.I tried 
to use it ,but I don't know how to use it correctly,especially when i tried to 
import from shapefile data and associated files and generate MySQL commands in 
an output file .
  Can you tell me how to use it in detail?
   
  Thanks
   
  zz

   
-
抢注雅虎免费邮箱-3.5G容量，20M附件！！ 

Re: SQL Question...

[z]

On Sat, 06 Apr 2002 22:56:11 -0500, Chuck \"PUP\" Payne wrote:
>Hello again,
>
>I am trying to set up a SQL statement using NOW(), what I am wanting
>to do
>is to use NOW() then do a search on any date less than 7 days.
>Before I get
>several e-mails asking why. I am trying to a news base database for
>the
>company intranet and I am wanting to only show newsitems that are 7
>days or
>less. And I want NOW() to set today date and then go back as far as
>seven
>days. But I am not sure now to use < less than in my statement with
>NOW(),
>or if it will work.

you could try
select someStuff where someOtherDate > date_sub(now(), interval 7 day)

-z


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: backup

[z]

On Thu, 18 Jul 2002 16:05:34 +0200, Massimo Petrini wrote:
>Also in may NT machine appear the same error. Which is the problem ?

DBI is a perl module for interfacing with databases

see
http://search.cpan.org/search?module=DBI

-z

sql mysql query
-- 
z, [EMAIL PROTECTED] on 07/18/2002


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: What's this in my netstat?

[z]

On Sat, 12 Jan 2002 17:06:36 -0600, jerry wrote:
>Hi-
>
>Anyone know what web.mysql.com is doing?  It's from a netstat on a
>RH 7.2
>running mysql 3.23.47
>
>myhost.mydomain:4570  web.mysql.com:auth  TIME_WAIT
>
>Thanks-
>
>
this is the list sending you mail

-z
sql mysql


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Aliasing all fields

[z]

On Wed, 18 Sep 2002 22:45:29 -0400, Rob Hutton wrote:
>Is there a way to get MYSQL to alias all fields in a select even if
>there is
>no naming conflict?  For instance, if I do a:
>
>select * from table1, table2 where table1.t1c1 = table2.t2c2
>
>then I want
>
would select table1.*,table2.* from 

do that?

-z

-- 
z, [EMAIL PROTECTED] on 09/18/2002


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Replacing MS SQL with MySql

[Y z]

I have a windows app that wants to talk to either a) an access database, b) a 
MS Sql Express database, or c) a MS Sql 2008 database. 

Can anyone please point me in the direction of configuring My Sql to imitate 
any of the above?

Thanks!

  
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: Replacing MS SQL with MySql

[Y z]

Thanks. The developer cheerily informs me that Access is 'deprecated' and will 
be phased out. So, SQL it is. 

I'm not sure what you mean by 'passthrough'. Do you mean
MYSQL
  |
ODBC
  |
Win app
?

If so, where do I go to learn how to configure MySQL and ODBC to dance together 
nicely, and talk to the app?

Thanks!

> No way to do that directly; however, using the MySQL ODBC connector you can
> get at least a) and c) to play passthrough. Performance will likely suffer,
> though; especially Access' Jet Engine has a tendency to pull in full remote
> datasets instead of passing through the query.
>
>
> On Wed, Feb 9, 2011 at 6:36 AM, Y z  wrote:
>
> >
> > I have a windows app that wants to talk to either a) an access database, b)
> > a MS Sql Express database, or c) a MS Sql 2008 database.
> >
> > Can anyone please point me in the direction of configuring My Sql to
> > imitate any of the above?
> >
> > Thanks!
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be
> >
> >
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
  
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Update Text + Text

[A Z]

Hi,

MySql 4.0.14

How can I do this?

Update Table1, Table2 set Table1.Field1 =
Table2.Field1 + Table1.Field1 where Table1.KeyField =
Table2.KeyField

Tried the above with no success.

Field1, in both tables is of type Text.

regards






___ 
ALL-NEW Yahoo! Messenger - all new features - even more fun! 
http://uk.messenger.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Select Query!

[A Z]

Hi,

Would this be the best way, if I was to run query to
obtain first 2 records of each category from the
database.  The database could contain literally 100s
of 1000s of records.

select t1.field1, t2.field2 as CommonFld from table1
t1, table2 t2 where t1.keyfield = t2.keyfield and
t1.field1 = 'AAA' limit 2
UNION
select t1.field1, t2.field2 as CommonFld from table1
t1, table2 t2 where t1.keyfield = t2.keyfield and
t1.field1 = 'BBB' limit 2
ORDER BY CommonFld Desc


regards


Send instant messages to your online friends http://uk.messenger.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Can't Start MySql

[A Z]

MySQL 4.0.14 Win98 platform.

what could cause the following error by typing 
mysqld --console.

regards


050525 16:50:13  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 1 1545457619
InnoDB: Doing recovery: scanned up to log sequence
number 1 1545457619
050525 16:50:13  InnoDB: Flushing modified pages from
the buffer pool...
050525 16:50:13  InnoDB: Started
C:\TEAM\SQL\BIN\MYSQLD.EXE: ready for connections.
Version: '4.0.14-max-debug'  socket: ''  port: 3306
050525 16:50:14  InnoDB: Assertion failure in thread
4293331611 in file ../innob
ase/include\page0page.ic line 482
InnoDB: Failing assertion: offs < UNIV_PAGE_SIZE
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a detailed bug report to
mysql@lists.mysql.com
InnoDB: Thread 4293334199 stopped in file
C:\build\build\mysql-4.0.14b\innobase\




___ 
How much free photo storage do you get? Store your holiday 
snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

OS error 1453

[A Z]

Dear Fellows,

How to deal with the following error:

regards


mysqld-nt --console
050608 11:12:42  InnoDB: Operating system error number
1453 in a file operation.

InnoDB: See http://www.innodb.com/ibman.html for
installation help.
InnoDB: Error number 1453 means 'Unknown error'.
InnoDB: See also section 13.2 at
http://www.innodb.com/ibman.html
InnoDB: about operating system error numbers.
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'aio read'.
InnoDB: Cannot continue operation.






___ 
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail 
http://uk.messenger.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Help is appreciated

[A Z]

I am running Delphi 6 Ent. along with Corelab
technology to access MySQL 4.1.14.

We run into problem of table coruption (error: 127,
145) from time to time using the following SQLs.  This
is done in the transaction context.  Most of the time
it works fine but it does get into problem.  We have
tested it with simple insert and it seems to be
working fine.

We really appreciate your input.

{SQL} 

Delete From Table1

INSERT INTO Table1 (Field1, Field2) SELECT a.Field1,
'2004-02-25' From Table2 a LEFT Join Table3 b ON
(a.Field1 = b.Field2) 
where a.Field4 = '0' and a.Field5 = '0' and a.Field6
<= '2004-02-25'
and a.Field7 Like 'ABC%' and b.Field1 = 'FF'


regards






___
Yahoo! Messenger - Communicate instantly..."Ping" 
your friends today! Download Messenger Now 
http://uk.messenger.yahoo.com/download/index.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem to use mysql

[Z. S.Ghand]

Hi All;
I have written a small mysql program with c++ in linux. i compile it by 
g++ -L/usr/lib/mysql -I/usr/include/mysql -lsqlplus  myprogram.cc
 
it works properly. but when i want to execute it i receive this error:
error while loading shared libraries: libsqlplus.so.1: cannot open shared object file 
: no such file or directory.
 
i have libsqlplus.so.1 in /usr/lib/mysql 
 
thanks in advance.
 
 



-
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!

How?

[A Z]

Hi,

MySql 4.0.14
How can I force the following query to use a reference
in table1.

select * from table1 a left join table2 b on (a.field1
 =  b.field1) order by b.field2 limit 1

both a.field1 and b.field1 have indexes.  Explaining
the command indicates that, MySql uses an index
(possible_keys) on table2 but All on table1.

Is this how it should be?

regards


Send instant messages to your online friends http://uk.messenger.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysqld-nt error 23. Urgent pls

[A Z]

MySQL 4.0.14

Need help please with the folowing:


On starting mysqld-nt using
mysqld-nt --console
we the get the follwing output

041115 10:31:59  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 3 3136790960
InnoDB: Doing recovery: scanned up to log sequence
number 3 3136791157
041115 10:32:00  InnoDB: Starting an apply batch of
log records to the database
..
InnoDB: Progress in percents: 32 33 34 35 36 37 38 39
40 41 42 43 44 45 46 47 4
 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
67 68 69 70 71 72 73 74
5 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92
93 94 95 96 97 98 99
InnoDB: Apply batch completed
041115 10:32:00  InnoDB: Flushing modified pages from
the buffer pool...
041115 10:32:02  InnoDB: Started
041115 10:32:09  InnoDB: Operating system error number
23 in a file operation.
InnoDB: See http://www.innodb.com/ibman.html for
installation help.
InnoDB: Error number 23 means 'Too many open files in
system'.
InnoDB: See also section 13.2 at
http://www.innodb.com/ibman.html
InnoDB: about operating system error numbers.
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'Windows aio'.
InnoDB: Cannot continue operation.


regards




___ 
Win a castle for NYE with your mates and Yahoo! Messenger 
http://uk.messenger.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysql & NTFS

[A Z]

MySQL 4.0.14

Are there any known issues with MySQL (above version)
and NTFS file system with 120 GB of hard-disk and Win
2000 pro.

We are facing a problem of mysqld-nt crashing
intermittently, throwing error numbers 995, 32.

any help is appreciated.

regards




___ 
Win a castle for NYE with your mates and Yahoo! Messenger 
http://uk.messenger.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqld-nt error 23. Urgent pls

[A Z]

Thanks,

We tried copying the file but with no success. 
Running Norton DD reported errors with file
descriptors.

regards


 --- Heikki Tuuri <[EMAIL PROTECTED]> wrote: 
> Hi!
> 
> 4.0.14 on Windows prints a wrong (errno)
> explanation. You should look at
>
http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html
> 
> "
> 23 (ERROR_CRC)
> Data error (cyclic redundancy check).
> "
> 
> Your file (system) is corrupt, and Windows notices
> it. It is a hardware 
> fault or a Windows bug.
> 
> Try copy:ing ibdata1 to another file. Does it
> succeed?
> 
> Best regards,
> 
> Heikki Tuuri
> Innobase Oy
> Foreign keys, transactions, and row level locking
> for MySQL
> InnoDB Hot Backup - a hot backup tool for InnoDB
> which also backs up MyISAM 
> tables
> http://www.innodb.com/order.php
> 
> Order MySQL technical support from
> https://order.mysql.com/
> 
> 
> 
> - Original Message - 
> From: "A Z" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.myodbc
> Sent: Wednesday, November 17, 2004 1:48 AM
> Subject: mysqld-nt error 23. Urgent pls
> 
> 
> >
> >
> > MySQL 4.0.14
> >
> > Need help please with the folowing:
> >
> >
> > On starting mysqld-nt using
> > mysqld-nt --console
> > we the get the follwing output
> >
> > 041115 10:31:59  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 3 3136790960
> > InnoDB: Doing recovery: scanned up to log sequence
> > number 3 3136791157
> > 041115 10:32:00  InnoDB: Starting an apply batch
> of
> > log records to the database
> > ..
> > InnoDB: Progress in percents: 32 33 34 35 36 37 38
> 39
> > 40 41 42 43 44 45 46 47 4
> > 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65
> 66
> > 67 68 69 70 71 72 73 74
> > 5 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91
> 92
> > 93 94 95 96 97 98 99
> > InnoDB: Apply batch completed
> > 041115 10:32:00  InnoDB: Flushing modified pages
> from
> > the buffer pool...
> > 041115 10:32:02  InnoDB: Started
> > 041115 10:32:09  InnoDB: Operating system error
> number
> > 23 in a file operation.
> > InnoDB: See http://www.innodb.com/ibman.html for
> > installation help.
> > InnoDB: Error number 23 means 'Too many open files
> in
> > system'.
> > InnoDB: See also section 13.2 at
> > http://www.innodb.com/ibman.html
> > InnoDB: about operating system error numbers.
> > InnoDB: File name .\ibdata1
> > InnoDB: File operation call: 'Windows aio'.
> > InnoDB: Cannot continue operation.
> >
> >
> > regards
> >
> >
> >
> >
> >
>
___
> > Win a castle for NYE with your mates and Yahoo!
> Messenger
> > http://uk.messenger.yahoo.com
> >
> > -- 
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: 
> >
>
http://lists.mysql.com/[EMAIL PROTECTED]
> > 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   
>
http://lists.mysql.com/[EMAIL PROTECTED]
> 
>  



___ 
Win a castle for NYE with your mates and Yahoo! Messenger 
http://uk.messenger.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

probs with starting mysql (urgent pls)

[A Z]

MySQL 4.0.14
InnoDB (File size as it stands at present) = 6 GB
We have tried move the data folder from one hard disk
to another still the same problem.  We really are in
need of help here.  Is there any size limit in InnoDB?


I did ask this before, I did get some reponse thank
you.  But due to the nature of the problem I'm give it
another try.

On trying to start Mysqld-nt --console the following
appears.

InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an
InnoDB database,
InnoDB: the problem may be that during an earlier
attempt you managed
InnoDB: to create the InnoDB data files, but log file
creation failed.
InnoDB: If that is the case, please refer to section
3.1 of
InnoDB: http://www.innodb.com/ibman.html
041123 13:38:36  Can't init databases
041123 13:38:36  Aborting

041123 13:38:36  InnoDB: Warning: shutting down a not
properly started
 InnoDB: or created database!
041123 13:38:36  mysqld-nt: Shutdown Complete


regards






___ 
ALL-NEW Yahoo! Messenger - all new features - even more fun! 
http://uk.messenger.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: General query question

[A Z]

Thanks,

I did think of it but not having the option as this is
linked to executables, which I'm sure have some sorts
of calculation for this field to calculate the next
value.

regards



 --- Jigal van Hemert <[EMAIL PROTECTED]> wrote: 
> > I want to create entries in the child table
> (table2)
> > for the missing records.  In table2 the primary
> key is
> > of type Integer,
> > for each new entry it should be
> > Max(table2.PrimaryKeyfield) + 1.
> 
> Why not make the primary key in table2
> autoincrement? If you have an
> autoincrement field as primary key MySQL will do the
> max(..)+1 automatically
> for you!
> 
> A query like
> 
> Insert into table2 (field1, field2)
> select a.field1, a.field2
> from table1 a
> left join table2 b on (a.field1 = b.field1)
> where b.field1 is null
> 
> could then be used to fill up the missing records in
> table2...
> 
> Regards, Jigal.
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   
>
http://lists.mysql.com/[EMAIL PROTECTED]
> 
>  





___ 
ALL-NEW Yahoo! Messenger - all new features - even more fun! 
http://uk.messenger.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

General query question

[A Z]

Hi,

Mysql 4.0.14

In a seconrio, some reocrds are missing from a child
table.  If we run this query it returns the missing
records:

select a.field1, b.field2 from table1 a left join
table2 b on (a.field1 = b.field1) where b.field1 is
null


I want to create entries in the child table (table2)
for the missing records.  In table2 the primary key is
of type Integer,
for each new entry it should be
Max(table2.PrimaryKeyfield) + 1.

How can I do this in one sql command (or is it
possilbe at all)?

something like:
Insert into table2 (primarykeyfiled, field1, field2)
Max(table2.priamrykeyfield) + 1 select a.field1,
a.field2 from table1 a left join table2 b on (a.field1
= b.field1) where b.field1 is null

regards






___ 
ALL-NEW Yahoo! Messenger - all new features - even more fun! 
http://uk.messenger.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Error: 1040 too many connections

[A Z]

Hi,

MySQL 4.0.14

This may have been queried a lot here.

We get this error and after re-starting the server
(MySQL) it seems to go away for a while.

As per instructions we have changed the max connection
in the My.ini to 500 (max_connections=500). 
MySQLAdmin displays connections = 120.

Is there anything else we can do to deal with this
issue?

regards






___ 
ALL-NEW Yahoo! Messenger - all new features - even more fun! 
http://uk.messenger.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Premature InnoDB conversion.

[A Z]

MySql 4.0.14

We tried to convert MyISAM table format to INNODB
format, it took forever to finish the process, someone
intervened and killed the process through Task
Manager.

Now can't run Mysqld-nt, running it with the --console
reports the followings.  Your help is appreciated.

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

c:\MySql\mysqld-nt --console
050201 11:26:22  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 799702164
050201 11:26:22  InnoDB: Starting an apply batch of
log records to the database.
..
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10
11 12 13 14 15 16 17 18 19
20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
38 39 40 41 42 43 44 45 46
 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64
65 66 67 68 69 70 71 72 7
3 74 75 76 77 78 050201 11:26:24  InnoDB: Assertion
failure in thread 1344 in fi
le ../innobase/include\page0page.ic line 482
InnoDB: Failing assertion: offs < UNIV_PAGE_SIZE
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a detailed bug report to
mysql@lists.mysql.com









___ 
ALL-NEW Yahoo! Messenger - all new features - even more fun! 
http://uk.messenger.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Cannot run MySQL

[A Z]

MySql 4.0.14

We tried to convert MyISAM table format to INNODB
format, it took forever to finish the process, someone
intervened and killed the process through Task
Manager.

Now can't run Mysqld-nt, running it with the --console
reports the followings.  Your help is appreciated.

Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

c:\MySql\mysqld-nt --console
050201 11:26:22  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 799702164
050201 11:26:22  InnoDB: Starting an apply batch of
log records to the database.
..
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10
11 12 13 14 15 16 17 18 19
20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
38 39 40 41 42 43 44 45 46
 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64
65 66 67 68 69 70 71 72 7
3 74 75 76 77 78 050201 11:26:24  InnoDB: Assertion
failure in thread 1344 in fi
le ../innobase/include\page0page.ic line 482
InnoDB: Failing assertion: offs < UNIV_PAGE_SIZE
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a detailed bug report to
mysql@lists.mysql.com






___ 
ALL-NEW Yahoo! Messenger - all new features - even more fun! 
http://uk.messenger.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Indexes

[A Z]

MySql 4.0.14

I understand that the most effective way of speeding
up SELECT statements is to have column level indexes. 
Are there any other level indexes exist?  I have been
told that there are but I have no idea, looked through
the manual, could not find anything that speeds up
column level indexing.

regards






___ 
ALL-NEW Yahoo! Messenger - all new features - even more fun! 
http://uk.messenger.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Performance

[A Z]

Mysql 4.0.14

2 Tables:

Table1: Indexed on Field1 (primary key), Field2
Table2: Indexed on Field1 (primary key), Field2
(Foreign key from table1)

When I do this
explain select a.*, b.* from table1 a, table2 b, where
a.field1 = b.field2 and a.field2 = 'value'. returns
the result:
Table   typepossible_keys   Key Key_len ref
a   ALL Primary, Field2 
b   ref Field2  Field2  37  a.Field1

And it takes along time to process (~25 seconds) on
only ~5000 records.  Is there anything we do wrong
here?

regards






___ALL-NEW Yahoo! Messenger - 
so many all-new ways to express yourself http://uk.messenger.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to?

[A Z]

An existing database table structures has changed, I
want to create the same database with new table
structures.  I do not want to lose any data.

How can I do this? do a backup how?


regards






___ALL-NEW Yahoo! Messenger - 
all new features - even more fun!  http://uk.messenger.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Concat

[A Z]

Hi,

Concat() returns Null if any field in the field list
is Null.  How can I use it to return a String
regardless, or is there another function to do it?

regards






___ALL-NEW Yahoo! Messenger - 
all new features - even more fun!  http://uk.messenger.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Select

[A Z]

MySQL 4.0.14

Trying to run a select statement on field (varchar)
containing values (e.g. ':', '/', '\') returns blank
recordset although records exist.

select * from table1 where field1 =
'c:\folder\filename.extension'

Is there any particular rule to follow.  I inserted
the same row twice and run a Distinct() returned only
one row.

regards






___ALL-NEW Yahoo! Messenger - 
all new features - even more fun!  http://uk.messenger.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Duplicate Rows

[A Z]

MySQL 4.0.14

In a scenario:

Ref  EmailAddr

1[EMAIL PROTECTED]
2[EMAIL PROTECTED]
3[EMAIL PROTECTED]
4[EMAIL PROTECTED]

how can I delete duplicate email entries (records 1,
2) leaving 4.

regards






___ALL-NEW Yahoo! Messenger - 
all new features - even more fun!  http://uk.messenger.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Select Performance

[A Z]

A table (Table1) with the relevant indices (e.g.
Field1Idx, Field2Idx) exists.  Running a query like:
Select * from table1 where Field1Idx Like 'Value%'
returns result in expected timing scale, so does the
query:
Select * from table1 where Field2Idx Like 'Value%'

The problem (very slow) occurs when the query is run
on combination of these fields:
Select * from table1 where (Field1Idx Like 'Value%' or
Field2Idx Like 'Value%')

We have followed everything by the book, the table
includes another index on (Field1, Field2), running
Explain command on the last query details that it uses
the index (Field1, Field2), it's just too slow
(minutes we are talking about).

Anything we have not done for this delay to occur?
please enlighten.

regards









___
Yahoo! Messenger - Communicate instantly..."Ping" 
your friends today! Download Messenger Now 
http://uk.messenger.yahoo.com/download/index.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Select Performance

[A Z]

Thanks, but this is not what we expected.  This means
to change the SQL command in the application.  Our
understanding from the manual and other relational DBs
is that, it's suffice for existence of an index on the
field in the criteria (where clause) to run at optimal
speed.

regards


 --- Harald Fuchs <[EMAIL PROTECTED]> wrote: > In
article
>
<[EMAIL PROTECTED]>,
> A Z <[EMAIL PROTECTED]> writes:
> 
> > The problem (very slow) occurs when the query is
> run
> > on combination of these fields:
> > Select * from table1 where (Field1Idx Like
> 'Value%' or
> > Field2Idx Like 'Value%')
> 
> Try a UNION query:
> 
> SELECT *
> FROM table1
> WHERE Field1Idx LIKE 'Value%'
> UNION
> SELECT *
> FROM table1
> WHERE Field2Idx LIKE 'Value%'
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   
>
http://lists.mysql.com/[EMAIL PROTECTED]
>  





___
Yahoo! Messenger - Communicate instantly..."Ping" 
your friends today! Download Messenger Now 
http://uk.messenger.yahoo.com/download/index.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Another Performance query

[A Z]

Thanks for your replies regarding to my previous
query.

We have encountered another problem:
MySQL 4.0.14, INNODB.
A table does have an Index on Field1, this field
(Field1) is also the Primary Key.  Querying on this
field takes a long time, running along with Explain
command it displays that it does not use the index. 
Prior converting to INNODB it had been working fine in
MYISAM.

What could cause this problem?

regards






___
Yahoo! Messenger - Communicate instantly..."Ping" 
your friends today! Download Messenger Now 
http://uk.messenger.yahoo.com/download/index.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Another Performance query

[A Z]

here we go:

explain select * from properties where reference like
'%2332'
+-+
Table ¦ type ¦ possible keys ¦ key ¦ key_len ¦ ref ¦
rows ¦ Extra
+-+
Properties ¦ All ¦ NULL ¦ NULL ¦ NULL ¦ NULL ¦ NULL ¦
2923 ¦ Using Where

describe properties;
+-+
Field ¦ Type ¦ Null ¦ Key ¦ Default ¦ Extra
+-+
Reference ¦ VarChar(7) ¦   ¦ PRI ¦   ¦

show index from properties;
+-+
Table ¦ Non_unique ¦ Key_name ¦ Seq_in_index ¦
Column_name ¦ Collation ¦ Cardinality ¦ Sub_part ¦
Pakced ¦ Null ¦ Index_type ¦ Comment
+-+
properties ¦ 0 ¦ PRIMARY ¦ 1 ¦ Reference ¦ A ¦ 2923 ¦
NULL ¦ NULL ¦   ¦ BTREE

regards



 --- Benoit St-Jean <[EMAIL PROTECTED]> wrote: > A
Z wrote:
> 
> >Thanks for your replies regarding to my previous
> >query.
> >
> >We have encountered another problem:
> >MySQL 4.0.14, INNODB.
> >A table does have an Index on Field1, this field
> >(Field1) is also the Primary Key.  Querying on this
> >field takes a long time, running along with Explain
> >command it displays that it does not use the index.
> 
> >Prior converting to INNODB it had been working fine
> in
> >MYISAM.
> >
> >What could cause this problem?
> >
> 
> Can you provide us with the EXPLAIN of the query, a
> DESCRIBE TABLE and a 
> SHOW INDEX to help us pinpoint what the problem is?
>  





___
Yahoo! Messenger - Communicate instantly..."Ping" 
your friends today! Download Messenger Now 
http://uk.messenger.yahoo.com/download/index.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

If DataBase Exists

[A Z]

MySQL 4.0.14

Possible to query for existence of a DB.  For example
connect to MySQL and run run a command to check if
Database (Test2) existed.

regards






___
Yahoo! Messenger - Communicate instantly..."Ping" 
your friends today! Download Messenger Now 
http://uk.messenger.yahoo.com/download/index.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MS 2000 Advance Server

[A Z]

Hi,

MySQL 4.0.14
Are there any known issues on windows 2000 advance
server?
After installation, on running the WinMySQLAdmin the
green light comes on for a second or two and then
disconnected.  We tried running MySQLd-nt on its own,
it simply cannot establish connection.

What could be wrong here?

regards







Yahoo! Messenger - Communicate instantly..."Ping" 
your friends today! Download Messenger Now 
http://uk.messenger.yahoo.com/download/index.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Query 2 DBs

[A Z]

Hi,

2 DBs sitting on different machines, any idea of how
to run the query?

Select a.*, b.field1 from computernam.db1.table1 a,
computername.db2.table1 b where a.fieldx = b.fieldx

where computername is host for DB.

regards







Yahoo! Messenger - Communicate instantly..."Ping" 
your friends today! Download Messenger Now 
http://uk.messenger.yahoo.com/download/index.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Filling column

[A Z]

Hi,

Is there a function to fill an integer column in
incremental order (1,2,..,n).
Cannot use Auto_Increment as the table has another
primary key.

regards







Yahoo! Messenger - Communicate instantly..."Ping" 
your friends today! Download Messenger Now 
http://uk.messenger.yahoo.com/download/index.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Max

[A Z]

Hi,

A field of type VarChar() with following syntax:
ABA1.
How to get the Max value.  Bearing in mind that value
ABA10 comes before ABA2.

regards







Yahoo! Messenger - Communicate instantly..."Ping" 
your friends today! Download Messenger Now 
http://uk.messenger.yahoo.com/download/index.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Exists

[A Z]

Hi,

How can I write this query?

Insert into table1 (field1) select (a.field1) from
table2 a where a.field1 not exists (select c.field1
from table1 c)

regards







Yahoo! Messenger - Communicate instantly..."Ping" 
your friends today! Download Messenger Now 
http://uk.messenger.yahoo.com/download/index.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Exists

[A Z]

MySQL 4.0.14

regards

 --- Rhino <[EMAIL PROTECTED]> wrote: > What version
of MySQL are you running? The answer to
> your question depends
> on the version.
> 
> Rhino
> 
> - Original Message - 
> From: "A Z" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, May 14, 2004 9:00 AM
> Subject: Exists
> 
> 
> > Hi,
> >
> > How can I write this query?
> >
> > Insert into table1 (field1) select (a.field1) from
> > table2 a where a.field1 not exists (select
> c.field1
> > from table1 c)
> >
> > regards
> >
> >
> >
> >
> >
> >
> >
>

> > Yahoo! Messenger - Communicate instantly..."Ping"
> > your friends today! Download Messenger Now
> > http://uk.messenger.yahoo.com/download/index.html
> >
> > -- 
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:   
>
http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
>  






Yahoo! Messenger - Communicate instantly..."Ping" 
your friends today! Download Messenger Now 
http://uk.messenger.yahoo.com/download/index.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Type=InnoDB

[A Z]

the following raises error:150.  Does this mean we
cannot do this in INNODB format?

create table t1 (a1 integer not null, b1 varchar(36),
primary key (a1), foreign key (b1) references t2(b1)
on delete cascade) TYPE=INNODB

regards







Yahoo! Messenger - Communicate instantly..."Ping" 
your friends today! Download Messenger Now 
http://uk.messenger.yahoo.com/download/index.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to (Unique value)?

[A Z]

4.0.14

Its rather a general SQL question, I'll ask it as I'm
using MySQL.

An converted table has field of type VarChar(6),
containing alphanumeric chars.
Is it possible to run a query to generate a unique key
so this can be used for new record?

regards






___ALL-NEW Yahoo! Messenger - 
so many all-new ways to express yourself http://uk.messenger.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

search query crashing mysql ..... :S

[toby z]

hay guyz

im havin  a weired problem

i ve this search query

$srch_qry = " select ctnt_inf.* from ctnt_inf ".
	" where (match (firstName ) against (\"".$srch."\") ".
		" or match (lastName ) against (\"".$srch."\") ".
		" or match (summary ) against (\"".$srch."\") ".
		" or match (body) against (\"".$srch."\") ".
		" or match (title ) against (\"".$srch."\") )";


$srch_qry_hndl = mysql_query ($srch_qry)
or die ('qry failed !  DA tbl must xixt in DA db specifyd bov  :s');


n im gettin bizzar results .


i)sometimes it works perfect showin all the results


ii)n some times it missbehavez . shows a sorry note for the strings i 
KNOW exist in the full text fields im serchin on .



iii)but most of the times  it crashes mysql . :S
i get thid msg box declaring mysql is gonna shut down



now
1. i ve got win 2K pro, php 4.2.2, mysql  3.23.39 , apache 1.3.24

2. im workin with unicode text n most of the fulltext fields im searching on 
are unicode


guyz im all stuck with this query
plz hlp


thnx a mill

toby ..




_
Add photos to your messages with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: search query crashing mysql ..... :S

[toby z]

thnx gerald

plz tell me how can i run the qoute() function on $srch

i tried to look the function up in mysql doccumentation online but no luck 
.


thnx a million

toby ..






From: gerald_clark <[EMAIL PROTECTED]>
To: toby z <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: search query crashing mysql . :S
Date: Mon, 25 Nov 2002 09:17:43 -0600

You did not run the quote() funcion on $arch.
If $arch contains any special characters, it will break your query.

toby z wrote:




hay guyz

im havin  a weired problem

i ve this search query

$srch_qry = " select ctnt_inf.* from ctnt_inf ".
" where (match (firstName ) against (\"".$srch."\") ".
" or match (lastName ) against (\"".$srch."\") ".
" or match (summary ) against (\"".$srch."\") ".
" or match (body) against (\"".$srch."\") ".
" or match (title ) against (\"".$srch."\") )";


$srch_qry_hndl = mysql_query ($srch_qry)
or die ('qry failed !  DA tbl must xixt in DA db specifyd bov  :s');


n im gettin bizzar results .


i)sometimes it works perfect showin all the results


ii)n some times it missbehavez . shows a sorry note for the strings i 
KNOW exist in the full text fields im serchin on .



iii)but most of the times  it crashes mysql . :S
i get thid msg box declaring mysql is gonna shut down



now
1. i ve got win 2K pro, php 4.2.2, mysql  3.23.39 , apache 1.3.24

2. im workin with unicode text n most of the fulltext fields im searching 
on are unicode


guyz im all stuck with this query
plz hlp


thnx a mill

toby ..




_
Add photos to your messages with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail 
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail 
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


_
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. 
http://join.msn.com/?page=features/virus


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

converting from foxpro to mysql ???????

[toby z]

ok guyz i need some inside info .

plz help me with:

1. there aint no foreign keys in mysql then what can i do about  cascading 
updates, deletes and all


2. if i ve to conver a db in foxpro to mysql or sql which one should i 
preffer and y 

3. and while im converting the foxpro db to mysql what will i ve to loose 
 the common pitfalls ..


4. n finally do i have anyother choice of open source database (cheapest if 
not completely free) for this conversion ?



id be eternally gratefull if anyone cud guide me thru this ..


thnx a billion zillion guyz .

toby ..


_
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: converting from foxpro to mysql ???????

[toby z]

thnx fo takin the time to reply anyways . :(

toby ..







From: Tonu Samuel <[EMAIL PROTECTED]>
To: toby z <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: converting from foxpro to mysql ???
Date: 28 Nov 2002 11:47:45 +0200

On Wed, 2002-11-27 at 17:05, toby z wrote:
>
>
> ok guyz i need some inside info .
>
> plz help me with:
>
> 2. if i ve to conver a db in foxpro to mysql or sql which one should i
> preffer and y 

pz do nt use thz hax0r w0rdz

It is really hard to read. Many people here do not speak english
natively and even just using plain english is complicated.

I am not going to read further about your problem. Sorry.

  Tonu


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail 
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


_
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

high speed insertion required

[Z Julian]

Hi everyone~~
I have a program inserting data into myisam tables continuously by queries 
like "insert into table1 select * from table2". I need an insertion speed 
about 1,000 entries per second with the average entry length of about 50 
bytes. But the actual speed of the insertion is only about 450 entries per 
second. If I comment the code doing insertion, the program can reach a 
speed about 1600 entries per second. So is there any way to tune mysql to 
improve the insertion speed ?

Thanks!  :)

_
Äú¿ÉÒÔÔÚ MSN Hotmail Õ¾µã http://www.hotmail.com/cn Ãâ·ÑÊÕ·¢µç×ÓÓʼþ


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: high speed insertion required

[Z Julian]

Hi Mark:
 "insert delayed" helps little.
 I think there are two reasons.
  1. One reason "insert delayed" speeding up insertion is that the client 
will return immediately after it issues a "insert delayed" query. I think 
all those inserts must be stored in a delayed queue and will be executed 
whenever it is possible or necessary. But since the delayed queue can't 
hold too many inserts and my program inserts data at a steady and high 
speed and will run for a long period of time (couple of days or maybe 
weeks), the queue will be full inevitably. And after the queue is full, I 
think no inserts can be delayed any longer. At that time, the insertion 
speed of my program will low down to the normal speed as insertion without 
"delayed" option chosen.
  2. Another reason "insert delayed" speeding up insertion is that inserts 
from many clients are bundled together and written in one block. But on my 
server there are no other clients. So the insertion of my program can't be 
accelerated in this way neither.

>Disable or remove indexes. This sometimes speeds it up tremendously
>depending on your indexes.

 Well, index... I do have some indexes in the tables, but I can't give them 
up because those tables will be accessed at any time during the insertion.

>Is the hash table in the same server/database?

 The hash tables are in the same database.

 Well, I think maybe I should face the reality, maybe my program has 
already tried its best, and so have we(us? hehe, poor english :).
 Any way, thanks for your help.

>From: "Mark Rissmann" <[EMAIL PROTECTED]>
>To: "Z Julian" <[EMAIL PROTECTED]>
>Subject: Re: high speed insertion required
>Date: Thu, 13 Sep 2001 11:14:26 -0700
>
>I use Delphi and am having a similar problem. But here are some things 
that
>can be done (that I haven't tried).
>
>INSERT DELAY -- this is supposed to help because my SQL will recognize a
>group of inserts into a table and queue them. This should be faster. 
You'll
>have to experiment on how long you allow the queue to build.
>
>Disable or remove indexes. This sometimes speeds it up tremendously
>depending on your indexes.
>
>Is the hash table in the same server/database?
>
>Please post your findings to the listserver. Let me know if this works or 
if
>you have any more questions.
>
>Mark Rissmann
>-Drifting Sands LLC
>
>- Original Message -
>From: "Z Julian" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Thursday, September 13, 2001 1:24 AM
>Subject: Re: high speed insertion required
>
>
> > Hi:
> > Thanks for your reply. :)
> > I write that program in C. I get data from a mysql heap table which is
>always full of records. That's why I use queries like "insert into table1
>select from table2" to insert data. Obviously table2 is the heap table I
>mentioned above.
> > I use that program to do some log jobs. Someone tells me to use "insert
>HIGH_PRIORIRY" to speed up the insertion, but I think that helps little
>since there are no other database clients running on my machine except the
>one which fills the heap table for my program.
> > Do you have any suggestion? Please mail. Thank you and have a nice day! 
:)
> >
> > >From: "Mark Rissmann" <[EMAIL PROTECTED]>
> > >To: [EMAIL PROTECTED]
> > >Subject: Re: high speed insertion required
> > >Date: Thu, 13 Sep 2001 01:02:31 -0700
> > >
> > >Hello,
> > >
> > >What development tool are you programming in? Where are you getting 
these
>records from?
> > >
> > >Have you received any good tips?
> > >
> > >Mark Rissmann
> > >-Drifting Sands LLC
> > >
> > >
> > >
> > >"I do not fear computers. I fear the lack of them." - Isaac Asimov
> >
> >


_
Äú¿ÉÒÔÔÚ MSN Hotmail Õ¾µã http://www.hotmail.com/cn Ãâ·ÑÊÕ·¢µç×ÓÓʼþ


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Auto reconnect in application?

[Z Julian]

Hi~
  I have a question. If I do nothing after I use mysql C API to connect to 
mysql server, how long the connection will be kept? If there is a time 
limit, what will happen if I execute some queries when the time is out? 
Will the API function like mysql_query () reconnect to the server and 
execute the queries automatically like the mysql client does?
  Thanks.   :)

Julian

_
Äú¿ÉÒÔÔÚ MSN Hotmail Õ¾µã http://www.hotmail.com/cn Ãâ·ÑÊÕ·¢µç×ÓÓʼþ


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

journaled file system

[Z Julian]

Hi~
 I want to use journaled file system on my computer. Can you give me some 
advice? Furthermore, could journeled file system improve the performance of 
mysql? If yes, which journeled file system is better for mysql?
 Thank you~~  :)


 Julian

_
Äú¿ÉÒÔÔÚ MSN Hotmail Õ¾µã http://www.hotmail.com/cn Ãâ·ÑÊÕ·¢µç×ÓÓʼþ


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Ask for Linux+MySQL installation help

[Z Julian]

try to copy mysql libraries to /usr/local/lib and /usr/lib
cp -a /usr/local/MySQL/lib/MySQL/* /usr/local/lib
cp -a /usr/local/MySQL/lib/MySQL/* /usr/lib


>From: "YANG" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Ask for Linux+MySQL installation help
>Date: Fri, 2 Nov 2001 13:43:46 +0800 (CST)
>
>Dear Sir:
>   I want to ask some questions about Redhat Linux+MySQL installation.
>1. At the Redhat Linux 6.2 opration system, I install MySQL database 
3.23.43. Commands is as follws:
># cd /usr/local
># tar ¨Czxvf MySQL-3.23.443.tar.gz
># mv MySQL-3.23.43 /usr/local/MySQL
># cd /usr/local/MySQL
># ./configure ¨Cprefix=/usr/local/MySQL
># make
># make install
>Instalation Success;
>2. Then, I write a small program test.c to test the mysql database C API. 
The makefile is as follows:
># gcc ¨CI/usr/local/MySQL/include/MySQL ¨Cc test.c
># gcc ¨Co test test.o ¨CL/usr/local/MySQL/lib/MySQL ¨Cl/MySQLclient
>Compile and link all success;
>3. But, when I run the program, error occurs. Error message is as follows:
># ./test: error in loading shared libraries:libMySQLclient.so.6 cannot 
open shared object file: No such file or directory
>4. I install MySQL Rpm Package in another computer. The version of Redhat 
Linux and MySQL is same as that mentioned previously. Instalation command 
is as follows:
># rpm ¨Ci MySQL-3.23.43-1.i386.rpm  MySQL-client-3.23.43-1.i386.rpm 
MySQL-devel-3.23.43-1.i386.rpm MySQL-shared-3.23.43-1.i386.rpm
>   I compile and link it with same makefile. This time, everything is OK.
>   Because I want use Linux+MySQL+Apache+PHP in our system, I want install 
MySQL database with the first method. So I ask for helping as soon as 
possible. Thanks.
>
>My E-mail address is: [EMAIL PROTECTED]
>
>
>
>
>
>
>


_
Äú¿ÉÒÔÔÚ MSN Hotmail Õ¾µã http://www.hotmail.com/cn Ãâ·ÑÊÕ·¢µç×ÓÓʼþ


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: run-all-tests always fails under reiserfs partition

[Z Julian]

Hi~:
I do use a via chipset mother board.

Today I tried the option notail, it really works!!!

Thanks  :)

  Julian

PS: Do you have any idea about sgi's xfs?

>From: George Eric R Contr AFSPC/CVYZ <[EMAIL PROTECTED]>
>To: Z Julian <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>Subject: RE: run-all-tests always fails under reiserfs partition
>Date: Thu, 8 Nov 2001 16:16:15 -
>
>FWIW, I'm not convinced reiserfs is ready for prime time, at least not on
>all hardware (Any chance you're running a Via chipset MB?).  I've had some
>serious stability problems when trying out reiserfs that magically
>disapeared when I went back to ext2 (and now ext3).
>
>One thing that I've heard helps is to set the notail option when mounting 
a
>reiserfs partition.
>
>
>-Original Message-
>From: Z Julian [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, November 08, 2001 1:16 AM
>To: [EMAIL PROTECTED]
>Subject: run-all-tests always fails under reiserfs partition
>
>
>Hi~:
>My OS is RH7.1 with kernel version 2.4.2-2.
>Yestoday I upgraded my kernel to 2.4.14 with configuring it to support
>reiserfs as build-in capability. After that I created a reiserfs partition
>and mounted it successfully. Everything seemed to be OK.
>Then I installed mysql and located the install directory to the reiserfs
>partition. Mysqld started. OK again.
>And then I entered the /reiserfs/partition/mysql/sql-bench directory to 
run
>the perl script "run-all-tests", things turned to be weird. I got the
>following display:
>
>*
>[root@server sql-bench]# ./run-all-tests --server=mysql
>Benchmark DBD suite: 2.13
>Date of test:2001-11-08 15:33:30
>Running tests on:Linux 2.4.14 i686
>Arguments:
>Comments:
>Limits from:
>Server version:  MySQL 3.23.41
>
>ATIS: Total time: 49 wallclock secs ( 7.95 usr  1.67 sys +  0.00 cusr  
0.00
>csys
>  =  9.62 CPU)
>alter-table: unable to handle kErneL paging request
>**
>
>and the machine freezed.
>I tries several times, every time I got different result. Sometimes the
>kernel infomation displayed, such as register value, stack info and etc.
>Sometimes the machine auto rebooted. And sometimes my machine turned to be
>a ambulance and made terrible noises. But there is not a single time the
>tests finished successfully.
>
>Once I recovered the partition to ext2 file system. All those problems
>vanished and tests finished successfully.
>
>What's wrong?
>
>   Confused Julian
>
>
>_
>Äú¿ÉÒÔÔÚ MSN Hotmail Õ¾µã http://www.hotmail.com/cn Ãâ·ÑÊÕ·¢µç×ÓÓʼþ
>
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail 
mysql.com>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail 
<[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


_
Äú¿ÉÒÔÔÚ MSN Hotmail Õ¾µã http://www.hotmail.com/cn Ãâ·ÑÊÕ·¢µç×ÓÓʼþ


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: storing PDF files in mysql ?????

[toby z]

thnx rich

but u see the problem iz my clients want their text IN pdf format to be

displayed with all these colors on the page in other  words they want

their sites layout to be maintained on the pages showing this pdf text

as they are pretty concerned bout security


so what do i do now 


thnx a mill

toby



>From: "R.Dobson" <[EMAIL PROTECTED]>
>To: toby gibbson <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: storing PDF files in mysql ?
>Date: Tue, 08 Oct 2002 16:35:56 +0100
>
>
>hi,
>2 ways to do this:
>
>a) don't store the file actually in the db but store the path to it.
>
>b)use the function LOAD_FILE(filename) to get the contents of a file as a 
>string value and store as a blob.
>
>decide which to use depending on how many pics you have
>
>cheers
>Rich
>
>toby gibbson wrote:
>
>>ok guyz more trouble
>>
>>now im supposed to convert all the text (from ms word) to PDF and put the 
>>pdf files in mysql db
>>
>>now i ve really got myslf stuck havent i
>>
>>can anyone plz hlp 
>>
>>thnx a million
>>
>>stuck az usual
>>
>>toby .
>>
>>
>>
>>_
>>Chat with friends online, try MSN Messenger: http://messenger.msn.com
>>
>>
>>-
>>Before posting, please check:
>>   http://www.mysql.com/manual.php   (the manual)
>>   http://lists.mysql.com/   (the list archive)
>>
>>To request this thread, e-mail <[EMAIL PROTECTED]>
>>To unsubscribe, e-mail 
>><[EMAIL PROTECTED]>
>>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>>
>
>
>--
>
>Richard Dobson
>Database Administrator
>MRC Bright Study
>Clinical Pharmacolgy
>St Bartholomew's and the Royal London
>School of Medicine and Dentistry
>Charterhouse Square
>London EC1M 6BQ
>Tel: 020-7882-5670
>Mob: 07711-522926
>Fax: 020-7882-5672
>[EMAIL PROTECTED]




_
Send and receive Hotmail on your mobile device: http://mobile.msn.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: storing PDF files in mysql ?????

[toby z]

thnx guyz

1) i m tryin to put the pdf file into a blob field but i cant insert it like 
normal text how shall i go about inserting it 



2) i m in the process of converting the word doccuments to pdf got this 
acrobat disteller n m havin a million probz with that alone like the 
security issue

I NO THIS IS THE WRONG LIST SORRY FOR THIS Q BUT .. has anyone worked with 
this thing n wouldnt mind me mailin him/her plz do lemme no


guyz plz hlp .

thnx a billion

toby


>From: "Sqlcoders.com Programming Dept" <[EMAIL PROTECTED]>
>To: "toby z" <[EMAIL PROTECTED]>,"list mysql" <[EMAIL PROTECTED]>
>Subject: RE: storing PDF files in mysql ?
>Date: Tue, 8 Oct 2002 21:47:23 -0600
>
>Toby,
>If I understand correctly you want to perform two distinct actions:
>1. Convert Microsoft Office Word .doc files into .pdf
>2. Store those pdf's in MySQL.
>
>You should look into (via google.com) some doc to pdf converters. An 
>example
>is this com object: 
>http://www.convertzone.com/doc2pdfcom/help.htm#HowtoBuy,
>it costs $219 and converts .doc to .pdf.
>
>If you can convert the .doc's into .html files, you might be able to get
>away with using Adobe's free email converter service.
>Email the HTML document to [EMAIL PROTECTED], wait an hour or so, and
>you'll find a pdf version in your inbox.
>(There's also a [EMAIL PROTECTED] address if you dont want to use html, but
>I think you wanted to keep formatting).
>
>Once you have the document in PDF, it's a relatively trivial action to 
>store
>the documents in your MySQL database.
>
>HTH,
>William.
>
> > -Original Message-
> > From: kayamboo [mailto:[EMAIL PROTECTED]]
> > Sent: 08 October 2002 18:20
> > To: toby z
> > Cc: list mysql
> > Subject: Re: storing PDF files in mysql ?
> >
> >
> > I think if you decide to store in the blob,
> > whatever it is, a pdf or jpeg or bmp, it is going to be in binary 
>format.
> > While you need to display it back, just convert them back to
> > whatever format
> > you like.
> >
> > Else there is always the choice of just storing the path in your 
>database.
> >
> > By the way, which language you are using to write your applications.
> > If it is delphi, I can send you some sample code
> >
> >
> > regards
> >
> > - Original Message -
> > From: "toby z" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Cc: <[EMAIL PROTECTED]>
> > Sent: Wednesday, October 09, 2002 1:14 AM
> > Subject: Re: storing PDF files in mysql ?
> >
> >
> > > thnx rich
> > >
> > > but u see the problem iz my clients want their text IN pdf format to 
>be
> > >
> > > displayed with all these colors on the page in other  words they want
> > >
> > > their sites layout to be maintained on the pages showing this pdf text
> > >
> > > as they are pretty concerned bout security
> > >
> > >
> > > so what do i do now 
> > >
> > >
> > > thnx a mill
> > >
> > > toby
> > >
> > >
> > >
> > > >From: "R.Dobson" <[EMAIL PROTECTED]>
> > > >To: toby gibbson <[EMAIL PROTECTED]>
> > > >CC: [EMAIL PROTECTED]
> > > >Subject: Re: storing PDF files in mysql ?
> > > >Date: Tue, 08 Oct 2002 16:35:56 +0100
> > > >
> > > >
> > > >hi,
> > > >2 ways to do this:
> > > >
> > > >a) don't store the file actually in the db but store the path to it.
> > > >
> > > >b)use the function LOAD_FILE(filename) to get the contents of
> > a file as a
> > > >string value and store as a blob.
> > > >
> > > >decide which to use depending on how many pics you have
> > > >
> > > >cheers
> > > >Rich
> > > >
> > > >toby gibbson wrote:
> > > >
> > > >>ok guyz more trouble
> > > >>
> > > >>now im supposed to convert all the text (from ms word) to PDF and 
>put
> > the
> > > >>pdf files in mysql db
> > > >>
> > > >>now i ve really got myslf stuck havent i
> > > >>
> > > >>can anyone plz hlp 
> > > >>
> > > >>thnx a million
> > > >>
> > > >>stuck az usual
> > > &

RE: storing PDF files in mysql ?????

[toby z]

thnx jan

vat im planning to do NOW is
ill store path to the pdf file in the db
as i ve been told the files r gonna take a hell lotta space (n i ve planty 
of them)

secondly i ll keep the TEXT of these pdf files in the db for indexing n them 
compare search keywordz with these n throw out the matching pdf file (no 
other way i can see about it)

third pal
if u ve ever worked with these thinggyz
i cant figure out how to disabble text selection while im cpnverting word to 
PDF so that nobdy can copy the files
(im using acrobat dissteller for conversion if this helps)


thnx a mill

toby ..


>From: Jan Steinman <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: RE: storing PDF files in mysql ?
>Date: Wed, 9 Oct 2002 12:58:33 -0700
>
> >From: "Sqlcoders.com Programming Dept" <[EMAIL PROTECTED]>
> >
> >You should look into (via google.com) some doc to pdf converters. An 
>example
> >is this com object: 
>http://www.convertzone.com/doc2pdfcom/help.htm#HowtoBuy,
> >it costs $219 and converts .doc to .pdf.
>
>That's $219 saved if you're on MacOS X, since PDF conversion is universally 
>available to any application that can print.
>
> >Once you have the document in PDF, it's a relatively trivial action to 
>store
> >the documents in your MySQL database.
>
>Using BLOBs, I assume? I believe the original quester also wanted to be 
>able to search them, which I believe is non-trivial! You can't simply slap 
>a FULLTEXT index on them, right?
>
>It seems to me one would have to create an index BEFORE putting the PDFs in 
>MySQL, then add that index as a separate FULLTEXT field.
>
> SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL SQL 
>
>--
>: Jan Steinman -- nature photography: 
>: Bytesmiths -- artists' services: 
>: Join the forums at 
>
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




_
Chat with friends online, try MSN Messenger: http://messenger.msn.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

making two fields primary key ????

[toby z]

hi guyz

i ve to alter my table n make two fields primary key
(well the combination of the two to be xact)

any idea how to do dis ?


thnx a mill

toby





:S:S:S:S:S:S:S mysql query :S:S:S:S:S:S:S



_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Workaround for distinct?

[Dwalu Z. Khasu]

On Thu, 14 Dec 2006, Chris Boget wrote:

=>>I tried this out this morning on MySQL 5.
=>> It works. Please try this in MySQL 4 and see.
=>
=>Unless I'm way off, I do not believe your solution will work in 4.x because 
=>it doesn't support sub-queries...
=>
4.1 does.  See http://dev.mysql.com/doc/refman/4.1/en/subqueries.html
-- 
- Dwalu
.peace
--
I am an important person in this world -
Now is the most important time in my life -
My mistakes are my best teachers -
So I will be fearless.
- Student Creed

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to restore 1 database from mysqldump of all databases

[Dwalu Z. Khasu]

On Tue, 10 Jul 2007 [EMAIL PROTECTED] wrote:

=>Thanks for your response, Rolando.  I know all the DML to create the
=>database is in the mysqldump.  I was looking for a command or command
=>options, if there are any, to extract the DML for the database, like what
=>you can do with mysqlbinlog.
=>
=>
Should be mysqldump --no-data  (or -d) -- Try mysqldump --help.
-- 
- Dwalu
.peace
--
I am an important person in this world -
Now is the most important time in my life -
My mistakes are my best teachers -
So I will be fearless.
- Student Creed

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Adding DSN into Coldfusion Admin?

[Dwalu Z. Khasu]

On Thu, 14 Oct 2004, Steve Grosz wrote:

=>If that's the case, its not working, I type a telnet 192.168.x.x:3306 
=>and get a "could not open a connection to the host"  even though 
=>Mysql-nt shows as running on the Win2003 server.
=>
=>Steve
=>
Try 'telnet host port'.

- Dwalu
.peace
--
I am an important person in this world -
Now is the most important time in my life -
My mistakes are my best teachers -
So I will be fearless.
- Student Creed

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Adding DSN into Coldfusion Admin?

[Dwalu Z. Khasu]

On Thu, 14 Oct 2004, Steve Grosz wrote:

=>I have tried telnet web-server2:3306
=>
=>Didn't work
=>
Neither the DOS nor Unix man pages for telnet mention a colon--Why do you 
think you need one?  Let me try again, how about 'telnet web-server 3306'?
...
...
=>Dwalu Z. Khasu wrote:
[snip]
=>> =>
=>> Try 'telnet host port'.
=>> 


-- 
- Dwalu
.peace
--
I am an important person in this world -
Now is the most important time in my life -
My mistakes are my best teachers -
So I will be fearless.
- Student Creed

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Adding DSN into Coldfusion Admin?

[Dwalu Z. Khasu]

On Thu, 14 Oct 2004, Dwalu Z. Khasu wrote:

=>Neither the DOS nor Unix man pages for telnet mention a colon--Why do you 
=>think you need one?  Let me try again, how about 'telnet web-server 3306'?
=>
Sorry for the typo.  For your example, that should've been:
telnet web-server2 3306

Are you sure you're connecting to the appropriate box?  Should your 
command string be telnet  3306 instead?  

- Dwalu
.peace
--
I am an important person in this world -
Now is the most important time in my life -
My mistakes are my best teachers -
So I will be fearless.
- Student Creed

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Data Standards on Database Export->Import

[Z X C V]

Hello,
Are there any good rfcs or other documents that would assist in the 
discussion I'm having with our organization's Oracle programmers in 
regards the following:

Oracle DB -> MySQL
They recommend:
~ col~col ~col~ col'",~col
NOTE::I placed the '" in for a reason.
I am looking for:
"col","col","col","col\'\",","col"
Of course the "non-Oracle" system is being tasked as the problem in this 
case for the "abnormal" data request.

Any help on this would be appreciated.
Rob.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Data Standards on Database Export->Import

[Z X C V]

Stephen,
That is interesting... The DBA and Oracle programmers are really raising 
an issue on the difficulties of this extraction. We can use a ~ delimited 
file but were told to give "our" standards. To which now they are saying 
is out of time scope.

Thank you for this information since it gives us some help understanding 
their side of the issue.

A view would be the best but that is a REALLY bad idea... At least in 
their opinion.

R.
On Wed, 23 Mar 2005, Stephen Andert wrote:
Actually, exporting data from an Oracle database is one of the weak
spots of Oracle.  Oracle makes it easy to get data in, but hard to get
it back out.  There are ways to do it, but nothing easy that an Oracle
DBA will have if they only read the Oracle docs.  Spooling an output
file can get tedius if there are a lot of columns in the table or many
tables.
There are a number of freeware and open source solutions as well as
third party solutions, but in most cases, a good DBA should be able to
develop some dynamic scripts to get the data out in the format you
need.  Features like the use of LONG datatypes may throw a monkey
wrench in the works.
Good luck.
Stephen
(Sr Oracle DBA by day - Jr MySQL DBA by night)
On Tue, 22 Mar 2005 10:48:53 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Z X C V <[EMAIL PROTECTED]> wrote on 03/21/2005 08:32:24 PM:
Hello,
Are there any good rfcs or other documents that would assist in the
discussion I'm having with our organization's Oracle programmers in
regards the following:
Oracle DB -> MySQL
They recommend:
~ col~col ~col~ col'",~col
NOTE::I placed the '" in for a reason.
I am looking for:
"col","col","col","col\'\",","col"
Of course the "non-Oracle" system is being tasked as the problem in this

case for the "abnormal" data request.
Any help on this would be appreciated.
Rob.
Unfortunately I am not sure any document like you seek actually exists (at
least not in any modern literature). There are many ways to move data from
memory to media and the format of the data on the media is usually
determined by a number of factors (type of data, type of media, is the
data intended for human or machine use, etc.). So I am not sure there ARE
any standards for database export formatting (I did a quick Google and
didn't find any in the top 50 responses for the search: data export
standard format CSV (see notes below))...
To be honest, the mysqlimport and LOAD DATA INFILE facilities should be
flexible enough to read the tilde-delimited format that your Oracle guys
want to give you. If not, you should be able to ask them to either create
a tab-delimited or comma-delimited dump (both formats are so "ancient" as
to be /de facto/ standards and should be something that Oracle can create
without any difficulty). What you were asking for is a comma-delimited
format but you need some extra escaping to make it more MySQL compatible.
I think that the extra escaping is what's throwing a monkey-wrench into
the export process.
One viable option is for you to write a quick converter that re-parses
their tilde-delimited format into something properly escaped for MySQL. IF
you write it correctly, your format converter should be able to process
several megabytes of dumped data per second. Yes, it's a pain in the neck
to take the extra conversion step but sometimes we DBA's have to assemble
our own lemons before we get to make the lemonade.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Notes:
a non-normative description of the CSV format:
http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm
An example data export screen, a "custom delimiter" of a tilde would
reproduce the format you are being offered:
http://www.jinfonet.com/manualpro/userguide/expt_txt.htm
Some export/import formats of various ecological data. Notice how many
there are: http://gce-lter.marsci.uga.edu/lter/data/formats.htm
A proposed format for "Thoughts" exchange:
http://www.ms.lt/importexport.html

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Trouble with correlated subquery

[Glenn Holden - Pivotal Z]

Hello,

I am having a problem with this correlated sub query.  I get a syntax error
at the second SELECT.
This is part of a larger query with other aggregated sub queries or I would
consider a JOIN instead.
I tried running the sub query by itself and it works.  I tried LEAST for
MIN, same result.
The jobnumber/jobno fields are Chars and the schstartrun is a Double.
I am developing on Windows XP with MySQL 4.17.

Thanks for any help
Glenn




  SELECT
pj.jobnumber,

 (SELECT MIN(pl.schstartrun)
 FROM plist pl
 WHERE pl.jobno = pj.jobnumber
AND pl.schstartrun > 0)
AS SchStart
 FROM
  planjobs AS pj





Glenn Holden - Pivotal Z
[EMAIL PROTECTED] / 303 400 0573 / www.pivotalz.com
17328 E Bates Place, Aurora, Colorado 80013-2206 / fax 425 984 0297


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]