Re: How do I import a .dmp file?

2004-07-23 Thread Martin Gainty
There is an easier path- you *could buy* a data migration tool such as ispirer http://www.ispirer.com/products HTH, Martin Gainty (cell) 617-852-7822 From: matt ryan <[EMAIL PROTECTED]> To: Martin Gainty <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: How d

RE: How do I import a .dmp file?

2004-07-22 Thread Martin Gainty
David Did you look at MYSQL LOAD DATA INFILE ??? doc is available at http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html regards, Martin Gainty (cell) 617-852-7822 (e) [EMAIL PROTECTED] (http)www.laconiadatasystems.com From: David Blomstrom <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject:

Re: blob and substring

2004-07-21 Thread Martin Gainty
http://www.javalobby.org/kb/entry!default.jspa;jsessionid=43D42C7656C249E645485AF43737A12A?categoryID=48&entryID=79&fromSearchPage=true HTH, Martin Gainty From: gerald_clark <[EMAIL PROTECTED]> To: jonathan dumaresq <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: blo

RE: Problem with GRANT...WITH GRANT OPTION

2004-07-21 Thread Martin Gainty
John- GRANT privilege ON table_or_database_name TO [EMAIL PROTECTED] IDENTIFIED BY 'password' in this case you need to GRANT GRANT ON table_or_database_name TO [EMAIL PROTECTED] IDENTIFIED BY 'password' Hope this helps, Martin Gainty SQL Consultant USA 001-617-852-7822 F

Re: Animals Database Questions

2004-07-17 Thread Martin Gainty
David- generate a composite index on a unique combination such as genus/species Regards Martin - Original Message - From: "David Blomstrom" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, July 17, 2004 1:03 PM Subject: Animals Database Questions > I'm working on a big animals

Re: Need help with my LEFT JOIN query...

2004-07-11 Thread Martin Gainty
Jeff Why are you doing a LEFT JOIN instead of a INNER JOIN right now you are getting all rows from first table regardless of match condition so all of the rows for a.ProductID FROM ImportLiebermansStep3Add are being returned try the inner join instead Martin - Original Message - From: "Jeff

Re: Between Operator

2004-07-10 Thread Martin Gainty
Craig- are you sure you want to test ranking_id < '10' ??? -martin - Original Message - From: "Craig Hoffman" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Friday, July 09, 2004 3:51 PM Subject: Re: Between Operator > Thanks everyone for helping out.I took Michael's advic

Re: How to query an oracle table from a mysql database

2004-07-07 Thread Martin Gainty
starts exhausting memory (including virtual disk drive space in particular) and computer resources in general Keep me apprised, Martin Gainty (cell) 617-852-7822 (e) [EMAIL PROTECTED] (http)www.laconiadatasystems.com From: Steve Davies <[EMAIL PROTECTED]> To: "'Alonso, Claudio F

Finding Tables created by views

2004-07-01 Thread Martin Gainty
Folks- I have a table that is chock full of errors..(PLAN shows Table Access full) so I know that it was created wrong Is there an easy way to setup a query to locate all views that use this table? Thanks, Martin Gainty (cell) 617-852-7822 From: Bill MacAllister <[EMAIL PROTECTED]> To

Re: Optimising SQL Statements

2004-06-25 Thread Martin Gainty
Thanks Shawn! Marty Gainty (cell) 617-852-7822 From: [EMAIL PROTECTED] To: "Martin Gainty" <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: Optimising SQL Statements Date: Fri, 25 Jun 2004 12:59:28 -0400 MIME-Version: 1.0 Received: from lists.mysql.com ([213.136.5

Optimising SQL Statements

2004-06-25 Thread Martin Gainty
delete and insert operations Any ideas on how I can optimise (I used truncate instead of delete and that helped big time) Vielen Danke, -Martin Martin Gainty __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relating to the

Re: general qn

2004-06-16 Thread Martin Gainty
Try http://www.yolinux.com/TUTORIALS/LinuxTutorialMySQL.html Oorey vie oort, Martin - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 16, 2004 11:37 AM Subject: general qn Hi folks, I'm trying to install mysql on linux and it's giving me troubl

Re: Tracking Down a Ghost Database

2004-06-14 Thread Martin Gainty
What happens if you SELECT DATABASE(); ??? -M - Original Message - From: "David Blomstrom" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 14, 2004 6:51 PM Subject: Tracking Down a Ghost Database > I'm not sure if I'm wrestling with a 1) PHP problem, > 2) MySQL problem, o

