Re: Data Directory

2001-06-13 Thread Gabriele Bartolini
Ciao! >I am new to both Linux and MySQL. I used the source to >compile MySQL on Linux 7.0 with the default options. >It's working fine. What's Linux 7.0? :-) >But can i change the data directory where all the >databases are stored to something other than the >default, without having to compile

load-balancing with NFS

2001-06-13 Thread Wouter de Jong
Hello, I have an idea about setting up 1 machine that contains the var-directory (RAID5 for backup, etc). Then I mount the var directory from 2 (to explain now :>) other servers, via NFS, and run mysqld on those. My question : is this going to work ? I mean, will mysqld allow me to have a shar

mysql and php3

2001-06-13 Thread Saisab Pradhan
Hi, Can somebody tell me why I cannot use php3 with mysql? I have just installed mysql (3.23.38) on a linux 6.2 machine. It is working fine. PHP3 was already installed when I installed mysql. Does it have to be the other way round? that is php first and then mysql? I also configured php3.ini

Error logs

2001-06-13 Thread Simon Windsor
Hi Is it possible to remove MySql's error log file without restarting the server. With other db's, ie Oracle, errors are just appended to the end of the log file. Is this the same with MySql, or does MySql permenantly hold the file open ? Thanx Simon -- Simon Windsor CricInfo http://www.cri

Re: Data Directory

2001-06-13 Thread Suvarsha Walters
Thanks a lot, But another problem. I did the changes in my.cnf and restarted mysql. It stops immediately, shows the following: Starting mysqld daemon with databases from /base1 010613 14:22:38 mysqld ended But when I changed the 'datadir' values in the my.cnf back to the default directory, it

Help me please

2001-06-13 Thread Anass El
Hi, I want to insatll Mysql in my station, i have Debian (linux 2.2),i installaed all the package of mysql, and after when i Write command :" mysqladmin -u user create db ", It ansers, " mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through so

RE: re: startup Help

2001-06-13 Thread Jon Haworth
I take it you're running Windows? If so then PATH is an environment variable that allows you to run any command in its directories from anywhere. Example: c:\> path=c:\windows;c:\windows\command c:\> dir *.exe Volume in drive C has no label Volume Serial Number is 07D1-0502 Directory of C

restore a backuped database

2001-06-13 Thread Tom Thurnherr
hello i need to export a database from a linux system to a nt-workstation so i've backuped the database with mysqldump and got this specific file. but what shall i do now with this file ? where do i have to copy it to on the nt-workstation, what are the commands to create the database from

mysql and MyODBC

2001-06-13 Thread Adrian D'Costa
Hi, My setup MySQL version : Ver 8.8 Distrib 3.23.22-beta OS : RH 7.0 I downloaded MyODBC-2.50.37-1.i386.rpm from mysql's site but when I tried to install it, give this error: libmysqlclient.so.10 is needed by MyODBC-2.50.37-1 In /usr/lib/mysql I have the following entries lrwxrwxrwx

Re: startup help

2001-06-13 Thread clay bond
On Tue, 12 Jun 2001, Neil Zanella wrote: > > On Tue, 12 Jun 2001, Martin Scherer wrote: > > > I am told that mysqladmin is not an understood command. > > Looks like you need to update your PATH variable. > Or one of the following: $ /var/lib/mysql/bin/mysqladmin $ cd /var/lib/mysql/bin

Re: mysql and php3

2001-06-13 Thread clay bond
On Wed, 13 Jun 2001, Saisab Pradhan wrote: > > Hi, > > Can somebody tell me why I cannot use php3 with mysql? I have just > installed mysql (3.23.38) on a linux 6.2 machine. It is working fine. > PHP3 was already installed when I installed mysql. Does it have to be the > other way round? t

RE: recursive select

2001-06-13 Thread Don Read
On 13-Jun-01 Alok K. Dhir wrote: > Ah recursion. Nothing like it to get your mind tied up in knots... :) > > Try this - untested, but this is the basic idea, and it or something > like it should work. Call the function with the node you want to start > from and the array you want the results t

table locking and priorities

2001-06-13 Thread anna soobrattee
Hi All, Can anyone help me... My registration form looks up the last username in the members table (select distinct username from members order by uid desc limit 1), and increments this username (e.g. from abc2 abc3) which will be used as the username for the next user to sign up... the

RE: mysql and php3

