Mysql.sock ????

Hi all, I've installed mysql 3.23.42 on Freebsd system but when i launch mysql i said me can't connect to localhost /tmp/mysql.sock not found. How can i repair this error? Thanks Moreno - Moreno Riccardi

mysql.sock ???

Hi all, I've installed mysql 3.23.42 on Freebsd system but when i launch mysql i said me can't connect to localhost /tmp/mysql.sock not found. How can i repair this error? Thanks Moreno - Moreno Riccardi

Re: How I can do this

Using MySql. I can make this from another language iteranting for each one of the elements in the table, but in this form it is really very slow, because the real table is too big,. for that reason I would like to know if it is possible to make this using only MySql instructions. Sorry for my

RE: Simple problem: Blank search box returns all records

Hi, This is more of a jsp/html/javascript issue. It is relatively easy to create a small procedure/function in javascript/jsp which checks all the fields are not emtpy, and gives a warning message when you click on the submit button. Its much easier to run the validation before sending the

RE: C API - mysql_store_result segfaulting

Hi Carsten, I have just had a similar experience, which Jorge from Mysql support helped me sort out (successfully) - here is his advice to me. Hi! Which compiler / version are you using ? If it is any from 2.96 series, you'd be better off using any in the 2.95 or 3 series,

mysqlbinlog

Hi, I have mysql - bin -log, but when i read this I can't find IP number from client who made connection to my server. How i find IP number in mysql - bin -log ? thanks - Before posting, please check:

General error: Can't lock file (errno: -1)

Hi, When I run my application I get java.sql.SQLException: General error: Can't lock file (errno: -1) at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java) at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java) at org.gjt.mm.mysql.Connection.execSQL(Connection.java)

RE: Problem with query

Hi, Getting non-empty results when comparing something with NULL seems very odd to me too. Even if it is undefined, id expect to see an error message telling me i shouldnt compare an undefined variable rather than receiving results. Why not ask someone to change things so that WHERE xx=NULL

ODBC Call Fails

Hi all, Not sure if this is the right place to ask this one but here goes! I'm trying to export an Access 2000 database to MySQL and remain using Access as the front end. Everything seems to be working fine, except for this one line of code which is giving me and ODBC call failed error.

Re: Binaries /Pictures in mysql

I have the same question but i want to store binaries in the database, but not sure how to go about it cheers Dave Siim Einfeldt aka Itpunk wrote: I know you most likely want to add the full source of teh pics to database, but this is nt a good idea. The best way would be to just write the

Re: make fails on AIX 4.3.3 using the IBM xlc/xlC compiler

Thank you for your report. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com

Re: MySQLGUI hangs on certain commands

David Wolf writes: I've been trying to play with MySQLGUI lately (running the win32 version of the GUI, Linux version of the server). I can connect fine. Run queries fine. But, when I try to do any grants on a database or edit a table, the client connects to the server as many times as it can

RE: Can not load database

Hello mysql I have been give the database files for a mysql database that I can not get to open and display records. I have run myisamchk, isamchk, mysqlcheck, mysqldump and all return the header does not support check/repair or cut Now I am using mysql 3.23 on win32 to view this and

Re: DATA DIRECTORY bug on Win32

Hi! Mike == Mike Blazer [EMAIL PROTECTED] writes: cut Mike Well, I'm sure there are some better ways too - it's a pity that it such Mike a useful feature fails on Win32. I have now changed MySQL 4.0.1 to ignore any DATA DIRECTORY directives, until we have come up with an acceptable

Re:difficulty compiling v4 --without-innodb

Hi Sommai! On Mon, 29 Oct 2001, Sommai Fongnamthip wrote: Did you mean V4 must ran with innodb? Oh! I have bad experience with innodb. It ate a lot my hard disk space. Oh no! Absolutely not required! I think V4 defaults to --with-innodb because './configure --help |grep -i inno' returns

RE: MySQL Security w/ PHP

Hi! On Oct 28, Kevin Maynard wrote: I have been building an extensive dB with MySQL for a large Insurance Company and am nearing the completion stage. I have build several PHP forms to show the preliminary pages to the various groups who will be using this dB. I have created the

RESOLVED: C API - mysql_store_result segfaulting