Re: Errors from Extra Spaces in Spreadsheets

2004-06-07 Thread Martin Gainty
David: Microsoft has a converter for Works files at http://www.microsoft.com/downloads/details.aspx?FamilyID=b9e11e83-f51b-4977-b572-8c042df802c1&displaylang=en I did'nt see any online documentation HTH, Martin - Original Message - From: "David Blomstrom" <[EMAIL PROTECTED]> To: <[EMAIL PR

Re: Comma Delimited Import Error

2004-06-06 Thread Martin Gainty
David looking at http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html Any of the field- or line-handling options can specify an empty string (''). If not empty, the FIELDS [OPTIONALLY] ENCLOSED BY and FIELDS ESCAPED BY values must be a single character. Addionally it is a good idea to say FIELDS TERMIN

Re: Set user password by using PowerBuilder

2004-03-16 Thread Martin Gainty
Basically to set the password you want to effect a GRANT on the Table here is example > >> >mysql> create database test_dummy; > >> >Query OK, 0 rows affected (0.00 sec) > >> >mysql> grant all on test_dummy.* to dummy; > >> >Query OK, 0 rows affected (0.00 sec) > >> >mysql> set password for 'd

Re: Valid Ports in Windows

2004-02-26 Thread Martin Gainty
Matt: Read the port specifications enumerated in the services file in %SystemRoot%\win32\drivers\etc Contact your net/sys admin to see which ports he is allowing to cross his firewall. Some admins shut off everything except 80 (HTTP) HTH, -Martin - Original Message - From: "Matt P. Fuller"

Re: Sequrity question or am I paranoid?

2004-02-17 Thread Martin Gainty
Store the password (encrypted of course) in your DB de jour Read the 'user record' for that username and pull the associated password Of course its nice to allow the capability to assign a new password Yes I Agree wholeheartedly with your first statement.. -Martin - Original Message - From:

Re: Expressions

2004-01-19 Thread Martin Gainty
you were so close http://www.mysql.com/doc/en/SELECT.html SELECT COLUMNNAME AS WHATEVER FROM TABLENAME; Marty Gainty - Original Message - From: "Ian O'Rourke" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 19, 2004 2:16 PM Subject: Expressions > Regarding the followi

Re: Selecting Articles by Month and Year

2004-01-18 Thread Martin Gainty
Ian- The first step would be to insert date/time stamp into each of your records during Insert/Update operations. Here is a link how to insert a DATE/TIME into a MySQL Column http://www.php-scripts.com/php_diary/070700.php3 Cheers, Martin Gainty 001-617-852-7822 - Original Message - From

Re: Looking for a tool

2004-01-13 Thread Martin Gainty
Here is how. http://forums.devshed.com/archive/4/2001/3/3/12143 Regards, -Martin - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 13, 2004 8:15 PM Subject: Looking for a tool > Several years ago, I used a cgi based tool that allowed me to uplo

Re: Strange reply

2004-01-10 Thread Martin Gainty
A way for the postmaster to convey that the recipients email address has changed. So the admin of [EMAIL PROTECTED] is going to go in and change the subscribed email of Person X to the new email advertised in this email To quote Homer Simpson "Yeah Right!" Regards, -Martin - Original Message --

Re: Convert MS Access to MySql

