Greetings All:
I'll keep this brief. Subject says it all.
There's MRTG, which appears to have branched to RRD, and Spong, and Big Brother
(which used to be good), and Big Sister, and MRTG-PME, inept, etc. ad nauseam.
Problem with most of the better developed ones is a perl basis and usage of
f
Create another table with an id column and a code column, and for each code
insert a column with the id of the row in the original database and the
code. Then do an SQL join to search. For example:
mysql> create table example (id int(11) NOT NULL auto_increment, blah
varchar(100), PRIMARY KEY(id)
Hi,
I am considering developing a project on mySQL or InterBase. I tried to
find comparisons, benchmarks, etc, but found nothing...
Could anyone point me to such documents?
If anyone cares, I wrote a small PHP script to benchmark both DB.. it's
really simple, but shows mySQL is faster all
I need to write a replace statement in a query that will replace the lower
case e with an accent over it and the uppercase A with an accent over
it. Anyone have any suggestions? I'm having trouble with those characters
ending up in HTML forms. Thanks,
-Chris
--
how do i start mysql gui interface in sun solaris 2.7 sparc ?
thanks very much
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the li
>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 |
+--+--+
| 12:00:00 | 12:00 PM |
| 14:00:00 | 2:00 PM |
+--
Read section 6.3 of the manual - restart mysqld with --skip-grant-tables.
Dave
At 10:35 18/05/01 +1000, you wrote:
>Hi all,
>
>
>Just a quick question. A friend of mine installed a mysql on a new FreeBSD
>box, and for some reason the root password wasnt empty. He has root access
>on the bo
Well, thanks to everybody for their replies. I appreciate the help,
and sorry to those who thought the question was asked in an
inappropriate list. I ended up just configuring using --with-mysql=/*
and everything seemed to work. Some how I doubt this was the
*right* solution, but oh well.
Perhaps this is a common problem:
I would like to have a database field that contains multiple code numbers
and later search for the presence of one of the codes. What I have come up
with so far is using a "&" delimter between the code numbers to end up with
a field like:
12&5&34
When searching I
Hi all,
Just a quick question. A friend of mine installed a mysql on a new FreeBSD
box, and for some reason the root password wasnt empty. He has root access
on the box but cant get into mysql as root to make the needed changes to
mysql ready for use.
Is there any way a user logged on as roo
Hey everybody,
This is my perl DBI script:
#!/usr/bin/perl -w
use DBI;
$username = "myusername" ;
$mypassword="mypassword" ;
my $dbh = DBI->connect("DBI:mysql:table1:localhost", "$username",
"$mypassword");
die "Can't open DB\n" if (!defined $dbh);
my $sth = $dbh->prepare("SELECT * FROM abc
> 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
hout the '-', ':' and spaces? (in a TIMESTAMP(14) like
> format)
>
> I always want 20010517 rather than 2001-05-17,
> and 20010517130500 rather than 2001-05-17 13:05:00
>
> Alternatively can I set the delimiters to '' or NULL somehow?
>
> Thing
Hi!
To compile the Win32 Debug version of mysqld with support of
InnodB, you need to remove the preprocessor definition __NT__
from the innobase - Win32 Debug configuration.
The above is to avoid an insertion error message on Win9x and
Win ME OSs when the server is started. For NT/Win2k OSs it i
> > I am running MySQL on a RedHat Linux with raid disks. Should I then
> > use --with-raid when installing ?
> No you dont. If you have a the raid setup by other HW or SW you dont need to
> use the --with-raid.
>
Your answer implied that if your box uses H/S RAID setup, you don't need
'--with-
WCBaker wrote:
> Wrong. As the MySQL Development Team suggested, this is a quesiton for
PHP
> people. THe message "Header files not found at .. " has nothing to
> do with MySQL. This is a header that is being generated (HTML HEADERS).
> Therefore, at the TOP of a (PHP) script file you ar
Wrong. As the MySQL Development Team suggested, this is a quesiton for PHP
people. THe message "Header files not found at .. " has nothing to
do with MySQL. This is a header that is being generated (HTML HEADERS).
Therefore, at the TOP of a (PHP) script file you are saying something lik
if i remember rightly (from memory) you probably will need to ./configure
--prefix=/path/to/mysqllibfiles
then makefile.pl, make...
it seems it cant' find your lib files in the place it expects them.
find them and then use the prefix option above.
- Original Message -
From: "aelma"
Hi, when i try to install the DBD::mysql that returns an error, i run the
perl Makefile.PL without problems, but in the next step (make) prints an
error.
This error is :
[root@microbell DBD-mysql-2.0900]# make
cc -c -I/usr/lib/perl5/site_perl/5.005/i686-linux/auto/DBI -Dbool=char -
DHAS_BOO
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello mysql,
Peter> Currently mysql waits until disk space freed for myisam tables for
Peter> all situations exept of repair and optimize.
Peter> Even more table is marked as crashed and will not repair
Peter> au
> What does "--with-raid" mean ?
It means that the mysqld has the ability to split the .MYD (datafile) intto
several datafiles (in several sub directories).
>
> I am running MySQL on a RedHat Linux with raid disks. Should I then
> use --with-raid when installing ?
No you dont. If you have a the
I'm trying to get the perl script below to write to my database. It didn't work and
the error log showed that it got hung up at line 8 (use DBI). any ideas why?
#!/usr/bin/perl -w
my $name = 'mel';
my $email = '[E
These guys work way to fast for me. I'm used to companies that go years between
revisions and have a world wide webcast to mark the event. I stand humbly
corrected. Though on solaris, I couldn't get 4.0.4 to work with 1.3.14. The
point is, it's always best to be current!!
Zachary Burnham wrote:
>
What if I have the following:
enum('foo','bar','baz') default 'bar' not null.
What if I want to change the value of "bar" to "bee"? What is the best way
to implement this in mysql? What if I want to change the default value?
Nicole Sweeney
Software Configuration Engineer
Akamai Technologies
1.3.19 actually, Matt :) I'm running .19 on both my Linux machine and
the G4. And as far as I can remember, PHP4.0.4pl1 worked ok on 1.3.14,
I was doing that for a while.
Z
On Thursday, May 17, 2001, at 08:59 AM, Matthew P. Marino wrote:
> Apache is up to 1.3.17 at least. I would update apac
You don't have a password yet, so drop the -p
Radu Adam wrote:
> I installed RedHat Linux 7.1 with PHP and MySQL.
>
> My problem is i can't do anything in MySQL ...
>
> I did as told in MySQL documentations about installing and this is what
> happens:
>
> shell> mysql_install_db
>
> ... th
Hi,
I was going through my sql documentation and found the
stability of mysql for locking is "Gamma".Does mysql
recommend the usage of explicit locking for sensitive
data or will it automatically handle concurrent
requests?
Regards,
Ravi
_
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject: mySQL handeling of NULL in insert and update on NOT NULL columns.
>Description:
This may
Hi,
I wonder whether any of the database has support for
the following situation:
I created a database in mysql with the name "SAMPLE".
Now whenever I change this database in any manner ie
by adding one additional table or an additional column
to the database table,I would like to have a version
Hi,
I wonder whether mysql has any default memory
allocation and has a similar procedure for extending
the memory as does Oracle.
Can someone throw some light on this?
Regards,
Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk address at h
Please read the manual about RAID table types.
On Thursday 17 May 2001 09:24, Jacob Friis Larsen wrote:
> What does "--with-raid" mean ?
> I am running MySQL on a RedHat Linux with raid disks. Should I then
> use --with-raid when installing ?
--
Joshua Kugler
Associated Students of the Universi
that might have been it - no I didn't call the table the same name, but I
certainly typed it there huh. I will try the code now and see what happens.
my biggest concern was if I simple had the necessary pieces to enter the
data into the table. for instance, if I keep calling this script will it
What does "--with-raid" mean ?
I am running MySQL on a RedHat Linux with raid disks. Should I then
use --with-raid when installing ?
Jacob
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht
I installed RedHat Linux 7.1 with PHP and MySQL.
My problem is i can't do anything in MySQL ...
I did as told in MySQL documentations about installing and this is what
happens:
shell> mysql_install_db
.. the message about mysqladmin
shell> mysqladmin -u root password -p 'somepass'
Acces
I much prefer the current behavior, our customers have no access to
the local host and anyone trying to gain access from the local host
with a sniffed password and account would fail. I am mildly paranoid,
but it gives me comfort (however unjust).
Ken
You have two quotes after 'email'.
Todd Marks wrote:
> hello,
> just want to start off saying that I am a complete newbie to mysql-sorry. I
>have a perl script that I am simply trying to dump three variables(name CHAR(30),
>email(50), and score INT) to a database table that has already be
At 9:50 AM -0400 5/17/01, Dave Carter wrote:
>We wanted users to be able to connect to a particular db remotely. Which
>would mean we would have to change their host to "%" This worked fine, but
>when we did that, we could not connect locally. In order to connect locally,
>we to create another use
Hi,
I have a table like this:
mysql> select id, ticketid, rdvwhen from rdv order by ticketid asc, id
desc;
++--++
| id | ticketid | rdvwhen|
++--++
| 1 | 18 | 2001050309 |
| 2 | 20 | 20010430153000 |
| 7 | 3
hello,
just want to start off saying that I am a complete newbie to mysql-sorry. I have
a perl script that I am simply trying to dump three variables(name CHAR(30),
email(50), and score INT) to a database table that has already been established.
having some difficulty and wanted to post t
I think the intention of the '%' is to use something like: '%.eliteukserve.net'.
I see your logic though. One would assume it should work. Interesting...
- Original Message -
From: "Dave Carter" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 2:50 PM
Subject: IS
Hi Milan,
The location you specified is the place where your tables are going to be
stored. However I was talking about the location of the TXT file that would
be used in the load of data.
As I said before, I placed the TXT file in the location you said but this is
not the place mySQL will lo
Hi, could someone point me to a tutorial on when to do table locking with the BDB
tables in MySQL?
I'm running version 3.23.37 on RH7.0 (with BDB tables :) and if I attempt to do
locking within a transaction, the transaction is automatically committed leaving me
with non-working transaction
Hello,
Quick (?) question:
I am happily running MySQL that I installed with an rpm installation.
However, I now want to install a source distribution version instead (I want
to be able to configure with a particular charset). Can I just take down the
server, and install the source distribution "ov
yep, spot on, also I didn't even need to specifically create the fields at
all.the Select clause does it for me...thanks very much for the helpI
can get on with the hard (for me) stuff now :-)
On Thursday 17 May 2001 03:22, Rolf Hopkins wrote:
> Original Message -
> From: "Ma
Hello mysql,
Currently mysql waits until disk space freed for myisam tables for
all situations exept of repair and optimize.
Even more table is marked as crashed and will not repair
automatically even after disk space freed.
This situation is not really good thing i think, as if r
Sorry Jorge. I thought that the individuals on this list would be
more qualified to answer a question regarding where a specific
installation (3.23.38 RPM) of MySQL placed specific files ( "header
files"? ) than would PHP users.
Justin Pease
On 17 May 2001, at 9:53, Jorge del Conde wrote:
>
Hi!
Steve corrected us: the option to use in mysqldump is
-e
or
--extended-insert
to generate multirow insert statements in the dump.
Then even autocommit=1 does not slow down table import to InnoDB
too much, because it does the commit only after several rows.
Regards,
Heikki
>Date: Thu, 1
Thanks for the responses. Unfortunately they didn't work. I tried
/usr/local /usr/local/mysql /usr/lib /usr/lib/mysql /usr/var
/usr/var/mysql and /usr/bin for the --with-mysql=/. command to
configure PHP4.
It still says "Header files not found at .. " Does anyone know
what
Hi,
This Q should be asked in the php lists instead, but in the mean time, try
configuring php like so:
./configure --with-mysql
that usually does the trick when RPM's are installed ...
Regards,
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del
Hi,
Yes, sounds great, it is possible to implement it in the next version
Andre
On 17-May-01 Michael Widenius wrote:
>
> Hi!
>
>> "Andre" == Andre Konopka <[EMAIL PROTECTED]> writes:
>
> Andre> Hi Michael,
> Andre> maybe something 'off topic'...
>
> Andre> I think a option to set
Ok, thanks for the input. I'll work on optimizing the code and look at the
indexes.
ryc wrote:
> Changing to C++ is not likely to give you a noticable speed difference
> because your bottleneck is not the code but the queries. With proper
> database design you should be able to acheive those res
The GET_LOCK() and RELEASE_LOCK() functions might help you,
if
you need this feature enough to build it yourself.
Cheers,
Kent Hoover
Feed the filter: database, query
-
Before posting, please check:
http://www.mysql.com/m
On Thu, May 17, 2001 at 06:36:23AM -0700, mansoor spake thusly:
*] i m new to mysql, how i can convert a string 28-MAR-2001 to date
*]
In what language?
--
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
Peter L. Berghold[EMAIL PROTECTED]
"Linu
Thanks for the hint. I'll try it with more tablespace.
The indexes have been optimized pretty much. I have to check whether I
can send you the table layout.
Just for your information. 3.23.38 has the same problem.
Heikki Tuuri wrote:
>Frank,
>
>there is obviously a bug in the insert buffer co
Hi!
> "Andre" == Andre Konopka <[EMAIL PROTECTED]> writes:
Andre> Hi Michael,
Andre> maybe something 'off topic'...
Andre> I think a option to set 'autocommit=0' is needed.
Andre> Last week I have made some data manipulation, stupidly my 'where condition' was
Andre> not correct. After pre
We wanted users to be able to connect to a particular db remotely. Which
would mean we would have to change their host to "%" This worked fine, but
when we did that, we could not connect locally. In order to connect locally,
we to create another user with the host value of localhost to get into th
At 09:12 17/05/2001 -0300, Paulo Arantes de Azambuja wrote:
Hi,
Thanks for the bug report, I was able to repeat the same
behavior on Win9x. We will fix this ASAP, while this please
use mysqld-max.exe instead of mysqld.exe.
Regards,
Miguel
>Got the following message after starting mysqld on WinME:
Frank,
there is obviously a bug in the insert buffer code of InnoDB. I will
look into it. The assertion failure indicates that there was not enough
free space on an index record page for a record cached in the insert buffer.
Your log files are ok. The size of log files does not constrain the
siz
Hi
i m new to mysql, how i can convert a string 28-MAR-2001 to date
Thanks
Hello,
When compiling mysql-3.23.8-alpha on Solaris 2.8 I get the following error:
mi_create.c: In function `mi_create':
mi_create.c:437: `MY_CHARSET_lAtin1' undeclared (first use in this function)
mi_create.c:437: (Each undeclared identifier is reported only once
mi_create.c:437: for each funct
This may border on the off topic side of things - But... does anyone know
how I can identify the type of MySQL specific error number occurred when a
DBI error (errstr() and err()) happens? The err() method is pretty generic.
I want to be able to identify MySQL's associated error number. I presume
Jausions, Philippe writes:
> Hi,
>
> Just wondering how to get through that "Can't connect to local MySQL server
> through socket '' (111)" error message with MySQL GUI for Linux (RedHat
> 7.0). I configured mysqlgui through ~/.my.cnf and client configuration file.
> I tried the static and semi-
Hi,
So far for everyone that asked about the permissions on my
directories that I've replied to, no one has said I had a permission issue.
We tried to upgrade to 3.23.37, and used :
gmake distclean
PATH=/usr/local/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/contrib/bin:/usr/X11/bin
Hi!
Would on the mailing list anyone know anything about LVM and fsync?
Jamie, do you know who has made that LVM?
Heikki
>Unfortunately I don't have an ordinary disk on that box. I'm thinking that
>InnoDB is having a major problem with LVM not ReiserFS. I tried it on an
>e2fs portion of the ser
Florin Andrei writes:
>
> Ok, finally i installed MySQL-bench with --nodeps (which is bad!).
>
> But, while trying to figure out how to use your test programs, i
> realised that they are poorly documented.
> I really don't have the time to dig into the scripts for information
> that should have
Apache is up to 1.3.17 at least. I would update apache and see what gives. PHP4
wasn't coded until Apache 1.3.15 was out.
"Dave Brooks, BCS Systems" wrote:
>
> Hello,
>
> I am trying to port a PHP/MySQL application that happily runs under Linux
> across to an AIX box.
>
> We have MySQL is runn
Steve and Monty,
yes, Monty is right, with
mysqldump --quick
you should get much faster import speed. But I have to correct
Monty: a big rollback segment does not slow down import
considerably.
Regards,
Heikki
At 12:25 AM 5/17/01 +0300, you wrote:
>
>Hi!
>
>> "Steve" == Steve Ruby <[EMA
> Is there a simple way to force mySQL to always return dates and
> datetime in
> ISO
> long format, without the '-', ':' and spaces? (in a TIMESTAMP(14) like
> format)
>
> I always want 20010517 rather than 2001-05-17,
> and 20010517130500 rather th
Paulo,
what MySQL version you are using? I released the source code
for InnoDB on Windows NT and 2000 at my website www.innobase.fi,
but I think it should not work on Win ME, because ME does not support
async i/o. You should compile with
#undef __NT__
on line 18 of mysql/innobase/include/univ
Got the following message after starting mysqld on WinME:
Innobase: Assertion failure in thread 4294849841 in file
M:\mysql-3.23\innobase\
os\os0file.c line 187
Innobase: we intentionally generate a memory trap.
Innobase: Send a bug report to [EMAIL PROTECTED]
010517 9:07:55 C:\MYSQL\BIN\MYSQLD
ke
format)
I always want 20010517 rather than 2001-05-17,
and 20010517130500 rather than 2001-05-17 13:05:00
Alternatively can I set the delimiters to '' or NULL somehow?
Things I DON'T want to do include:
str_replace() or =~ s/[- :]//g
SELECT SOMEFUNC(mydate) AS mydate
use
Hi Heikki,
now .38 is up and running
Thank you for your fast help
Andre
On 16-May-01 Heikki Tuuri wrote:
> Andre,
>
> try the following put on the line 330 in mysql/innobase/log/log0log.c
>
> lsn = log_reserve_and_open(OS_FILE_LOG_BLOCK_SIZE);
>
> Maybe gcc will compile in a diffe
>Description:
mysql --help states that the -e option produces output similar
to that of --batch. This is not the case.
>Fix:
Either the text or the program should be changed to conform
to each other.
>Release: mysql-3.23.33 (Official MySQL RPM)
>Environme
Hello,
I am trying to port a PHP/MySQL application that happily runs under Linux
across to an AIX box.
We have MySQL is running under AIX - using mysql we can create tables,
insert rows, etc and even access data via a C program.
PHP is running as an Apache module - a simple phpinfo() works.
Hi,
> I have to manipulate (or access) MySQL Database through pure C or
> C++, but I am not getting the exact libraries for it. Also, I don't
> know how to do it. Please anybody would tell me if it is possible
> or not. And if it is possible, then let me know how to do it and
> what to do for it.
Hi,
> Hi,
> I'm trying to use an if then alike statement in MySQL, myabe
> anyone can tell me the correct syntax if got a variable named
> naam. when the content of this variables is empty the following
> SQL statement should be executed:
> select * from beheerder;
> when naam is not empty:
> sel
Dear Friends,
I have to manipulate (or access) MySQL Database through pure C or C++,
but I am not getting the exact libraries for it.
Also, I don't know how to do it. Please anybody would tell me if it is
possible or not.
And if it is possible, then let me know how to do it and what to do for
i
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]
>Description: I have
> Hi:
>
> I'm having a memory leakage executing the next statement that
> iterates about 10 times within a loop in mysql 3.22.27:
>
> for (Count = 0 ; Count < 10 ; Count++)
> {
> mysql_query(mysql
> ,"LOAD DATA LOCAL
> INFILE '/tmp/FicN1N6.tmp'
>
Hi,
I'm trying to use an if then alike statement in MySQL, myabe anyone can tell me the
correct syntax
if got a variable named naam. when the content of this variables is empty the
following SQL statement should be executed:
select * from beheerder;
when naam is not empty:
select * from beheerde
80 matches
Mail list logo