Hi all.
I'm going to upgrade a mysql-3.22 Linux Pentium server to mysql-3.23.49a.
Which is the best way to convert a database of ISAM table to MyISAM?
mysqldump?
How to do it?
Iago.
-
Before posting, please check:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 1:00 PM
To: Chetan Lavti
Subject: Re: running script through C program
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass
Try:
SELECT B.name FROM B LEFT JOIN A ON A.name = B.name WHERE A.name is null;
-Original Message-
From: Pichan M. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 14 March 2002 12:19 PM
To: [EMAIL PROTECTED]
Subject: Retrive distinct data from two tables
I have 2 tables, let says, table A
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 2:22 PM
To: Chetan Lavti
Subject: Re: mysql, query :running script through C program
Your message cannot be posted because it appears to be either spam or
simply off topic to our
i wonder if its possible to perform multiple WHERE statements in one
mysql SELECT statement like:
SELECT * FROM table WHERE field1=3D'one' AND field2=3D'two' OR
field3=3D'three';
it works with as many AND and
it works with OR but not together
is there something like brackets or other logical
Hi all,
I have changed database for my Java app to MySQL. The
app was developed with SQL Server. Some of the logic
is dependent on getting the no. of rows updated
returned after an UPDATE query. MySQL does only
return the rows that are really updated, not the rows
matched of an UPDATE. This
Jan,
i wonder if its possible to perform multiple WHERE statements in one
mysql SELECT statement like:
SELECT * FROM table WHERE field1=3D'one' AND field2=3D'two' OR
field3=3D'three';
it works with as many AND and
it works with OR but not together
is there something like brackets or other
Hi Jari,
have not figured out if one can do character changes with mysql, any one
know how to do the following for fields in a table
Altering all the x-characters to character y ?
=You sure can. Manual reference: 6.3.2 String Functions
REPLACE() will find the x-characters and replace them all
hello,
i'm new to the list and don't know if this has been discussed before, so
excuse me if repeating.
i have the idea of setting up a two-way replication system with 2 mysql
servers for my radius database.
i need them to act interchangeably:
1. if server1 is alive, all selects and updates
Mark,
Wednesday, March 13, 2002, 9:53:08 PM, you wrote:
MS Quick question -
MS I have a db named content with user admin and pass mypass Do I still
MS use -u root p maypass ? or would I use
MS mysqlhotcopy -u admin -p mypass content /path/to/copy/the/data/to
MS Thanks again for your help.
If
mailing,
Wednesday, March 13, 2002, 9:41:11 PM, you wrote:
ml I am attempting to add the ROOT user as a MYSQL administrator using the
ml following syntax:
ml mysqladmin -u root password 12345
This command doesn't add user 'root', it can only change password for
that user.
ml and I recieve the
Pichan,
Thursday, March 14, 2002, 6:19:23 AM, you wrote:
PM I have 2 tables, let says, table A and table B. Each table record person
PM name.
PM select B.name from B, A where B.name = A.name
PM Query above should return the name which recorded in both tables (duplicate
PM name)
PM In
denonymous,
Wednesday, March 13, 2002, 9:06:48 PM, you wrote:
d Hi all -- I just need a quick sanity check on a query.
d I have two tables:
d CREATE TABLE users (
d userID VARCHAR(10) NOT NULL PRIMARY KEY,
d [many other fields]
d )
d CREATE TABLE subscriptions (
d userID
Iago,
Thursday, March 14, 2002, 10:17:10 AM, you wrote:
IS I'm going to upgrade a mysql-3.22 Linux Pentium server to mysql-3.23.49a.
IS Which is the best way to convert a database of ISAM table to MyISAM?
IS mysqldump?
IS How to do it?
You can use mysqlcheck or ALTER TABLE statement.
You can
Hi Jari,
have not figured out if one can do character changes with mysql, any
one
know how to do the following for fields in a table
Altering all the x-characters to character y ?
=You sure can. Manual reference: 6.3.2 String Functions
REPLACE() will find the x-characters and replace
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, 14 March, 2002 12:48
Subject: a quick sanity check...
: denonymous,
: Wednesday, March 13, 2002, 9:06:48 PM, you wrote:
:
: d Hi all -- I just need a quick sanity check on a query.
:
Description:
Left outer join on null datetime column produces incorrect result.
The 2nd select below produces no rows, which is incorrect and inconsistent
with the fourth select which produces 1 row.
I get the same results with server version 3.23.41 - binary version from
It looks like you hit some C++ code on the first line. There are still
major problems in using gcc 3.x for compiling C++ on Linux. On my own
box, I had to downgrade to gcc 2.9.6. MySQL compiles flawlessly now.
On Thu, 2002-03-14 at 01:19, MWP wrote:
Hi all...
I get:
c++-303
I want to access the mysql through C-language.
Please tell me which files I have to patch , from
which sites.
If u can give me any tuitorial that will be great.
Please reply me on my Email-Id given below.
My Email-Id is :- [EMAIL PROTECTED]
__
This is my last mail trying to get an answer from you to those 2 questions.
You could at least say: go to the manual or don't know or
don't ask it again or something
Is the subject boring ?!?!?!
_
Subject: Default RPMs and RAID support
I want to
- Original Message -
From: [EMAIL PROTECTED]
To: Patrick [EMAIL PROTECTED]
Sent: Thursday, March 14, 2002 2:05 PM
Subject: Re: Replication 2 way
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
Tomasz,
are you using a non-latin1 character set?
The bug fixed in 3.23.49
MySQL/InnoDB-3.23.49, February 17, 2002
* Fixed a bug: if one defined a non-latin1 character set as the default
character set, then definition of foreign key constraints could fail in an
assertion failure in
Hi All
Do any of you use SSL option in MySQL and if so are there and performance
problems when connecting to MySQL?
Thanks
Simon Green
--
Live Life in Broadband
www.telewest.co.uk
The information transmitted is intended only for the person or entity to
* ds
This is my last mail trying to get an answer from you to those 2
questions.
You could at least say: go to the manual or don't know or
don't ask it again or something
I don't think it is a good idea to reply I don't know or similar... don't
know how many readers are on this list, but
Alex Vandiver writes:
Heya,
I've managed to repeatably crash mysqlgui by running a query that
returns a column of type year. Though it dumps core, gdb does not
provide a useful stack trace. Though this is not a serious bug, it is a
bit of an annoyance.
- Alex Vandiver
--
Konstantin,
Thursday, March 14, 2002, 1:04:42 PM, you wrote:
KT : denonymous,
KT : Wednesday, March 13, 2002, 9:06:48 PM, you wrote:
KT :
KT : d Hi all -- I just need a quick sanity check on a query.
KT :
KT :
KT : d I have two tables:
KT :
KT : d CREATE TABLE users (
KT : d userID
Unable to invoke mysql prompt after the trial download on sun solaris 2.8
Unix.
attaching the error which i got after running the
./scripts/mysql_install_db
--
./scripts/mysql_install_db
ld.so.1: ./bin/my_print_defaults: fatal: libz.so: open failed: No such file
or directory
WARNING:
Hello Again - I'm posting this again, since it still is an issue that I can
not resolve - please help!
I've recently installed mySQL on a RH7.2 box without any problems - it runs
great. I've been testing some long running queries (full table scans, etc)
under different scenarios, and get
fdfghd,
Thursday, March 14, 2002, 2:06:05 PM, you wrote:
fg I want to access the mysql through C-language.
fg Please tell me which files I have to patch , from
fg which sites.
fg If u can give me any tuitorial that will be great.
What about C API for MySQL?
You can read about in at:
Hi guys,
I have a quad Xeon 550 server, 4gb RAM, with a RH Linux 6.2 + patches,
kernel 2.4.8 and mysql Ver 11.17 Distrib 3.23.49a.
After the start, mysql starts to grow memory usage. It grows until it
consumes all machine memory. After a restart it uses only 17Mb of memory, 18
right, of course ;-) (i neglected the join part)
so, now i know exactly whom to ask ;-)
i have the following bother (it's in the planning state):
i have the idea of setting up a two-way replication system with 2 mysql
servers for my radius database.
i need them to act interchangeably:
1. if
Hi guys,
I have a quad Xeon 550 server, 4gb RAM, with a RH Linux 6.2 + patches,
kernel 2.4.8 and mysql Ver 11.17 Distrib 3.23.49a.
After the start, mysql starts to grow memory usage. It grows until it
consumes all machine memory. After a restart it uses only 17Mb of memory, 18
If a table has a blob type containing binary data, like jpeg images or PDF
files for example, can mysqldump be told to encode the data so it is ASCII
compatible? (using uuencode or something like that..)
I am not sure of the 'right' way to do this, but some informal tests where I
dump and
Hi folks,
Let me first say that I am used to using mysql through PHP rather than
command line . . .
And, as I understand it mysql does not support any sort of timers.
I need to use a Unix command like cron to automate either a mysql
command or php script to output a selection from a few mysql
You said
This is my last mail trying to get an answer from you to those 2 questions.
You could at least say: go to the manual or don't know or
don't ask it again or something
Is the subject boring ?!?!?!
I reply---
Who is the you you are addressing? This list is a self-help list for
Hello,
I work with Suse 7.1 and mysql 3.23.30 gamma. I have killed the mysql
settings and so I remove the mysql-RPMs and install mysql 3.23.41 with
yast1.
Perhaps a mistake, I didn´t reboot the system after removing the RPMs.
Then I have same Problems, like:
I Funny I still have the same exact
On Thursday, 14. March 2002 15:13, Andrew Hazen wrote:
Can I just write the mysql commands as a .sql file and tell Unix to
execute it? Or is there another way?
When you already use PHP, why don't use php-cli and execute it via cron?!
Regards
Georg
From: schwingenschloegl jan [EMAIL PROTECTED]
i wonder if its possible to perform multiple WHERE statements in one
mysql SELECT statement like:
SELECT * FROM table WHERE field1=3D'one' AND field2=3D'two' OR
field3=3D'three';
it works with as many AND and
it works with OR but not
and yet there is another novel option to this particular problem. you can
pay someone to teach you how to do it. in just about any case where money
is in fact exchanging hands, results are expected. then you'd have an actual
reason to bitch.
jay downs
- Original Message -
From:
You sure can do it..
Just put your sql commands into a .sql file and use mysql file.sql syntax
to to have them executed by mysql. And you can always use cron in Unix to do
it periodically.In your Unix box do:
man crontab
man cron
to learn more about cron jobs. You can also consult to
Hi I have 2 SQL fragments that pull up 2 differing results and I have no
idea why. The two pieces of code are identical bar one line which is :
AND individual_id ='AB00090004' AND Category = 'DXS1047'
The code that produces the correct code is:
select Raw3_2.category,
Hi I have 2 mySQL fragments that pull up 2 differing results and I have no
idea why. The two pieces of code are identical bar one line which is :
AND individual_id ='AB00090004' AND Category = 'DXS1047'
The code that produces the correct code is:
select Raw3_2.category,
MySQL
Hi all,
I am receving this error message sometimes when I tried to update a record.
I am using Delphi 3, ODBC connection and TTable object.
What I have to do ?
Somebody can help me ?
Tks,
Roberto Alexandre
-
This has nothing to do with this list...
It's just that i'm sorry for the message i sent today, i agree with ppl
who answered me and realised i was being..well...you know what.
Once again, sorry, i won't do it again and thank you for the answers.
--
dsoares
(sql)
This might not be the best way, but for the people here at my office who
aren't familiar with command line interfaces, I've setup MyODBC and MS
Access. This let's them add/edit user's account info directly. The only
thing you can't do (afaik), is change a user's password.
-- Mike Miller
--
The record you want to update is locked by another client.
Check return value of your update()
What you have to do is approx. the following:
while( record_locked)
{
sleep(...)
if( update(...) == OK )
break;
}
Roberto Freitas Alexandre wrote:
MySQL
Hi all,
I am receving
Thanks for your help Victoria.
Iago.
-Mensaje original-
De: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Enviado el: jueves 14 de marzo de 2002 11:48
Para: [EMAIL PROTECTED]
Asunto: Convert ISAM table to MyISAM
Iago,
Thursday, March 14, 2002, 10:17:10 AM, you wrote:
IS I'm going
I have a strange, but probably easy to fix problem. I need to check to see
if something is in a table...that part is easy, but if the table is empty,
it doesn't go through my while statement so that I can create something
in it. I am sure that if there was something in the table, that I
Perhaps this is common knowledge, but is there still no support for UDFs in
Windows. If not, are there any work arounds for trying to perform
complicated calculations on the server?]
Thanks,
Craig
mysql, query
-
Before
After I went through the following steps successfully,
(The previous problem I had regarding inability to untar files was solved by
downloading stuff on that computer where it was untarred. Before that I was
trying to untar stuff downloaded on to a samba share !!!)
shell groupadd mysql
shell
Hi.
For what are files with extension .TMM and .TMD?
Are residual files of mysqldump?
I killed a mysqldump, and I see these files on the directory of the database
but I don't know if they were before the mysqldump.
Iago.
-
At 01:57 2002-03-14, Heikki Tuuri wrote:
Tomasz,
are you sure you are running 4.0.1? In the rpm of 4.0.0 there were no
foreign keys.
I tested this on mysql-max-4.0.1, and it worked.
Well...
[root@flow11 httpd]# mysqladmin -p version
Enter password:
mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for
* Richard
[...]
When the same code is run but without the line:
AND individual_id ='AB00090004' AND Category = 'DXS1047'
a fragment of the results is:
+--+---++---+-+-+
| category | Individual_ID | Inactivate | count | minkey | maxkey
I have totally different task.
I don't want to give users any other privileges but SELECT.
But because I use MERGE tables for showing reports to users
I must give for these tables UPDATE and DELETE privileges.
And here I am talking about several hundreds tables for each user.
MySQL doesn't have
At 07:22 2002-03-14, Heikki Tuuri wrote:
Tomasz,
are you using a non-latin1 character set?
No, didn't change the charset. As You can see from my reply to Victoria
yesterday, will need to, eventually (for different reasons, though, not
books), but right now I am in a proof-of-concept stage:
Dear folks,
Now i try to migrate my Visual Basic Application from
MS SQL Server to My SQL, I met problem when my crystal
report connect ot My SQL, Below is my code:
CrystalReport1.connect = DSN=testDB;uid=amy;pwd=test
CrystalReport1.Destination = 0
CrystalReport1.ReportFileName =
Hi Andrew,
Let me first say that I am used to using mysql through PHP rather than
command line . . .
And, as I understand it mysql does not support any sort of timers.
I need to use a Unix command like cron to automate either a mysql
command or php script to output a selection from a few
Tomasz,
I tested also with mysql-4.0.1 and it worked.
But are you using a non-latin1 character set?
If yes, the bug which was fixed in 3.23.49 might cause the problem.
Did you compile MySQL yourself? If yes, what compiler?
Please download the official MySQL-Max-3.23.49a binary from
At 08:14 2002-03-14, Konstantin Tsolov wrote:
right, of course ;-) (i neglected the join part)
so, now i know exactly whom to ask ;-)
i have the following bother (it's in the planning state):
i have the idea of setting up a two-way replication system with 2 mysql
servers for my radius
Danny,
Wednesday, March 13, 2002, 2:30:10 PM, you wrote:
DK I'd like to know how I can do the following:
DK I want to query a single table like this:
DK select field1, field2, field3 from table1 where field1='something' and
DK field2=0;
DK This query will result in more then one match. It's
Yana,
Thursday, March 14, 2002, 5:00:40 PM, you wrote:
Y Helo!
Y Is there any other way to set permissions to the list of
Y tables in mysql db (big list!) with similar names (f.e. c%),
Y then running a script on it?
No, it's impossible. You should use database name, table name etc or
'*' to
Thank You. This did the trick. I knew that it had to be something
simple. I wasn't even thinking of a if(!$row) statement.
Steve
At 10:05 AM 3/14/2002, you wrote:
- Original Message -
From: Steve Buehler [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, 14 March, 2002 17:46
OK. So I just read in CHANGES FOR 3.23.37 (patch by Ralph Mason) that
there is now support for UDFs in Windows . So anyone know where I might
find some Windows specific examples (or info) on them?
Thanks,
Craig
At 09:47 AM 3/14/2002 -0600, you wrote:
Perhaps this is common knowledge, but is
At 02:05 AM 3/14/2002, you wrote:
Hi,
I run mysql on windows as well as linux.
table creation and access right are given by java program.
Problem im facing is.,
i create a table with name TEMP
in windows in creates table with name temp and linux TEMP
while giving rights thru GRANTstatement ,
as you said, the table is empty. mysql_fetch_object should return NULL.
that's why the block in the while statement doesn't got executed.
while (($row = mysql_fetch_object($result))){
if($row-team_id == $team_id){
echo It is in there;
}else{
echo We will need to add it to the table;
Has anyone used MySQL as the datasource for AutoCAD? Specifically AUTODESK MAP?
Autodesk lists as a capability:
# Link to ODBC-compliant databases including Microsoft Access, Excel, Oracle, dBase,
FoxPro, Paradox, and SQL Server.
Sounds like MAP _should_ work with MyODBC.
Has anyone tried
I am trying to set up MyODBC on a Win2K box to access MySQL on a Linux machine. I am
getting an error message that says my host is not allowed to connect. I then tried to
run a GRANT query under the mysql on the Linux machine to create a valid user in the
hosts table.
I am using version
On Thursday 14 March 2002 9:32 am, BD wrote:
Why or why couldn't MySQL have used case insensitive names in the first
place? Store everything in lower case internally, but allow the user to use
Invoice_Number or invoice_number or INVOICE_NUMBER in the SQL
statement and it should refer to the
Hi All;
I have just recieved a request to build a database using mySQL and I have a
bit of a dilemma.
The database is to be used for relations between politicians and their constituents,
and I have to have tables for constituents and their information. I would like
to have one main database
is anyone getting errors when trying to install mysql++, after
installing the patch for gcc3?
i've gotten a flood of errors which i've fixed, step by step, by adding
std:: to various
variables. manip.cc is spitting out error messages like this one:
manip.cc:141:choosing
IMHO - I would use ADO over the MyODBC layer to retrieve disconnected
recordsets representing your report data from MySQL, then pass said adors to
Crystal Report's viewer.
To learn more about this approach, search seagate.com for ado disconn. rs,
which utilizes ttx files (tab delimited text
At 10:41 +0100 3/14/02, Rune Steinseth wrote:
Hi all,
I have changed database for my Java app to MySQL. The
app was developed with SQL Server. Some of the logic
is dependent on getting the no. of rows updated
returned after an UPDATE query. MySQL does only
return the rows that are really
Rob,
Thursday, March 14, 2002, 7:01:02 PM, you wrote:
RQ I am trying to set up MyODBC on a Win2K box to access MySQL on a Linux machine. I
am getting an error message that says my host is not allowed to connect. I then tried
to run a GRANT query
RQ under the mysql on the Linux machine to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi:
I'm using MySQL 3.2.3.39 for Win98.
Has anybody been able to develop applications using Mingw32 compiler?
If so, where can I get a version of the libmysqlclient library that
will work with this compiler?
Thank you.
- --
Alfredo J. Cole
What is the default table engine used in the binary version of mysql-max -- innodb
or Berkeley? If not innodb, how do I get the innodb to be the default? Can someone
point me to the manual section?
-
Before posting, please
Product : MySql
Version : 3.23.45
Error : Invalid duplicate key error for large
numeric primary key's
Description
---
When a large numeric primary key is created
ID NUMERIC(38)
PRIMARY KEY (ID)
And you insert two records with different
Hi: Installed the following packages (with no errors) from the Red Hat Linux
V7.1 RPM files. It installed MySQL3 3.23.36-1, MySQL-devel3.23.36-1,
MySQL-Server3.23.36-1, and MySQLclient9.3.23.22.4.
However, following instructions, I typed in, at the command line, mysql and
received the
ok, more specific:
here is a table:
CREATE TABLE FOO (foo1 int NOT NULL, foo2 int NOT NULL Default 1)
If I do an insert into the FOO table with the following:
INSERT INTO FOO (foo1,foo2) VALUES (1,1)
Everything works as planned.
If I do an insert into the FOO table with the following:
We are having a serious problem with a simple replication setup using
MySQL. One small database with 12 tables is being replicated one way
-
one master, one slave. Write transaction load is small, about 1
record
per second, usually on only one of the tables. Read load is also
light.
The
Hi Joe,
On Thu, 14 Mar 2002 11:00:33 -0800
Joe Krusick [EMAIL PROTECTED] wrote:
Hi: Installed the following packages (with no errors) from the Red Hat
Linux V7.1 RPM files. It installed MySQL3 3.23.36-1,
MySQL-devel3.23.36-1, MySQL-Server3.23.36-1, and MySQLclient9.3.23.22.4.
However,
Hi:
I work with Linux Cobalt (identic to RedHAT), gcc-2.7.2 and MySQL-3.22.32-1.
I need install DBD-mysql-2.1011, but I received the next error in the
instalation:
(I execute make):
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH=/usr/lib/mysql:/usr/lib /sbin/perl myld
cc -shared
John Hunter wrote:
I have a mysql server behind a firewall. The firewall forwards port
3306 requests to the server, so the outside world can use it. I want
to replicate this database with a slave outside the firewall. So the
slave would request port 3306 on the firewall, but get the
I have tried the last 10 releases of webmin and cannot get it to work with
MySQL. I have a standard install of Mysql 3.23 into /usr/local/mysql. Webmin
keeps complaining that it cannot find the libraries.
The MySQL libraries are here: /usr/local/mysql/lib/mysql
I have set that path both in the
Treat the master and slave as if the firewall wasn't there.
It shouldn't be any different than a router. The outside computer shouldn't
care what it is called on the internal network.
If that's not fact, then its my strong opinion :)
-Original Message-
From: John Hunter [mailto:[EMAIL
From: Al Johnson [EMAIL PROTECTED]
Nothing in the MySQL error logs. Don't know what you are refering to as
the replication log. There is no binlog for the slave and there are no
other logs in the data directory or log directory. Is this something that
has to be enabled?
I was referring to
At 11:17 AM 3/14/2002, you wrote:
On Thursday 14 March 2002 9:32 am, BD wrote:
Why or why couldn't MySQL have used case insensitive names in the first
place? Store everything in lower case internally, but allow the user to use
Invoice_Number or invoice_number or INVOICE_NUMBER in the SQL
Can you telnet into anything else? How about a webserver? Try port 80
or 25 if you have a mail server. If you can't, you need to make sure
you have telnet rights
-Original Message-
From: Jianping Zhu [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 1:58 PM
To: [EMAIL
At 14:58 -0500 3/14/02, Jianping Zhu wrote:
I use:
telnet mysqlserverhostname 3306
and get following response:
Host 'mylocalcomputer' is not allowed to connect to this MySQL server
What does this mean? and how to fix the problem?
The MySQL client-server protocol is a binary protocol.
It
Show me the output of the following:
SHOW GRANTS FOR 'username'@'hostname';
output:
mysql show grants for 'root@localhost';
ERROR 1064: You have an error in your SQL syntax near 'grants for 'root@localhost'' at
line 1
I noticed that my user table doesn't seem to have all the fields it
On Thu, 14 Mar 2002, Todd Williamsen wrote:
telbet to webserer is OK,
I use
telnet thesamename 80
get following messge
!DOCTYPE HTML PUBLIC -//IETF//DTD HTML 2.0//EN
HTMLHEAD
While doing make on a Dec 3000 OSF1 V4.0 I got the following error:
echo timestamp linked_libmysql_r_sources
make all-recursive
No Suffix list
Making all in include
No suffix list.
Make: % rule can only use a single ''/ Stop.
Exit 1
There currently isn't a y2k patch installed. I haven't
I didn't realize you were trying to telnet to a client. You cannot do
that. You need to telnet to the SERVER. Whatever the server is
You need to make sure the user you are trying to use has access rights
for the user for telnet
-Original Message-
From: Paul DuBois [mailto:[EMAIL
lol list spam filter is quite severe
sql, query
- Original Message -
From: Sylvain Hamel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 14, 2002 3:47 PM
Subject: character encoding problems with org.gjt.mm.mysql jdbc1.0
environment : java jdbc, with MM driver, jdk
On Thu, 2002-03-14 at 00:04, [EMAIL PROTECTED] wrote:
Please, i'll need some help.
I've installed mysql-3.22.32 in my machine, and when i run (from
/usr/local/mysql)
./bin/safe_mysqld
this is the bug that present (from my *.err file)
I don't know if this will help you but try this:
# mysqld --help | grep dir:
basedir: /
datadir: /var/lib/mysql/
tmpdir: /tmp/
So, you'll find mysql log files in your datadir (is this case,
/var/lib/mysql/).
my.cnf is usually at /etc/my.cnf
If you don't have it, find a
At 14:46 -0600 3/14/02, Todd Williamsen wrote:
I didn't realize you were trying to telnet to a client. You cannot do
that. You need to telnet to the SERVER. Whatever the server is
He *is* telnet-ing to the server (port 3306 is the server port).
But it doesn't make sense. A Web server might
Hi,
We have Mysql standard distribution (ver 3.23.32) for
Solaris and we just realised that we needed InnoDB
support. What would be the easiest way to add InnoDB
table type? Is it possible to do it without affecting
the tables and databases that are already present.
thanks,
Sanjay Chigurupati
Thanks for your advices.
In the offical mysql webpage, there is a paragraph tell us how to usinng
telnet test mysql server connectivity.
---
http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html
If you get the error message
Thanks for your advices.
In the offical mysql webpage, there is a paragraph tell us how to usinng
telnet test mysql server connectivity.
That test tells you only whether or not there's a MySQL server listening
on the port. It doesn't tell you that you should actually try to communicate
with
Description:
When I run a MATCH query against a full-text index using the IN BOOLEAN MODE
option, the mysqld server
crashes.
How-To-Repeat:
see the information below
Fix:
I haven't figured it out yet.
Submitter-Id: none
Originator:Owen Borseth
Organization:
1 - 100 of 134 matches
Mail list logo