2003-12-21 Thread Martin Gainty
Arthur On converting data from MS Access. I've done this several times myself, and found the easiest way is to: 1. Create your mySQL database tables 2. Define a DSN (ODBC Connection) from your workstation to the mySQL database 3. Link the mySQL tables into your MS Access database 4. Copy the conte

Re: "undefined reference to `errno'"

2003-12-14 Thread Martin Gainty
the reference is found in the source.. from crt.c #include Regards, -Martin - Original Message - From: "Jeff Gordon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, December 14, 2003 3:57 PM Subject: Re: "undefined reference to `errno'" > On Sun, Dec 14

sample my.cnf

2003-11-28 Thread Martin Gainty
the MySQL path via my.cnf or my.in but cannot find any my.ini or my.cnf in the downloaded zip Could someone supply me their my.ini or my.cnf so I may overcome the hardcoded I:\MyMySQL spec? Many Thanks, Martin Gainty 617-852-7822

Re: web interface...

2003-10-09 Thread Martin Gainty
Dont worry The indians will put 3 more of us out of work by tommorrow am! -M - Original Message - From: "John Nichel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 09, 2003 6:45 PM Subject: Re: web interface... > Martin Gainty wrote: > &

Re: web interface...

2003-10-09 Thread Martin Gainty
There are about 1000 people on this list that can put a web front end for you Something to think about.. -Martin Gainty - Original Message - From: "Dora" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 09, 2003 6:21 PM Subject: web interface...

Re: Question about logging in to mysql via PAM or using existing login credentials

2003-09-17 Thread Martin Gainty
yes Kerberos is the ticket use stashticket to cache your unix credentials http://www.cs.wisc.edu/csl/doc/info/kerberos/ then put the runauth script in ~/public/.forward check the link for details -Martin - Original Message - From: "Tomasz Korycki" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTE

NULL

2003-09-15 Thread Martin Gainty
Randy- NULL means No Data So in the case of a MySQL Column defined as Type String NULL is equivalent to "" Best Regards, Marty Gainty

Re: mysqldev user ?

2003-09-10 Thread Martin Gainty
Jason- Login as root then issue grant statements on the priveleges to assign to the new user http://www.mysql.com/doc/en/Adding_users.html -Martin - Original Message - From: "Jason Frisvold" <[EMAIL PROTECTED]> To: "mySQL Listserv" <[EMAIL PROTECTED]> Sent: Wednesday, September 10, 2003

Re: Calling a stored procedure from MS Access

2003-09-09 Thread Martin Gainty
Daniel Pass thru query executes on an ODBC Database. Is your MySQL Server setup as an ODBC Database? -Martin - Original Message - From: "Daniel Kasak" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 09, 2003 4:17 PM Subject: Calling a stored procedure from MS Access

Re: MYSQL not starting

2003-09-04 Thread Martin Gainty
did you look at datadir specification in my.ini? -Martin - Original Message - From: "Jerry Rasmussen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 04, 2003 5:59 PM Subject: MYSQL not starting > I recently installed mysql 4 from source. After compiling everything

Re: Constraint Symbol

2003-09-04 Thread Martin Gainty
SHOW TABLE STATUS FROM yourdatabasename LIKE 'departments' which will show us the constraints for table departments..-Martin- Original Message - From: "Daniel Rossi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 04, 2003 5:50 PM Subject: Constraint Symbol What is t

Re: Can't start MySQL

2003-09-01 Thread Martin Gainty
Bob- I would start to look in \Apache Group\Apache2\logs and tell us what error.log says -Martin - Original Message - From: "Bob Demers" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 01, 2003 6:46 AM Subject: Can't start MySQL > I've clearly done something worng but,

Re: Need help with oracledump (contributed program)

2003-09-01 Thread Martin Gainty
Doug I copied this from an SAP integration with Orace site http://saphelp.cob.csuchico.edu/OraHelp/Darwin36/inst36fhp/html/5-odbc.htm 5.5.3 tsnames.ora File the file ORACLE_HOME/network/admin/tnsnames.ora must point to the listener (i.e., the TCP/IP port) on the database server. (ORACLE_HOME is th

