Problem with mysql

Hello, I have installed the mysql-max version 3.23.38 and I now have a problem with mysql. Whenever I try to access mysql I get an error when loading mysql.so that mysql_init is an undefined symbol. Where could the problem be? Andrew

transaction

Does MySQL for Windows support transaction ? If YES, all version ? Thanks a lot. -- K Free E-mail http://www.k.ro/ by KappaNet http://www.kappa.ro/ - Before posting, please check:

RE: transaction

Hi No not all versions. You have to have either BDB, InnDB or GEMINI to use transactions. The new mysqld-max has either BDB or InnoDB and some have Both. Regards ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell

Re: Problem with mysql

Andrew Wafula wrote: Hello, I have installed the mysql-max version 3.23.38 and I now have a problem with mysql. Whenever I try to access mysql I get an error when loading mysql.so that mysql_init is an undefined symbol. Where could the problem be? Andrew

Master election feature thing in Mysql 4.0 ?

Hi, I heard something about a master election feature or something that will decide if a server would act as master or slave in a mysql replication cluster.. But that was for version 4.0 ? I'm currently trying to set up a solution where all mysql machines starts up with no slave or

Re: how do i start mysql gui interface in sun solaris 2.7 sparc ?

Fengxian Guo writes: how do i start mysql gui interface in sun solaris 2.7 sparc ? thanks very much Hi! There is a README that comes with a source and binary distros. If you do not have one, please let me know. If you find problems, then again let me know.

Advice about 'many aborted clients'

Hello, we're using mysql 3.23.33 on a separate Linux server, but about 50% of all connections go wrong and get an error like this: Aborted connection 84620 to db: 'xxx' user: 'yyy' host: `aaa.bbb.cc.ddd.' (Got timeout reading communication packets). There are 3 frontends (Sun) webservers. We're

Re: Problems again ...

-p is for when you have a password set, but you don't have one set yet. password is used to set or change the password but it needs a parameter following it, the new password. You did install mysql from the mysql web site, not RH's mysql, didn't you? - Original Message - From: Radu

Re: mysql start failed.

