always get error when check table

2001-07-04 Thread Osman Omar
Hi, I use php to connect to mysql server. after that I check my table, myisamchk report that client not properly close the connection how to avoid this error? where should I check? thx. - Before posting, please check: ht

Unicode Support in MYSQL C -API

2001-07-04 Thread jofy chirayath
Sir/Madam, I am using MYSQL C-API to access MYSQL database . I am having problems when i gave Unicode support to my code, as the API functions accept parameters of the type "const char *" .With Unicode support the values being passed are the of the type "unsigned short". Is there any way I can m

Re: download Mysql manual to win 95?

2001-07-04 Thread Jeremy Zawodny
On Wed, Jul 04, 2001 at 11:31:01PM -0700, Ken Sommers wrote: > Hello, > > how do I download the Mysql manual to win 95? > > what is a Tarball? It's sort of like a ZIP file on Windows. You can use WinZip to extract it. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Fin

Mysql and Cobalt

2001-07-04 Thread dijana cetinic
Hi all, just a quick question .. has neone setup mysql on a cobalt RAQ4 before? If so ne recommendations on how to go about doing it? thanx heaps D --- Send the right message --- + Today freemail + Get your free, private email address at http://www.today.com.au

download Mysql manual to win 95?

2001-07-04 Thread Ken Sommers
Hello, how do I download the Mysql manual to win 95? what is a Tarball? Ken

Re: 7 MySQL Language Reference till the end ,on my hard drive back home

2001-07-04 Thread Jeremy Zawodny
On Wed, Jul 04, 2001 at 11:03:25PM -0700, Ken Sommers wrote: > Is there any way to get from chapter 7 MySQL Language Reference till > the end of the MySql Manual,on my hard drive back home? I'm a bit confused. Are you looking for the downloadable manual? It's on www.mysql.com along with all the

7 MySQL Language Reference till the end ,on my hard drive back home

2001-07-04 Thread Ken Sommers
HI, Is there any way to get from chapter 7 MySQL Language Reference till the end of the MySql Manual,on my hard drive back home? using win 95,,cuz it was free.. Ken - Before posting, please check: http://www.mysql.com/manu

Re: different subdir for database

2001-07-04 Thread Jan Muszynski
On 4 Jul 2001, at 21:21, Jeremy Zawodny <[EMAIL PROTECTED]> expounded about "Re: different subdir for database": > On Thu, Jul 05, 2001 at 12:10:07PM +0800, Jaime Teng wrote: > > Hi, > > > > I have mysql on NT4 (soon to be win2000). one question is that the > > database files all reside under dr

Getting errors when running 'make '

2001-07-04 Thread Marvin Cheung
Hi all, Do you know how I can resolve the following errors which happened when I ran 'make' after I sucessfully ran ./configure ? ar cru .libs/libmysqlclient.a libmysql.o net.o password.o get_password.o errmsg.o my_init.o my_static.o my_malloc.o my_realloc.o my_create.o my_delete.o my_tempnam

RE: different subdir for database

2001-07-04 Thread Chris Bolt
> > Hi, > > > > I have mysql on NT4 (soon to be win2000). one question is that the > > database files all reside under drive c. NT does not have symbolic > > link > > I seem to recall Microsoft making a big deal out of the fact that they > "invented" symbolic links and added them to Win2000. A

Re: different subdir for database

2001-07-04 Thread Jeremy Zawodny
On Thu, Jul 05, 2001 at 12:10:07PM +0800, Jaime Teng wrote: > Hi, > > I have mysql on NT4 (soon to be win2000). one question is that the > database files all reside under drive c. NT does not have symbolic > link I seem to recall Microsoft making a big deal out of the fact that they "invente

different subdir for database

2001-07-04 Thread Jaime Teng
Hi, I have mysql on NT4 (soon to be win2000). one question is that the database files all reside under drive c. NT does not have symbolic link is there a way to tell mysql that a particular database is located on a different folder? where is the documentation for this one? jaime

Re[3]: Proposition: Attach a comment to each connection

2001-07-04 Thread Werner Stuerenburg
> Am I naive or is this a viable proposition? Oh, I see, you would like to connect this information with the pid, right? I wouldn't know how to do that. How do you get a pid? Is this something MySQL could provide? -- Herzlich Werner Stuerenburg

Re: asking for teaching?