Re: Cannot Connect to Server

2003-09-01 Thread Martin Gainty
Make sure %WINDOWS%\my.ini has the entry bind-address=127.0.0.1 -Martin - Original Message - From: "Antony Dovgal" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, September 01, 2003 3:42 AM Subject: Re: Cannot Connect to Server > On Mon, 1 Sep 2003 11:34:

Re: Table Query taking WAY TO LONG...HELP PLEASE!!!

2003-08-27 Thread Martin Gainty
Indexing columns will help but you *may* need to take a peek at some other factors such as Memory Management Read Jeremy's article on MySQL Performance Tuning http://www.linux-mag.com/2001-12/mysql_01.html Hth, Martin - Original Message - From: "Roger Baklund" <[EMAIL PROTECTED]> To: <[EM

Re: [jstarnaud@zenderford.com: sql error]

2003-08-26 Thread Martin Gainty
Use PHP Domain Administrator (ohoAdmin?) and Export the Table Select Table , Structure -OR- If you have SSH access, login and you can issue these commands: mysql -p USE yourdatabasename; (this is specified in includes/config.php, the database you run your forum on) DESCRIBE Table Take a Hard loo

Re: Copying distinct data to a new table

2003-08-21 Thread Martin Gainty
Glad that helped! -M - Original Message - From: "Dan Jones" <[EMAIL PROTECTED]> To: "MySQL Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, August 21, 2003 5:46 PM Subject: Re: Copying distinct data to a new table > On Thu, 2003-08-21 at 20:09, Dan Jones wrote: > > I'm attempting to nor

Re: MySQL 4.0.13 Memory problem under heavy load

2003-08-20 Thread Martin Gainty
I would run the DB on a RAMDisk http://www.ibiblio.org/mdw/linuxfocus/English/November1999/article124.html Anyone else? Martin - Original Message - From: "Kayra Otaner" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 20, 2003 3:56 PM Subject: MySQL 4.0.13 Memory problem

Re: Oracle DBA here looking for advice on MySQL ....

2003-08-20 Thread Martin Gainty
As a Oracle followup question Oracle supports Tablespaces That is 2 or more logically separate entities for System Data and User Data Does MySQL have Tablespace support? Many Thanks, Martin - Original Message - From: "Adam Nelson" <[EMAIL PROTECTED]> To: "'Johnson, Michael '" <[EMAIL PROT

Re: mysql and ESRI shape files

2003-08-17 Thread Martin Gainty
What is a dbf file? -Martin - Original Message - From: "Bruce Bushby" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, August 17, 2003 1:40 PM Subject: mysql and ESRI shape files > hello > > Please excuse the 'baby' question :) I have a 'digital dataset' of the > streets and > su

Re: SQL Server 2000 to mySQL Server