has it already started? ps -ef | grep mysql - Original Message - From: DEVOS BASTIEN [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 18, 2001 19:11 Subject: mysql start failed. Here's a problem I have when trying starting mysql. Config : RH7.0, MySQL 3.23.32, kernel2.4.3.

Re: phpmyadmin + mysql +Unknown database 'test'

Hi, Well, I also had the same problem and finally traced the bug down to a file called db_readdump.php3 in phpmyadmin directory. If you'r still having the problem, may be this is helpful to you too. edit db_readdump.php3 and add in the beginning of the file $db = trim($db); Then at the

I am newbie and I can't resist anymore !!!!

so ... this is another story: mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! Indeed there is no mysql.sock

Transactions

How can I use transactions in mySQL ver. 3.23.38-nt? Tel.: 0422-678874 mailto:[EMAIL PROTECTED] Carlo Scalet - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

problem regarding ASP+MySQL in NT with IIS (web server)

respected sir, i have a problem regarding connectivity between ASP and mysql. will it possible to connect asp with mysql if yes then how we can do it will it need any driver if yes then from where we get that driver .. will i get some tutoril in this matter... thanking you ashutosh

RE: mysql start failed.

Nothing is running. I tried removing the socket mysql.sock and trying reconnect, but it creates a new socket mysql.sock and mysql is not running. I know this kind of problem is known, but I never found a solution. -Original Message- From: Rolf Hopkins [SMTP:[EMAIL PROTECTED]] Sent:

Instalation problems!!!!

Hi, I want to install mysql for unix machine (digital/compaq) alphav56-dec-osf4.0d. Is there any version of mySQL for this version of digital unix?!!! I tried to ftp a version called mysql-3-23-25-beta-dec-os4_0f-alphaev6_tar and I have a problem with instalation manual: I can't find the

Re: Instalation problems!!!!

Fariba Noorbakhsh writes: Hi, I want to install mysql for unix machine (digital/compaq) alphav56-dec-osf4.0d. Is there any version of mySQL for this version of digital unix?!!! I tried to ftp a version called mysql-3-23-25-beta-dec-os4_0f-alphaev6_tar and I have a problem with

CPU usage running mysql

Hi, We run mysql V3.22.32 (solaris 2.5.1 version ) on a Solaris 2.6 box. The top command shows the mysqld running at 98.3% of cpu time when the system is idling. On a Solaris 7 box runnning Solaris 7 running mysql-3.22.32 (solaris 7 version) but also idle, the top command shows 0.5% for the

Re: FW: ERROR 1136: Column count doesn't match value count at row 1

Amy Wan wrote: Hi all, I have a regular table like this CREATE TABLE MediaChannel ( MediaChannelID INT NOT NULL, Medium VARCHAR(5) NOT NULL, CallLettersVARCHAR(12) NOT NULL, StationNickNameVARCHAR(40), Slogan

Re: Is it possible? ODBC doubt.

In message 001301c0ddf3$49e1cc60$12ffa8c0@notodo, Martin Cabrera Diaubalick [EMAIL PROTECTED] writes Hi there! I installed MyODBC and tried to import a Database from my Web Hosting account but didn't let me. Was it me that didn't know how to do it or is it possible that access is only allowed

my sql admin site

Can some one let me know about the URL to go through the mysql Admin issues. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie

DBI problem

Hi, I tried to connect to the database, when I compiled it, it replied with (offline mode: enter name=value pairs on standard input) - What is this meant? Below is my code: #!/usr/bin/perl -w use strict; use CGI; use DBI; my $dbh; my $sth; my @row; my $form = new CGI; print $form-header;

RE: DBI problem

try connect with a minimal script, like this (I didn't try it) : snip #!/usr/bin/perl -w use strict; use CGI; use DBI; my $dbh; print something before connect; $dbh = DBI-connect(DBI:mysql:$database, $username, $password) or die Couldn't connect to database: . $dbh-errstr; print something

OT: Anyone know of a good Real Audio/Video host in East Coast

I am moving all my web-hosting stuff for my company in-house (finally)! Thanks to Dell's price cuts and Mpower DSL connection (at an unbeatable price) I am able to bring in-house most of the stuff (including fabulous MySQL database) BUT the Real Audio/Video server. I need a plan that gives me

RE: problem regarding ASP+MySQL in NT with IIS (web server)

Hi Ashutosh, You can try a tool like MySQLX which was specifically developed for MySQL and ASP, see: http://www.scibit.com/MySQLX or any of the other ASP API interfaces in the mysql Contrib section. Regards Jacques http://www.scibit.com/mysql -Original Message- From: ASHUTOSH SHARMA

Re: Telnet and ftp problem

You don't use telnet or ftp to connect to the MySQL server. You use the client mysql. Rodolfo Baselli wrote: Hi I've got a MySQL box running on a PIII/700 with SuSE Linux 6.4 and cannot connect to it via telnet and ftp. I have my telnet prompt back as I stop the MySQL server daemon (from

if or statement possible?

Is it possible to make this type of logical command in MySQL? if ((x == y) or (x == z)) { response1 } else{ response2 } From what I can see the sql if statement will only handle one argument on the LHS. Can this be done, or do I need to look at multiple queries and then combine the

Re: DBI problem

that is because you are calling a script using cgi from the command prompt. that's really a question for a perl/cgi group. cgi's are intended to be run from the web. i think you can just press Ctrl+D (or Ctrl+Z - can't remember which) when you get that prompt to continue. - Original

mySQL 3.22.32-1

Hi, Does mySQL 3.22.32-1 work on Windows 98? My ISP is using Chili!Soft ASP which only talks to mySQL 3.22.32-1, therefor mySQL 3.23 is out of the question. Any reply is greatly appreciated. Putri Alam US-ASEAN Business Council Washington, DC

RE: problem regarding ASP+MySQL in NT with IIS (web server)

Our solution to this was installing myODBC on the NT Server and connecting in this fashion: Dim Conn_STRING Conn_STRING = driver={mysql};database=dbname;uid=uname;pwd=password;option=16386; set rsRecordSet = Server.CreateObject(ADODB.Recordset) rsRecordSet.ActiveConnection = Conn_STRING This

Re: if or statement possible?

On Fri, 18 May 2001, Kip Turk wrote: Is it possible to make this type of logical command in MySQL? if ((x == y) or (x == z)) { response1 } else { response2 } I'll go ahead and follow up my own post, as I found a solution, using regexp. Here's a test case I ran if anyone else is

Re: MySQL-Based System Monitoring Tool

Hi Van, I use a program called netsaint. (netsaint.sourceforge.net) It uses mysql or postgresql for almost everything. The history file is still flat ASCII, but its on the todo list to move it to the mysql database. (it's the only file that has NOT been put into a database!). The mysql

SELECT DISTINCT on two columns

I have two columns in a table I need to get distinct values out of. I know I can get distinct combinations of the values of the two columns with SELECT DISTINCT fruits1, fruits2 but what I need is unique values among the two. So that if in fruits1 I have values apples and oranges, and in

MysqlGUI interace

I am intersted in your MySQL GUI. Any specs available ? Will the software be at a cost ? Are you looking for distributors ? I am an independant consultant in France and enthused by free software field. Yours truly, Michel Demonfaucon Ahimsa

Re: Weird problem. 3.23.37, RH 6.0

try SELECT * WHERE x like '3411'. Steve Sobol wrote: I have a varchar field that contains the street number (part of a mailing address). It's a varchar because the field may occasionally contain non-numeric characters, but normally it doesn't. Let's call the field x. I have a record

Re: NT installation / port issues

At 11:36 18/05/2001 -0400, Michael Britton wrote: Hi, That error message should means: the server wasn't started or the client wasn't able to connect for privileges issues. The server you should use is: mysqld-nt.exe The recommended way on NT is as service so install it by:

Re: Weird problem. 3.23.37, RH 6.0

Dibo Chen wrote: try SELECT * WHERE x like '3411'. Like doesn't work either. I tried it. mysql select ppn from main where streetnum=3411; +---+ | ppn | +---+ | 01A003290 | | 01A016440 | +---+ 2 rows in set (3.04 sec) mysql select ppn

Matching errors.

Description: Using MATCH in select-clauses returns: ERROR 1030: Got error -1 from table handler How-To-Repeat: Table: CREATE TABLE files (id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, filename BLOB, comment

Grant problems

I have successfully installed MySQL 3.23.38. I can start the server and log in as root. When I try to grant new users using: grant insert to test.* for testuser identified by 'testpassword'; It comes back saying 0 rows affected. I can go the the MySQL db and look at the grant table and

PATCH: InnoDB assertion failure in ibuf0ibuf.c in large table import

Hi! A bug fix patch: If you do a lot of inserts into a table and a column in a secondary index contains NULL values, then the insert buffer may overflow, causing an assertion failure in ibuf0ibuf.c, line 2264. A fixed mysql/innobase/ibuf/ibuf0ibuf.c can be downloaded from

Error installing DBI mySQL Driver

Hello I am trying to install DBD-mysql, i have installed all the requisites that its needs : 1. Perl == ActivePerl-5.6.1.626 2. MySQL == Ver 9.38 Distrib 3.22.32 3. DBI == DBI-1.15 4. C compiler and Gzip libraries are included in the installation of Linux , but when i run the make told

Restoring data to a database

Hi, I back up my entire database with the following command: mysqldump --opt -ppassword mydbf_db /mydir/mydbf.backup Does anyone know the counterpart command to restore from the backup file? Thanks, Don - Before posting,

Re: Hierarchy Queries - Multiple LEFT JOINs of the same table?

cool, thanks! I don't know why I was using LEFT JOINS :) What would I do if I wanted to go the other way... ie see everyone who reports to Bob? Also, won't this query return blank if you can't go up 2 levels to S3? Thanks! Graeme - Original Message - From: Dibo Chen [EMAIL PROTECTED]

Re: Restoring data to a database

Don Pro writes: Hi, I back up my entire database with the following command: mysqldump --opt -ppassword mydbf_db /mydir/mydbf.backup I've got: mysqldump -h mysql.io.com -u user -p --opt database ! backup-file.sql mysql -h mysql.io.com -u user -p database backup-file.sql In your

Re: Restoring data to a database

If you look at the 'text' file you created with the 'dump', you'll see that it contains all of the 'SQL commands' to recreate the tables and 'insert' the data you've extracted. So you simply type: mysql mydbf_db /mydir/mydbf.backup (you might have to insert/add the -u and a username and

ENUM and large strings

Hi! In order to save space in our database, we designed our tables to use enumerated datatypes. For one column, we have about 2,800 different values, each of which is about 30-40 text characters long. Now, all the MySQL documentation I have read states that the limit for the number of ENUM

Re: date_format sets time to 12:00:00

Sinisa Milivojevic wrote: [EMAIL PROTECTED] writes: Description: date_format is setting times to 12:00 AM; time_format works fine How-To-Repeat: mysql select start,TIME_FORMAT(start, '%l:%i %p') AS start2 FROM time; +--+--+ | start| start2 |

question about a select application (sql, database)

Hi, everyone, I wrote a program to keep inserting rows to the databases. But I want to check the LAST row I inserted. Is there any good way to do it?? thanks, Joe

RE: question about a select application (sql, database)

Does the table have an auto_increment column? If so: select * from table where autoinccolumn = LAST_INSERT_ID(); I wrote a program to keep inserting rows to the databases. But I want to check the LAST row I inserted. Is there any good way to do it??

RE: ENUM and large strings

Perhaps in your case it would be better to use another table and do a join? Hi! In order to save space in our database, we designed our tables to use enumerated datatypes. For one column, we have about 2,800 different values, each of which is about 30-40 text characters long. Now, all

RE: Grant problems

I think you're using it incorrectly. It should be: grant insert on test.* to testuser@localhost identified by 'testpassword'; I have successfully installed MySQL 3.23.38. I can start the server and log in as root. When I try to grant new users using: grant insert to test.* for testuser

MySQL instalation problem

Recently, I've been trying to install MySQL on a redhat 7.2 system. I am trying to do so from source. Everything seems to go well untill I have to change the root password. Basicly the following happens: Installing all prepared tables 010518 10:22:02 /usr/local/mysql/libexec/mysqld:

Need help with outer join...

Hello, all. Having a small problem with MySQL and need some expert help. Trying to do a left outer join on one table out of seven. As shown below the only table which may have no row would be the pnotes table. Also shown below is the results I am getting (*use a fixed font for proper

RE: MySQL instalation problem

You can start the MySQL daemon with: cd /usr/local/mysql ; /usr/local/mysql/bin/safe_mysqld ... [root@stupidsiteforjerks mysql-3.23.38]# /usr/local/mysql/bin/mysqladmin -u root -p password 'new-password' Enter password: /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost'

RE: ENUM and large strings

In order to save space in our database, we designed our tables to use enumerated datatypes. For one column, we have about 2,800 different values, each of which is about 30-40 text characters long. Now, all the MySQL documentation I have read states that the limit for the number of

[isp-linux] Apache make fails (apache, ssl, php, mysql)

I'm trying to add php support into apache and the 'make' command fails. mysql-3.23.38 installed fine and I ran some tests and everything is working. php-4.0.5 also installed fine (but don't know how to test it from the command line). The apache configure also went fine: [root@dns2