Thanks to the help of Sasha Pachev and Robin Keech, the problem has been resolved. The solution came in three stages: 1) Downgrading glibc and glibc-devel to non-RedHat 2.2.4-5 RPMs 2) Ditto for gcc - down to v. 2.95.3 3) And an error on my own: removing some extraneous

Re: [MySQL 4.0 compile fails on Linux]

Ed Carp writes: Description: make[3]: Entering directory `/usr/local/src/mysql-4.0.0-alpha/sql' gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ - DDATADIR=\/usr/local/var\ -DSHAREDIR=\/usr/local/share/mysql \

RE: insert BLOB in perl

On Mon, 29 Oct 2001, Jindo Soul wrote: Why this error exists is beyond my knowledge though. I am guessing that Perl DBI escapes ' \ in bind_param call. And MySQL escapes the data again when using big5 charset, which ultimate causes an error because of double escaping. Well, its not that

MySQL privileges

Hi! I'm working on a Linux Mandrake 8.1 station. I have installed MySQL. I have typed './mysql_install_db' When i type mysql, i have the prompt mysql But when i type create database phpdig i have the error message: ERROR 1044: Access denied for user: '@localhost' to database 'phpdig'. Can

ODP: MySQL privileges

Hi Just type: mysql -u root Regards -Oryginalna wiadomoœæ- Od: COLLINEAU Franck FTRD/DMI/TAM [mailto:[EMAIL PROTECTED]] Wys³ano: 29 paŸdziernika 2001 15:05 Do: '[EMAIL PROTECTED]' Temat: MySQL privileges Hi! I'm working on a Linux Mandrake 8.1 station. I have installed

SecureCRT

I am using SecureCRT to login to a remove MySQL server. I can get pass the initial login. However, a login screen displays on the screen asking for a second password. I have entered all information correctly, but the system is still requesting another password. Verlin Taylor

Question - Request. Are they the same? I dont think so. (fwd)

Hei Could anybody explain me the different between a question and a sql-request in mysql?. F.example: If I send a sql-request to mysql: select * from Table where column_A=1 and column_B=2 order by column_C; num.sql_request = 1 and num.questions = 1 Is this true? Can I send 1 sql_request

my_print_defaults: not found

When I run my startup script, I get the following message: # /etc/rc2.d/S99mysql start /etc/rc2.d/S99mysql: my_print_defaults: not found # Starting mysqld daemon with databases from /usr/local/mysql/data I've tried adding a command print-defaults to my.cnf, but that caused the startup to

Re: SecureCRT

[EMAIL PROTECTED] wrote: I am using SecureCRT to login to a remove MySQL server. I can get pass the initial login. However, a login screen displays on the screen asking for a second password. I have entered all information correctly, but the system is still requesting another password.

Installation question on Linux.

Hi, all, I am installing MySQL+Gemini 3.23.41 on Linux 6.2. I followed the instructions such as tar xvf, etc. Then I came to the : CFLAGS=-03 \ CXX=gcc CXXFLAGS=-03 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=~/local/mysql\ --enable-assembler

Further to the installation fail on Linux.

Hi, all, About my earlier message about installation of mysql on Linux. the ~/local/ directory is a local scratch space allocated by my lab. And my problem is that no Makefile is created after the ./configure and thus I cannot make. Wei

Can MySQL be run from a CD-ROM?

I'd like to package MySQL, some databases, and PHP-enabled Apache on a CD-ROM, with all components runnable with, essentially, no installation in a Windows environment. This would be a read-only database accessed through a web browser by way of PHP scripts. Is such a thing possible?

JSP newbie needs to run MySQL-JDBC.

Hello Everyone, I need to run MySQL using JSP. I am a JSP newbie, actually a Java newbie too. I am more of a PHP/MySQL guy. I have successfully installed Allaire JRun 3.0 on Win98 using PWS. JRun has an application management console and I cannot seem to run MySQL. I am totally

a little problem

Hello, I started developing a small application that uses this great library (mysql) with its API (mysqlpp) and wxWindows. But, i couldn´t even compile the program because I received some errors like this: C:\SQLPP\INCLUDE\set3.hh(23) : error C2872: 'ostream' : ambiguous symbol

createing database

Hi! I have the mysql prompt. mysql I type : mysql CREATE DATABASE menagerie; I have the error message: ERROR 1044: Access denied for user: '@localhost' to database 'menagerie' ?? Franck - Before posting, please check:

RE: Generate random, unique value...

I can see one problem with this, which is that in the case that you get two identical number in the second column their order will be strongly dependent on the values in the first column. I'm not sure what the problem with this is? The first (unique) column is independent of the second

Re: Optimizing query (2nd attempt)

David Wolf wrote: Not quite fixed.. When I run the query without limiting by time, it still fails to use the userid key. i.e. if I only select where users.username=testuser, I'd expect that users.username to return the users.id=2, and to search using the indexed log.userid=2 MySQL can only use

Re: createing database

You need to setup your permisions in MySQL. Look in the MySQL reference material on how to setup users and permisions. M;) Hi! I have the mysql prompt. mysql I type : mysql CREATE DATABASE menagerie; I have the error message: ERROR 1044: Access denied for user: '@localhost' to

Re: Generate random, unique value...

George Eric R Contr AFSPC/CVYZ writes: I'm not sure what the problem with this is? The first (unique) column is independent of the second (random) column. If the random column has duplicate values, it just means that the corrosponding first column values will be adjacent in the sorted

Re: Beginner Question

- Original Message - From: jim barchuk [EMAIL PROTECTED] With luck you got the book at a reputable dealer who'll allow you to exchange it for Paul Dubois _MySQL_ New Riders ISBN0-7357-0921-1. Please spend a few extra $ and save yourself many many hours of confusion and frustration.

Re: Optimizing query (2nd attempt)

Maybe I'm missing something here--I don't know of a way to create an index on TWO tables at once? Also, when I do: EXPLAIN SELECT log.entity, log.action, LEFT(users.username,10) AS username, LEFT(boards.title,15) AS Board, LEFT(topics.subject,22) as Subject, log.postid, log.extraid,

Server configuration denies access to data source

I have a couple java servlets and WebObjects applications that fetch data from MySQL databases. I recently tried running them and received the following error: SQLException raised when connecting : java.sql.SQLException: Server configuration denies access to data source Since the last time

Re: Optimizing query (2nd attempt)

David Wolf wrote: Maybe I'm missing something here--I don't know of a way to create an index on TWO tables at once? Also, when I do: My bad. You cant. Since you are joining on the primary key, you want to add an index like: ALTER TABLE users ADD UNIQUE ( id, username(10)); Since you are

Re: createing database

COLLINEAU Franck FTRD/DMI/TAM writes: I have read the manual. I don't understand because when i type: SELECT VERSION(), CURRENT_DATE; it's OK, the server answer to me!! I have the error message: ERROR 1044: Access denied for user: '@localhost' to database 'menagerie' If you've read

RE: createing database

Try http://www.mysql.com/doc/A/c/Access_denied.html it explains further what needs to be done. M;) I have read the manual. I don't understand because when i type: SELECT VERSION(), CURRENT_DATE; it's OK, the server answer to me!! Fanck -Message d'origine- De : [EMAIL

it shows columns when it should only show tables ( mysql client )

Description: this is how i find the bug. under the mysql console, i tried to drop a table, and i know that the mysql console do the same thing like bash some of the command ... TABTAB and the command autocomplets. OK .. let me show mysql drop table categor; categories

RE: JSP newbie needs to run MySQL-JDBC.

Are you sure MySQL is listening on port 80? The default port is 3306: jdbc:mysql://192.168.1.2:3306/database -Original Message- From: Benj Arriola [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 10:56 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: JSP

RE: Generate random, unique value...

I'm not sure what the problem with this is? The first (unique) column is independent of the second (random) column. If the random column has duplicate values, it just means that the corrosponding first column values will be adjacent in the sorted table. If you're really depending on the

RE: JSP newbie needs to run MySQL-JDBC.

Hello - You may wish to try something a little bit more fundamental if you are new to the Java thing. one good way to learn how everything works in JSP is to use a free Java Server, such as Tomcat, and build pages using Macromedia's ultradev software. There is an extension that installs

Re: Encode function

Luca Vertua [EMAIL PROTECTED] 8volante srl soluzioni_internet Via Cernaia 7 25034 - Orzinuovi - Bs Tel.: 030/9444003 Fax: 02/700430453 www.8volante.com - Original Message - From: [EMAIL PROTECTED] To: Luca Vertua [EMAIL PROTECTED] Sent: Monday, October 29, 2001 6:06 PM Subject: Re:

(errno: 40)

Hello, I've tried to use CREATE INDEX to create a fulltext index on an existing table and received the message: Can't create table './old/#sql-d55_ae7.frm' (errno: 140). I tried dropping the table and recreating it with the fulltext index in the new table description and got this message: Can't

Re: (errno: 40)

On Mon, 29 Oct 2001 11:38:12 -0600, Eric Dean [EMAIL PROTECTED] wrote: Hello, I've tried to use CREATE INDEX to create a fulltext index on an existing table and received the message: Can't create table './old/#sql-d55_ae7.frm' (errno: 140). I tried dropping the table and recreating it with

Problem installing 3.23.43 (@HOSTNAME@ command not found)

Hello: I tried to set-up mysql 3.23.43 on my RedHat 7.1 server, following the binary installation instructions. Here is what I did: lynx ftp://mirror.sit.wisc.edu/mirrors/mysql/Downloads/MySQL-3.23/mysql-3.23.43-p c-linux-gnu-i686.tar.gz tar zxvf mysql-3.23.43-pc-linux-gnu-i686.tar.gz

Mysql query optimiser

Hello, Just wanted to talk about the MySql Query Optimiser. After having performance problems with some queries, I arrived to thoses conclusions: - The order of joins with constants and column have no effect on the speed of the query - MySql make all joins between tables before extracting the

Installation from Source

Hi! Deepanshu == Deepanshu Shukla [EMAIL PROTECTED] writes: Deepanshu Hi!, Deepanshu I tried to install from mysql-3.23.43.tar.gz. Deepanshu i configured using ./configure Deepanshu --prefix=/usr/local/mysql Deepanshu --localstatedir=/usr/local/mysql/data Deepanshu and then make and make

Re: PHP and MySQL 4.0.0

Hi! Sebastian == Sebastian Bergmann [EMAIL PROTECTED] writes: Sebastian Michael Widenius wrote: The symbol 'mysql_module_entry' doesn't come from the MySQL library, so this is a PHP problem. Sebastian Okay. Note that you can use MySQL 4.0 with the old MySQL 3.23 library without any

Re: DATA DIRECTORY bug on Win32

Hi! Mike == Mike Blazer [EMAIL PROTECTED] writes: Mike Miguel Angel SolÕrzano wrote: At 14:24 24/10/2001 +0400, Mike Blazer wrote: Hi Mike, Thanks for the bug report. The explanation why the insert command doesn't works on Win32, is because the link file pointing for the DATA

Problem with MySQL 3.23.37-3.23.43 Binary Distributions...

I have been using MySQL for approximately 6 months now on Solaris 2.6/2.7 and have never had a problem installing from source and compiling, but have never been successful in installing a binary distribution. In particular, after untarring the files using (GNUtar), after changing permissions,

Re: can auto_increment wrap?

Chris Bolt wrote: Only with ISAM tables which reuse deleted auto_increment numbers. MyISAM tables will give you Duplicate entry errors if you hit the maximum. I hadn't realized this and tested it out in MySQL 3.23.43, but in my tests ISAM tables also returned a Duplicate entry error when I

Problem mysql installation

Hi all; i have problem with mysql -3.23.42 installation on my freebsd 4.3-RELEASE, when I execute a make i get an error make: no target to make. Thanks and have a great day! - Before posting, please check:

will someone kindly remove me from this list.

Ive tried mailing: mailto:mysql-unsubscribe-%4B%2E%48%61%75%67%68%74%6F%6E%3D%62%6C%75%65%79%6F [EMAIL PROTECTED] x 8 [EMAIL PROTECTED] x 5 [EMAIL PROTECTED] x 3 the website getting rather FUCKED OFF WITH TRYING. - Before

RE: Anyone worked with the new 4.0 on RH6.2?

Patrick Nelson wrote: - Having problems getting the server started. First mysql_install_db reported that resolveip can't resolve my servers host name (of cowa) bla bla bla but this means I only have to use ip addresses in my grant stuff. Fine but the problem is that mysql_safe

Re: SELECT Query in PHP

Heh, yeah that sounds rookie ;) Have you ever done work in Perl? PHP is a lot like Perl in many aspects (and nothing like it in many others). Heh. Check out http://www.zend.com/ for some other tutorials, if you can find 'em. http://www.phpbuilder.com/ has some gooduns, too. Mike Todd

RE: Problem installing 3.23.43 (@HOSTNAME@ command not found)

I had to replace @HOSTNAME@ with HOSTNAME in the file mysql.server on the line, pid_file=$datadir/HOSTNAME.pid. @HOSTNAME@ wasn't a valid variable. -Original Message- From: Neil Aggarwal [mailto:[EMAIL PROTECTED]] Sent: Monday, October 29, 2001 10:29 AM To: Mysql list Subject:

RE: can auto_increment wrap?

Only with ISAM tables which reuse deleted auto_increment numbers. MyISAM tables will give you Duplicate entry errors if you hit the maximum. I hadn't realized this and tested it out in MySQL 3.23.43, but in my tests ISAM tables also returned a Duplicate entry error when I hit the max. Was

RE: can auto_increment wrap?

Chris Bolt wrote: Only with ISAM tables which reuse deleted auto_increment numbers. MyISAM tables will give you Duplicate entry errors if you hit the maximum. I hadn't realized this and tested it out in MySQL 3.23.43, but in my tests ISAM tables also returned a Duplicate entry error when

RE: Generate random, unique value...

You could also do ORDER BY RAND(), which I just discovered in the DuBois book when looking for the syntax of the RAND() function (which I haven't used before). For a different take on retrieving random records, check out http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_21_0 / Carsten -- Carsten

Newsgroups

The information in this email is great, but the volume of mysql emails mixed in with my other emails is forcing me to unsubscribe! (yes, I could filter, but that still fills up my email client.) Could we have newsgroups instead? That would provide history, conversation threads, etc. We could

busy site w/ high cpu usage on mysql

Hello I have a very busy site (www site) w/ a lot of hits my site is very heavily integrated w/ mysql and when i do top it shows me like over 80% of cpu even though i have dual p3 850mhz w/ 1.5 gig of ram any ideas what to do about it so it'll drop down? thank you in advance

Re: Newsgroups

I agree, the volume of email is too huge and it makes communication on certain topics (like this one for example) cumbersome. Steve - Original Message - From: Matt Sellers [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, October 29, 2001 3:22 PM Subject:

Re: busy site w/ high cpu usage on mysql

alexus wrote: Hello I have a very busy site (www site) w/ a lot of hits my site is very heavily integrated w/ mysql and when i do top it shows me like over 80% of cpu even though i have dual p3 850mhz w/ 1.5 gig of ram any ideas what to do about it so it'll drop down? Have you

Server configuration denies access to data source

I have a couple java servlets and WebObjects applications that fetch data from MySQL databases. I recently tried running them and received the following error: SQLException raised when connecting : java.sql.SQLException: Server configuration denies access to data source From a command line,

Re: Newsgroups

On Mon, Oct 29, 2001 at 01:22:55PM -0700, Matt Sellers wrote: The information in this email is great, but the volume of mysql emails mixed in with my other emails is forcing me to unsubscribe! (yes, I could filter, but that still fills up my email client.) You think this list is busy? Try

Re: 3.23.43 fails merge test ON make test of src.

Hi! R == R Talbot [EMAIL PROTECTED] writes: cut R Below is My bug report... R Mysql 3.23.40 is runjning after the compile but, R after a compile with errors 3.23.42 or .43 won't run the R server starts and fails so I guess we should concentrate on 3.23.40 R gcc version egcs-2.91.66

Re: mysql.sock ???

Riccardi Moreno ([EMAIL PROTECTED]) writes: Hi all, I've installed mysql 3.23.42 on Freebsd system but when i launch mysql i said me can't connect to localhost /tmp/mysql.sock not found. How can i repair this error? First, you can refrain from posting the same question twice. Second, you

Delete performance

Does anyone know how to speed the performance of deletes on a large table? I have a large table w/ approx. 180,000,000 rows, with the following table structure: mysql desc TABLEA; |+--+---+--+-+--+---+| Field | Type

Security

Hello All, I'm fairly new to mySQL but not to SQL or databases in general. I have recently installed mySQL on an NT box without much difficulty. My question is about security. What are the steps to ensure our data and client data is not accessible to the hacker public? I'm not a network

Re: mysql.sock ???

Or you could add path-to-unix-socket= somewhere else than /tmp Sometimes your machine will delete things in the /tmp directory without you knowing. I put it in /var/lib/mysql (linux). Ed Carp wrote: Riccardi Moreno ([EMAIL PROTECTED]) writes: Hi all, I've installed mysql 3.23.42 on

Re: Newsgroups

PMFJI, Do any of the public web archives of the list suit your needs? Have you seen them? It's fine for archived messages but too hard to find new messages, say within the last 7 days. Staying current with MySQL is a lot harder with the mailing list because you have to keep up with the mail

Re: Newsgroups

In the next version of my mysqldeveloper site (which I hope to release here pretty quick) it will support a feature to show you which messages are new and which you've already read. Hope this helps ;-) BD wrote: PMFJI, Do any of the public web archives of the list suit your needs?

configure/documentation error for HPUX 10.20?

Description: I'm running HPUX 10.20 on a 9000/782. I configured according to section 2.6.6.2, HP-UX Version 10.20 Notes (see below). make test warns that setrlimit fails, then fails the join test, presumably because it requires more than 60 files. (Full output below) It appears that

myODBC error list?

Any way of getting a native error,sqlstate,error number list ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread,

Re: Delete performance

On Mon, Oct 29, 2001 at 05:49:57PM -0500, C. Williams wrote: Does anyone know how to speed the performance of deletes on a large table? I have a large table w/ approx. 180,000,000 rows, with the following table structure: [snip] It takes approximately 45 seconds to delete an hour's worth

Re: improve the speed of update, insert, delete and select queries through mySQL

- Original Message - From: Jason Parker To: [EMAIL PROTECTED] Sent: Tuesday, October 30, 2001 9:11 AM Subject: improve the speed of update, insert, delete and select queries through mySQL Anyone, Does anyone know ways to improve the speed of update, insert, delete and select queries

Re: improve the speed of update, insert, delete and select queriesthrough mySQL

indexes. On Tue, 30 Oct 2001, Jason Parker wrote: - Original Message - From: Jason Parker To: [EMAIL PROTECTED] Sent: Tuesday, October 30, 2001 9:11 AM Subject: improve the speed of update, insert, delete and select queries through mySQL Anyone, Does anyone know ways to

BUG: Update Log does not re-open file when filename specified

Description: To make myself clear, I am talking about the binary update log file. When specifing a fixed filename in my.cnf and running the flush-logs command (via mysqladmin) MySQL does not close the file and open the new file when run by a logrotate script. This does work correctly if no log

Please...... mysql error! please reply~ here is South Korea.

I'am not english speak. sorry~ ^^;; [error] # ./bin/safe_mysqld --user=mysql Starting mysqld daemon with databases from /usr/local/mysql/data 011030 09:04:16 mysqld ended #

persistant insert trouble

INSERT INTO duser (username, upass, fname, lname, hphone, haddress, hcity, hstate, hcountry, hemail, utype) VALUES ('$username','$upass'.'$fname','$lname','$hphone','$haddress','$hcity','$hstate','$hcountry','$hemail','$utype') this is an insert statement that works fine in the console, but

RE: Newsgroups

It puts the messages in a tree and makes viewing pertinent threads a breeze, My mail client puts messages in a tree and makes viewing pertinent threads a breeze. And even with the archives: http://marc.theaimsgroup.com/?t=10043869449w=2r=1 Doesn't look hard to me...

Re: Newsgroups

Hi All! Do any of the public web archives of the list suit your needs? Have you seen them? It's fine for archived messages but too hard to find new messages, say within the last 7 days. Staying current with MySQL is a lot harder with the mailing list because you have to keep up with the

3.23.43 build fails on mysqlbinlog under HPUX 10.20

Description: Though not mentioned in the Change log, it appears that mysqlbinlog was moved from sql/ to client/ sometime between 3.23.41 and 3.23.43. As a result, make fails under HPUX 10.20 with /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -DHPUX -I/opt/dce/include -felide-constructors

Re: jdbc connectivity problem

On Saturday 27 October 2001 10:10, shanmukha rao balla wrote: i had set proper classpath for jdbc drivers and my username , password and database name,port no also correct. i am able to connect to mysql server using that username,password at COMMAND line. but while connecting to database

Re: Re: SSL in version 3 and 4

Hi. Okay, my post was rejected because it was automatically suspected to be spam for not explicitly including certain words. obnoxious-jokeSo I am tempted to advertise a useless database engine, competitor to mySQL, with claims that it supports trillions of queries a second and multi-petabyte

Ordering Semi-Numeric ???

Hi All, Ive been searching the archives and the documentation but dont really know the terminology im looking for, or even if its do-able or not so I figure I would just ask here instead.. I have a list of records in a table, and one of the fields is alpha numeric. They look like

BOOLEAN Variable

I am using MySQL 3.23.22-beta pls tell is there any way to define boolean variable in this db what is the BOOL for ? declaring a var BOOL make it TINYINT(1)! but not boolean thanks Shomaai - Before posting, please check:

RE: BOOLEAN Variable

Hi there, My understanding is that there is no BOOL type in MySQL but BOOL is allowed in create table statements (or alter table etc) for compatibility with other databases (but MySQL uses a tinyint for a bool because it doesn't have bool). You can use a tinyint and say that 0 is false 1 is

Re: persistant insert trouble

Michael Stassen I owe you my sanity!!! THANK YOU THANK YOU THANK YOU!!! (my wife is laughing at me for being such a dork) I really appreciate your help thank you very much. From: Michael Stassen [EMAIL PROTECTED] To: Curtis Gordon [EMAIL PROTECTED] Subject: Re: persistant insert trouble Date:

Comparing strings as ints

Hi Everyone, After staring blankly at the mysql manual for a long time, I thought it might be time to ask the list... I have a table setup with a varchar(20) column, I am using this column to store a price, the reason I chose varchar(20) is because the prices I am dealing with are fairly

RE: BOOLEAN Variable

Shomaail [SMTP:[EMAIL PROTECTED]] wrote: I am using MySQL 3.23.22-beta pls tell is there any way to define boolean variable in this db what is the BOOL for ? declaring a var BOOL make it TINYINT(1)! but not boolean thanks Shomaai --- Noel Clarkson [EMAIL PROTECTED] wrote: You

Re: Problem installing 3.23.43 (@HOSTNAME@ command not found)

We have the same problem with MySQL (3.23.36) for SCO OpenServer, in script mysql.server. Here is the problem code, showing my workaround. ... if test -z $pid_file then # pid_file=$datadir/`@HOSTNAME@`.pid pid_file=$datadir/`hostname`.pid # changed @HOSTNAME@ to hostname else case

Re: Ordering Semi-Numeric ???

Is there a better answer than making sure the mixed keys have enough leading zeros in the numeric sub-field to suppress the string comparison effect? ergo (if you know you will never have ten thousand records): XY-0001-BLAH XY-0002-BLAH XY-0003-BLAH XY-0004-BLAH XY-0005-BLAH XY-0006-BLAH

Re: SecureCRT

On Mon, Oct 29, 2001 at 09:23:46AM -0500, [EMAIL PROTECTED] wrote: I am using SecureCRT to login to a remove MySQL server. I can get pass the initial login. However, a login screen displays on the screen asking for a second password. I have entered all information correctly, but the

Database Transfer

Hi all i have a mysql database running on linux machine..i would like to have the complete database to be transfered with all its properties and settings into another linux machine.. how can i do that.. can anyone help me... thanks in advance Sai D Burra

Re: SecureCRT

On Mon, Oct 29, 2001 at 08:24:48AM -1000, Luis wrote: Why dont you use ssh to login to you sever . SecureCRT is an SSH implementation for Windows. [ It is useful for accessing SQL DATABASEs like MYSQL ] -- Michael T. Babcock http://www.fibrespeed.net/~mbabcock/

  1   2   >