2001-07-04 Thread Werner Stuerenburg
If your box supports php, install phpMyAdmin. This really comes easy. Look for an address in Google for download. Sie schrieben am Donnerstag, 5. Juli 2001, 02:55:04: > Hi, all, > I am a newer to MySQL, being learning, i have installed the bianary 3.23.29 > into my pc which is running windows 2

Re: Got error 127 from table handler

2001-07-04 Thread Werner Stuerenburg
127 means Record-file is crashed. See manual, run isamchk for repair. Sie schrieben am Donnerstag, 5. Juli 2001, 02:50:22: > I got this error messages when I try to access my table > "Got error 127 from table handler" > -

Re[2]: Proposition: Attach a comment to each connection

2001-07-04 Thread Werner Stuerenburg
How about tracking your own record until then? Create a table and insert a record for each connection. If you would use a class to connect like db_mysql.inc from PHPLIB, it would be a snap to implement. From php, you know all sorts of variables to identify your general setting. I assume that the

RE: asking for teaching?

2001-07-04 Thread Mike
At the mysql> type use firstdb; then type show tables; -Original Message- From: Shania Qiu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 04, 2001 8:35 PM To: 'Mike' Cc: '[EMAIL PROTECTED]'; Ken Sommers Subject: RE: asking for teaching? Thank you all for your help, i created a datab

RE: asking for teaching?

2001-07-04 Thread Shania Qiu
Thank you all for your help, i created a database called 'firstdb' with one table 'members' successfully. I opened WinMySQLadmin 1.1, databases, i cant see the database 'firstdb' i just created sitting there, except mysql and test that are system's example db's. Any ideas, Shania Qiu -O

RE: asking for teaching?

2001-07-04 Thread Mike
Yes themember_id int(11) NOT NULL auto_increment, starts at 1 and goes up automaticly and is maintained by MySQL thePRIMARY KEY (member_id) just makes the member_id the PRIMARY KEY Snip from Manual A PRIMARY KEY is a unique KEY with the extra constraint that all key columns must be defined

Re: asking for teaching?

2001-07-04 Thread Ken Sommers
HI, when you created table: Create a table CREATE TABLE members ( member_id int(11) NOT NULL auto_increment, fname varchar(50) NOT NULL, lname varchar(50) NOT NULL, tel varchar(15), email varchar(50) NOT NULL, PRIMARY KEY (member_id) ); is that primary Key also an index authoma

RE: asking for teaching?

2001-07-04 Thread Mike
Try http://www.analysisandsolutions.com/code/mybasic.htm#creating for a nice tutorial and http://www.devshed.com/Server_Side/MySQL/Speak/page7.html has some excellent tutorials To Create a database and table CREATE DATABASE member; Create a table CREATE TABLE members ( member_id int(11) NO

RE: asking for teaching?

2001-07-04 Thread John Meyer
On Wed, 04 Jul 2001, Shania Qiu wrote: > Thank you, Luis, > > I type in 'login mysql', the system responded me with 'Welcome to Microsoft > Telnet Server', then back to c:\, according to your instruction, i typed in > create database test, the message ' 'create' is not recognized as an > internal

RE: asking for teaching?

2001-07-04 Thread Shania Qiu
Thank you, Luis, I type in 'login mysql', the system responded me with 'Welcome to Microsoft Telnet Server', then back to c:\, according to your instruction, i typed in create database test, the message ' 'create' is not recognized as an internal or external command, operable program or batch fil

Re: asking for teaching?

2001-07-04 Thread Luis
well you should read the man pages that come with it also there are alot of book on mysql. But you know what since your a newbie. I wills how you. I dont have mysql installed on a windows machine, but on a linux box. i believe the commands are the same. log in mysql create database test; ---h

asking for teaching?

2001-07-04 Thread Shania Qiu
Hi, all, I am a newer to MySQL, being learning, i have installed the bianary 3.23.29 into my pc which is running windows 2000. Can someone tell me where and how to create tables in MySQL. Thank you all. shania. - Before p

Got error 127 from table handler

2001-07-04 Thread Osman Omar
I got this error messages when I try to access my table "Got error 127 from table handler" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list arch

RE: Replication, update log, mysqldump???

