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
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:
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
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
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
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.
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
-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
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.
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
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
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/
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
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:
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
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
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
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
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
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
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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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:
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
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
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
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
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
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,
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]
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
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
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
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 |
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
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??
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
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
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:
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
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'
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
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
55 matches
Mail list logo