i use mysql 3.23.34a and using BLOB's and timestamps leads to errors (
when giving all timestamps the value now() only some of them return
the correct date the BLOB's don't even return anything ... )
... is this version that buggy ?
Hi guys
I wanted to setup password for mysql access so I typed 'mysqladmin
mypasswordhere' but now I have problems even doing mysqlshow
because it requires a password.
How do I disable the password ?
thanks
Tom
Hi
I am using resin-1.2.3 and mysql at backend on windows 2000...I am trying to connect
to mysql thru my JSP's but gotta bad handshake...I am using mysql-jdbc driver...
My JSP code is like this..
%@ page language=java import= java.sql.*, java.util.* %
%@ page import=sqlBean %
%@ page
I did a search and i do not have that file on my system, and i have been
running RedHat for about 6 years now. And this is a redhat-7.1 box
HTH
--
Dane Knudson wrote:
I have installed mysql during the install of RH linux. When I try and
start the service, there is an entry in the error log
Running FreeBSD 4.2 64MB Ram 2Gb HD on Pent MMX166.
df says that I have 1.2GB free on /usr
Trying to make Mysql 3.23.37 source
after a while I get the following error
bsdbox /kernel swap_page_getswapspace: failed
Now I don't know if this a BSD problem or to do with
Mysql
Any ideas anyone?
On Mon, 7 May 2001 06:27:08 -0400 (EDT)
Jon Valvatne [EMAIL PROTECTED] wrote:
As you'd expect, the server gets bogged down rather quickly at this
point, serving new requests very slowly if at all. Restarting MySQL helps
right away, buying me another 24 hours of stable uptime.
If this is a
Hi,all
How can I get rid of the lock on database?
for I want to operate one database but two tables at same time,
Thanks and best regards
~{B7B~B~FdP^T6Yb~}
~{Na=+IOOB6xGsKw~}
-
Before posting, please check:
A brand new installation has no password set, therefore you do not need -p
so your command should be exactly as I've already given you. Of course you
add your-brand-new-password after the word password.
If that still doesn't work, you can stop the server, delete the privileges
database, rerun
I actually wanted to disable passwords completely.
so when I type mysql the mysql comes up.
Tom
- Original Message -
From: Zak Greant [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, May 06, 2001 11:57 PM
Subject: Re: mysqladmin
Use the -p option to allow
Jon Valvatne wrote:
Hello,
I have a hopefully simple question here:
My web site is dynamically serving 300k page views a day from a MySQL
database, running on a dual P3/700 with 512 megs of ram. Considering the
complexity of my queries and the data amount involved, I know I should
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
With a bad syntax, i create a database named : Ysa2E3iUbr
mysql create it, but i can't drop it...?
there's a bug?
How can i do to drop it?
Thank's..
Davy
Azevedo
La Vie est l'art d'apprendre à mourir dignement
La Naissance est son Apothéose.
That's the weird part; it doesn't seem to be swapping at all. When trying
different combinations in my.cnf, I had key_buffer as low as 64M without
any effect.
Jon
On Mon, 7 May 2001, Joseph Bueno wrote:
Hi,
Are you sure that you need 200Mb of key_buffer cache ?
Since your machine is
I am going to assume that you are on a windows platform and tell you
about what I did. I developed a large ERP system using MSAccess for
the front end and MySQL for the backend. Because MSAccess doesn't
notice changes to the table structure of a MySQL (ODBC) table, I wrote
a routine that
On Mon, 7 May 2001 07:40:26 -0400 (EDT)
[EMAIL PROTECTED] wrote:
Thanks for the quick reply.
I set max_connections so low because even at peaks I never need more, and
when the slowdowns happen, it seems to have an easier time recovering if
there are 15 slow connections hanging than if
I Installed redhat 7.1 and Mysql. And use mysql_install_db and know when i
use mysqladmin -u root -h myhostname -p password 'mypassword' take a error
message. It's began Can't connect to MySQL server on ... (111) and i didn't
see mysql.sock file anywhere in my HD. I try telnet myhost 3306 but i
Check what cron does every day at 0:00.
It is probably deleting your socket.
Stephan Skusa wrote:
Hello,
I've got a problem:
My MySQL-Server gets signal 11 almost every day arround 0:00 am ... I have a
nice
mrtg - graph showing this ... ;o)
In fact every time the server crashes the
On Mon, May 07, 2001 at 07:21:59AM -0700, [EMAIL PROTECTED] wrote:
Hi all,
I've started using MySQL for the first time and I'm hvaing a bit of a problem with
defining an AUTO_INCREMENT column. I'm using ver 3.23.32 which I downloaded for
Linux and Win2k. I am having this problem on both
On Mon, 7 May 2001, Rene Tegel wrote:
On Mon, 7 May 2001 07:40:26 -0400 (EDT)
[EMAIL PROTECTED] wrote:
Thanks for the quick reply.
I set max_connections so low because even at peaks I never need more, and
when the slowdowns happen, it seems to have an easier time recovering if
Hi,
From a system point of view, there are 3 main reasons for a slowdown:
- CPU : Your machine is slow because the CPUs are at 100% and can't
do anything more.
- I/O : Your processes are waiting for data from the disk.
- RAM : You don't have enough RAM so your machine is swapping and
Hi,
As the subject states, I am getting an error in my Perl script telling
me that a table is not locked yet all I am doing is a SELECT. Why do I
need lock a table in order to issue a SELECT?
The code in question is:
$sqlCmd = $dbh-prepare(q{
SELECT Booking FROM Bookings where
On Monday 07 May 2001 03:37, Andrew Leshkin wrote:
Hello,
I have the following perfomance problem with simple query on one of my
servers:
Here is my table ~6 records.
+-+-+--+-++-
---+
| Field | Type
Your Name wrote:
dear sir/madam
i'm currentlly doing a research on MYSQL and i would like to know more
information about it :where does MYSQL come from who created it ...
www.mysql.com
-
Before posting, please check:
http://mmmysql.sourceforge.net/mm.doc.tar.gz
-Original Message-
From: Greg Cardoza [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 07, 2001 3:10 PM
To: [EMAIL PROTECTED]
Subject: Database Connection
Hello:
Is there anyone who can supply me with the syntax for
connecting to a database
I just installed mySQL and want to install the rpm that allows it to communicate with
php. When I do that I get the following error:
error: failed dependencies:
mysql is needed by php-mysql-4.0.4pl1-9
I don't understand. Here is a list of installed components:
Hello Folks,
I wonder how can I return the number of deleted rows after a DELETE SQL statement.
Is there any way to return the quantity of updated rows as well?
Thanks,
C.F.
Not having a copy of the MYSQL manual in front of me, I asked my resident M$
SQL expert. He said if there is no built in function, then do a count
before, a count after and subtract the two. :)
Cal
- Original Message -
From: Carlos Fernando Scheidecker Antunes [EMAIL PROTECTED]
To:
Hi,
In various create table statements char columns are converted to varchar..
I was wondering why this was happening. Here's an example:
CREATE TABLE realtors(name VARCHAR(255) not null, address VARCHAR(255) not
null, city VARCHAR(255) not null, state CHAR(2) not null, country CHAR(2)
not
After installation of MySQL version 3.23.37 on
Linux/i386 with the command:
rpm -i MySQL-3.23.37-1.i386.rpm
two lines of instruction come up, asking to
/usr/bin/mysqladmin -u root -p password 'new-password'
/usr/bin/mysqladmin -u root -h hostxxx -p password
'new-password'
the first line
http://www.mysql.com/doc/S/i/Silent_column_changes.html
second item, quoted here:
If any column in a table has a variable length, the entire row is
variable-length as a result. Therefore, if a table contains any
variable-length columns (VARCHAR, TEXT, or BLOB), all CHAR columns longer
than
Alec Solway wrote:
Hi,
In various create table statements char columns are converted to varchar..
I was wondering why this was happening. Here's an example:
CREATE TABLE realtors(name VARCHAR(255) not null, address VARCHAR(255) not
null, city VARCHAR(255) not null, state CHAR(2) not
Hi,
Char columns are used with fixed-length type table, whereas varchar are used
with dynamic table. If you have varchar columns in your table, all char
columns will be convert to varchar column (you can't have a fixed-length
table if your table contain varchar, blob or text field).
Here
Hi all:
I need help here. I am trying to install mysql here. First, I was able to
install it, but only be able to run it as either root or mysql. I tried
installation several times. Somehow, it worked now. I was able to login as
a different user and run /usr/local/mysql/bin/mysql (just run mysql
We are trying to purchase a server for mysql and were wondering about what is the best
hardware to go with. Any suggestions or web sites that have information would be
appreciated.
Thank you,
Dan Mouw
Is anyone using mysql for OLAP? Any particular tools to check?
thanks in advance,
thalis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Hi,
I am having a peculiar problem with C_API.How to
execute a query string with its length more than 255
characters using mysql_query() function.My sql query
is
more than 255 characters long and is getting
truncated.
Regards,
Ravi
On Tue, May 08, 2001 at 12:51:02AM +0100, VVM Ravikumar Sarma Chengalvala wrote:
Hi,
I am having a peculiar problem with C_API.How to
execute a query string with its length more than 255
characters using mysql_query() function.My sql query
is
more than 255 characters long and is getting
Try mysql_real_query(). This function takes three parameters, the first two
are the same as mysql_query(). The third is the length of the query string.
Regards.
Alec
At 06:51 PM 5/7/01, VVM Ravikumar Sarma Chengalvala wrote:
Hi,
I am having a peculiar problem with C_API.How to
execute a query
- Original Message -
From: tang jie [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 08, 2001 5:41
Subject: problem while SETting A PASSWORD during installation
After installation of MySQL version 3.23.37 on
Linux/i386 with the command:
rpm -i MySQL-3.23.37-1.i386.rpm
It could be either you haven't set up a user by that name or you didn't set
that users password correctly. Have another read of Ch 6 of the manual and
then the GRANT and REVOKE commands in chapter 7.
- Original Message -
From: Xiaowu Gai [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
MySQL support two locks:table lock,db lock,
is it true?
if true,how could I get rid of db lock for I want to access two different tables in
one db,
help!
Thanks and best regards
~{B7B~B~FdP^T6Yb~}
~{Na=+IOOB6xGsKw~}
-
Why would you want to manually set an AUTO_INCREMENT column?? You might
as well use an integer column if you want to be able to change its
values...
- TIM
Description:
On some releases of mysql, after you manually set an AUTO_INCREMENT
column to a negative value, the AUTO_INCREMENT
Description:
I've been using the Slackware mysql package, but I want to use ODBC, and
MyODBC won't compile because my_dir.h is missing. In order to get all
the headers, shared libraries, and thread support I need, I apparently
have to compile MySQL from source, but I'm can't get that to work.
Hi,
I'm a new user for MYSQL, I have a problem that I want to install the GUI application
for MYSQL.
Which I should download and install, also would you mind send or tell me where I can
find the install instruction?
Thank you for you attention, and I'm look forward to heard from you soon.
I'm a bit confused about AUTO-INCREMENT behaviour. I have a table with an
AUTO-INCREMENT column defined as int unsigned primary key. Records are
regularly added and then later deleted from this table. If the last record
is deleted, the sequence begins at 1 again.
Reading from MySQL (Paul Dubois)
On Monday 07 May 2001 20:35, [EMAIL PROTECTED] wrote:
Description:
I've been using the Slackware mysql package, but I want to use ODBC, and
MyODBC won't compile because my_dir.h is missing. In order to get all
the headers, shared libraries, and thread support I need, I apparently
have to
Hi,
I am having a terrible problem with MySQL and I am desperated as
nobody seems to find the source. I have a Web site ( www.genteirc.com )
whith MySQL database access. The problem is that those Mysql processes are
growing continuously until they consume all of the memory ( 2
At 12:14 AM -0400 5/8/01, Kevin McBrearty wrote:
I'm a bit confused about AUTO-INCREMENT behaviour. I have a table with an
AUTO-INCREMENT column defined as int unsigned primary key. Records are
regularly added and then later deleted from this table. If the last record
is deleted, the sequence
I get the following message:
$ mysqladmin -u root password 'newpassword'
mysqladmin: unable to change password; error: 'Can't find file: './mysql/user.fr
m' (errno: 13)'
I think I may have run scripts/mysql_install_db twice! (never work on a computer when
you're half
asleep!) Could that be
Fatal error: out of dynamic memory in yy_create_buffer() in Unknown on line 0
I am getting this error on my machine. MySQL proccesses are growing up to consume
all the machine memory. I have seen them running with 48 M . How can I find out
the source of the problem ? ; how can I
Description:
On some releases of mysql, after you manually set an AUTO_INCREMENT
column to a negative value, the AUTO_INCREMENT fails.
On mysql 3.23.32
mysql DROP TABLE IF EXISTS temp;
Query OK, 0 rows affected (0.00 sec)
mysql CREATE TABLE temp(
-id INT NOT NULL
50 matches
Mail list logo