2001-07-04 Thread Joe Taraba
At 11:28 AM 07/04/2001 , you wrote: >hi. > >w/r/t your first question: mysqldump just generates a text file containing >the sql statements necessary to recreate the dumped table(s). >if you use mysqldump -uuser -p > dumpfile.txt you can open it in vi or >notepad and edit it if desired... >the err

sql-bench/test-create error "bdb: Metapage flush failed"

2001-07-04 Thread jdd
>Description: MySQL 3.23.39 on FreeBSD 4.3. Running the sql-bench/test-create script using BDB, mysql will fail to create a table and will log the error "dbd: Metapage flush failed" >How-To-Repeat: sh# test-create --log --create-options=TYPE=BDB Testing server 'MySQL 3.23.39 log' at 2001-07-05 0:

Re: problem with d/l

2001-07-04 Thread greg
oh nevermind, i just tryed ftp.mysql.com (at random though) and found it thanks - Message d'origine - De : <[EMAIL PROTECTED]> À : <[EMAIL PROTECTED]> Envoyé : jeudi 5 juillet 2001 0:40 Objet : problem with d/l > Hi, > > I can't download > http://www.mysql.com/Downloads/mysqlgui/mysqlg

problem with d/l

2001-07-04 Thread greg
Hi, I can't download http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-1.zip Can you help? Been trying several times and from several places thanks bye greg - Before posting, please check: http://www.m

"repetition-operator operand invalid" error?

