Re: Newbie--Easy data loading question

2002-05-27 Thread Gerald Clark
Because mysql needs 'rx' permissions to read and search the directory. 755 should have been sufficient. Menard, Inc. Information Systems wrote: I figured it out but I'm a bit confused as to why it happened. I'm running the load as user1. The file resides at /home/user1/data/filename

Re: Read Only on User table

2002-05-27 Thread Egor Egorov
Richard, Friday, May 24, 2002, 5:04:49 PM, you wrote: RD I'm rather new to MySQL and trying to figure out GRANT and REVOKE so a RD password is required for access. RD Both GRANT and REVOKE give errors saying Table 'User' is read only. A text RD search in the manual for read only did not yield

Re: Read Only on User table

2002-05-27 Thread Van
Rick: I believe this is a faq, but check permissions. bash-2.05$ ls -lrtd /mysql/ drwxr-x--- 42 mysqlmysql4096 May 1 11:34 /mysql/ [root@winslow RPMS]# ls -lrt /var/lib/mysql/ total 12 drwx--2 mysqlmysql4096 May 24 22:01 test -rw-rw1 mysqlmysql

Re: File created by mysqldump cannot be read into MySQL

2002-05-27 Thread Gerald Clark
Don't use 'more'. It adds characters to the output. Instead: mysql --host=host --user=user --password=pwd error_repeat.sql Elliot Smith wrote: Description: I used mysqldump to create an SQL file containing a dump of all databases on the server, including all tables and data (using

foreign key and check ICs: implementation suggestion

2002-05-27 Thread Neil Zanella
Hello, The documentation often mentions that foreign key support in mysql is not implemented because it slows down the database server. The argument is that since the applications built on top of mysql have to check for database integrity constraints (ICs) it is redundant for the database to

Re: Help with REPLACE INTO statement syntax

2002-05-27 Thread Andrew Lietzow
At 21:27 -0500 5/23/02, Andrew Lietzow wrote: Dear MySQL wizards, I have two tables, call them a and b. The database structure is identical. I want the records in b to overwrite the records in (REPLACE INTO) a. This is the statement that does NOT work. REPLACE INTO a SELECT b.* FROM b

Re: Servers Tables

2002-05-27 Thread Andrew Lietzow
Dear Curtis, RE: How do I log in and see the table layout and data? How do I create a connection to access the tables and data from my ASPs? The first question is a popular one, asked and answered multiple times in the FAQ's. I would also recommend that you look into a GUI front end, like

Re: Newbie--Easy data loading question

2002-05-27 Thread Andrew Lietzow
Dear Jake and MySQL listers, RE: I had to change permissions on user1 to 777 in order for it to work. If I'm logged in as that user, why would I have to do that??? I can't say for certian, though I would imagine that the mysqld actually does the processing on this type of a table load, i.e.

Re: Installing / Running

2002-05-27 Thread Erik Perrohe \(Computer Consultant\)
I had a weird problem similar to this on an older version of Red Hat. Debuging init.d etc...I found that the socket was being created in one location and mysql was trying to use it in a different locationThe process of launching is kinda complicated, so rather then spend a whole

bug in dynamic linker?