2003-08-14 Thread Martin Gainty
The official mySQL response is that you are overflowing the maxlength attribute Although there are many posts where SQLServer to MySQL have caused this error the solutions I have seen say go plain text and import using LOAD DATA INFILE Martin - Original Message - From: "David Alonzo" <[EMAI

Re: Converting Sequel to MYSQL

2003-08-14 Thread Martin Gainty
http://darkstar.ist.utl.pt/mysql/doc/en/LOAD_DATA.html Pay particular attention to FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' for the File you will be importing..(You can also use mysqlimport)-Martin - Original Message - From: "Mike Doanh Tran" <[EMAIL PROTECTED]> To: <[EMAIL

Re: column privilege problem--Solved

2003-08-14 Thread Martin Gainty
I'm glad that worked for you the manual should be updated with clearer examples.. -Martin Allan Bakke was right! - Original Message - From: "Tiffany Wilkes" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Sent: Tuesday, August 05, 2003 3:48 PM Subject: column privilege problem--Solved

Re: Cant login as a user I thought I created

2003-08-14 Thread Martin Gainty
To take it one step firther I do mysql>use database This way all the consequent commands are directed at the specified DB Regards, Martin - Original Message - From: "Murad Nayal" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, August 13, 2003 5:44 PM Subject: Re: Cant login as

Re: A final Windows MySQL PHP plea

2003-08-14 Thread Martin Gainty
I have heard Apache croaks after 130 connections.. -M - Original Message - From: "Nils Valentin" <[EMAIL PROTECTED]> To: "Andrew Rothwell" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, August 13, 2003 6:34 PM Subject: Re: A final Windows MySQL PHP plea Hi Andrew, I guess y

Re: What is causing me to get this anti spam message

2003-07-30 Thread Martin Gainty
I wrote to the [EMAIL PROTECTED] and told him if he didnt stop sending me messages I would fly to Brazil and handle the matter personally. That worked... very Very annoying... -M - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Kim Mackey" <[EMAIL PROTECTED]>; <[EMAIL PROTE

Re: 1040 error, too many connections?

2003-07-27 Thread Martin Gainty
What happens if you keep the original connection open and ALWAYS query with that connection -M - Original Message - From: "Michael" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, July 27, 2003 6:41 AM Subject: 1040 error, too many connections? > I'm running a series of queries

Re: how to convert SQL Server 2000 database to MySQL?

2003-07-26 Thread Martin Gainty
http://hotwired.lycos.com/webmonkey/99/21/index2a_page6.html?tw=programming An example of PHP reading MySQL DB Hth, Martin - Original Message - From: "kumar mcmillan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, July 26, 2003 3:43 PM Subject: how to convert SQL Server 2000

Re: MySQL on a website

2003-07-23 Thread Martin Gainty
get a broadband connection and host the website yourself Martin - Original Message - From: "awards" <[EMAIL PROTECTED]> To: "Daniel Glenfield" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, July 23, 2003 4:23 AM Subject: Re: MySQL on a website > Hi, > > I doubt you will find f

Re: set/show variables

2003-07-21 Thread Martin Gainty
mysqladmin has the capability to specify the my.ini file to read on startup under " my.ini Setup " hth, Martin - Original Message - From: "Bogdan TARU" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 21, 2003 6:37 AM Subject: set/show variables > > Hi everyone, > > I have

Re: MySQL++ & Visual Studio.Net

2003-07-21 Thread Martin Gainty
I would export the makefile and try to include the MySQL library with the other libraries nmake -f makefile -Martin - Original Message - From: "Ron Ohmer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 21, 2003 6:15 AM Subject: MySQL++ & Visual Studio.Net > Has anyone got

Re: passwords & DBI/DBD

2003-07-19 Thread Martin Gainty
when you connect you connect to a running daemon try running mysqld beforehand -Martin - Original Message - From: "Jeremy Booker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, July 19, 2003 7:12 PM Subject: passwords & DBI/DBD > I installed the current stable release of My

Cbuilder

2003-07-09 Thread Martin Gainty
You are going to have to give us more information on what those functions do If at all possible capture the query itself and let us know more about the details Also what type of connection to the Database ODBC, JDBC are you implementing. Regards, Martin -- MySQL General Mailing List For list ar

Re: Where is 'sqlplus.hh' ?

2003-07-08 Thread Martin Gainty
Peter hh is supposed to be a C++ header file "In some cases hh is a precompiled header" I would check out your make script or Ant build.xml to see how it's used Is there an accompanying .h file e.g. sqlplus.h file? Martin - Original Message - From: "Peter Moscatt" <[EMAIL PROTECTED]> To:

Re: Possible OT: ADONewConnection Error

2003-07-06 Thread Martin Gainty
Post the code Martin - Original Message - From: "marvc" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, July 05, 2003 7:08 PM Subject: RE: Possible OT: ADONewConnection Error > I take it no one is familiar with particular error? Didn't get anything > on google. > > -Ori

Re: Problem

2003-07-04 Thread Martin Gainty
Arkadiusz- Could you post the code..Many of us would like to compile and link it..be aware that you cannot use the Microsoft linker to link against linux libtool *.libs..It is always best to compile all of the code on your target platform; create a library and then link against it Brak Danych! Mart

Re: Now I have solved my problem!

2003-06-28 Thread Martin Gainty
Itoh- Is the MySQL doc incorrect? Please advise. Martin - Original Message - From: "Itoh Kohji" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, June 28, 2003 4:56 AM Subject: Now I have solved my problem! > > Now I have solved the problem I asked you to help me! > > The

Re: DISASTER recovery...hopefully

2003-06-03 Thread Martin Gainty
Mike- check out http://www.mysql.com/doc/en/SHOW_VARIABLES.html for information on which variables to SET for configuring MySQL Hth, Martin - Original Message - From: "ComCity" <[EMAIL PROTECTED]> To: "Peter J. Milanese" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, June 02, 200

Re: SELECTing last occurences from a table

2003-06-02 Thread Martin Gainty
SELECT * FROM myTable ORDER BY COLUMN_WHICH_CONTAINS_INSERTED_DATE ASC LIMIT 1; COLUMN_WHICH_CONTAINS_INSERTED_DATE is a column which contains the date that the record was inserted Hth, Martin - Original Message - From: "Mateusz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, Jun

Re: Server configuration denies access to data source

2003-06-02 Thread Martin Gainty
You need to create the user and grant permissions try (username=teva): INSERT INTO user (Host,User,Password) VALUES ('%', 'teva', PASSWORD('your_password')); and finally add access to the database INSERT INTO db (Host,Db,User) VALUES('%','NameOfDatabase','teva'); Hope this helps, - Original Me

Re: Advice on improving our current method

2003-06-02 Thread Martin Gainty
let the DB manage the sequencing before and after Make Chart # an Index Martin - Original Message - From: "Don Read" <[EMAIL PROTECTED]> To: "Daniel Crompton" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, June 01, 2003 1:54 PM Subject: RE: Advice on improving our current method

Re: Help NEWBIE!

2003-06-01 Thread Martin Gainty
Check running processes, to see how many are currently using mysql (mysqladmin proc). Compare to "max_connections" (mysqladmin var). Change my.cnf (or whever your config file is) and restart mysql Martin - Original Message - From: "ABHIJIT NAIK" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTE

Re: Replication: Master Server gets SIGNAL 11

2003-05-31 Thread Martin Gainty
You are going to have to use the backtrace utility (Stackdump analyzer) see http://www.mysql.com/doc/en/Using_stack_trace.html Hth, Martin - Original Message - From: "Sakthivel Muthusamy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 30, 2003 10:19 AM Subject: Replication: M

Re: help with load from file

2003-05-27 Thread Martin Gainty
Ted- check out http://www.mysql.com/doc/en/LOAD_DATA.html (go to mysql prompt and issue command LOAD DATA INFILE) keeping attention to format for INFILE Hth, Martin - Original Message - From: <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Tuesday, May 27, 2003 9:25 PM Subj

Re: Suggestions for choosing GUI Language that has a MySQL DB backend

2003-04-03 Thread Martin Gainty
If speed isnt a issue I would say develop with one of the interpreted languages (Perl/Python) My experience trying to get anything compiled under linux or windows because of missing headers or libraries will cause you and your project to experience insufferable delay. Regards, Martin - Original

Re: 4.0.12 libmysqlclient.a

2003-04-03 Thread Martin Gainty
, Martin PostScript So when will your company be publishing a book on the Rock n Roll bands from Birmingham? - Original Message - From: "Allen Grace" <[EMAIL PROTECTED]> To: "Martin Gainty" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]> Se