2001-06-13 Thread Don Read
On 13-Jun-01 Saisab Pradhan wrote: > > Hi, > > Can somebody tell me why I cannot use php3 with mysql? I have just > installed mysql (3.23.38) on a linux 6.2 machine. It is working fine. > PHP3 was already installed when I installed mysql. Does it have to be the > other way round? that is php

Re: table locking and priorities

2001-06-13 Thread anna soobrattee
Hi, The username field is text and number so you I can't autoincrement a username like "abc003434" ... - Original Message - From: "Mohammad Shoja" <[EMAIL PROTECTED]> To: "anna soobrattee" <[EMAIL PROTECTED]> Sent: Wednesday, June 13, 2001 11:57 AM Subject: Re: table locking and priorit

Re: table locking and priorities

2001-06-13 Thread Mohammad Shoja
No, I mean you can use an autoincrement field besides your username field. and use that to constructing user name, In this way you will be sure about uniqness and also you can maintain your user name as a text field although its some sort of redundancy. Regards > Hi, > > The username field is

table corrupt - cant/wont recover! Help!!

2001-06-13 Thread Rob
One of my tables is corrupt and I tried all the usual ways to repair it but to no avail even when I restored the backup.. Tried this.. isamchk --recover --quick user_host isamchk --recover user_host isamchk --safe-recover user_host All that happened is the last 3 records were wiped out! Pre

Re: GRANT annoyance...

2001-06-13 Thread Benjamin Pflugmann
Hello. Only a minor correction: On Tue, Jun 12, 2001 at 09:35:19PM -0230, [EMAIL PROTECTED] wrote: [...] > GRANT ALL ON 'database'.'table' TO 'user'@'host' IDENTIFIED BY 'password' > > - the PRIVILEGES keyword is redundant. > - database can be * for all databases. > - table can be * for all tab

Re: compile problem on solaris , possibly others

2001-06-13 Thread Sinisa Milivojevic
Mark Vann writes: > Well, i just did a pkginfo | grep zlib and this is > what I got, > > application JGzlib zlib > > So it appears to be installed. > Any ideas? > Take a look at the end of config.log. Cut the code at the end and try to build it with a command immediately above. T

Can't create table from another table