2002-05-27 Thread Neil Zanella
Hello, I have a script with INSERT statements. I run it quite often and today for the first time I got the following message while inserting from the mysql client: BUG IN DYNAMIC LINKER ld.so: rtld.c: 621: dl_main: Assertion `_dl_rtld_map.l_libname' failed! I simply reran the script and it

Greek characters support

2002-05-27 Thread Dennis Bekatoros
Hi! First of all I would like to congratulate you for MySQL, which I, among many users, have found a both useful and powerfull tool. My name is Dennis Bekatoros. I am a pretty new user of MySQL but having some experience with other SQL platforms I managed to get used to MySQL environment in

Cannot find header files

2002-05-27 Thread Jacob Friis Larsen
When I try to install Php like this: ./configure --with-mysql=/usr/local/lib/mysql I get: configure: error: Cannot find header files under /usr/local/lib/mysql I have installed: http://www.mysql.com/Downloads/MySQL-4.0/MySQL-4.0.1-2.i386.rpm

A Proprietary MySQL Business Model

2002-05-27 Thread Solomon John HART
How much third party software is incorporated into the non-GPL version of MySQL. Obviously the included software can't itself be under the GPL. How does MySQL get around this? Does MySQL have contracts with contributors instead of contributions being under the GPL? It seems like an interesting

Connection Problem

2002-05-27 Thread Will K.
Greets Folks, I am trying to get an online database set up and running, but I keep getting error messages at login. Here are two sample scripts I have been running (both are from Paul DuBois' book MySQL and Perl for the Web). ## SCRIPT 1 ## #! /usr/bin/perl -w # intro4.pl - generate

Is the Mysql list down?

2002-05-27 Thread Chuck \PUP\ Payne
I am just checking to see if the mysql server is down I haven't gotten any e-mails today? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

Re: php+apache+mysql installation. Help

2002-05-27 Thread Andy Cheng
Do I need to uninstall the old Apache before installing the newer version? How do I uninstall the old Apache in linux? Do I just use the package manager to remove the package? What does make do? I don't know how linux work. Please advise. Thanks. From: Andrew Lietzow [EMAIL PROTECTED]

Re: query

2002-05-27 Thread Myk Melez
saraswathy saras wrote: is there any other specific command instead order by ID DESC to select all the record from table where the ID is the last ID.The ID is autoincrement. Not sure from your message if you already know this, but ORDER BY ID DESC LIMIT 1 gives you what you want. -myk

Bug fix for MySQL v3.23.49

2002-05-27 Thread Bluett, Mike
Hi, We have identified a rather serious bug in libmysqlclient of v3.23.49. The client we are using is RIPE 3.1.0 (an Internet Routing Registry server) proivded by RIPE. This latest version uses threaded libraries. Upon starting this server it would very shortly thereafter crash. This occured

MySQL / Firewall

2002-05-27 Thread Daniel Kasak
Hi all. I've just been forced to install a hardware firewall by our parent company. We now have our MySQL server in a DMZ zone, and I am having trouble opening up access to it. The firewall doesn't have an entry for the MySQL service, so I create a user-defined service and fill in the following

Re: Locking TABLES for myisamchk, please help!!

2002-05-27 Thread Stephen Brownlow
I understand all of the reasons given by Alexander. Yet I think that in 99% of cases, it would be best for myisamchk to do as Mark suggest, and not run when a MySQL server is active. Safety would be the default. There could be a special option (--no-safety) for myisamchk to override that check.

Re: [7241] Indexes on columns that are declared differently?

2002-05-27 Thread Stephen Brownlow
I am hoping that a MySQL person will give a definite answer to my question. Thanks, Stephen - Original Message - From: Dan Nelson [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, May 20, 2002 3:18 PM Subject: Re: [7241] Indexes on columns that are declared

MySQL corrupted abruptly.

2002-05-27 Thread
Yesterday my server died abruptly. I can't even guess the reason. Fortunately there remain error messages, following are the messages mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt,

INSERT IF NOT EXISTS?

2002-05-27 Thread Markus Lervik
(filter fodder: sql, query) Hello group! Quick question: Is there a simple way to do something like INSERT IF NOT EXISTS, other than first doing a SELECT and checking if it returns any rows? If not, that would be pretty high up on my whish-list : ) Cheers, Markus -- Markus Lervik

Is the list server down?

2002-05-27 Thread Jeremy P. McKay
I haven't seen a mysql question since friday? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL

Thread leak in libmysqld for win32

2002-05-27 Thread Frans E. van Dorsselaer
The embedded server of 4.0.1 for win32 leaks one thread (the server thread to be exact) per mysql_server_init / mysql_server_end pair. I've experimented with mysql_shutdown and mysql_thread_end as well, but they do not resolve the issue. Eventually (after 10 times or so starting/ending the

ODBC Questions

2002-05-27 Thread Jule
Hey guys, I have some questions concerning ODBC, I'm doing a job on a server which requires me to access a MS Access DB and write a front end for it, so employees of the company can run query's. I just have some questions. I'm using mysql w/ odbc drivers and php. Does teh server (NT 4) need to

What files are these?

2002-05-27 Thread Batara Kesuma
I have some very big files in my /var/lib/mysql. [root@nias mysql]# ls -l nias-bin* -rw-rw1 mysqlmysql1073741921 5$B7n(B 8 04:33 nias-bin.001 -rw-rw1 mysqlmysql875448838 5$B7n(B 9 18:31 nias-bin.002 -rw-rw1 mysqlmysql 86 5$B7n(B 9

What happened??

2002-05-27 Thread Mark
What happened to this MySQL list?? For the last two days all I got was a Connecyion deferred, and I have not received mail from it for the last two days either. - Mark - Before posting, please check:

Re: multi-table delete bug

2002-05-27 Thread Jocelyn Fournier
- Original Message - From: Jocelyn Fournier [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, May 25, 2002 3:35 PM Subject: Re: multi-table delete bug Hi, Yes, you're right, but to see the problem, you have to restart mysql between

Grant Tables Creation

2002-05-27 Thread Michael Widenius
Hi! Glenn == Glenn Hancock [EMAIL PROTECTED] writes: Glenn I also have had trouble with the script that creates my user access tables. Glenn I am assuming those tables should get created in the ./var/mysql folder. Glenn Its my fault but I removed those tables just to see if they had anything

Re: Re: MySQL 3.23.44 not using indexes

2002-05-27 Thread Michael Widenius
Hi! Luciano == Luciano Barcaro [EMAIL PROTECTED] writes: Luciano Hi Monty, Luciano Michael Widenius wrote: Hi! Jeremy Is that supposed to happen in 4.0.x? I don't recall having seen a Jeremy commit that affected the key cache yet. Sanja has been trying to do improvements to the key

replication error

2002-05-27 Thread Kannan R
Placed At : Hi.. I'm facing another problem with replication..I have jus one table with over 4 million records in it. I run mysql-3.23.49 on both my master and slave.following is the problem am facing.. I had taken a consistent dump from the

How to retrieve the lastest update or insert record?

2002-05-27 Thread Jack
Dear all I had a table which containing (date/time) field, now i want to retrieve 5 most latest update / insert record from that table, what query should i use? Thx a lot! Jack [EMAIL PROTECTED] - Before posting, please

Re: multi-table delete bug

2002-05-27 Thread Sinisa Milivojevic
Hi! Thank you for your test case. However, with latest 4.0.2 code I am getting correct results with it. Difference in number of rows in select and delete are stemming from the fact that select reports number of rows in result set, while delete reports total number of rows deleted. These are

Problem starting server

2002-05-27 Thread Matt Hargraves
I keep getting the following error: error: 'Can't connect to MySQL server through the socket '/var/lib/mysql/mysql.sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! This wouldn't be a problem, but mysql.sock does exist and when I try to run

Indexing Question

2002-05-27 Thread Ben Holness
Hi all, I have developed a system that lets people send messages to each other, with a MySQL database and PHP. Among the tables that exist, one is called Users and contains information such as Username, password (md5'd of course), email address etc. This table has a primary key UserID that is

Re: building tree view in mysql?

2002-05-27 Thread hassan
HI, For trees you need self joins. Could You please explain that ? Regards, At 19:11 23/05/02, Georg Richter wrote: On Thursday, 23. May 2002 16:16, Sagi Bashari wrote: Hi, snip How can I get MySQL to sort it like that? I tried to use group/order by, but I cannot get it to

InnoDB and temp. tables

2002-05-27 Thread Bill Easton
I note by experiment (by observing the content of the binary log) that I get the following actions when trying to use a temporary table during a transaction: -- on creating a temporary table, the create (only) is committed -- on dropping a temporary table, the current transaction is committed

Re: Connection Problem

2002-05-27 Thread Mike(mickalo)Blezien
Will, In your $dbh connection handler, you need to change the host=localhost and database= to just localhost and the database name. $dbh = DBI-connect (DBI:mysql:localhost;database_name, **, ***, {PrintError = 0, RaiseError = 1}); On Fri, 24 May 2002 16:43:50

replication error

2002-05-27 Thread Kannan R
Placed At : Hi.. I'm facing another problem with replication..I have jus one table with over 4 million records in it. I run mysql-3.23.49 on both my master and slave.following is the problem am facing.. I had taken a consistent dump from the

RE: Newbie--Easy data loading question

2002-05-27 Thread Slawomir Duda
-Original Message- From: Menard, Inc. Information Systems Sent: Friday, May 24, 2002 3:44 PM I figured it out but I'm a bit confused as to why it happened. I'm running the load as user1. The file resides at /home/user1/data/filename Permissions: filename 666 data 777 user1 700

2 way replication ?

2002-05-27 Thread Bjarne Jørgensen
Hi! I've watched the development of replication on mysql with great joy. However I haven't been able to understand when og if mysql is going to support 2 way replication. In other words. Will it be possible to have 2 databases on 2 different locations, that synchronize with each other in a way,

2 way replication

2002-05-27 Thread Bjarne Jørgensen
Hi! I've watched the development of replication on mysql with great joy. However I haven't been able to understand when og if mysql is going to support 2 way replication. In other words. Will it be possible to have 2 databases on 2 different locations, that synchronize with each other in a way,

Re: INSERT IF NOT EXISTS?

2002-05-27 Thread João Paulo Vasconcellos
On Monday 27 May 2002 10:59, Markus Lervik wrote: (filter fodder: sql, query) Hello group! Quick question: Is there a simple way to do something like INSERT IF NOT EXISTS, other than first doing a SELECT and checking if it returns any rows? If not, that would be pretty high up on my

RE: ODBC Questions

2002-05-27 Thread Tim Ward
It gave me an error saying error in SQL syntaz at CREATE TABLE.. I think that's because your query does not look to me like valid MS Access SQL syntax. is the SQL sytnax exactly the same as 'normal' SQL syntax? Both Access and MySQL implement quite a lot of standard SQL syntax (if that's

BLOB field and ADO

2002-05-27 Thread Bruno Batarelo
Greetings! Has anyone ever had the following problem with ADO ODBC connection: I create a table with a BLOB field. From MySQL shell I update that field using insert into statement and all works perfectly. But when I try to execute that query from VB usnig ADO and ODBC connection (MyODBC 2.50 or

Re: How to retrieve the lastest update or insert record?

2002-05-27 Thread Peter Fleming
Hi Jack select * from TableName order by DateTimeField DESC limit 5 Should do it. Peter At 05:04 PM 5/27/2002 +0800, Jack wrote: Dear all I had a table which containing (date/time) field, now i want to retrieve 5 most latest update / insert record from that table, what query should i use?

RE: Indexing Question

2002-05-27 Thread Svensson, B.A.T. (HKG)
Since I been working implementing some triggers in my system recently this suggestion first came into my mind: create a delete trigger for the user table. Every time a user it deleted, the trigger fires and could for example moves this information to a history table, with date of deletion, etc.

RE: Indexing Question

2002-05-27 Thread Andrew Hazen
Why not have the application check for existing usernames, if one exists,present the info the admin user and ask if this is the user they are trying to create, if yes, then change the active flag, if not, tell them they need to choose a different username. That way your auditing and your unique

synopsis of the problem (one line)

2002-05-27 Thread root
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release:

Re: Newbie question: Which is better InnoDB or BDB?

2002-05-27 Thread Benjamin Pflugmann
Hello. On Thu, May 23, 2002 at 11:53:49AM -0400, [EMAIL PROTECTED] wrote: Hello, I'm new to MySql. I plan to switch my Java/JDBC web application to use MySql. The application requires transactions so, as I understand it, I need the table types to be BDB or InnoDB. Can anyone offer comments

RE: How to retrieve the lastest update or insert record?

2002-05-27 Thread Takenori Satoh
Dear Jack, If (date/time) field means the last time updated or inserted, how about this; select * from [the table] order by (date/time) desc limit 1, 5; -Original Message- From: Jack [mailto:[EMAIL PROTECTED]] Sent: Monday, May 27, 2002 6:05 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]

Visualizing the shema of the db

2002-05-27 Thread andy
Hi there, I am wondering if there is a software (free or shareware) which is visualizing the shema (table strukture) of the mysql database. thanx for any hint, Andy query - Before posting, please check:

Re: Replication problem

2002-05-27 Thread Benjamin Pflugmann
Hi. As I have seen no answer yet, just a wild guess: Maybe you have some query which used both databases, something like INSERT INTO fdf.whatever SELECT FROM access.pagespromo ... You can always use the binlog utilities and have a look at the query which caused the failure. Regards,

Any Luck Running Threaded Client on Win95 and/or WinNT

2002-05-27 Thread John Shackelford
Hi, I am running MySQL 3.23.44 and MyODBC 2.50.39. I am developing a client application that submits queries to MySQL. The queries are threaded. The Win2000 version runs great, but I have problems running on Win95 and WinNT. I was curious to see if anyone has created a threaded client on those

RE: MySQL / Firewall

2002-05-27 Thread Basil Hussain
Hi, The firewall doesn't have an entry for the MySQL service, so I create a user-defined service and fill in the following details: SourcePort Low: 3306 SourcePort High: 3306 DestPort Low: 3306 DestPort High: 3306 Transport: TCP (choices are TCP-6, UDP-17, and Other) Your problem here

Re: Indexing words

2002-05-27 Thread Benjamin Pflugmann
Hi. If FULLTEXT indexes are out of question, what your suggestion is the way to go. Although I would usually use an additional table: CREATE TABLE places ( idp INT(8) NOT NULL, place CHAR(32), /* Ex: New York */ PRIMARY KEY(idp) ); CREATE TABLE tokens (

Re: Servers Tables

2002-05-27 Thread Benjamin Pflugmann
Hi. Sounds as if you should start with reading the manual or a good tutorial (some are listed in the manual): http://www.mysql.com/documentation/index.html Regards, Benjamin. On Fri, May 24, 2002 at 09:34:28AM -0400, [EMAIL PROTECTED] wrote: I just got ViewPoint, which generates

Re: What files are these?

2002-05-27 Thread Victoria Reznichenko
Batara, Sunday, May 26, 2002, 11:11:25 AM, you wrote: BK I have some very big files in my /var/lib/mysql. BK [root@nias mysql]# ls -l nias-bin* BK -rw-rw1 mysqlmysql1073741921 5$B7n(B 8 04:33 nias-bin.001 BK -rw-rw1 mysqlmysql875448838 5$B7n(B 9 18:31

Re: INSERT IF NOT EXISTS?

2002-05-27 Thread Victoria Reznichenko
Markus, Monday, May 27, 2002, 4:59:30 PM, you wrote: ML Is there a simple way to do something like INSERT IF NOT EXISTS, ML other than first doing a SELECT and checking if it returns any rows? ML If not, that would be pretty high up on my whish-list : ) You can use IGNORE keyword in INSERT

Re: Problem starting server

2002-05-27 Thread Egor Egorov
Matt, Monday, May 27, 2002, 9:20:32 AM, you wrote: MH I keep getting the following error: MH error: 'Can't connect to MySQL server through the socket MH '/var/lib/mysql/mysql.sock' (111)' MH Check that mysqld is running and that the socket: MH '/var/lib/mysql/mysql.sock' exists! MH This

Re: bug in dynamic linker?

2002-05-27 Thread Egor Egorov
Neil, Friday, May 24, 2002, 8:14:08 PM, you wrote: NZ I have a script with INSERT statements. I run it quite often and NZ today for the first time I got the following message while inserting NZ from the mysql client: NZ BUG IN DYNAMIC LINKER ld.so: rtld.c: 621: dl_main: Assertion NZ

Re: Read Only on User table

2002-05-27 Thread Benjamin Pflugmann
Hi. AFAIK, a table is considered read only, if either the underlying filesystem says so (what you called OS attribute) or it is a compressed table. If it would be a problem with the privileges, you would rather get an error like Access denied for ... to So your problem is quite probably

Re: What files are these?

2002-05-27 Thread Harrison C Fisk
These are binary update log files. They keep track of all updates to your database. They are often used when restoring from a backup and also are required for replication. You can doa FLUSH LOGS and then move away the old logs or delete them if that is what you want to do. Be sure to always

The silence...

2002-05-27 Thread João Paulo Vasconcellos
Wow, what happened today ? Never saw that list so quiet. SQL. -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [EMAIL PROTECTED] - Before posting, please check:

Replication out of sync

2002-05-27 Thread Luc Foisy
My replication became out of sync. (Which in turn seems to rewrite my master.info with some garbage) In this particular instance, the LOG_FILE name had a bunch of spaces appended to it, and the PORT got changed to 0. The slave was running, but not going anywhere of course. Usually I can just

Re: multi-table delete bug

2002-05-27 Thread Sinisa Milivojevic
Hi! I still can not reproduce your case. I first ran this script: create database xx; use xx; CREATE TABLE `t1` ( `titre` char(80) NOT NULL default '', `numeropost` mediumint(8) unsigned NOT NULL auto_increment, `ouvert` tinyint(1) unsigned NOT NULL default '1', `date` datetime

Re: Visualizing the shema of the db

2002-05-27 Thread Yegor N. Bryukhov
Hello andy, http://www.datanamic.com/ a Hi there, a I am wondering if there is a software (free or shareware) which is a visualizing the shema (table strukture) of the mysql database. a thanx for any hint, a Andy a query a

Re: BLOB field and ADO

2002-05-27 Thread Philippe PETIT
view this article, it's work fine with vb6 : http://support.microsoft.com/default.aspx?scid=kb;EN-US;q194975 ' insert Dim ts As String, Sql As String Dim RS Set RS = CreateObject(ADODB.Recordset) RS.CursorLocation = adUseServer RS.Open tbl_test, CreateConnexionString(CnxSGDB), 3,

Re: A Proprietary MySQL Business Model

2002-05-27 Thread Tonu Samuel
On Mon, 27 May 2002, Solomon John HART wrote: How much third party software is incorporated into the non-GPL version of MySQL. Obviously the included software can't itself be under the GPL. How does MySQL get around this? Does MySQL have contracts with contributors instead of contributions

Approximate(?) numeric data types WAS: Indexing words

2002-05-27 Thread Svensson, B.A.T. (HKG)
CREATE TABLE places ( idp INT(8) NOT NULL, Contex: SQL, database Just curious, but is this a 8-bit (smalint maybe?) or approximate 8-byte integer? - Before posting, please check: http://www.mysql.com/manual.php

RE: query

2002-05-27 Thread Ki Mien
did you try MAX(ID)? cheers, Ki Mien -Original Message- From: Myk Melez [EMAIL PROTECTED] Sent: Saturday, May 25, 2002 1:41 AM To: saraswathy saras [EMAIL PROTECTED], mysql [EMAIL PROTECTED] Subject:Re: query saraswathy saras wrote: is there any other specific command

Re: INSERT IF NOT EXISTS?

2002-05-27 Thread Rob
And one of the built-ins work on totally general cases: they restrict you to duplication of unique keys. If you want a general insert-if-not-condition format, you can do your full insert into a temporary table, left join that table against the real table on your general condition and selecting

triggers and stored procudures

2002-05-27 Thread Ki Mien
Hi all, I would like to find out if anyone here has any experience writing stored prods and triggers in mySQL. Hopefully someone can tell me which version of mySQL is more stable if I want to write stored prods and triggers. cheers, Ki Mien

Fw: Problem starting server

2002-05-27 Thread Matt Hargraves
I keep getting the following error: error: 'Can't connect to MySQL server through the socket '/var/lib/mysql/mysql.sock' (111) 'Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! This wouldn't be a problem, but mysql.sock does exist and when I try to run

Re: Visualizing the shema of the db

2002-05-27 Thread Egor Egorov
andy, Monday, May 27, 2002, 4:48:24 PM, you wrote: a I am wondering if there is a software (free or shareware) which is a visualizing the shema (table strukture) of the mysql database. What about MyCC? http://www.mysql.com/downloads/gui-mycc.html a thanx for any hint, a Andy a query

Re: triggers and stored procudures

2002-05-27 Thread Victoria Reznichenko
Ki, Monday, May 27, 2002, 6:41:02 PM, you wrote: KM I would like to find out if anyone here has any experience writing stored prods and triggers in mySQL. KM Hopefully someone can tell me which version of mySQL is more stable if I want to write stored prods and triggers. Stored procedures

binary update log: configure by database, not daemon?

2002-05-27 Thread jim hopp
Greetings, We plan to use the binary update log plus backups to enable us to restore databases and then re-apply updates when necessary. It appears to me that the binary update log contains updates to all databases on the mysqld-max process, and that there is no way to keep a separate

Re: Indexing words

2002-05-27 Thread olinux
Is this approach still of use if many more tables are added? so basically you create a lot of 'relations' tables to store key relations rather than store the relation in each table? olinux --- Benjamin Pflugmann [EMAIL PROTECTED] wrote: Hi. If FULLTEXT indexes are out of question, what

Re: Fw: Problem starting server

2002-05-27 Thread Phil Dobbin
On 27/5/02 at 12:47, [EMAIL PROTECTED] (Matt Hargraves) wrote: I keep getting the following error: error: 'Can't connect to MySQL server through the socket '/var/lib/mysql/mysql.sock' (111) 'Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! Try the

Re: building tree view in mysql?

2002-05-27 Thread olinux
create a table like this: id | parent_id | category parent_id points to the parent categories id. Top level categories get parent_id of '0' ex: 1 | 0 | auto 2 | 1 | repair 3 | 2 | body 4 | 2 | windshields 5 | 1 | detailing 6 | 2 | tires Tree would look like: auto repair body

Re: building tree view in mysql?

2002-05-27 Thread Sagi Bashari
Yeah, thats exactly what I wanted to do. But how do I make MySQL sort it like that? Show the parent first, and then all its childs, so the application can determite if it's subcategory by checking if the parent is was changed. Sagi From: olinux [EMAIL PROTECTED] create a table like this:

SV: building tree view in mysql?

2002-05-27 Thread Carsten Gehling
Well you'll neew to do some coding in your application language. What are you using to connect to MySQL? Perl? PHP? Java? Tell me, and I'll give you an example where you only query the database once (for optimum performance). - Carsten -Oprindelig meddelelse- Fra: Sagi Bashari

Re: Fw: Problem starting server

2002-05-27 Thread Matt Hargraves
Been there, done that. Didn't change a thing. Guess I should have changed the e-mail before resending it, but I'm not really sure what the problem is. The server won't start for more than a tenth of a second. Here's what happens when I try to start mysqld: [root@server mysql]# safe_mysqld

InnoDB logs

2002-05-27 Thread Balteo
Hello, I have a couple of questions regarding InnoDB logs' structure. -Are the innodb logs stored in the main innodb tablespace? -How is the information stored in the logs? Does it look like SQL queries as the mysql binary update logs do? -What is the difference between the mysql binary logs and

timestamp(8) GROUP BY problem

2002-05-27 Thread sitnikov
); Query OK, 4 rows affected (0.00 sec) Records: 4 Duplicates: 0 Warnings: 0 mysql SELECT * FROM test; ++--+--+ | id | dd | data | ++--+--+ | 1 | 20020527 |1 | | 2 | 20020527 |2 | | 3 | 20020527 |3 | | 4 | 20020527 |4

Re: InnoDB logs

2002-05-27 Thread Sherzod B. Ruzmetov
Guys, i get the following error. What does this mean? DBI-connect(myskycastle) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at teamstats.pl line 16 - Before posting, please

Shared message queue?

2002-05-27 Thread Philip Mak
I have a bunch of processes running on the same machine that should be able to send unicast, multicast and broadcast messages to each other. Messages should be received in the same order that they were sent. I'm trying to figure out how to implement that. These processes are already sharing the

Re: Fw: Problem starting server

2002-05-27 Thread Phil Dobbin
On 27/5/02 at 14:39, [EMAIL PROTECTED] (Matt Hargraves) wrote: Been there, done that. Didn't change a thing. Guess I should have changed the e-mail before resending it, but I'm not really sure what the problem is. The server won't start for more than a tenth of a second. Here's what

Re: Approximate(?) numeric data types WAS: Indexing words

2002-05-27 Thread Benjamin Pflugmann
Hi. On Mon, May 27, 2002 at 05:21:20PM +0200, [EMAIL PROTECTED] wrote: CREATE TABLE places ( idp INT(8) NOT NULL, Contex: SQL, database Just curious, but is this a 8-bit (smalint maybe?) or approximate 8-byte integer? That is an 4 byte integer with an supposed display-width of

Re: The silence...

2002-05-27 Thread Jeremy Zawodny
On Fri, May 24, 2002 at 06:17:09PM -0300, João Paulo Vasconcellos wrote: Wow, what happened today ? Never saw that list so quiet. The machine hosting the lists was unavailable for the past several days. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk:

Re: Indexing words

2002-05-27 Thread Benjamin Pflugmann
Hello. On Mon, May 27, 2002 at 10:31:52AM -0700, [EMAIL PROTECTED] wrote: Is this approach still of use if many more tables are added? As I said (in the not-quoted part) [This] is the standard approach for implementing a M to N relationship. so basically you create a lot of 'relations'

Re: Fw: Problem starting server

2002-05-27 Thread Mark
- Original Message - From: Matt Hargraves [EMAIL PROTECTED] To: Phil Dobbin [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, May 27, 2002 8:39 PM Subject: Re: Fw: Problem starting server Been there, done that. Didn't change a thing. [root@server mysql]# safe_mysqld Starting

MyODBC connection to Linux MySQL

2002-05-27 Thread yvon darang
Hi, I tried to connect to a mysql database running on a linux server using an odbc connection in windows 98. I get the following message: [TCX][MyODBC]Host x.x.x.x is not allowed to connect to this MySQL server (#1130)[Microsoft][ODBC Driver Manager] Connection not open (#0) The username

Re: building tree view in mysql?

2002-05-27 Thread Sagi Bashari
I'm using PHP From: Carsten Gehling [EMAIL PROTECTED] Well you'll neew to do some coding in your application language. What are you using to connect to MySQL? Perl? PHP? Java? Tell me, and I'll give you an example where you only query the database once (for optimum performance). -

Re: Visualizing the shema of the db

2002-05-27 Thread MikeParton
I think most of the data modeling tools (ERwin, SilverRun RDM, for example) will reverse engineer your schema into them. Have not tried the two I specifically mention with MySQL, but they have reverse engineering functionality. HTH Mike - Original Message - From: Yegor N. Bryukhov

Re: Fw: Problem starting server

2002-05-27 Thread Matt Hargraves
OK, that helps a lot. There is no '/usr/local/mysql directory' Any chance that this is different in RedHat? There is very little in the rc.local file and nothing having to do with mysql. Matt - Original Message - From: Phil Dobbin [EMAIL PROTECTED] To: Matt Hargraves [EMAIL

ODBC Connection to Linux MySQL

2002-05-27 Thread yvon darang
Hi, I tried to connect to a mysql database running on a linux server using an odbc connection in windows 98. I get the following message: [TCX][MyODBC]Host x.x.x.x is not allowed to connect to this MySQL server (#1130)[Microsoft][ODBC Driver Manager] Connection not open (#0) The username

Re: InnoDB logs

2002-05-27 Thread Jeremy Zawodny
On Mon, May 27, 2002 at 01:33:30PM -0600, Sherzod B. Ruzmetov wrote: Guys, i get the following error. What does this mean? DBI-connect(myskycastle) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at teamstats.pl line 16 Please *don't* hijack

Re: Is the list server down?

2002-05-27 Thread Jeremy Zawodny
On Sun, May 26, 2002 at 01:35:00PM -0700, Jeremy P. McKay wrote: I haven't seen a mysql question since friday? It was, yes. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 4.0.2: up 3 days,

  1   2   >