Re: 4.0.12 libmysqlclient.a

2003-04-03 Thread Martin Gainty
= db_connect("test"); (and will resolve all MySQL API methods) - Original Message - From: "Allen Grace" <[EMAIL PROTECTED]> To: "Martin Gainty" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]> Sent: Thursday, April 03, 2003 1:40 A

Re: Can we make some C, Java based "Mysql App Server"

2003-04-03 Thread Martin Gainty
Daniel How about 1 working Java or C or C++ example which uses MySQL Personally every example I have used (both Linux and Windows) uses libraries which cannot resolve the simplest MySQL functions with no ability to recover. Very frustrating. Thank You, Martin - Original Message - From: "Dan

Re: MySQL 4.0.12 -max-nt Error 1148: Used command is not allowed with this MySQL Version

2003-04-02 Thread Martin Gainty
Try sqlimport (it is in the bin directory) Martin - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 02, 2003 4:33 PM Subject: MySQL 4.0.12 -max-nt Error 1148: Used command is not allowed with this MySQL Version > I am trying to load a table from

4.0.12 libmysqlclient.a

2003-04-02 Thread Martin Gainty
Attempting to run the makefile for test_libmysqld.c -I am linking against /cygdrive/g/mysql/mysql-debug-4.0.12-pc-linux-i686/lib/libmysqlclient.a $ make gcc -g -W -Wall -I/cygdrive/g/mysql/mysql-debug-4.0.12-pc-linux-i686/include -D_ THREAD_SAFE -D_REENTRANT -static test_libmysqld.c -L -l/cygdr

