Re: Embedded MySQL

2002-09-27 Thread Jeremy Zawodny
On Fri, Sep 27, 2002 at 01:37:24PM +0930, David Lloyd wrote: What's the advantages of using Embedded MySQL instead of, say, Berkely's DB? Well, the SQL interface is probably the biggest advantage. There is no query language for Berkely DB, so ad-hoc queries are time-consuming to code. --

compiling

2002-09-27 Thread Paco
Hello I'm trying to compile the first example of the mysql++ api by myself and I'm getting this output: /tmp/ccu3Iehs.o: In function `main': /tmp/ccu3Iehs.o(.text+0x2e): undefined reference to `MysqlConnection::MysqlConnection(char const *, char const *, char const *, char const *, bool)'

Re: MyISAM or InnoDB

2002-09-27 Thread Dr. Frank Ullrich
Heikki, Heikki Tuuri schrieb: Hi! - Original Message - From: Orr, Steve [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, September 26, 2002 9:56 PM Subject: RE: MyISAM or InnoDB PROVOCATIVE RANT MySQL doesn't provide native support for transactions

Re: Japanese Charset

2002-09-27 Thread Joel Rees
Lastly, I am convinced that this is a problem with MySQL. I have some time again, let me try again. It's a tortuous tale, but bear with me. Background in brief: Shift-JIS is a real pain in the neck to parse. When you look at a byte, it's often impossible to tell whether you're looking at the

SHAPE command for Hierarchical Recordset

2002-09-27 Thread NZEYIMANA Emery Fabrice
I have created a MySQL database that will help me manage my Invoicing system but I have been stack when I tried to print a report using a VB application. I have read from Help that I will need to use a hierarchical recordset to achieve what I want to. You know an Invoice has some headers like:

Re: MyISAM or InnoDB

2002-09-27 Thread Heikki Tuuri
Frank, - Original Message - From: Dr. Frank Ullrich [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, September 27, 2002 11:18 AM Subject: Re: MyISAM or InnoDB Heikki, Heikki Tuuri schrieb: Hi! - Original Message - From: Orr,

Re: SHAPE command for Hierarchical Recordset

2002-09-27 Thread CP
I would suggest you use MS Access report with MyTool-DLL For VB and MySQL. - Original Message - From: NZEYIMANA Emery Fabrice [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 27, 2002 4:40 PM Subject: SHAPE command for Hierarchical Recordset I have created a MySQL

Re: SHAPE command for Hierarchical Recordset

2002-09-27 Thread NZEYIMANA Emery Fabrice
Where can I get those tools? With MS access, my queries work fine after importing the data from MySQL Thanks Emery - Original Message - From: CP [EMAIL PROTECTED] To: NZEYIMANA Emery Fabrice [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, September 27, 2002 10:47 AM Subject: Re:

Problem with symlinked files used with load data infile

2002-09-27 Thread Christian Mondrup
I'm new to MySql but accustomed to Oracle. Hope the below problem report contains the necessary information. Output from mysqladmin: mysqladmin Ver 8.23 Distrib 3.23.49, for redhat-linux-gnu on i386 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with

Re: newbie only

2002-09-27 Thread Gunter Geis
Hello The error 10061 on windows means, that the host refueses the connection. In a command promt type: net helpmsg 10061 Do you running a firewall ? Gunter Victoria Reznichenko wrote: weng, Thursday, September 26, 2002, 3:05:25 AM, you wrote: wc i've installed ver 3.23.47 sa

Re: Filemaker database to MYSQL

2002-09-27 Thread Joel Rees
Has anyone created a plugin or script that will allow me to convert my filemaker database to MYSQL Check the archives. There has been some discussion of this in the past. -- Joel Rees [EMAIL PROTECTED] - Before posting,

Re: MYSQL C++ API

2002-09-27 Thread Stefan Fleiter
Paco wrote: I'm having probles with the c++ api of mysql... could somebody help me plesae? Could be, maybe you should post your specific problem. - Before posting, please check: http://www.mysql.com/manual.php (the

Passing Connection Objects between DLLS

2002-09-27 Thread Michael J. Fuhrman
Hello All, When passing a connection object between DLL's it appears that myODBC driver is not able to create Editable RecordSets objects from it. However, I can create Static RecordSet objects. A work around that I have found is to have the 2nd DLL open a new connection object. Code samples

provider for .net

2002-09-27 Thread Jay Fields
I'm building an asp.net app and I want to connect to mysql, but I dont what which DataAdapter to use, and I don't know what Provider to specify in my connection string. Anyone have any advice? - Before posting, please check:

Re: SELECT COUNT

2002-09-27 Thread andy thomas
On Fri, 27 Sep 2002, Michael J. Fuhrman wrote: Hello All, I seem to be running into a very strange problem. In the mySQL command line interface I issue SELECT COUNT (*) FROM The correct syntax is SELCT COUNT(*) ie, there's no space between SELECT and the (*). Andy

re: SELECT COUNT

2002-09-27 Thread Egor Egorov
Michael, Friday, September 27, 2002, 3:16:49 PM, you wrote: MJF I seem to be running into a very strange problem. MJF In the mySQL command line interface I issue SELECT COUNT (*) FROM MJF test; and get -- ERROR 1064: You have an error in your SQL syntax MJF near '(*) from test' at line 1. MJF

Re: Re: Replication

2002-09-27 Thread Victoria Reznichenko
Hello CP, Friday, September 27, 2002, 3:11:14 AM, you wrote: C hi Victoria, thanks for the reply. I have set server id in the very C beginning, but its still not working. I don't understand why the MySQL would C not let me change its server id accordingly. The server id was set to 1. You must

How to get select for missing row working?

2002-09-27 Thread rick
While the subject sounds counter-intuitive, I think I'm trying to do something simple and I can't figure it out. I have a simple table, lookup, with two columns, id and decode. I want to write a simple query that retrieves the decode if there, and the id if the row is missing for a given

Re: [bug] koi8-r codepage bug

2002-09-27 Thread Cyril Zlachevsky
Victoria Reznichenko wrote: Cyril, Thursday, September 26, 2002, 11:30:39 PM, you wrote: CZ ---cut--- mysql DROP TABLE IF EXISTS COUNTRIES; CZ Query OK, 0 rows affected (0.02 sec) mysql CREATE TABLE COUNTRIES (Name varchar(30) NOT NULL DEFAULT 'n/a', CZ - PRIMARY KEY (Name) ); CZ

Re: SQL question

2002-09-27 Thread Joseph Bueno
Try: SELECT fieldname FROM table ORDER BY 0+fieldname; Regards John Almberg wrote: That gives a syntax error, unfortunately. -- JOhn -Original Message- From: Mihail Manolov [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 9:51 PM To: Mysql Subject: Re: SQL question

Re: problem changeing the root password

2002-09-27 Thread gerald_clark
mysqladmin is in the clients rpm. Niko Itajarvi wrote: I installed the MySQL-3.23.52-1.i386.rpm packet on my RedHat 7.3 server machine. Installation went OK, then it told me to change my root password by typeing: /usr/bin/mysqladmin -u root password newpasswd But i cant find mysqladmin at

Re: provider for .net

2002-09-27 Thread Dr. Michael Wittmann
Hi Jay, see http://www.mysql.com/press/release_2002_10.html for an overview. HTH, Michael Jay Fields wrote: I'm building an asp.net app and I want to connect to mysql, but I dont what which DataAdapter to use, and I don't know what Provider to specify in my connection string. Anyone

Re: Bug report

2002-09-27 Thread gerald_clark
This is documented behavior. Indexes are not used with DESC. Ver 4.X does, however support DESC with an index. Grigoriy Vinogradov wrote: Bug Report: Version: 3.23.51-max OS: Windows ME Problem: Synopsis: Does not use index when ordering records on datetime field in the descending order, even

Re: SQL question

2002-09-27 Thread gerald_clark
ORDER BY 0 + fieldname if this is not quit right try ORDER BY 0 + fieldname , fieldname John Almberg wrote: That gives a syntax error, unfortunately. -- JOhn -Original Message- From: Mihail Manolov [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 9:51 PM To:

Re: Japanese Charset

2002-09-27 Thread Michael T. Babcock
Joel Rees wrote: Shift-JIS is a real pain in the neck to parse. When you look at a byte, it's often impossible to tell whether you're looking at the first byte or the second byte of the character. Can I make a minor recommendation that doesn't help your current situation at all? Use UTF-8.

connecting to mysql via ODBC from asp.net

2002-09-27 Thread Jay Fields
I've installed the windows version of mysql. I configured nothing. This is the code I'm trying to use to access mysql from an asp web service (in vb): - WebMethod() Public Function dbConnect() As String Dim connString As String = DRIVER={MySQL ODBC 3.51 Driver}; _

InnoDb restore - Please help

2002-09-27 Thread Scott Pippin
I am new to InnoDb and was wondering what steps I would have to do to restore a table. Lets assume I am backing up the data by backing up the tablespaces. Thanks in advance (MySQL, query) - Before posting, please check:

RE: SQL question

2002-09-27 Thread William McCormick
I don't know that there is knowing the way sorts usually work I'd say no. This is my first posting to this group and I am just in the initial phases of supporting MySQL as a backend for out application. If the numbers always precede the letters I would split them off into two separate columns

rename database

2002-09-27 Thread Jorge Martinez
Exists any way to rename a database ? Thanks Jorge sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread,

Re: stopping a query

2002-09-27 Thread Robert Citek
Hello Ozette, At 05:36 AM 9/27/2002 -0400, Ozette Brown wrote: To stop a running query, you'll need to do a 'myqsladmin processlist' and once you find the PID for the query, issues a mysqladmin kill PID. This should do the trick. Is there not a more elegant solution? Would not the above

FW: SQL question

2002-09-27 Thread John Almberg
Nope. I've tried every combination I can think of of these ideas. They all give syntax errors. I don't think arithmatic is allowed in an ORDER BY clause. Doesn't even work on an INT field. -- John -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED]] Sent: Friday,

foreign key support??

2002-09-27 Thread Remco Barendse
Hi! According to the website MySQL 4.0.x supports foreign key constraints. For version 4.1 foreign key integrity rules are planned. What is the difference between these 2? On previous versions of MySQL it was possible to create foreign keys but changed data was not replicated to other

re: Re: error:mysqld got signal 11

2002-09-27 Thread Victoria Reznichenko
Vaso, Thursday, September 26, 2002, 11:48:03 PM, you wrote: VK Hello Victoria, VK I have installed mysql 3.23.49 for Sorlaris and I have installed it VK from the source distribution. I checked it on 3.23.52 installed from binary and it worked well. VK Do you have any idea about my problem?

Re: SHAPE command for Hierarchical Recordset

2002-09-27 Thread John Ragan
try corereader at http://ww.corereader.com/ it's certainly not designed to create reports with much of eye candy. however, it queries mysql and access (and any other data source), lets you create queries with point and click, stores queries and connections, and gives you a few report

Re: MySQL 4.0.3 on glibc-2.1.3?

2002-09-27 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 26 September 2002 15:11, Klaus Friis Østergaard wrote: Is it possible to run the new MySQL 4.0.3 on a system that uses glibc-2.1.3, especially the MySQL-shared? Not using the precompiled binaries from the download pages (they have

Force NOW() result to type datetime

2002-09-27 Thread Iago Sineiro
Hi all. I execute the query SELECT NOW() in Delphi 5.0 against MySQL 3.22.30 and Delphi understand that the column of the query is of type ftString (String) when it should be ftDateTime (datetime). Any query I execute that contains a datetime column returns the datetime type. In MySQL 4.0.3 I

Obtaining a count of the First and Last values

2002-09-27 Thread Alexis Antonakis
Hi, I have a table used for generating stats (In fact it is phpTracker) What I am trying to do is to generate the 1st page visited and the last paged visited, per session, but grouped together. i.e. request_timeSession referer_uri 21/09/2002 12:51:08

Obtaining a count of the First and Last values

2002-09-27 Thread Alexis Antonakis
Hi, I have a table used for generating stats (In fact it is phpTracker) What I am trying to do is to generate the 1st page visited and the last paged visited, per session, but grouped together. i.e. request_timeSession referer_uri 21/09/2002 12:51:08

Re: Not Null

2002-09-27 Thread Clayburn W. Juniel, III
On Thursday, September 26, 2002, at 06:30 AM, Egor Egorov wrote: Clayburn, Thursday, September 26, 2002, 3:58:13 AM, you wrote: CWJI I create a table with a VarChar field set to not null. When I do an CWJI insert into this table with no value for this field it goes through

re: Re: [bug] koi8-r codepage bug

2002-09-27 Thread Victoria Reznichenko
Cyril, Friday, September 27, 2002, 4:19:25 PM, you wrote: CZ if I build mysql with CZ ./configure --with-charset=koi8_ru CZ then check (make; make check; make test) failed! Because MySQL by default uses latin1 character set and you have compiled only with koi8_ru. CZ But if I build mysql with

Re: SQL question

2002-09-27 Thread speters
How about SELECT fieldname FROM table ORDER BY CAST(fieldname as SIGNED) UNSIGNED could replace SIGNED, depending on your needs. this works for me on Mysql 4.02 alpha on solaris regards, sean peters [EMAIL PROTECTED] - Original Message - From: John Almberg [EMAIL PROTECTED] To:

Re: FW: SQL question

2002-09-27 Thread Joseph Bueno
Here is a small example I have just run : mysql create table test (f char(20)); Query OK, 0 rows affected (0.90 sec) mysql insert into test values ('11xbc'); Query OK, 1 row affected (0.01 sec) mysql insert into test values ('2bcv'); Query OK, 1 row affected (0.00 sec) mysql insert into test

re: foreign key support??

2002-09-27 Thread Egor Egorov
Remco, Friday, September 27, 2002, 6:29:28 PM, you wrote: RB According to the website MySQL 4.0.x supports foreign key constraints. RB For version 4.1 foreign key integrity rules are planned. RB What is the difference between these 2? On previous versions of MySQL it RB was possible to create

Re: foreign key support??

2002-09-27 Thread Paul DuBois
At 17:29 +0200 9/27/02, Remco Barendse wrote: Hi! According to the website MySQL 4.0.x supports foreign key constraints. For version 4.1 foreign key integrity rules are planned. What is the difference between these 2? On previous versions of MySQL it was possible to create foreign keys but

Re: foreign key support??

2002-09-27 Thread Scott Pippin
It is supported in MySQL 4.0.x if you use the InnoDb table handler. I'm not sure about 4.1. Remco Barendse [EMAIL PROTECTED] 09/27/02 09:29AM Hi! According to the website MySQL 4.0.x supports foreign key constraints. For version 4.1 foreign key integrity rules are planned. What is the

RE: automating import process

2002-09-27 Thread sql_newbie
Hi Carl, Thanks for your reply. I have created a shell script but I get stuck on the part where it asks to input password. How do I get the script to input the password that I put in? So far my script looks like this: ./mysql -u 'root' -p echo abc The script executes, but it just waits for

RE: SQL question

2002-09-27 Thread Derek Scruggs
I just tried it and it works fine. It doesn't solve my similar problem, which is related to letters coming *before* numbers, but the parser doesn't reject it. Wish I could offer a solution, but I'm not very knowledgable about MySQL internals config. -Derek -Original Message- From:

Re: Need help with simple problem... I think

2002-09-27 Thread Clayburn W. Juniel, III
On Thursday, September 26, 2002, at 10:46 AM, Darrell A. Sullivan, II wrote: I am sure I am going to feel ignorant when I get the answer to this question because it will be something simple that I have overlooked, but here goes anyhow. I am using MySQL Version 3.23.51-max. I am

Re: FW: SQL question

2002-09-27 Thread Mark Matthews
John Almberg wrote: Nope. I've tried every combination I can think of of these ideas. They all give syntax errors. I don't think arithmatic is allowed in an ORDER BY clause. Doesn't even work on an INT field. -- John Have you tried a computed column, i.e, SELECT BLAH, 0 + BLAH as

A FAQ type question, but not in the FAQ - How to change my hostname, but not make replication puke

2002-09-27 Thread Eric Frazier
Hi, I changed my hostname(The DNS change was taken care of elseware) in FreeBSD 4.6 in the rc.conf file, rebooted. Mysql had no problems starting, but it failed to start the slave. In the new error log I saw: 020927 10:15:58 mysqld started 020927 10:15:59 InnoDB: Started 020927 10:15:59

Re: FW: SQL question

2002-09-27 Thread jacob
A couple things off the top of my head: - Have you looked into MySQL's 'SET' type? - What about something like SELECT 0+fieldname as zerofield FROM table ORDER BY zerofield; - Would using grouping help? - Have you considered creating a custom character set? (This may be too extreme. Can be

Mysqld always shuts down after running mysqld

2002-09-27 Thread mailto
Description: hi mysql team, i am a mysql newbie (my first time i install it) i give up, i can't solve the problem without help. all the time i try to start the mysqld, it ends up instantly with a shutdown of mysqld, i cant run the prog: i edited the mysqld.log and tried to figure out the problem,

Re: rename database

2002-09-27 Thread Clayburn W. Juniel, III
On Friday, September 27, 2002, at 07:57 AM, Jorge Martinez wrote: Exists any way to rename a database ? Thanks Jorge sql You can create a new database and then: Rename Table old_database.table_name to new_database.table_name. You would have to do this for every table. You could then

Re: Japanese Charset

2002-09-27 Thread Michael T. Babcock
Dawn Friedland wrote: Prior to my client requesting that I add Japanese content to the content tool database, I had zero experience with characters sets other than Latin. I always used notepad to filter out any weird MS Word formattings and left the default as ANSI. I had that problem a year

RE: automating import process

2002-09-27 Thread Iikka Meriläinen
Hi, use this: mysql -u root -ppassword It's important NOT to put a space between -p and the real password. Having a password in a script is unsafe at its best, though. I'm not sure if you have any other options than to put it that way or enter it manually each time you run the script. Regards,

Re: SQL question

2002-09-27 Thread BobJ
I'm new at SQL so I may be off base, but in traditional programming practice when you want that kind of sort (right justified) you would fill the field with preceding zeros and that would cause the sort that you are seeking. I'm sure that you could suppress the zeros on print with some sort of

possible left join problem?

2002-09-27 Thread Matt MacDougall
Hi, I've got two tables, links and categories. links ... id int(11) NOT NULL auto_increment, name text, note text, link text, category1 int(11) NOT NULL default '0', category2 int(11) NOT NULL default '0', category3 int(11) NOT NULL default '0', date_added timestamp(14) NOT

Re: [PHP] Encrypted MySQL passwords

2002-09-27 Thread Steven Kreuzer
http://www.stunnel.org/examples/mysql.html SK mysql, sql, query On Thursday, September 26, 2002, at 12:40 PM, John Holmes wrote: I am connecting to a mysql server on a remote machine, and opened up port 3306 for this purpose. But, I am concerned about sending a clear text password, via

RE: FW: SQL question

2002-09-27 Thread John Almberg
Yes, that works! Thank you very much! -- John -Original Message- From: Mark Matthews [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 1:33 PM To: John Almberg Cc: Mysql Subject: Re: FW: SQL question John Almberg wrote: Nope. I've tried every combination I can

Postfix + MySQL on FreeBSD - Can't create a new thread

2002-09-27 Thread Marcio Merlone
Dears, I'm running a postfix box with a mysql virtual users database on a FreeBSD 4.6.2 machine. It is a dual Xeon 800, 2GB RAM, 140GB Raid5 SCSI. This postfix holds about 11.000 virtual accounts and I'm running on a big problem. Whem mysql approaches 240 simultaneous conections I get this

Re: rename database

2002-09-27 Thread Support
From what I heard, yes. If you stop MySQL, then rename the dir/database. It may work. Worked for me (did it about 3 months ago). HTH, Ricardo. - Original Message - From: Jorge Martinez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 27, 2002 11:57 AM Subject: rename

Re: CPU 100%

2002-09-27 Thread John R. Diehl, Jr.
If you find an answer, I would really like to hear about it. I have been working on this for months. No one seems to have a clear answer, although several people have reported curing it by either adding your server to c:\WINNT\system32\drivers\etc\hosts or setting the mysql service up to

Mysql and RedHat 7.3

2002-09-27 Thread Luc Foisy
When I installed Mysql ( whatever the current 3.x series is on RedHat 7.3, the service did not start when I restarted. If you have gnome installed, you can acess Service Configuration and set MySQL to start when system boots. Just information for those that may experience this. Luc Foisy

Selective silence

2002-09-27 Thread rick
Is there anyway within a mysql batch script to make individual statements silent? For example, if I have a script like: select @t1:=desc from decode_table where id=42; select @t2:=desc from decode_table where id=64; select concat('the msg is ',ifnull(@t1,42),' part two is ',ifnull(@t2,64)); I

please help with sql query

2002-09-27 Thread Michael Knauf/Niles
I have two tables: products +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id | int(6) |

mysql instla

2002-09-27 Thread root
I tried to start it with safe-mysqld --u=mysql when I ran the mysqltest I get cannot connect to local mysql server through socket '/var/lib/mysql/mysql.sock'  Any idea ... - Before posting, please check:

MySQL 4.03 and merge tables: bug with BETWEEN

2002-09-27 Thread Tac
We're having a problem with a huge merge table and BETWEEN. The same query in MySQL 3, using an identical (binary) copy of the database, takes a fraction of a second, in MySQL 4.03 it runs without stopping. The query is a simple Select * from my_merge_table where my_code BETWEEN '2026676653'

one step up ...

2002-09-27 Thread hans schneidhofer
hi list, have a simple newbie-question was looking for a possibility to go back one step after do a use sample_db but cannot find anything in the doc-files. what I mean is this : logging into mysql with using : mysql -u root -p then I get : mysql now I'm using use sample_db and can do some

RE: FW: SQL question

2002-09-27 Thread John Almberg
Yes, that works! Thanks very much to all who suggested similar solutions! -- John -Original Message- From: Mark Matthews [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 1:33 PM To: John Almberg Cc: Mysql Subject: Re: FW: SQL question John Almberg wrote: Nope.

RE: FW: SQL question

2002-09-27 Thread John Almberg
Yes, that worked. Thanks to all who contributed similar solutions! Now I'm going to mention MySQL in my message so that my message isn't rejected as spam by the list manager! (What's that all about???) Thanks again (mentioning MySQL again (just to be safe)) -- John -Original Message-

Re: FW: SQL question

2002-09-27 Thread gerald_clark
Then try: select somefields,fieldname + 0 as orderfield order by orderfield John Almberg wrote: Nope. I've tried every combination I can think of of these ideas. They all give syntax errors. I don't think arithmatic is allowed in an ORDER BY clause. Doesn't even work on an INT field. -- John

Re: please help with sql query

2002-09-27 Thread Clive Smart
Hi there Try This: SELECT products.product_name, products.fg_number, images.image_name, images.thumbnail, images.image_path, images.color_depth, images.width_inches, images.height_inches, images.resolution, images.filesize, images.filetype, images.notes FROM products LEFT JOIN images ON

Re: mysql instla

2002-09-27 Thread Clayburn W. Juniel, III
On Friday, September 27, 2002, at 12:28 PM, root wrote: I tried to start it with safe-mysqld --u=mysql when I ran the mysqltest I get cannot connect to local mysql server through socket '/var/lib/mysql/mysql.sock'  Any idea ... Try: safe_mysqld -u=mysql or safe_mysqld

granting FILE privileges

2002-09-27 Thread Mark Hennessy
I'm using FreeBSD 4.6 and MySQL 3.23.36 I keep trying to grant file privileges to a user, but no matter what I do, it seems that the customer keeps getting access denied errors. They are trying to execute the following: select * into outfile '/tmp/list.txt' fields terminated by | lines

Re: [PHP] Encrypted MySQL passwords

2002-09-27 Thread Mark Matthews
Steven Kreuzer wrote: http://www.stunnel.org/examples/mysql.html SK mysql, sql, query On Thursday, September 26, 2002, at 12:40 PM, John Holmes wrote: I am connecting to a mysql server on a remote machine, and opened up port 3306 for this purpose. But, I am concerned about

Re: one step up ...

2002-09-27 Thread Clive Smart
Hi there Just type in: show databases;, which will list all databases, then type in: use mysql; or whichever database you require Simple Clive hans schneidhofer wrote: hi list, have a simple newbie-question was looking for a possibility to go back one step after do a use sample_db but

RE: CPU 100%

2002-09-27 Thread Brian . Duke
Don't have a fix but look at the swap file size. May need to increase that. A further note MS Access on NT run 100%,...100% of the time. -Original Message- From: John R. Diehl, Jr. [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 1:05 PM To: Peter Zuidema; [EMAIL PROTECTED]

Re: MySQL overload problem ?

2002-09-27 Thread Ken Menzel
Hi Cristiana, I am another FreeBSD user and I can tell you that FreeBSD 4.1.1 does have problems with threads. I would very much recommend that you update as there are also many security problems with that version if you are running a server that is remotely available. There were many

RE: Mysql and RedHat 7.3

2002-09-27 Thread Brian . Duke
Redhat...Linux systems: running Xwindows login at runlevel5 cd /etc/rc.d/init.d/rc5.d/ search for mysqld mv ./K74mysqld ./S78mysqld The K denotes Kill The S denotes Start If you run you system at a different run level like 3 then go to /rc5.d/ directory and change the file name there. The

Re: Mysql and RedHat 7.3

2002-09-27 Thread Robert Citek
Hello Luc, At 03:13 PM 9/27/2002 -0400, Luc Foisy wrote: When I installed Mysql ( whatever the current 3.x series is on RedHat 7.3, the service did not start when I restarted. If you have gnome installed, you can acess Service Configuration and set MySQL to start when system boots. Just

Re: one step up ...

2002-09-27 Thread Clayburn W. Juniel, III
On Friday, September 27, 2002, at 12:56 PM, hans schneidhofer wrote: hi list, have a simple newbie-question was looking for a possibility to go back one step after do a use sample_db but cannot find anything in the doc-files. what I mean is this : logging into mysql with using : mysql

Basic RPM Installation

2002-09-27 Thread DeNewbie
I am new to this newsgroup and I am a SUSE Linux 7.3 user. I want to learn how to use PHP and MySQL and I am reading the MySQL reference manual. Firstly I am trying to install these RPM files. MySQL-3.23.52-1.i386.rpm MySQL-client-3.23.52-1.i386.rpm MySQL-devel-3.23.52-1.i386.rpm They all

Re: Fixed width alternative to TEXT type field?

2002-09-27 Thread Gary Traffanstedt
On Thursday 26 September 2002 11:16 pm, Jeremy Zawodny scribbled something about: On Thu, Sep 26, 2002 at 11:24:14AM -0700, Gary Traffanstedt wrote: sql,query I have a table that has approximately 40 colums and all but 1 of them I have been able to make fixed width. The sole hold out is

Basic RPM Installation

2002-09-27 Thread DeNewbie
-- Forwarded message -- Date: Fri, 27 Sep 2002 19:27:22 -0400 From: DeNewbie [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Basic RPM Installation I am new to this newsgroup and I am a SUSE Linux 7.3 user. I want to learn how to use PHP and MySQL and I am reading the MySQL

How to see warning messages for load data infile

2002-09-27 Thread David Yee
Hi all. I'm trying to load a file into mysql using load data infile and got a ton of warnings. Is there any way to see what the warnings are? Thanks. David - Before posting, please check: http://www.mysql.com/manual.php

Re: Basic RPM Installation

2002-09-27 Thread Chuck \PUP\ Payne
Did you install from the SuSE CD? If so then you have to tell YaST to start MySQL. You can start it from /etc/rc.d/mysql. If you want to use PHP you will need to tell YaST to install PHP for apache as well. SuSE has made running MySQL and PHP so easy by using YaST. Also run YaST to update PHP

RE: Mysql and RedHat 7.3

2002-09-27 Thread Brian . Duke
Oops correction: If you run you system at a different run level like 3 then go to /rc3.d/ directory and change the file name there. -Original Message- From: Duke, Brian Sent: Friday, September 27, 2002 3:45 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Mysql and RedHat 7.3

RE: automating import process

2002-09-27 Thread sql_newbie
Thanks for your reply. Just out of curiousity, is it possible to use it by echoing back the password somehow? I think that echoing back the reply would work great if I ever needed any unattended process using scripts. Thanks. Peter On Fri, 27 Sep 2002, [ISO-8859-1] Iikka Meriläinen wrote:

Re: Basic RPM Installation

2002-09-27 Thread John Coder
On Fri, 2002-09-27 at 19:27, DeNewbie wrote: I am new to this newsgroup and I am a SUSE Linux 7.3 user. I want to learn how to use PHP and MySQL and I am reading the MySQL reference manual. Firstly I am trying to install these RPM files. MySQL-3.23.52-1.i386.rpm

Duplicate entries

2002-09-27 Thread John Coder
at work I run mysql 3.23.45. on a windows2000 machine with apache 1.3.23 and php4.06. at home it's Linux SuSe *.0, mysql 4.03 apache 1.3.26 and php4.2.3. the problem is I'm having problems inserting data into temporary tables. the results are different running the same script. here is the script

MySql Insert optimization

2002-09-27 Thread Dan Cumpian
Hello,   I am running MySql on a Windows 2000 PIII-1Ghz PC with 256MB of RAM. I have three table that need to get updates when a new record gets created. I have minimized the number of indexes on the tables and the insert process goes like this:   (All three tables have a primary key to prevent

PLEASE HELP

2002-09-27 Thread Mrs. ELIZABETH OBED
Dear mysql , MRS ELIZABETH OBED C/O. SAM BELLO BARRISTER SAM BELLO CO. LEGAL PRACTITIONAL 2, FALOHUN STREET, AGUDA S/L LAGOS, NIGERIA. FAX: 234-1-7594260 I am Mrs. Elziabeth Obed, widow of the late Lt. Col. M. Obed, the former military Administrator of Kaduna state of Nigeria. my late

DB Problems

2002-09-27 Thread Odhiambo Washington
Hi Users, I have some problems with my database and not being quite profficient in SQL, I did myisamcheck and posted the data on the site below: http://ns2.wananchi.com/~wash/RT2/myisamcheck.txt I am wondering if someone can take a look and possibly tell me if they notice a problem and what I

mysql.sock mystery!

2002-09-27 Thread ÀÌö¿ì\(õ¸®¾È\)
Hello, Freinds! I'm new to MySQL. Anyway... My O/S is FreeBSD 4.6. In /etc/hosts there are only two line. 127.0.0.1localhostlocalhost.paldal.com 192.168.0.88unix.paldal.comunix And in /etc/host.conf, first seek : /etc/hosts second seek : bind And some PHP