2001-06-13 Thread Jonas Arvidsson
Hi Sorry for this question but this is my first shot at this list. I have created a table that contains the following: CREATE TABLE liggare (raknare INT(10) UNSIGNED ZEROFILL DEFAULT '00' NOT NULL, projno INT(5) UNSIGNED ZEROFILL DEFAULT '1' NOT NULL, ritnummer INT(8) UNSIGNED ZE

Re: mysql.sock not created

2001-06-13 Thread Benjamin Pflugmann
Hello. On Tue, Jun 12, 2001 at 08:39:59PM -0700, [EMAIL PROTECTED] wrote: > Thanks for the reply > > Conducting a 'find' does not turn up the mysql.sock file anywhere on my > server. Is there any reason why the installation would not create this > file? That may sound like a stupid question, b

Re:

2001-06-13 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: > >Description: > Unable to compile a binary for mysql-3.23.38. > > >How-To-Repeat: > Downloaded mysql-3.23.38.tar.gz. Used gunzip, then gtar to > uncompress. No errors indicated. > > Used the command from the mysql instruction manual: > CFLAGS="-O3" CXX=gcc CXXFLAGS=

Re: Error logs

2001-06-13 Thread Benjamin Pflugmann
Hi. On Wed, Jun 13, 2001 at 09:35:09AM +0100, [EMAIL PROTECTED] wrote: > > Is it possible to remove MySql's error log file without restarting the server. > > With other db's, ie Oracle, errors are just appended to the end of the log > file. Is this the same with MySql, or does MySql permenantly

Re: Help me please

2001-06-13 Thread Benjamin Pflugmann
Hi. On Wed, Jun 13, 2001 at 11:12:02AM +0200, [EMAIL PROTECTED] wrote: [...] > Hi, I want to insatll Mysql in my station, i have > Debian (linux 2.2),i installaed all the package of > mysql, and after when i Write command :" mysqladmin -u > user create db ", It ansers, > " mysqladmin: connect to

Re: What's the easiest way to export MySQL table structure and data AUTOMATICALLY using MySQL++?

2001-06-13 Thread Sinisa Milivojevic
David Ayliffe writes: > As subject; I'm using the MySQL C++ API's and compiling under MS VC++ 6? > > I want to accept a table name at runtime, and then export both the data > and data structure to a file which is compatible with MS Access; which > the table will eventually be imported into. > >

New DBTools version (1.0.9) Available

2001-06-13 Thread Crercio Osmaildo da Silva
I'm glad to let you all know that there is a new version of DBTools available. Go to our website http://dbtools.vila.bol.com.br to download it. What´s new: - Fixed bug when Importing from MSSQL Server using ODBC in tables that has IDENTITY (autoincrement) property - Added XML support to Dump

Re: restore a backuped database

2001-06-13 Thread Benjamin Pflugmann
Hi. On Wed, Jun 13, 2001 at 11:17:55AM +0200, [EMAIL PROTECTED] wrote: > hello > > i need to export a database from a linux system to a nt-workstation > > so i've backuped the database with mysqldump and got this specific file. > > but what shall i do now with this file ? > > where do i h

Password not accepted

2001-06-13 Thread scherj
I have the problem, that since a few weeks ago my mysql-server does not let me in anymore as root or admin. the connect via scripts on the internet(asp) works fine but i can't administer it anymore. so, what can i do that i can login again. i also tried to start the daemon with the option --skip

Re: Can't create table from another table

2001-06-13 Thread Benjamin Pflugmann
Hi. On Wed, Jun 13, 2001 at 01:47:53PM +0200, [EMAIL PROTECTED] wrote: > Hi > > Sorry for this question but this is my first shot at this list. > > I have created a table that contains the following: > CREATE TABLE liggare (raknare INT(10) UNSIGNED ZEROFILL DEFAULT '00' NOT >NULL, > >

CPU usage (was) Multiple CPU's in Freebsd

2001-06-13 Thread Ken Menzel
Hi Drew, Ok, your question may be a bit more complicated. When your CPU load goes up to 90% are there many processes running? What version on FreeBSD are you on (4.3 which is pretty good?)? Becuase there were bugs in threads on the 4.2 FBSD release. There was a MySQL change relating to the

Re: Data Directory

2001-06-13 Thread Gabriele Bartolini
At 14.38 13/06/01 +0530, Suvarsha Walters wrote: >Thanks a lot, > >But another problem. I did the changes in my.cnf and restarted mysql. It >stops immediately, shows the following: > >Starting mysqld daemon with databases from /base1 >010613 14:22:38 mysqld ended > >But when I changed the 'datadi

Getting MySQL-3.23.35/up working on my box.

2001-06-13 Thread SDiZ Cheng
Hi all, I am a new subscriber of this list. I have a question that have confuse me for a long time. I am currently running MySQL-3.23.32 on Debian(woody) with kernel 2.4.x on a i386 box /w 1G Ram.. We are currently runing two different kind of database on the same server. One of them is a few ta

Re: table corrupt - cant/wont recover! Help!!

2001-06-13 Thread Gerald Clark
I sounds like the data or index file may be getting larger than the maximum file size allowed by the operating/filesystem. What operating system and kernel version are you using, and what file system? How big are these files? Rob wrote: > One of my tables is corrupt and I tried all the usual

special select

2001-06-13 Thread franky

Re: mysql and MyODBC

2001-06-13 Thread Benjamin Pflugmann
Hi. Sounds as if you have to install a newer MySQL package. Use rpm -qf /usr/lib/mysql/libmysqlclient.so.9.0.0 to find out, which package contains the lib (for me, it is MySQL-shared-3.23.36-2mdk, which contains libmysqlclient.so.10.0.0) and install a more recent version (take it, for example,

New InnoDB release in MySQL/InnoDB-3.23.39

2001-06-13 Thread Heikki Tuuri
Hi! MySQL/InnoDB-3.23.39 binaries and source now available for Unix at http://www.mysql.com. Windows binaries will be released in a few days. InnoDB is a database backend which brings high-performance transactions and row level locking to MySQL. Main changes in InnoDB: * CHECK TABLE now works

GRANT ANNOYANCE REVISITED

2001-06-13 Thread David Simcik
Thank you all for your original suggestions, but I'm still having problems. I copied this verbatim from the MySQL docs and tried it on two seperate servers: mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%" ->IDENTIFIED BY 'some_pass' WITH GRANT OPTION; ERROR 1047: Unknown command

howto insert a variable in a query in C?

2001-06-13 Thread Kenneth Johansen
hi all, im currently using a C program to access my mysql database. but i have a small question. How do i insert a variable into a query? imagine: *query="select blah,blah from table_name where name = variable"; im a bit in the dark on this one and would appriciate any/all suggestions. regards k

Error locating host.frm

2001-06-13 Thread Furmaniuk, Michael
I've installed the Solaris 2.7 binary and am trying to connect to the database after doing the setup, when I attempt to start the database I get a message that mysql ended and there is no process started. I use the following (all things should be run with sudo on our server) - > sudo ./bin/sa

Re: how to install mysql replication ?

2001-06-13 Thread Whit Blauvelt
On Tue, Jun 12, 2001 at 08:23:02PM -0400, William M. Quarles wrote: > Make sure you have also read chapter 4.16, most importantly 4.16.5. it has > some important information in it, too. Those chapters have nothing directly regarding replication. If you're to the point of worrying about replicat

Problem adding new charset

2001-06-13 Thread Ivan Lulukyan
Hi, I am trying to add new charset in my preinstalled mysql-3.23.26-beta. Manual says: Add the character set name to the CHARSETS_AVAILABLE and COMPILED_CHARSETS lists in configure.in. But I CAN NOT find COMPILED_CHARSETS list there. Please help me. Regards, Ivan Lulukyan

Re:

2001-06-13 Thread Whit Blauvelt
Even if you have the zlib library, you may have to add the flag for it manually - it's not properly found by the configure routine as of 3.23.37, at least on Debian Linux 2.2. On Wed, Jun 13, 2001 at 03:11:42PM +0300, Sinisa Milivojevic wrote: > [EMAIL PROTECTED] writes: > > >Description: > > Una

Re: Getting MySQL-3.23.35/up working on my box.

2001-06-13 Thread SDiZ Cheng
I cannot find the core file.. where is it? BTW, system seems somtimes run out of file handles / max processes. There is some more information to provide: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readab

Re: mysql and php3

2001-06-13 Thread Whit Blauvelt
If PHP is compiled with its own MySQL support (as compared to using the MySQL shared libraries - which are not in every MySQL distribution) it expects mysql.sock to be in /tmp - whereas recent versions of MySQL put it in /var/lib/mysql/. PHP will find it if you add "mysql.default_socket = /var/lib

Newbie stumped by table error

2001-06-13 Thread Jeff Caron
Hello- I'm just beginning to teach myself MySQL with the help of Michael Widenius' book "MySQL". I've entered the create table statement exactly as shown in the book (pg. 28 if you have the book) and I get an error message every time. This is very frustrating as I can't go any further with the tu

Re: Always problem

2001-06-13 Thread Benjamin Pflugmann
Hello. On Wed, Jun 13, 2001 at 05:01:21PM +0200, you wrote > hi, > when i do : "find / -name mysqld.sock", it doesn't > find nothing, > i have read the article what u tell me, it wrote, for > running server mysql, u put :"mysql" or > "mysqld.server" i tried the both :when i put > "mysqld.server",

Field length problem 2!

2001-06-13 Thread Simon Abolnar
Hello! I would like to specify my problem once again! I have a field type: VARCHAR(100) NOT NULL When I add new record in database everything works OK! When I want to modify data in a field using ADO with: RS.Fields(0).Value="Value" function everything works OK again when I use the same or les

mysql GUI for windows NT/98 is it available?

2001-06-13 Thread John Kennedy
I am just curious to know whether you have any GUI for mysql for Windows NT/98? If so kindly send me the link where I could download it. I am curios to work on MYSQL. thanks John _ Get your FREE download of MSN Explorer at http://e

RE: howto insert a variable in a query in C?

2001-06-13 Thread Diego Zabaleta
sprintf(query,"select blah,blah from table_name where name = '%s'",variable); -Mensaje original- De: Kenneth Johansen [mailto:[EMAIL PROTECTED]] Enviado el: Miércoles, 13 de Junio de 2001 11:38 a.m. Para: [EMAIL PROTECTED] Asunto: howto insert a variable in a query in C? hi all, im cu

Re: GRANT ANNOYANCE REVISITED

2001-06-13 Thread Paul DuBois
At 10:16 AM -0500 6/13/01, David Simcik wrote: >Thank you all for your original suggestions, but I'm still having problems. >I copied this verbatim from the MySQL docs and tried it on two seperate >servers: > >mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%" > ->IDENTIFIED BY 'some_

Daemon crashing (I'm going nuts here)

2001-06-13 Thread Walker, Brian
I'm at wits end here, I've been through the documentation multiple times, asked questions on this list, but I still cannot get this server running. I've restarted the server and everything. The only thing I know is that the mysqld daemon crashes when I try to start it. I could not have another

Re: how to install mysql replication ?

2001-06-13 Thread quarlewm
However, it is important to know about my.cnf and where to put it, IMHO! Quoting Whit Blauvelt <[EMAIL PROTECTED]>: > On Tue, Jun 12, 2001 at 08:23:02PM -0400, William M. Quarles wrote: > > > Make sure you have also read chapter 4.16, most importantly 4.16.5. > it has > > some important infor

Re: GRANT ANNOYANCE REVISITED

2001-06-13 Thread Benjamin Pflugmann
Hello. On Wed, Jun 13, 2001 at 10:16:36AM -0500, [EMAIL PROTECTED] wrote: > Thank you all for your original suggestions, but I'm still having problems. > I copied this verbatim from the MySQL docs and tried it on two seperate > servers: > > mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%" > -

Re:New InnoDB release in MySQL/InnoDB-3.23.39

2001-06-13 Thread Heikki Tuuri
Hi! I have to correct immediately the release note: the new my.cnf parameter name is innodb_unix_file_flush_method. It should be specified only in special cases if you are not satisfied with disk write performance. Read the InnoDB manual about the risks in specifying this parameter. It is not a

Re:

2001-06-13 Thread Mark Vann
How do you do this? --- Whit Blauvelt <[EMAIL PROTECTED]> wrote: > Even if you have the zlib library, you may have to > add the flag for it > manually - it's not properly found by the configure > routine as of 3.23.37, > at least on Debian Linux 2.2. > > On Wed, Jun 13, 2001 at 03:11:42PM +0300,

Re: howto insert a variable in a query in C?

2001-06-13 Thread Benjamin Pflugmann
Hi. This is not really a MySQL related question, but something about C basics, IMHO. On Wed, Jun 13, 2001 at 04:38:28PM +0200, [EMAIL PROTECTED] wrote: > hi all, im currently using a C program to access my mysql database. > but i have a small question. > How do i insert a variable into a query?

Anyone have stunnel MySQL replication running with _current_ MySQL?

2001-06-13 Thread Whit Blauvelt
For those who think I'm off the wall, here's what's driving me up it: Had MySQL doing replication through stunnel for many months, flawlessly, using MySQL 3.23.27 on master and slave. Now going to MySQL 3.23.37 on master and 3.23.38 on slave, it's broken. MySQL has some inconsistent weirdness ab

RE: Newbie stumped by table error

2001-06-13 Thread massey
Go through http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html This is a good starting point. Look this over and you will see your error ; Use a CREATE TABLE statement to specify the layout of your table: mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), ->

Re: Newbie stumped by table error

2001-06-13 Thread Barry C. Hawkins
on 6/13/01 10:58, Jeff Caron at [EMAIL PROTECTED] wrote: > Hello- > > I'm just beginning to teach myself MySQL with the help of Michael Widenius' > book "MySQL". I've entered the create table statement exactly as shown in > the book (pg. 28 if you have the book) and I get an error message every

MySQL compilation problems, Solaris 8

2001-06-13 Thread Josh Rivel
Hi. I am trying to compile MySQL-3.23.38 on Solaris 8 box. This is a Sun Netra T1 (1u rackmount, UltraSPARC-IIe CPU) I've tried using both Sun's gcc (2.95.2) and gcc-2.95.2 from www.sunfreeware.com, both with the same results. For whatever reason, gcc is being reported as a cross compiler, so mys

Re: my.cnf mystery

2001-06-13 Thread quarlewm
My point was that this is a configuration file, text, not a program. Still, there should be an appendix in the documentation that lists all of the options rather than have this hunt-and-seek approach. Quoting Paul DuBois <[EMAIL PROTECTED]>: > At 8:15 PM -0400 6/12/01, William M. Quarles wrote

Re: mysql GUI for windows NT/98 is it available?

2001-06-13 Thread Tyler Longren
http://mirror.sit.wisc.edu/mysql/downloads/gui-clients.html Tyler - Original Message - From: John Kennedy <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 13, 2001 10:31 AM Subject: mysql GUI for windows NT/98 is it available? > I am just curious to know whether you ha

Re: Newbie stumped by table error

2001-06-13 Thread Jeff Caron
Thanks, Barry! I entered the date without the dashes and was able to create the table just fine. Do you have any idea why this makes a difference? Can't believe everything you read in a book, I guess! And yes, I did end the statement with the semicolon when I submitted it;) Onward... Jeff >

Re: special select ( try 2)

2001-06-13 Thread franky
Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, yo

Re: Multiple CPU's in Freebsd

2001-06-13 Thread Matthew Reimer
Try this: update your ports, then build the mysql port with "WITH_LINUXTHREADS=1". This should result in a FreeBSD native binary linked against linuxthreads instead of libc_r, so it should use multiple processors. Matt Ken Menzel wrote: > > Hi Rafael, >This is not an easy task, there are r

Re: GRANT annoyance...

2001-06-13 Thread Neil Zanella
On Wed, 13 Jun 2001, Benjamin Pflugmann wrote: > Hello. > > Only a minor correction: > > On Tue, Jun 12, 2001 at 09:35:19PM -0230, [EMAIL PROTECTED] wrote: > [...] > > GRANT ALL ON 'database'.'table' TO 'user'@'host' IDENTIFIED BY 'password' > > > > - the PRIVILEGES keyword is redundant. > > - da

Re: Newbie stumped by table error

2001-06-13 Thread Tim
Also, I don' think "-00-00" is a valid Date. You might want to use something else as a default. - TIM > Hello- > > I'm just beginning to teach myself MySQL with the help of Michael Widenius' > book "MySQL". I've entered the create table statement exactly as shown in > the book (pg. 28 if y

Re: Newbie stumped by table error

2001-06-13 Thread Tim
Did you try taking out one of the 'last_name' field definitions?? It looks like you have two there... - TIM > Hello- > > I'm just beginning to teach myself MySQL with the help of Michael Widenius' > book "MySQL". I've entered the create table statement exactly as shown in > the book (pg. 28 if

Re: mysql GUI for windows NT/98 is it available?

2001-06-13 Thread William R. Mussatto
you might checkout dbtools. It seems to work quite well for me. Had some problems with setting permisions with it, but that was an earlier version. http://dbtools.vila.bol.com.br Also there is a myGUI in development from the My Sql team. Check the downloads area http://www.mysql.com/downlo

RE: GRANT ANNOYANCE REVISITED

2001-06-13 Thread David Simcik
Nope, it says version 3.23.38. However, I should point out that I started the service (under NT) with the --skip-grant-tables option enabled. Was locked out of my database when I updated my password manually using a SQL Update on the User table, so I am trying to change that using the method desc

i need help completing install of newest version

2001-06-13 Thread Andrew Hook
so i'm trying to install mysql 3.23.38 on slackware linux, kernel 2.0.27 i'm installing from a tar.gz and have no previous mysql on this server. so i'm ok to scripts/mysql_install_db.sh then i get the following 3 lines scripts/mysql_install_db.sh: my_print_defaults: command not found didn't find

Re: Error locating host.frm

2001-06-13 Thread Gerald Clark
Make sure that mysql owns its files and directories. Furmaniuk, Michael wrote: > I've installed the Solaris 2.7 binary and am trying to connect to the > database after doing the setup, when I attempt to start the database I get a > message that mysql ended and there is no process started. I u

Re: Daemon crashing (I'm going nuts here)

2001-06-13 Thread Whit Blauvelt
Have you tried rebooting? I'm seeing the same problem with 3.23.38 (after stopping the server with mysqladmin and then trying to restart with safe_mysqld) but rebooting resets whatever it is that 3.23.38 is not properly clearing on the shutdown. Don't have this problem on another system running 3

mysql -h error

2001-06-13 Thread Nancy Yang
Hi, when I try the following command, I got is not allowed to connect to this mysql server. Any clue? Nancy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Getting MySQL-3.23.35/up working on my box.

2001-06-13 Thread Sasha Pachev
Upgrade to 3.23.39 first ( and make sure to use our binary). 3.23.35 has some critical bugs. -- MySQL Development Team For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /

Re: Daemon crashing (I'm going nuts here)

2001-06-13 Thread Gerald Clark
Walker, Brian wrote: > I'm at wits end here, I've been through the documentation multiple times, > asked questions on this list, but I still cannot get this server running. > I've restarted the server and everything. > > The only thing I know is that the mysqld daemon crashes when I try to s

Re: Re: Procedures

2001-06-13 Thread John Tsangaris
Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your

RE: Newbie stumped by table error

2001-06-13 Thread Barry C. Hawkins
Jeff, From what I have seen, implicit data type conversion is not present within MySQL's SQL subset. However, I could be wrong. It could be that this is one more area where the efficiency of MySQL is being paid for by the absence of some of the RDBMS spiffs we have all come to know and l

Re: my.cnf mystery

2001-06-13 Thread Dennis
At 08:30 PM 06/12/2001, Philip Mak wrote: >[client] >port=3306 >socket=/home/mysql/mysql.sock > >[mysqld] >port=3306 >socket=/home/mysql/mysql.sock here are examples of variables that you could not deduce from using --help. the "socket" one,for example, was one that I asked about last week, whe

Fwd: mysql -h error

2001-06-13 Thread Nancy Yang
The command I used was: mysql[2]mysql -u root -h som-host-name ERROR 1130: Host 'some-host-name.bbn.com' is not allowed to connect to this MySQL serv er >Date: Wed, 13 Jun 2001 14:18:46 -0400 >To: [EMAIL PROTECTED] >From: Nancy Yang <[EMAIL PROTECTED]> >Subject: mysql -h error >Cc: Danny Vuke

Re: mysql GUI for windows NT/98 is it available?

2001-06-13 Thread j.urban
Try urSQL from http://www.urbanresearch.com/ursql also see the MySQL website: http://www.mysql.com/downloads/gui-clients.html http://www.mysql.com/downloads/contrib.html#SEC592 On Wed, 13 Jun 2001, John Kennedy wrote: > I am just curious to know whether you have any GUI for mysql for Windows

RE: special select ( try 2)

2001-06-13 Thread Barry C. Hawkins
Is this French for "This is a MIME format message in multiple parts?" If so, Franky, try sending your message in plain text, please. Merci, -- Barry C. Hawkins Systems Consultant, MCSE 4.0 [EMAIL PROTECTED] -Original Message- From: franky [mailto:[EMAIL PROTECTED]] Sent: Wednesday, Jun

Re: MySQL compilation problems, Solaris 8

2001-06-13 Thread Mark Vann
Ya know, why is solaris such a pain in the butt. I have issues, no one appears to be able so answer it. When i compile this on linux, it works great. WTF --- Josh Rivel <[EMAIL PROTECTED]> wrote: > Hi. > I am trying to compile MySQL-3.23.38 on Solaris 8 > box. > This is a Sun Netra T1 (1u rackmo

THANKS! RE: GRANT ANNOYANCE REVISITED

2001-06-13 Thread David Simcik
Thanks to all of those who lent their advice. Seems that when you initialize MySQL using the --skip-grant-tables option enabled, it disallows the ability to use the GRANT command. I guess that makes perfect sense. I also forgot the use the PASSWORD() function when I used SQL to update my root acco

RE: load-balancing with NFS

2001-06-13 Thread Sven Huster
Hi As far as i know, DON'T DO THIS mysql with serveral instances accessing the same database will not work as expected. check http://www.mysql.com/doc/M/u/Multiple_servers.html we run mysql over nfs but only with one instance. seems to be quite stable (db server freebsd - nfs server netapp file

Can't install mysql-2.23.6 server , client on Redhat 6.2

2001-06-13 Thread assied
Hi there, I'm trying to setup qmail with mysql database. How can i work the install process on Redhat 6.2 is there a specific package (rpm) that i can install quickly since i got a long way to go. regards, _ AVISO ! Le meilleur de l'Int

Re: Multiple CPU's in Freebsd

2001-06-13 Thread Ken Menzel
Hi Matt, I am trying it now! Thanks! Seems to work, I am running it on one of the QA servers now and I see it spawning many mysql processes! Very cool! BTW to anyone usings ports after a source install use DB_DIR=/usr/local/var you will get an error at the end of make install, but it's OK

Re: GRANT annoyance...

2001-06-13 Thread Benjamin Pflugmann
Hi. On Wed, Jun 13, 2001 at 02:55:07PM -0230, [EMAIL PROTECTED] wrote: > On Wed, 13 Jun 2001, Benjamin Pflugmann wrote: > > On Tue, Jun 12, 2001 at 09:35:19PM -0230, [EMAIL PROTECTED] wrote: > > [...] > > > GRANT ALL ON 'database'.'table' TO 'user'@'host' IDENTIFIED BY 'password' > > > > > > - th

Super-smack compile error

2001-06-13 Thread Ken Menzel
Hi All anyone ever get this? FreeBSD 4.3 OS, using default configure. $ gmake -s Making all in src client.cc:21: redefinition of `union semun' /usr/include/sys/sem.h:49: previous definition here client.cc: In method `void Client::setup_pipe()': client.cc:286: no matching function for call to `sem

Re: Multiple CPU's in Freebsd

2001-06-13 Thread Matthew Reimer
It went in Wed May 23 20:26:06 2001 UTC. http://www.freebsd.org/cgi/cvsweb.cgi/ports/databases/mysql323-server/Makefile.diff?r1=1.114&r2=1.115 Matt Ken Menzel wrote: > > Hi Matt, I am trying it now! Thanks! Seems to work, I am running > it on one of the QA servers now and I see it spawnin

MySQL 3.23.39 released

2001-06-13 Thread Michael Widenius
Hi! This release fixes a couple of bugs in InnoDB tables and a couple of other minor bugs. If you are not using InnoDB tables, you probably don't need to upgrade. Changes in release 3.23.39 -- * If one dropped and added an `AUTO_INCREMENT' column, the `AUTO_IN

URGENTE

2001-06-13 Thread Ricardo Ferrari (SPO-LAB)
hey eu estou acessando um banco de dados do mysql via delphi usando o winzeos meu chefe pediu p/ instalar na máquina dele p/ ele ver como está (ainda nao terminei tudo) e eu nao consigo instalar pois ele da erro na hora de executar a query eu ja coloquei a libmysql.dll no pc e nada alguem poderi

snort plug-in database: mysql question

2001-06-13 Thread Nancy Yang
Hi, I have installed mysql version 3.23.38 on solaris 2.7and then installed and configured the snore to have mysql as the plug-in database. I created a database 'snort' for snort and a user 'snort' that has privileges to INSERT and SELECT on that database. I then built the structure of the dat

error reading communication packets

2001-06-13 Thread Todd Merritt
I am getting the following error in my error log periodically, 010613 9:45:38 Aborted connection 1246 to db: 'databaset' user: 'user' host: `localhost' (Got an error reading communication packets) since upgrading from 3.22.32 to 3.23.36. The only application using the database is a multithre

Re: mysql -h error

2001-06-13 Thread Neil Zanella
In order for this to work you must have privileged access to the mysqld server on which you must be able to execute a GRANT statement to allow access from your host. If you do not have this privilege then you're out of luck. Connecting from other hosts then the server host is considered to be a s

Re: mysql GUI for windows NT/98 is it available?

2001-06-13 Thread Philip Mak
Some months ago I had the same question and I looked at many different Windows MySQL GUI clients. The best one I know of is Mascon. They have a free version for download. http://www.scibit.com/Products/Software/Utils/Mascon.asp -Philip Mak ([EMAIL PROTECTED]) -

Re: mySQLGUI Error

2001-06-13 Thread Thomas Karcher
Hi, > I am trying to use MySQL GUI client on W2K to connect to MySQL server running on >RedRat Linux 7.1 and I am getting the following error > Host '192.168.0.152' is not allowed to connect to this MySQL server. > Do I need to change something on my Linux? Yes, you have to check your MySQL acc

Re: mysql GUI for windows NT/98 is it available?

2001-06-13 Thread Thomas Karcher
Hi, > I am just curious to know whether you have any GUI for mysql for Windows > NT/98? If so kindly send me the link where I could download it. I am curios > to work on MYSQL. Look at http://www.mysql.com/downloads/index.html - you will find what you are searching ... Thomas Karcher -

Re: mysql and php3

2001-06-13 Thread Thomas Karcher
Hi, > Can somebody tell me why I cannot use php3 with mysql? I have just > installed mysql (3.23.38) on a linux 6.2 machine. It is working fine. > PHP3 was already installed when I installed mysql. Does it have to be the > other way round? that is php first and then mysql? I also configured > php

Re: my.cnf mystery

2001-06-13 Thread Paul DuBois
At 2:30 PM -0400 6/13/01, Dennis wrote: >At 08:30 PM 06/12/2001, Philip Mak wrote: >>[client] >>port=3306 >>socket=/home/mysql/mysql.sock >> >>[mysqld] >>port=3306 >>socket=/home/mysql/mysql.sock > > >here are examples of variables that you could not deduce from using >--help. the "socket" one,fo

  1   2   >