Working examples

2003-04-01 Thread Martin Gainty
Ive seen plenty examples in books but are there any working MySQL examples someone can use immediately..Anything anywhere? Thank You, Martin - Original Message - From: "Marko Hrastovec" <[EMAIL PROTECTED]> To: "'gerald_clark'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, April

Re: Passwords don't work in a WinME installation?

2003-04-01 Thread Martin Gainty
The key to Pandoras Box is available to those who wrote the encryption algorithm Triple DES anyone? -Martin - Original Message - From: "Doug Thompson" <[EMAIL PROTECTED]> To: "Martin Gainty" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Mond

Re: Could we make this a web discussion forum?

2003-03-31 Thread Martin Gainty
a not properly started InnoDB: or created database! 030331 18:16:45 MySql: Shutdown Complete does this make any sense to you? Muchas Gracias Martin - Original Message - From: "miguel solorzano" <[EMAIL PROTECTED]> To: "Martin Gainty" <[EMAIL P

Re: Could we make this a web discussion forum?

2003-03-31 Thread Martin Gainty
Sorry to hike the thread but I have a specific question What causes "System Error 1067" when starting mysql in Windows Does anyone know? Martin - Original Message - From: "Seth Brundle" <[EMAIL PROTECTED]> To: "David Brodbeck" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, March 31

Re: What port to forward ?

2003-03-31 Thread Martin Gainty
forward Port 3306 to mysqlserver daemon the ports are illustrated in the my.conf file -Martin - Original Message - From: "Darryl Hoar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 31, 2003 3:49 PM Subject: What port to forward ? > Well, > I have a firewall on my LAN,

Re: Passwords don't work in a WinME installation?

2003-03-31 Thread Martin Gainty
Hello Michael- Would you know of any links to working examples for Windows? Thanks! Martin - Original Message - From: "Michael Shulman" <[EMAIL PROTECTED]> To: "Martin Gainty" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent:

Re: Passwords don't work in a WinME installation?

2003-03-31 Thread Martin Gainty
Michael et al- I am trying to locate ONE working MySQL example for windows. Is this a myth or is there WORKING source example out there somewhere? Thanks, Martin - Original Message - From: "Michael Shulman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, March

Re: Passwords don't work in a WinME installation?

2003-03-31 Thread Martin Gainty
Great! any links to working examples would be greatly appreciated! Thanks! Martin - Original Message - From: "Michael Shulman" <[EMAIL PROTECTED]> To: "Martin Gainty" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, Ma

missing function in library-

2003-03-30 Thread Martin Gainty
- From: "Martin Gainty" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Sunday, March 30, 2003 11:08 AM Subject: missing function > Attempting to compile the 4.1 mysql library I encounter a missing function: > ret = select(0, NULL, NULL, NULL, &a

missing function

2003-03-30 Thread Martin Gainty
Attempting to compile the 4.1 mysql library I encounter a missing function: ret = select(0, NULL, NULL, NULL, &t) == -1 ? __os_get_errno() : 0; called from os_sleep() Where is this function? Thank You, Martin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u

Re: hi

2003-03-28 Thread Martin Gainty
The first step is to get a working example- WARNING: you may have to compile the library to get it working on your platform.. Good Luck, Martin - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 28, 2003 2:08 AM Subject: re: hi > On Th

Re: "Soon"?

2003-03-27 Thread Martin Gainty
Hej Michael- In order to to see 4.1 mysqladmin working I started to compiling the 4.1 source obtained from bitmaker Originally I had 1000 errors with 1000 unresolved link errors.. I am down to about 50 on both counts God Tur- Martin - Original Message - From: "Michael Edlund" <[EMAIL P

Request on source

2003-03-26 Thread Martin Gainty
To Creators- In my attempt to obtain 1 working example of this DB: I am compiling all of the code. I have a request for Monty with the creators in theit function declarations: e.g. int strcasecmp(s1, s2) const char *s1, *s2; please enclose the const char *s1, *s2 declaration within the argument

missing file-

2003-03-26 Thread Martin Gainty
Hello In attempting to build winmysqladmin.cpp winmysqladmin.cpp \MySQL\mysql-4.1\VC++Files\winmysqladmin\winmysqladmin.cpp(2) : fatal error C1083: Cannot open include file: 'vcl.h': No such file or directory initsetup.cpp \MySQL\mysql-4.1\VC++Files\winmysqladmin\initsetup.cpp(2) : fatal error C1

VC dump

2003-03-25 Thread Martin Gainty
when I attempt to run your sample I get \WindowsMySQL\lib\debug\libmysql.lib : fatal error LNK1106: invalid file or disk full: cannot seek to 0x3e74f746 All disks have 1gb + free so its not a disk full.. I have seen this error happen when someone puts a corrupted library on their site so... Is ther

Re: CONNECT BY PRIOR in MySQL

2003-03-24 Thread Martin Gainty
Nitin- If you want a SELF Join try http://www.devshed.com/Server_Side/MySQL/SQLJoins/page9.html Regards, -Martin - Original Message - From: "Nitin Nanivadekar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 24, 2003 10:07 PM Subject: CONNECT BY PRIOR in MySQL > Dear Fri

Re: SSL With Visual Basic ADO

2003-03-24 Thread Martin Gainty
Sean- lots of examples here http://www.winsockvb.com/ -Martin - Original Message - From: "Sean Biganski" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 24, 2003 10:25 PM Subject: SSL With Visual Basic ADO > I am looking for a way to encrypt my ADO queries using SSL wit

Re: Your professional opinion Please...

2003-03-24 Thread Martin Gainty
Brian- why not use grep or fgrep on the files and catch the hyperlink resultset to formatted html..? Regards, Martin - Original Message - From: "Brian" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Monday, March 24, 2003 7:41 PM Subject: Your professional opinion Please... > H

Re: Question on MySQL, MyODBC & VC++

2003-03-24 Thread Martin Gainty
Terry- Personally I cant do much until I can see the stack trace, local variables and any diagnostics from your try/catch.. Regards, -Martin > > Hello Everybody, > I install MySQL in my W2K server and MyODBC also. I created a new > database named "Log" and tried to connect from my project in

Re: InterBase vs. Mysql

2003-03-24 Thread Martin Gainty
David- There are many of us out there who have a variety of DBs to choose from CodeBase, InterBase, FileMaker, Access..Before selecting MySQL or any other DB make sure it works for your client's needs..Otherwise you just would be tossing good money out the window... Regards, -Martin > > Hello David

<    1   2   3