Can anyone out there tell me how to use java and JDBC to connect to a
MySQL db on a linux box, i've downloaded the api of the website but I
can't get it working correctly. Could someone send me some sample code
and/or tell me where to put the api and how to reference it?
thankx alot!
-nico
--
*
Hi, I think I found a bug in mysql. I tried the mysqlbug thing but it
didn't work right away. I hope this message will be detailed enough.
I am not subscribed to the mailing list.
In the following sections are the output of, respectively:
mysql -e "SHOW VARIABLES"
mysqldump sqmail sequence
yeah that was my problem, i manually installed apache/mysql/php and that has
solved it!
thanks neil
- Original Message -
From: "Neil Zanella" <[EMAIL PROTECTED]>
To: "Steve Sapsford" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, June 03, 2001 5:24 AM
Subject: Re: mysql &
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Background:
I'm trying to install the full complement of mysql software...share,
development, client, and server. I have installed the source for
3.23.38 server and it has worked flawlessly. Nonetheless, I now need
all of the above pieces of softwar
On 03-Jun-01 mysql list wrote:
> In my UNIX (FreeBSD) system the database directories
> shows up as below.
> drwx-- 2 mysql mysql512 May 11 11:51 mysql
> drwx-- 2 mysql mysql512 May 11 22:40 test
>
> I guess this means I should only start mysql server by
> being the user mysq
At 7:05 PM -0700 6/2/01, mysql list wrote:
>In my UNIX (FreeBSD) system the database directories
>shows up as below.
>drwx-- 2 mysql mysql512 May 11 11:51 mysql
>drwx-- 2 mysql mysql512 May 11 22:40 test
>
>I guess this means I should only start mysql server by
>being the user
ps -ef | grep mysqld is the command you want to check if the server is
running.
Can't say for sure what your problem is nor do I know what this ver 9.16 is
but I do know that you are running an old version of mysql and I think
freebsd as well. Sorry, I use linux so I'm not sure. The latest vers
In my UNIX (FreeBSD) system the database directories
shows up as below.
drwx-- 2 mysql mysql512 May 11 11:51 mysql
drwx-- 2 mysql mysql512 May 11 22:40 test
I guess this means I should only start mysql server by
being the user mysql. But how can I become the user
mysql?
The us
InfiniteDimensions (http://InfiniteDimensions.com) is proud to
offer a new unique set of online tools for database and web site
content management. It's hard to imagine an easier way to
keep your web site current.
Using our high-speed multi-processor MySQL database servers, you can
power
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello mysql,
Peter> I'm repeating my test's now with more information and on more
Peter> powerfull maching with no load now, this should give more accurate
Peter> results.
Peter> The machine is Dual PIII-750/1GB RAM
Hi,
I am storing fairly large hunks of data into a MyISAM table
and am wondering what the best way of retrieving that data
would be. I have a longblob column which is used to store
data but when that data is returned, I'd rather it wasn't
allocated a buffer in memory.
Provided the connection to
Hi,
I've started mysql with the parameter -O wait_timeout=1000 and verified
that it is set using show variables. Yet I routinely see lingering
processes with times over 1100 and higher. I have about 1000 active
database users at the moment, most are connecting via php pages and I had
been r
In response to a recent question I posted regarding installing
MySQL/PHP/Apache on a G4 tibook I was recommended to get a copy of
Mac OS X as this was condsidered to be the most stable and easily
configurable option at my disposal.
I am fairly well-versed in relational concepts but a bit slow
On Thu, 31 May 2001, Jean-Philippe Durrios wrote:
> Hi,
> How do I set the root password after installing MySQL server and client?
> I followed the after installation instructions,@they don'T work.
>
> mysqladmin -p password 'new-password' I don't get it.
The message from the RPM file is w
Did you manage to compile PHP with mysql support?
I think by default red hat disables it.
Neil
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
Hello mysql,
I'm repeating my test's now with more information and on more
powerfull maching with no load now, this should give more accurate
results.
The machine is Dual PIII-750/1GB RAM
I'm trying the following table structure:
CREATE TABLE g00hits (
id int(10) unsigned NOT NULL
> 2 - Your INSERT statement is using a SELECT statement to
> chose VALUES to be inserted into the table. Since MySQL
> does not support sub-SELECT statements, the second part
> of your query is not returning any values, resulting in
> the NULL value error stated above.
MySQL does support INSERT .
Hello,
I am new to both MySQL and JDBC. I installed a MySQL binary on a Linux
machine, and I want to access the database as a server over a network. I
have had a hard time finding documentation on how to set this up. How do I
decide which port the server runs on, and do I need some kind of ext
Danger, danger! UltraDev code ahead!
First off, do yourself a favor and try to ween yourself off UltraDev and
learn ASP and SQL from a good book and write the code yourself. It will
probably save you many headaches in the future.
I think that your problem might be twofold and they are related.
chris@illusion:~$ perror 13
Error code 13: Permission denied
chris@illusion:~$
Make sure your database directory is owned by the same user that MySQL is
running as.
> When I attempt to get into this database this error
> comes up, but other databases work ok. I cannot find a
> reference to 'Er
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.23.38 (Source distribution)
>Environment:
Question:
My question is does anyone know of a full blown
implementation (client(s) and database design) using MySQL
for running an ISO 9000 medical device manufacturing type
company? I have seen such an animal using Filemaker and it
looked like a disaster waiting to happen... again...
I have lo
I am working with porting an ASP website that connected to an Access Database to MySQL
and am still very new to the Syntax differences.
I've found more than a majority of the site works except one crucial part that submits
the results of a survey into the database and am not sure *exactly* wher
When I attempt to get into this database this error
comes up, but other databases work ok. I cannot find a
reference to 'Errcode: 13' or any 'Errorcode' in the
manual or mailing list archives.
mysql> use vhosts;
Can't read dir of './vhosts/' (Errcode: 13)
There is instruction on how to perform r
"darthzeth" <[EMAIL PROTECTED]> wrote:
> would anyone out there know how to use PHP to turn
> a MySQL Timestamp (not datetime) into a UNIX
> timestamp. using PHP.
I have a PHP function that converts a MySQL timestamp into epoch time. I
use it in conjunction with another function that returns the
Hi,
Seems I've never had any luck with MySQL and OpenBSD, and I'm hoping I can
finally get some help now that I've finally got around to recompiling it
again.
I'm running OpenBSD 2.7 and am compiling MySQL 3.23.38. I'm using the
configure options;
"CXXFLAGS="-O6 -march=i586" CFLAGS="-O6 -march=i
On Sat, Jun 02, 2001 at 02:17:38PM +0300, Jüri Kuzmin wrote:
> Hi all!
> Can someone please tell me,
> why i can not save the .pdf version of MySql manual
> (http://mysql.tradenet.ee/documentation/mysql/alternate.html)
>
> Can someone help me, I would like to save this file in my hard disk,
On Sat, Jun 02, 2001 at 02:17:38PM +0300, Jüri Kuzmin wrote:
> Hi all!
> Can someone please tell me,
> why i can not save the .pdf version of MySql manual
> (http://mysql.tradenet.ee/documentation/mysql/alternate.html)
>
> Can someone help me, I would like to save this file in my hard disk,
It d
You can *STORE* Unicode (UTF-8) in MySQL just fine. Just don't expect
text-search (LIKE, =, etc) to do anything useful with it.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] On Behalf Of md
> Sent: 1 June 2001 15:22
> To: [EMAIL PROTECTED]
> Subject: Unicod
Hi all!
Can someone please tell me,
why i can not save the .pdf version of MySql manual
(http://mysql.tradenet.ee/documentation/mysql/alternate.html)
Can someone help me, I would like to save this file in my hard disk,
with thanks in advice,
Jüri Kuzmin
---
Peter D Bethke writes:
> Sinisa,
>
> In the first case I was trying to connect to the Linux box using a MySQL
> client on the Mac called MacSQL. This box is called malacoda.local.
>
> I'm still getting the same error, trying to connect from a mysql client on
> my NT system, called lucifer.local,
hi
i want to know is there any size limit(no. of rows) for mysql created table.
In my case table contain only four cloumn
date,ip_address(varchar[20],tx_bytes(integer),rx_bytes(integer).
i want to maintain a huge database of this format.
so plz i want to know the limit of mysql database.
regard
>> AFAIK you can compile mysql on FreeBSD with LinuxThreads (they have
>> been ported on FreeBSD). In this case threads will spread across the
>> CPUs as on Linux.
JZ> Funny you mention that... It comes up once in a while, but almost
JZ> everytime it's someone saying "I've heard that you can..."
hi there ...
I'm using MySQL through the Perl DBI and I want to merge
two SQL statements that would simplify my code:
1. SELECT * FROM filters WHERE folder != '$folder'
2. SELECT * FROM mails WHERE folder_name = '$folder' AND x$filters->{type} LIKE
'%$filters->{pattern}%'
for each of the resul
try this:
grant all on *.* to admin identified by 'password';
this would create user called 'admin' who can access
mysql from any host.
...Rohit
- Original Message -
From: daddius <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 02, 2001 7:43 AM
Subject: FW: ezmlm respo
would anyone out there know how to use PHP to turn a MySQL Timestamp (not datetime)
into a UNIX timestamp. using PHP. I know there is the UNIX_TIMSTAMP(feild) query, but
that would be a huge pain to go and edit the queries. I guess this really counts as a
PHP question, but maybe someone here kn
hi,
I'm using
mysql Ver 9.16 Distrib 3.21.33b, for
unknown-freebsd3.0 (i386)
and i'm using 'C' program to interface with mysql
database,
I didn't get any compilation errors, but while
executing i receive the following error :
File '¡$Pè7' not found (Errcode: 1)
Below is my code that gives
37 matches
Mail list logo
