HI
This is srikanth, and i am persuing my final semester of Masters in Computers
Applications in India,
I have been recently to you site on advice of one of my friend, and i have downloaded
your setup file from the net and installed the database and the odbc setup file both
in my c:\mysql di
Dear.
I have questions About Replicatation Features.
There is next sentence as follows (In Manual '11.4 Replication Features and known
problems')
>MySQL only supports one master and many slaves. We will in 4.x add a voting algorithm
>to automatically change master if something
goes wrong wit
Even my mysql is compile with Big5, I couldn't use Chinese charaters (big 5)
as column name. Is that normal?
==
Best Regards
Jason Kwok
==
---
Virus Free
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.274 / Virus Database: 144 - Release Date: 2001/8
Gary Huntress wrote:
>
> In the past few days 3 different people have asked me about "xml support" in
> mysql. I was unsure what to tell them actually, beyond saying "you can
> easily export recordsets to xml documents".Obviously you can store
> entire XML documents in a TEXT field, but I'm
Jason Kwok writes:
> Even my mysql is compile with Big5, I couldn't use Chinese charaters (big 5)
> as column name. Is that normal?
Did you quote the names? And did they contain any of the illegal
characters discused in
http://www.mysql.com/doc/L/e/Legal_names.html ?
I wonder why ÿ is not allo
Hi,
I have Windows NT 4.0 (build 1381/SP6a) running IIS4 Webserver (
http://www.abadon.net or 212.30.85.173 ) connected via CableModem/LAN to
Internet. I have also PHP ( Version 4.0.6 )scripting engine and MySQL server
( Client API version 3.23.32 said PHP info page, but in WinMySQL admin Ver
1.3
Ed,
Thanks for the email. I was a bit tired last night and was a little frustrated (4
nights getting nowhere), so apologies if I was little rude (I've just reread my email)
and
sarcastic, but thanks for the 'Details' pun. I've dug myself into a hole offering to
set up a Linux/Apache Webserver
In a SQL like : SELECT table1.f1,table2.f1 FROM table1,table2
you get a listing like this.
+++
| f1 | f1 |
+++
| 1 | 1 |
| 1 | 2 |
| 1 | 3 |
+++
When using the DBI function fetchrow_hashref() you get only one value since
the key is not unique.
Is there a way to get
At 10:33 05/09/2001 +0200, abadon wrote:
Hi,
>Hi,
>
>I have Windows NT 4.0 (build 1381/SP6a) running IIS4 Webserver (
>http://www.abadon.net or 212.30.85.173 ) connected via CableModem/LAN to
>Internet. I have also PHP ( Version 4.0.6 )scripting engine and MySQL server
>( Client API version 3.23.
)-Original Message-
)From: Deryck Henson [mailto:[EMAIL PROTECTED]]
)Sent: Tuesday, September 04, 2001 10:10 PM
)To: [EMAIL PROTECTED]
)Cc: MySQL
)Subject: Re: What does this error mean??!!
)
)
)Would you be so kind as to do that step by step? I'm very new to this and
)don't know half th
>Description:
Mysql doesn't allow to alias locked tables. See "how to repeat"
for details. This problem make impossible to use more complex
"select" queries on locked tables.
>How-To-Repeat:
-- let's suppose there's a MyISAM table "testtable"
lock tables tes
Hi,
Ive just started playing about with MySQL. I created a database called
haworth, no problem there, then created a table called list.
I put 3 entries in it, and checked it using
SELECT * FROM list;
It showed all the records fine. The MySQL server is running on NT, and I can
connect remot
[EMAIL PROTECTED] writes:
> 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
> one of the following words in your message:
>
> database,sql,query,table
>
> If you just reply to this message, and includ
Hi folks!
I need to search a mysql database using wildcards. I know about the * and
the _ wildcards (any number of any character and 1 character of any kind,
respectively) but I need to match any number, any letter and thing like
that.
An SQL book claimed it could be done using brackets and
Iago Sineiro writes:
> Hi all.
>
> When is supposed the 3.23.42 mysql version released?
>
> Iago.
>
Very soon.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /
> I need to search a mysql database using wildcards. I know about the * and
> the _ wildcards (any number of any character and 1 character of any kind,
> respectively) but I need to match any number, any letter and thing like
> that.
>
> An SQL book claimed it could be done using brackets and rang
Carlos Augusto Perez Lima writes:
> Hi,
>
> I'm trying to install the mysql for Compaq Tru64 Unix 4.0f. I did the
> download of file < mysql-3.23.41.tar >
> # ./configure.
> # make
> ...
> ...
> + rm -f ./typelib.c
> + /sbin/ln -s ../libmysql/typelib.c ./typelib.c
> + rm -f ./violite.c
> +
>I used MySQLGUI 1.7.5 binary with Red Hat 6.2. and MySql 3.22 All the functions
>except table related functions (specially table create functions) are working
>Do let me know what i should do to make the table create function work
>regards
>venkatesh
>e mail - [EMAIL PROTECTED]
>
Peter Duffy writes:
> Hi Sinisa,
>
> My problems are within the mysqlclient and MyODBC libraries, both used
> directly by the application (and therefore all on the "client" side of
> the socket.) Both the mysqlclient and MyODBC libraries do (or in my case
> did) contain calls to the DBUG function
BSD/OS 4.0.1, MySQL source 3.23.41, gcc 2.7.2.1, gmake 3.75,
latest m4, autoconf, aclocal and automake:
../configure --prefix=/home/[u]/[user]/mysql --disable-shared \
--with-unix-socket-path=/home/[u]/[user]/mysql/run/mysqld.sock \
--with-tcp-port=[port] --with-mysqld-user=[user] \
--with-low-
Brad Stockdale writes:
> Hello all,
>
> I'm new to the list... Been using MySQL for various things for a year
> now, but have never ran into the following situation...
>
> I have a flat text file that I have exported from FileMaker Pro. I want
> to import that into MySQL, but there's a
>
> Since the crash happens in the client directory, I tried even
> configuring --without-client in pure desperation. It didn't
> help; the compiler went into the client directory even then
> and crashed just the same way.
>
> Does anyone know how to fix this?
>
After you run the
I want to build a VB application that connects to mysql (over the internet)
running on linux. i have mysql currently running on LAMP system fine, but do
i just need to install MyODBC for linux on the mysql server or what?
also, are there any major security issues to this i should know about? any
h
IS their and ISP tracking list for MySQL adopters?
--
contact:
Dave Yadallee NetLine 2000 The Edmonton Internet Service Company
[EMAIL PROTECTED] http://www.nl2k.ab.ca
990-3244
-
Before posting, please check:
http://www.my
Ken Menzel writes:
> Hello Sir,
> Your return of Poll 1 seems to indicated that there is a descriptor
> ready to be serviced (hence the going in continuosly) but that the
> daemon does not seem to be able to complete the servicing of that
> descriptor. I am not sure why your daemon skips 'cloc
[EMAIL PROTECTED] writes:
> Hi People,
>
> I'm trying to connect to Mysql server using Access2k, VBA and DSN less
> connection, and mysql v3.23.36.
>
> All queries sent to the server exceute or returns records just fine except
> one simple query.
>
>
> "show datbases ..." is OK
> "describ
Neil Zanella writes:
>
> On Tue, 4 Sep 2001, Sinisa Milivojevic wrote:
>
>
> Red Hat 7.1 has a very nice apache + mysql + php installation and invoking
> mysql function calls from the php interface works very well. The only
> aspect that puzzles me a little bit is that when I look at the output
On Wed, 5 Sep 2001, Sinisa Milivojevic wrote:
> > Red Hat 7.1 has a very nice apache + mysql + php installation and invoking
> > mysql function calls from the php interface works very well. The only
> > aspect that puzzles me a little bit is that when I look at the output of
> > phpinfo(); I see
Hi Russell,
have you applied patches M410-008, M410-012 and most important
M410-014? Even after applying the patches there are major thread
problems (althought MySQL should 'run' ). My advice to you is to
update to 4.2 which seems to fix the threads problems, and apply
current patches as ther
Hi guys,
I've a question using the c-api.
I sent a query to the server with
mysql_query( pConnHandleArr[iDbHnd], pcQuery )
and stores the result on the client locally with
pResSetArr[iDbHnd] = mysql_store_result( pConnHandleArr[iDbHnd] );
What happens if I do not free the
[EMAIL PROTECTED] writes:
>
>
>
> >I used MySQLGUI 1.7.5 binary with Red Hat 6.2. and MySql 3.22 All the functions
>except table related functions (specially table create functions) are working
> >Do let me know what i should do to make the table create function work
> >regards
> >venkatesh
>
De-install gcc 2.7.2.1 and install 2.95.2 or gcc 3.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql
Is that the correct location for mysql.sock?
If yes, is it world readable and writeable?
If no, is the socket location defined in /etc/my.cnf?
If it is, this file must be world readable.
½ÉÃ溸 wrote:
> I installed linux and mysql 3.23.40.
> Root installed and started mysql and user (charley) w
Read the manual, especially the section on the GRANT command.
Roland Thompson wrote:
> Hi,
>
> I've just started playing about with MySQL. I created a database called
> 'haworth', no problem there, then created a table called 'list'.
> I put 3 entries in it, and checked it using
>
> SELECT * F
Jason Bailey ([EMAIL PROTECTED]) writes:
> >>You mean "/var/lib/mysql/mysql.sock"? Details are IMPORANT.
>
> Yes, thanks for the pun. It was the above "/var/lib/mysql/mysql.sock" and I noted
>that deleting it and then running mysql_install_db or possible safe_mysqld
>recreated.
Well, it wa
Terje Kristensen ([EMAIL PROTECTED]) writes:
> In a SQL like : SELECT table1.f1,table2.f1 FROM table1,table2
> you get a listing like this.
>
> +++
> | f1 | f1 |
> +++
> | 1 | 1 |
> | 1 | 2 |
> | 1 | 3 |
> +++
>
> When using the DBI function fetchrow_hashref() you
The slave does not have a server-id.
Duc Chau wrote:
> Hi, this is my first time posting to the list. I've followed mysql
> replications how-tos to a tee...and I am still not able to get it to work.
>
> the master mysql is running on a sun sparc station (SunOS 2.8) with mysql
> 3.23.41
>
> th
Hi John,
> I've noticed rare occasions (about 1% of the time) when poll()
returns 0
> -- these are always preceeded in the trace output by a signal
handler,
> like this:
> 45689 mysqld 0.08 CALL sigreturn(0x826ae7c)
> 45689 mysqld 0.10 RET sigreturn JUSTRETURN
> 45689 mysqld 0
)-Original Message-
)From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
)Sent: Wednesday, September 05, 2001 5:35 AM
)To: [EMAIL PROTECTED]
)Cc: [EMAIL PROTECTED]
)Subject: Re: DSN-Less connection Strange error!
)
)
)[EMAIL PROTECTED] writes:
)> Hi People,
)>
)> I'm trying to connect to
I have to insert a file wav into a blob field of a
table. Is that possible?And how can I do it?
Thanks in advance.
__
Do You Yahoo!?
Il tuo indirizzo gratis e per sempre @yahoo.it su http://mail.yahoo.it
---
Hi,
I'm using MM JDBC driver version 2.0.4 to access a MySQL database
3.23.40 on Solaris 2.8.
When I do the following query "SELECT NOW()", I always get String data
and not Date data when fetching the data.
Is it normal that Date functions returns a String? Is this a MySQL bug?
Th
Hi Srikanth
)-Original Message-
)From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
)Sent: Wednesday, September 05, 2001 12:56 AM
)To: [EMAIL PROTECTED]
)Subject: I am facing problems in creating tables
)
)
)HI
)
)This is srikanth, and i am persuing my final semester of Masters
)in C
Hello Roland,
Basically users are defined with their 'hostname'. So if i dial in
from my isp it might be [EMAIL PROTECTED] so I have to define rights to
that user.
Along with the manual bit below .. you might want to get Paul DuBois's
great book on Mysql.
This bit is from the manual .. 7.35
)-Original Message-
)From: Roland Thompson [mailto:[EMAIL PROTECTED]]
)Sent: Wednesday, September 05, 2001 3:38 AM
)To: [EMAIL PROTECTED]
)Subject: Can't connect to source
)
)
)Hi,
)
)Ive just started playing about with MySQL. I created a database called
)haworth, no problem there, then
Hi !!!
)-Original Message-
)From: Ghislain Gadbois [mailto:[EMAIL PROTECTED]]
)Sent: Wednesday, September 05, 2001 7:37 AM
)To: MySQL List (E-mail)
)Subject: Date functions returning Strings
)
)
)Hi,
)
)I'm using MM JDBC driver version 2.0.4 to access a MySQL database
)3.23.40 on Sola
Hi everyone,
I just installed MySQL on my linux box. But when I tried to connect to my
own box with jdbc (jdbc:mysql://localhost/red), it gave me "SQLException:
server configuration denies access to data source". I have already added
root in the mysql.user and mysql.db, why is this happening
On Wed, Sep 05, 2001 at 04:44:01PM +0300, Sinisa Milivojevic wrote:
> De-install gcc 2.7.2.1 and install 2.95.2 or gcc 3.
Stay with gcc 2.95.X until 3 is fixed!
> --
> Regards,
>__ ___ ___ __
> / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
> / /|_/ /
Ed,
Once again, thanks for the email response. I'm going to try all the suggestions I've
received.
A colleague has suggested as I'm new to Linux to select the 'Install Everything'
option in red hat 7.1. He suggests that it's probably easier (for me) to get everything
installed and work backwa
This may not be the best workaround, but I changed the 'localhost' to my
actual server url, and then it worked.
Someone else mentioned this as a means of fixing privileges:
http://sourceforge.net/forum/forum.php?thread_id=123272&forum_id=50480
cheers,
Brett
-Original Message-
From: Sil
During my attempt to configure the 3.23.41 source, I encountered the error:
"configure: error: no acceptable cc found in $PATH". As I'm using gcc on
this box, where/how do I identify gcc for configure to use properly?
Thanks,
Brian
--
=?iso-8859-1?q?Cinzia=20Rubattino?= ([EMAIL PROTECTED]) writes:
> I have to insert a file wav into a blob field of a
> table. Is that possible?And how can I do it?
Bad, bad, BAD IDEA!
Read: http://www.bitbybit.dk/mysqlfaq/faq.html#storing_images
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/3
Dear Sirs and Madams,
EMS HiTech company is announcing the NEW software MySQL Manager --
A Powerful MySQL Administration and Development Tool.
You can download the latest version from
http://www.mysqlmanager.com/download.phtml
What is the EMS MySQL Manager?
EMS MySQL Manager provides you power
I am new to MySQL. I've installed the package under SuSe Linux 7.1
(kernel 2.4). When I try to start the database using commands from the
manual I get the following message.
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock'. I'm pretty much lost at this point as I
hav
If i put a server-id in the slave my.cnf file and start up the database with
safe-mysqld, it starts and dies with this error in the log file.
unrecognized option `--server-id=2'
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 7:25 AM
subnet writes:
> Hi,
>
> I'm running OpenBSD 2.8 and MySQL 3.22.32 (recent cvs port).
>
> After time (< 1day) the cpu load for the mysqld process goes up to
98%..
>
> Is this a known problem? any ideas?
> Thanks,
> Stu
>
>
> Hi! There is a known problem in 2.8 thread library. I do no
Hi,
I'm using :
- Win NT 4.0 SP6
- Apache 1.3
- PHP 4.05
- MySQL 3.23
When I try to upload JPG files, the temporay files on the server are OK.
But when I store them into a BLOB field into mySQL, some images (not all)
are truncated after some lines.
It's like an EOF byte found ...
The SQL is:
$reqS
OK simple stuff
Did mysql_install_db work ok?
When you do a ps can you see any thing runing?
Are you stating it from the right place?
/use/local/mysql/bin/safe_mysql &
It will be somthing simple so if you just go over stuff it will work...
Than you will be flighing...;o)
Simon
-Original Me
hi.
assuming you're using a bash-type shell and gcc is in /some/directory/gcc
>PATH=$PATH:/some/directory
>export PATH
>echo $PATH
otherwise:
>setenv PATH /some/directory:${PATH}
if more errors crop up, copy and paste the error message into google and see
if any relevant results are returned.
h
Hi,
I'm using :
- Win NT 4.0 SP6
- Apache 1.3
- PHP 4.05
- MySQL 3.23
When I try to upload JPG files, the temporay files on the server are OK.
But when I store them into a BLOB field into mySQL, some images (not all)
are truncated after some lines.
It's like an EOF byte found ...
The SQL is:
$reqS
> Hi,
> I'm using :
> - Win NT 4.0 SP6
> - Apache 1.3
> - PHP 4.05
> - MySQL 3.23
> When I try to upload JPG files, the temporay files on the server are OK.
> But when I store them into a BLOB field into mySQL, some images (not all)
> are truncated after some lines.
> It's like an EOF byte found .
>I'm running OpenBSD 2.8 and MySQL 3.22.32 (recent cvs port).
>After time (< 1day) the cpu load for the mysqld process goes up to 98%..
>There is a known problem in 2.8 thread library. I do not know
>when will they fix it. You can ask them , though ..
>I've seen that this has been addressed in th
At 6:35 PM +0200 9/5/01, Carsten H. Pedersen wrote:
> > Hi,
>> I'm using :
>> - Win NT 4.0 SP6
>> - Apache 1.3
>> - PHP 4.05
>> - MySQL 3.23
>> When I try to upload JPG files, the temporay files on the server are OK.
>> But when I store them into a BLOB field into mySQL, some images (not a
Hi Derek,
- Original Message -
From: "Derek Sivers" <[EMAIL PROTECTED]>
>
> But with LOTS of MySQL traffic (20,000 unique users a day on a 100%
> MySQL-driven website) - yes the mysqld process goes up to 99% and
freezes
> the server until I reboot.
>
Have you tried capturing informati
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
>
> At 6:35 PM +0200 9/5/01, Carsten H. Pedersen wrote:
> > > Hi,
> >> I'm using :
> >> - Win NT 4.0 SP6
> >> - Apache 1.3
> >> - PHP 4.05
> >> - MySQL 3.23
> >> When I try to upload JPG files, the temporay files on
Hello!
It seems that with a wrong command:
mysql> delete from user where host='%';
I have casually deleted all data in user table :(((
It works for now but after "reload" all data in the table will be lost ...
Can I recover the user table in such a situation ???
Thank you !
--
Piter
At 7:34 PM +0200 9/5/01, Carsten H. Pedersen wrote:
> > -Original Message-
>> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
>>
>> At 6:35 PM +0200 9/5/01, Carsten H. Pedersen wrote:
>> > > Hi,
>> >> I'm using :
>> >> - Win NT 4.0 SP6
>> >> - Apache 1.3
>> >> - PHP 4.05
>> >>
I'm trying to use a socket besides the standard /tmp/mysql.sock one. I've
tried specifying socket=/path/to/socket in both [client] and [mysqld]
sections of my.cnf, and I've tried to edit safe_mysqld directly with this
path. In all cases, the mysql server appears to start (no error messages
are g
Hello again !
Sorry I made some mistakes.
The the wrong command was - DELETE FROM user WHERE Host LIKE "%";
and got this:
mysql> select * from user;
Empty set (0.00 sec)
Can I recover the user table in such a situation ???
Thanks agin.
> It seems that with a wrong command:
>
> mysql> delet
> I'm trying to use a socket besides the standard /tmp/mysql.sock one. I've
> tried specifying socket=/path/to/socket in both [client] and [mysqld]
> sections of my.cnf, and I've tried to edit safe_mysqld directly with this
> path. In all cases, the mysql server appears to start (no error messag
Yes, I gave it 644 permissions.
- Original Message -
From: "Carsten H. Pedersen" <[EMAIL PROTECTED]>
To: "BW (ST)" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 10:58 AM
Subject: RE: 'tmp/mysql.sock' (2) error
> > I'm trying to use a socket be
Hi!
Since I heard Monty is in Sweden, which will probably delay
the release of 3.23.42 still a couple of days, I decided to
release the InnoDB-3.23.41b source at my website
http://www.innodb.com right now.
The release fixes the bad BLOB bug where any update of
the primary key of a > 8000-byte ro
I am New at this Mailing List, `cause of it first of all lemme say Hi to
everybody...
I`m facing a problem with my Web Server, it`s a Conectiva Linux, running
Apache
We had a problem with it last night, all configuration files were lost and
were forced to recover the backup. After this, trying to
Hi all
Is there a document available somewhere outlining
some guidelines regarding what parameters should be
set in the my.cnf files for the MySQL database and to
what values?
thanks
=
__
Do You Yahoo!?
Get email alerts & NEW webcam
Hello all,
I am trying to integrate the mysql with php. As I am using the Red Hat
7.0, I know that they come pre-installed and pre-configured. When i
created test.php with the line, the page shows that
the php is able to recognize the presense of mysql. I created a small
table 'namelist' in a da
Chakravarthy K Sannedhi wrote:
> $db=mysql_connect ("localhost","myname","mypassword");
> mysql_select_db ("newone",$db);
> $result = mysql_query ("select * from namelist");
[snip]
> Warning: MySQL Connection Failed: Can't connect to local MySQL server
> through socket '/var/l
hmm. Are you sure that MySQL is running? Conversely, does the file
/var/lib/mysql/mysql.sock exist?
Steve
At 11:52 AM 9/5/01 -0700, Chakravarthy K Sannedhi wrote:
>Hello all,
>
>I am trying to integrate the mysql with php. As I am using the Red Hat
>7.0, I know that they come pre-installed a
Hi,
I' have installed mysql on linux 7.1 and
when a web application open a new session of mysql it remain
opened in memory, so my server goes in memory overload.
please help me.
thanks
P.S.: Sorry for my english !!!
-
Before
Well, this is a client error, not a server error.
What client is this?
Maybe you have another my.cnf in the data directory,
or possibly a .my.cnf file in your home directory.
BW (ST) wrote:
> I'm trying to use a socket besides the standard /tmp/mysql.sock one. I've
> tried specifying socket=/pa
Is it possible to modify the following query:
SELECT COUNT(*) AS pass WHERE test=x AND value BETWEEN low AND high;
to also count the total number of records where 'test=x'
and hence return the percentage pass mark all within one statement, or am I
stuck using 2 statements 1 as above to count the
I think your slave version is too old.
Duc Chau wrote:
> If i put a server-id in the slave my.cnf file and start up the database with
> safe-mysqld, it starts and dies with this error in the log file.
>
> unrecognized option `--server-id=2'
>
>
> -Original Message-
> From: Gerald Clar
I need to read the fields of a table dynamically using
DBI.pm
The resulting cgi script should be a form that has a
checkbox for each field...the user will then create a
temporary table based on which fields are checked in
the form.
=
--
Anthony Ettinger
[EMAIL PROTECTED]
415-504-8048
http:
SELECT SUM( test=x ) AS total, COUNT(*) AS pass FROM table WHERE text=x AND
value BETWEEN low AND high;
b.
Chris Thorpe wrote:
> Is it possible to modify the following query:
>
> SELECT COUNT(*) AS pass WHERE test=x AND value BETWEEN low AND high;
>
> to also count the total number of records
Apologies for the off topic, but I'm collecting some information, and I
figured the lists that I'm on would provide a good feedback mechanism.
Replies to me off-list if you would please. My apologies for the very
short notice, but I just heard that I need this by ~8 AM EST Thu 6th
Sept :(
A col
my $dbh = DBI->connect( ... );
my $sth = $dbh->prepare( "SHOW COLUMNS FROM $table" ) or die;
$sth->execute( ) or die;
my @columns;
while( my( $column_name ) = $sth->fetchrow_array( )){
push @columns, $column_name;
}
$sth->finish( );
b.
"Anthony E." wrote:
> I need to read the fields of a ta
On Wed, Sep 05, 2001 at 08:30:53PM +0100, Chris Thorpe wrote:
> Is it possible to modify the following query:
>
> SELECT COUNT(*) AS pass WHERE test=x AND value BETWEEN low AND high;
>
> to also count the total number of records where 'test=x'
> and hence return the percentage pass mark all with
Hello,
I keep getting this:
insert into tmp select * from ascend_log_2001_08_25;
ERROR 1114: The table 'tmp' is full
tmp is a heap table
I've looked through the docs and mailing list archives and can't find anything
that matches my problem. I'm using 3.23.41 so it should switch to disk if it
On Wed, Sep 05, 2001 at 07:59:15AM +0800, Steve Doig wrote:
> Hi Folks,
>
> I'm running a batch command in win2K: cmd> mysql < batch-file > output.txt
> In the batch file, can I specify that values are separated by commas instead
> of tabs?
>
> Cheers,
> Steve
>
not using that syntax but with
I've been running a master/slave MySQL database system for about four months now and
I've got nearly 360mb of binary logs. I want to archive anything over about a month
old, but I've heard that there is a procedure that you have to go through to do that.
---
Hi folks, just signed up to the list so I hope this is the correct place to
send such a question:
I have recently upgraded to Red Hat Linux 7.1 from Red Hat 6.x
I had successfully run MySQL under that distribution but am having problems
with it under Red Hat 7.1
I have installed mysql-3.23.36
On Wed, Sep 05, 2001 at 03:46:03PM -0400, Duncan Hill wrote:
> A college graduate, with only an Associate's Degree and a CCNE
> approaches you/your company, with a resume that indicates no experience
> whatsoever, just the schooling from an associate's degree, a CCNE and
> knowledge of layers 1 -
"Adams, Bill TQO" wrote:
> SELECT SUM( test=x ) AS total, COUNT(*) AS pass FROM table WHERE text=x AND
> value BETWEEN low AND high;
>
> b.
Ugh, brain fart.
SELECT COUNT(*) AS total, SUM( value BETWEEN low AND high ) AS pass FROM table
WHERE text=x;
--Bill
-
FVFM (thats: From the Very Fine Manual )
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Databa
se_Administration.html#SHOW_VARIABLES
You may have the above line split by your mail reader, just cut and
paste the two havles in or go to:
http://www.mysql.com/documentation/mysql/bych
[EMAIL PROTECTED] wrote:
> Hello,
>
> I keep getting this:
>
> insert into tmp select * from ascend_log_2001_08_25;
> ERROR 1114: The table 'tmp' is full
>
> tmp is a heap table
There is a size limit to temp tables. See:
http://www.mysql.com/doc/F/u/Full_table.html about increasing the allowed s
Greetings,
This morning we sucessfully inserted a new record on our master MySQL
machine. 4 1/2 hours later, the change showed up on the slaves. I was
under the impression that MySQl replication would occur in a more timely
fashion.
We have a single master with 4 slaves replicating only one o
[EMAIL PROTECTED] (Jason Bailey) writes:
> >If the server is creating mysql.sock in and something else is looking
> >for it in /tmp, this is the easiest way to get it to work, besides
> >checking to make sure that the permissions are such that anyone who
> >needs to can read and write to mysql.so
Hi!
I am trying to understand and fix a severe performance problem I am having
with MySQL for some weeks now, but to no avail. So I am coming here, hoping
you understand more than I do (which is not very hard to do :-)
Im am running mysql 3.23.41 (from the mysql-server-3.23.41-1 debian
packag
I can't help you with your problem, because I have almost the same thing
happening to my server every 2-3 days. It is exactly as you described
Please someone offer us suggestions??
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
- Original Message -
From: "He
On Wed, Sep 05, 2001 at 11:10:49PM +0200, Henning Schroeder wrote:
> Looking in the process table reveals (when the page is fast) lots of
> sleeping processes, sometimes (when the page is slow -- 30sec to load a web
> page) lots (20+) processes that are locked. Usually they are some SELECTs
> a
Try something like putting a peice of code (asuming you are using something
like ASP/PHP)
Session_On_end()
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: "Claudio Muzzio" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 2:09 PM
Subje
--- Steve Suehring <[EMAIL PROTECTED]> wrote:
>
> hmm. Are you sure that MySQL is running? Conversely, does the file
> /var/lib/mysql/mysql.sock exist?
>
> Steve
The mysql server is running and the mysql.sock file exists. Also I am
able to connect to the mysql database by any of the follow
1 - 100 of 142 matches
Mail list logo