2001-07-04 Thread Chris Petersen
I recently started getting this error from a query: > Got error 'repetition-operator operand invalid' from > regexp (SELECT id, IF(parents LIKE '_%',CONCAT(parents,' > name),name) AS name, usergrp FROM Categories WHERE id > 10 AND id > AND parents NOT RLIKE '^\* New Category \*(|$)' O

Re: Proposition: Attach a comment to each connection

2001-07-04 Thread Alexandre BAUMEISTER
Bonjour, I sent this post a few days ago but it didn't get a lot of contributions. Wouldn't it be an interresting feature ? > > > When you have a big web site with a lot of pages, programs, > > > cronjobs, applications ... connecting to Mysql, it's sometimes > > > difficult

mysql driver for java

2001-07-04 Thread Daniel Aderhold
I recently installed the MySQL driver for Java in my system with Win98. I downloaded the mm binary version. Then I copied the org directory in my PC and added the following line in my Autoexec.bat : classpath=\org;%classpath% Is that right? I could access the MySQL database from my Java classe

Re: Urgent : Execute querys stored in file but from phpmyadmin

2001-07-04 Thread Werner Stuerenburg
> I want Execute querys stored in file but from > phpmyadmin interface, I want to use telnet to execute > the command : > # mysql mydb_name < file.sql > but in telnet prompt its invalid command So not from phpMyAdmin, right? Use mysql -hlocalhost -uUsername -p dbName < file.sql You will have

Re: Copy table structure to another database?

2001-07-04 Thread Werner Stuerenburg
> Can I copy a table (structure only) to another database? I've searched > though my manuals without success so far. use phpMyAdmin. It is a push of a button (you have to give a name for the copy first). -- Herzlich Werner Stuerenburg ___

Re: Automatically running SQL command through a batch file

2001-07-04 Thread Mark Rowlands
On Wednesday 04 July 2001 21:37, Christopher Brown-Floyd wrote: > Is there a way to run a SQL command or create a database through a batch > file? jeez! for some one who is omniscient you don't know much read the friendly manual section 9.6 : Using mysql in batch-mode also check out mysqldu

Linking C++ API

2001-07-04 Thread Malkhaz Mangoshvili
Hello. My name is Mike. I am writing a C++ program to access a MySQL database. I have MySQL-3.23.36 server running on Linux Mandrake 8.0. I downloaded mysql++-1.7.9 version from the internet and installed it successfully. When I try to compile my C++ program using: g++ /usr/local/lib/libsq

Automatically running SQL command through a batch file

2001-07-04 Thread Christopher Brown-Floyd
Is there a way to run a SQL command or create a database through a batch file? If not, is there some kinda work around? I'm trying to make a batch file that will create a skeleton database structure for deployment of a website that I'm working on. TIA -Chris --

Re:innodb crash

2001-07-04 Thread Heikki Tuuri
Julien, sorry that I did not notice your message earlier, but I was running tests on new big BLOBs, and a stress test passed now without errors :). But the problem you have is probably the rollback bug in .38. It has been fixed in .39. Upgrade to to .39 and try to start the database again. Rega

RE: Data Binding

2001-07-04 Thread Don Read
On 04-Jul-01 Ken Sommers wrote: > Dynamic HTML (DHTML) promises to change radically the way developers build > Web applications. It empowers the client end of the Web server/browser > relationship. The DHTML feature most oriented to the needs of database > developers is data binding. Data binding

RE: Copy table structure to another database?

2001-07-04 Thread Don Read
On 04-Jul-01 Graham Nichols wrote: > Hi, > > Can I copy a table (structure only) to another database? I've searched > though my manuals without success so far.\ $ mysqldump -d db da_table | mysql newdb Regards, -- Don Read [EMAIL PROTECTED] -- It's always

RE: Replication, update log, mysqldump???

2001-07-04 Thread Ravi Raman
hi. w/r/t your first question: mysqldump just generates a text file containing the sql statements necessary to recreate the dumped table(s). if you use mysqldump -uuser -p > dumpfile.txt you can open it in vi or notepad and edit it if desired... the error about the table existing is because the

Re: choosing primary keys

2001-07-04 Thread Steve Edberg
At 1:45 PM +0100 7/4/01, matthew yee-king wrote: >Hello >sorry if this is old hat... > >i am trying to figure out a way to assign primary keys to my database tables. >I have previously used ints with auto_increment but i am wondering >what happens when you reach the highest number possible for an

Re: Replication, update log, mysqldump???

2001-07-04 Thread Joe Taraba
At 10:52 AM 07/04/2001 , you wrote: >I think you can check this link > >http://www.mysql.com/documentation/mysql/bychapter/ That's what I'm reading, and quoted from below, and what gave rise to the questions in this email. And, all of it deals with 3.23.29--unless you are referring to all the

Re: Replication, update log, mysqldump???

2001-07-04 Thread Web Mailing List
I think you can check this link http://www.mysql.com/documentation/mysql/bychapter/ - Original Message - From: "Joe Taraba" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 04, 2001 1:47 PM Subject: Replication, update log, mysqldump??? > Hi; > > I'm trying to learn M

Replication, update log, mysqldump???

2001-07-04 Thread Joe Taraba
Hi; I'm trying to learn MySQL, having some difficulties understanding backup strategies. mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) Where is the documentation (besides man pages) for mysql Ver 3.22.32 According to the the 3.23.29 online docs it appears that there are four ways

Re: Copy table structure to another database?

2001-07-04 Thread Hannes Niedner
When I need recreate a table structure I do it like CREATE db_target.table_copy SELECT * FROM db_source.table WHERE 1=0; The only thing that you have to do now is DESCRIBE db_target.table_copy; DESCRIBE db_source.table; Since you need to manually reestablish the indices in the new table. Alt

Re: Relations between tables?

2001-07-04 Thread Joe Taraba
Mohan; I'm also new to this database administration and development. There are some excellent tutorials at Devshed.com. Below is a link to the tutorial on Database Normalization, I think this will give you some answers to your query: http://www.devshed.com/Server_Side/MySQL/Normal/ Joe At 0

RE: Windows 2000 MySQL case sensitive?

2001-07-04 Thread Gerald R. Jensen
Jane ... (This is based on our own experience, and info found in the MySQL Manual ... http://www.mysql.com/doc/N/a/Name_case_sensitivity.html). We have used this procedure to convert dozens of databases, and found that setting the server's variable to lower-case tables also requires converting

Urgent : Execute querys stored in file but from phpmyadmin

2001-07-04 Thread Sofiane Sakhri
hello, I want Execute querys stored in file but from phpmyadmin interface, I want to use telnet to execute the command : # mysql mydb_name < file.sql but in telnet prompt its invalid command Can you help me? Thanx ___ Do You Yahoo!? -- Pour

RE: Insert queries add TWO records to database

2001-07-04 Thread Rob Donat
Thanks for the note, I will determine if this applies to our situation. However I believe I found the solution to my problems to be apache related. I found that after upgrading to apache 1.3.20, MANY of our web server requests were duplicated & some times tripled when using IE 5.5 (and presumably

Re: Relations between tables?

2001-07-04 Thread John Meyer
On Wed, 04 Jul 2001, Mohan Khurana wrote: > database enthusiasts, > > I'm fairly new to database administration and development, I'm currently > still learning about features of databases so that I can ensure that my > design for the database that I create will be correct. I will be storing > ge

Relations between tables?

2001-07-04 Thread Mohan Khurana
database enthusiasts, I'm fairly new to database administration and development, I'm currently still learning about features of databases so that I can ensure that my design for the database that I create will be correct. I will be storing general pieces of information in an index table that wil

Re: Store picture

2001-07-04 Thread Duncan Hill
On Wed, 4 Jul 2001, Moonesh Suggun wrote: > hi To All, > > Has anyone try to insert images e.h. gif into mysql database.. I > have tried using blob type but how would I verify that it is OK. It can be done, however general wisdom is that one should use the filesystem to store images, simply beca

Query from two different databases ?

2001-07-04 Thread Andrey F. Mindubaev
Hi, How to create query to get data from tables of two different databases ? Best regards, Andrey [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Copy table structure to another database?

2001-07-04 Thread Ilya Martynov
GN> Hi, GN> Can I copy a table (structure only) to another database? I've searched GN> though my manuals without success so far. you can use query show create table TABLENAME which will show what query recreates table named TABLENAME -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Copy table structure to another database?

2001-07-04 Thread Graham Nichols
Hi, Can I copy a table (structure only) to another database? I've searched though my manuals without success so far. kind regards, Graham - Before posting, please check: http://www.mysql.com/manual.php (the manual) ht

Re: Help please, create table, and set Auto field

2001-07-04 Thread Nelson Goforth
CREATE TABLE namelist ( name CHAR(60), id SMALLINT AUTO_INCREMENT) You will find much useful information at http://www.mysql.com - check the documentation section. I also use the O'Reilly book "MySQL and mSQL" by Yarger, Reese and King, which has detailed in

Re: Store picture

2001-07-04 Thread Sherzod Ruzmetov
Well, i did that using Perl/CGI. I have no clue how to load it directly. WHat i did was opened a *.gif file, and stored it into the BLOB column the same way as you would text. That's it Sent on Jul 4 by Moonesh Suggun to MySQL News Group suggun> hi To All, suggun> suggun> Has anyone try to

Re: Help please, create table, and set Auto field

2001-07-04 Thread Nessi
I think you are looking for something like: create table namelist (ID int not null auto_increment, name char(60), ...); ?!? Cheers, Nessi >At 15:21 04/07/01 , you wrote: >>I move from MDB to mySQL, I got a question concern how to create a auto >>digital number field in mysql table, >> >>crea

Store picture

2001-07-04 Thread Moonesh Suggun
hi To All, Has anyone try to insert images e.h. gif into mysql database.. I have tried using blob type but how would I verify that it is OK. Thanks in advance, Regards, Moonesh

Re: Help please, create table, and set Auto field

2001-07-04 Thread Sherzod Ruzmetov
You meaaan, auto incrementing field ??? If so CREATE TABLE t_name (id INT AUTO_INCREMENT); Workds. But there's no "auto digital number" thingy Sent on Jul 4 by Web Mailing List to [EMAIL PROTECTED] websig> I move from MDB to mySQL, I got a question concern how to create a auto digit

Help please, create table, and set Auto field

2001-07-04 Thread Web Mailing List
I move from MDB to mySQL, I got a question concern how to create a auto digital number field in mysql table, create table namelist ( name char(60), ID auto, date date());

using mysql wiht lotus approach

2001-07-04 Thread Conor McTernan
sorry for asking this question here, i'm sure it's a myODBC question, but i asked there a couple of days ago and got no responce I was just wondering if anyone has much experience of using a MySql backend for an approach APR, using of course myODBC. I've been playing around wiht the idea of mig

Re: Question about DELETE and Index.

2001-07-04 Thread Sinisa Milivojevic
Fournier Jocelyn [Presence-PC] writes: > Hi, > > Does DELETE take advantage of index to locate more quickly row to be deleted ? > > Thank you :) > > Jocelyn Fournier > Presence-PC Of course. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL

innodb crash

2001-07-04 Thread jrevel
Hello, I have mysdl 3.23.38 with innodb (dont know which version) support on Linux RedHat 6.2 Mysqld crashed, and when I try to restart it, I have the following error: 010704 16:50:34 mysqld started InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB:

RE: exel to mysql

2001-07-04 Thread Crercio Osmaildo da Silva
Hi, Use DBTools (http://dbtools.vila.bol.com.br) to convert/import from Access, Excel, DBF, ODBC and TXT. You can also generate csv files and import them into mySQL with LOAD DATA INFILE. []'s Crercio O. Silva -Original Message- From: jake williamson 28 [mailto:[EMAIL PROTECTED]] Sent:

RE: Initial setup in Linux RH7.1

2001-07-04 Thread Roberto Carlos Sánchez Barroso
Sorry, now I´m reading, through re-compiling and re-installing mysql, the version info, and i´m running 3-23-22 beta. Thanks. > -Mensaje original- > De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Enviado el: miércoles 4 de julio de 2001 13:41 > Para: Roberto Carlos S

RV: Initial setup in Linux RH7.1

2001-07-04 Thread Roberto Carlos Sánchez Barroso
> -Mensaje original- > De: Roberto Carlos Sánchez Barroso > Enviado el: miércoles 4 de julio de 2001 13:45 > Para: '[EMAIL PROTECTED]' > CC: '[EMAIL PROTECTED]' > Asunto: RE: Initial setup in Linux RH7.1 > > I´m running mysql 3.23.39!!! > Can anybody help me!!!

Re: Initial setup in Linux RH7.1

2001-07-04 Thread Trond Eivind Glomsrød
Roberto Carlos Sánchez Barroso <[EMAIL PROTECTED]> writes: > I´ve got the same problem, installing mysql through RH7.0, > "Can't connect to local MySQL server through socket > '/var/lib/mysql/mysql.sock' and i´m trying all the solves you post, but > anything help me, could anybody p

RE: Initial setup in Linux RH7.1

2001-07-04 Thread Roberto Carlos Sánchez Barroso
And What´s up with a RH7.0? Thanks. > -Mensaje original- > De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Enviado el: miércoles 4 de julio de 2001 13:38 > Para: [EMAIL PROTECTED] > CC: [EMAIL PROTECTED] > Asunto: Re: Initial setup in Linux RH7.1 > > Yi-chen

choosing primary keys

2001-07-04 Thread matthew yee-king
Hello sorry if this is old hat... i am trying to figure out a way to assign primary keys to my database tables. I have previously used ints with auto_increment but i am wondering what happens when you reach the highest number possible for an int... is there some way of 'reclaiming' primary key

Re: Initial setup in Linux RH7.1

2001-07-04 Thread Trond Eivind Glomsrød
Yi-chen Lan <[EMAIL PROTECTED]> writes: > When I type "service mysql start", it gives me "mysql: unrecognized service" Oops, typo :) - "service mysqld start" -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please che

Re: exel to mysql

2001-07-04 Thread Duncan Hill
On Wed, 4 Jul 2001, Sherzod Ruzmetov wrote: > > That's what I'd do (assuming there's no other programs available, but aint > sure). Save the excell spreadsheet as a *.csv file, then load it to mysql with > LOAD DATA command Be warned, Excel throws out some stupid looking CSV files. I've had it

Re: SSH tunnel

2001-07-04 Thread Duncan Hill
On Wed, 4 Jul 2001, Caroline Leclerc wrote: > Hi, > > Sorry to send this mail to the mailing list but I browsed all the > archives concerning a secure connection without success. > I did the following: > ssh -l username mysqlserver -L 222:mysqlserver:3306 -N a) Try using port 3306 locally if yo

Re: Insert queries add TWO records to database

2001-07-04 Thread Sebastiaan J.A. Kamp
It's more of a PHP than a MySQL 'problem' & certainly not a MySQL bug, but... Upon processing "$res_insert_campaign=mysql_query($sql,$conn);" the script will insert a line into your database. Then, upon evaluating "if (!$res_insert_campaign) {" it will do "if (!mysql_query($sql,$conn))" and ins

Re: MySQL with perl error

2001-07-04 Thread Michael Ott
hallo! With reference to Dawn H on 04.07 00:36: > The error log says, > > Can't call method "do: on an undefined value. . . > > But the EXACT SAME code works on another script I'm running. I don't see any > reason for it to suddenly have a problem. What does this error message MEAN? > > Co

RE: Initial setup in Linux RH7.0 (sorry)

2001-07-04 Thread Roberto Carlos Sánchez Barroso
If somebody could help to, this is the message that is shown in the /va//lib/mysql/[domain server name].err 010704 11:07:58 mysqld started 010704 11:07:58 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist 010704 11:07:58 /usr/libexec/mysqld: Normal s

Maximum parallel Users on MySQL

2001-07-04 Thread Lutz Maibach
Hi, is there a limit of concurrent connections or threads in MySQL? What do I have to consider when many users (500 - 1000) want to use MySQL at the same time? Greetings from Germany Lutz Maibach EasyCom GmbH

RE: Initial setup in Linux RH7.1

2001-07-04 Thread Roberto Carlos Sánchez Barroso
Thanks, but my directory /var/lib/mysql owner´s already mysql. drwx-- mysql... > -Mensaje original- > De: oyun [SMTP:[EMAIL PROTECTED]] > Enviado el: miércoles 4 de julio de 2001 11:06 > Para: Roberto Carlos Sánchez Barroso > Asunto:

Re: exel to mysql

2001-07-04 Thread Sherzod Ruzmetov
That's what I'd do (assuming there's no other programs available, but aint sure). Save the excell spreadsheet as a *.csv file, then load it to mysql with LOAD DATA command Sent on Jul 4 by jake williamson 28 to [EMAIL PROTECTED] jake.w> jake.w> jake.w> hello, jake.w> jake.w> does anyone k

LINUX Errors...

2001-07-04 Thread Jon Brookes
Hi, I have been using mysql fine on a win32 box.. but have now also installed it on Linux box. The version details are below: Red Hat Linux release 6.0 (Hedwig) Kernel 2.2.5-15smp I am using this version of mySQL: mysqladmin Ver 5.3 Distrib 3.20.32a, for pc-linux-gnu on i686 TCX Datakonsult

exel to mysql

2001-07-04 Thread jake williamson 28
hello, does anyone know how/are there any help programs to convert a excel spreadsheet into a mysql database? i can get the spreadsheet into access - would it be a case of i can then export that to mysql?? any ideas oh guru's???!! cheers, jake 28 23a great queen street londo

Problem with CSV's on import

2001-07-04 Thread Reflex Point Ops
TWIMC, When I try to import a comma serparated flat file it usually works just fine. The exception is if any of the records in the file end with a double quote, [as records often do with CSV files] I lose all the data from that point on or until MySQL finds another double quote at the be

Re: Initial setup in Linux RH7.1

2001-07-04 Thread Yi-chen Lan
When I type "service mysql start", it gives me "mysql: unrecognized service" On Tuesday 03 July 2001 22:41, Trond Eivind Glomsrød wrote: > Yi-chen Lan <[EMAIL PROTECTED]> writes: > > When I try to run mysql, the system give an erroe message "Can't connect > > to local MySQL server through socket

Uploading a File Directly into an INSERT INTO

2001-07-04 Thread Van
Greetings All: Pardon the asp tags. I use frontpage extensions for Linux; Win2K client in a VMWare session. It's easier for testing what Windoze users see. My client, and, all... The FORM: ... ... ACTION executes the following PHP script: $qry = "INSERT INTO Resumes SET rid = '',

RE: Initial setup in Linux RH7.1

2001-07-04 Thread Roberto Carlos Sánchez Barroso
I´ve got the same problem, installing mysql through RH7.0, "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' and i´m trying all the solves you post, but anything help me, could anybody post any other? Thanks. > -Mensaje original- >

SSH tunnel

2001-07-04 Thread Caroline Leclerc
Hi, Sorry to send this mail to the mailing list but I browsed all the archives concerning a secure connection without success. I would like to encrypt the connections using DBI modules with mysql drivers(Or perhaps it is already encrypted?) Anyway, I did not manage to connect to mysql when the

RE: MySQL with perl error

2001-07-04 Thread Sherzod Ruzmetov
The only reason why that might happen (assuming it is working somewhere else), the object isn't return. So connect() constructor couldn't return the object. To read the error message from DBI, you'll have to read $DBI::errstr: my $dbh = DBI->connect(dsn, login, password) or die $DBI::errstr;

RE: Clean way of execution of query....

2001-07-04 Thread Don Read
On 04-Jul-01 Asha Ramaiah wrote: > Hey! guys! > > I wanted a little help on the following : .. > > Scenario: > I have 2 tables : one task and the other tasksequence > > desc task : (primary key taskId, varchar taskdesc) > desc tasksequence (primary key (taskId,milestoneId)) > > Now the que