Do you know what is differnet between command
mysql_connect and
mysql_pconnect
Thankx
This is a PHP question. This should've been the first
place you looked:
http://us2.php.net/manual/en/index.php
mysql_connect
http://us2.php.net/manual/en/function.mysql-connect.php
mysql_pconnect
i have mysql server located in in machine that used Red Hat 8.0
and my mysql server version was 3.23.58. I am trying to connect
using my machine..And currently i used Red Hat Fedora...But when
i am trying to connect to mysql server i got this error
message.
ERROR 2013: Lost connection to
Andy,
Thanks a lot for the response. We are using Linux OS. Is there any
configuration parameter that enables more frequent flush or a parameter
that enables direct write to disk and any idea about performance
implications.
Thanks once again,
Ravi
-Original Message-
From: andy
In article [EMAIL PROTECTED],
dan orlic [EMAIL PROTECTED] writes:
i have an question about ordering a set of records...
ab c d
-
1Tax 120001.33
1Tax 115002.5
1
Titus, Jeff,
- Original Message -
From: Jeff Smelser [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Tuesday, November 23, 2004 11:24 PM
Subject: Re: I need to understand INNO better.
--nextPart3014813.KeZKZSIgGj
Content-Type: text/plain;
charset=iso-8859-1
On 23 Nov 2004 at 22:36, Tim Trice wrote:
How can I reset the permissions on my database? I have no clue when I did
it (at least several months ago), haven't used it until today but I cannot
for the life of me figure out how I can create a new user with all
permissions. The only user I have
How to upgrade from 3.23.58 to 4.1.7? Which is the easiest way with minimal
risk and downtime?
Background: Heavy loaded mysql server, only one database but it is huge -
5GB.The database is replicated to another server.Mysql 3.23.58.Linux OS.
Here is the my plan, please correct me if there is a
What is the best client program that I can use to get connected to MySQL
remotely? I'm running Windows 2000...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I know this is not the exact topic of the list but I am sure some people
from this list spend some time on it.
I am new to VC++ but getting better indeed. I need help on how to connect to
MySQL server.
I need a connector and an example. It must be free because this is a student
project :)
Hi,
I use those 2...
MySQL Control Center
http://www.mysql.com/products/mysqlcc/
PHPMyAdmin
http://www.phpmyadmin.net/home_page/
Cheers...
- Original Message -
From: Scott Hamm [EMAIL PROTECTED]
To: 'Mysql ' (E-mail) [EMAIL PROTECTED]
Sent: Wednesday, November 24, 2004 2:38 PM
Isn't there any text-based program like telnet.exe or putty.exe that allows
me to use similiar to 'cmd'?
-Original Message-
From: Ferhat BINGOL [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 24, 2004 8:47 AM
To: Scott Hamm; 'Mysql ' (E-mail)
Subject: Re: Client program
Hi,
I use
Hello People
I should have the count from 3 tables in one query; something like this:
select count(*) from table1 union select count(*) from table2 union select
count(*) from table3 union;
The Problem ist, that the query gives 3 results back (the count from table1,
table2 and table3) BUT I
http://dev.mysql.com/doc/administrator/en/mysql-administrator-menus-tools-mysql-command-line-client.html
this may cheer you up than...
- Original Message -
From: Scott Hamm [EMAIL PROTECTED]
To: 'Ferhat BINGOL' [EMAIL PROTECTED]; Scott Hamm
[EMAIL PROTECTED]; 'Mysql ' (E-mail) [EMAIL
You may have noticed that Monty I have spoken out against software
patents regularly. We have actually been fighting them since way before
MySQL! For example David joined the LPF (see lpf.ai.mit.edu) in 89/90.
We believe that software patents will work against software developers
by enabling the
just to save your time..
C:root/to/mysql/dir/bin/mysql.exe -h HOST_NAME_HERE -u USERNAME -p
you will be promt for password.
- Original Message -
From: Scott Hamm [EMAIL PROTECTED]
To: 'Ferhat BINGOL' [EMAIL PROTECTED]; Scott Hamm
[EMAIL PROTECTED]; 'Mysql ' (E-mail) [EMAIL PROTECTED]
I need to store huge data series using MySQL with InnoDB as storage
engine. The data type of the parameters can be double, float, int,
smallint, mediumint, tinyint So, I've thought to store them in
the following way:
Table Parameter:
Parameter ID - small int
Parameter Name - varchar(8)
Hi
I am new to VC++ but getting better indeed. I need help on how to connect
to
MySQL server.
This is a big topic and as you say not really appropriate here. Join this
MSVC list and I'll help you there:
http://peach.ease.lsoft.com/archives/msvc.html
Regards
Paul
Paul Grenyer
email: [EMAIL
This is MySQL 4.1.5-gamma-max on Darwin Kernel Version 7.6.0 (OS X
v10.3.6), installed via the Mac OS X installer.
mysql select gid, fbin from fdata where gid = 3557 order by fbin;
+--+--+
| gid | fbin |
+--+--+
| 3557 | 1000.007086 |
| 3557 |
Is there a reason you aren't using the mysql client that comes with the
server? I am on a W2K machine and I can connect and interact with every
MySQL server on our network from it. A useful by-product of setting this
up is that you can have your own MySQL server on your machine. That has
been
Using mySQL 4.0, I would like to know how I can code a query that will change
the value of Participants.Active from Y to N is for three or more CONSECUTIVE
sessions they have Attendance.Present = 'No'?
The Attendance Table has Attendance.Session which coresponds to
Sessions.SessionID and
I have three questions about mysql.
1.
mysql CREATE TABLE board (
- boardid char(6) binary NOT NULL,
- title varchar(128) binary NOT NULL,
- ) ENGINE=MYISAM;
Query OK, 0 rows affected, 0 warning (0.00 sec)
mysql desc board;
+--+--+--+-+-+---+
| Field |
- Original Message -
From: Martin Rytz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 24, 2004 8:47 AM
Subject: Multiple table count in one sql-query
Hello People
I should have the count from 3 tables in one query; something like this:
select count(*) from
RTFL. THIS HAS BEEN ASKED AND ANSWERED TWICE BEFORE. If you have problems
with the answers, address the answers. Stop re-posting!!!
1. http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html
2. The physical sequencing of the records on disk is out of the
administrator's control.
3.
On Wednesday 24 November 2004 04:02 am, Heikki Tuuri wrote:
Only two ways to make copies of innodb.. mysqlhotcopy (its not free)
mysqlhotcopy is free, but it works only for MyISAM.
See:
http://dev.mysql.com/doc/mysql/en/Backing_up.html
Sorry, I meant the hot backup tool for innodb.. ;)
On Wednesday 24 November 2004 07:32 am, Hristo Chernev wrote:
How to upgrade from 3.23.58 to 4.1.7? Which is the easiest way with minimal
risk and downtime?
Yeah right.. ;)
Background: Heavy loaded mysql server, only one database but it is huge -
5GB.The database is replicated to another
How about:
select (@CNT:=count(*)) FROM table1
union
select (@CNT:[EMAIL PROTECTED](*)) from table2
union
select (@CNT:[EMAIL PROTECTED](*)) from table3;
If you want only the sum:
(select (@CNT:=count(*)) FROM table1)
union
(select (@CNT:[EMAIL PROTECTED](*)) from table2)
union
(select
Rhino wrote:
- Original Message -
From: Martin Rytz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 24, 2004 8:47 AM
Subject: Multiple table count in one sql-query
Hello People
I should have the count from 3 tables in one query; something like this:
select count(*) from
A little off topic, sorry, but I am wondering if anyone has any good
Mac Web Dev resourses that i may find useful. Right now I am trying to
figure out how to install mySQL to get my local dev setup and any
pointers would be appreciated.
Thanks
Wikki
--
MySQL General Mailing List
For list
Hi all,
I have problem by using PHP and MySQL. I have installed MySQL Server
4.1.7 on a Linux machine with Apache. PHP interpreter has been
installed on it by default but I am not sure if PHP modules for MySQL
has been installed too or not. On MySQL download section there is only
some
You didn't say which Linux you were using and I am not sure about the rest,
but if you are using RedHat, you probably need to install php-mysql which
is A module for PHP applications that use MySQL databases. If you can
use up2date, you can type in up2date php-mysql and that will let you run
[snip]
I have problem by using PHP and MySQL. I have installed MySQL Server
4.1.7 on a Linux machine with Apache. PHP interpreter has been
installed on it by default but I am not sure if PHP modules for MySQL
has been installed too or not. On MySQL download section there is only
some
Hello,
If you aim for for absolute control over the storage (the fileystem
nature is the limit), and speed, do not use an SQL system. Of course,
you would have to face all the trouble of writing your own
mini-engine/subsystem for the job. It all comes down to what your
needs are and how much
Things are pretty much the same for the Mac as any other Unix platform,
so there aren't too many sites out there that will give you Mac
specific stuff. Any instructions for Unix/Linux are pretty much the
same for the Mac, except for the darn path differences between Unix
platforms. You should
Jay Blanchard wrote:
snip
This is probably a better question for a PHP list.
Do you know of one? ;)
If you're running a rpm based distro (RedHat, Fedora, etc.), and you
have php installed by rpm, you should just need to install the php-mysql
rpm, and restart Apache.
--
John C. Nichel
ÜberGeek
I wish everyone a good and fateenin' Thanksgiving from United States!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
We are shortly to go live with a new set of databases (InnoDB).
The data in each database is identical in fields and types, the only
difference being in the relevance of the data - they are soccer leagues,
and each database represents information on the leagues/teams for a
single season.
Wamp servers are an excellent windows install for It elimininates those
little hiccups
http://www.wampserver.com/en/index.php
Thanks
Donny Lairson
President
http://www.gunmuse.com
469 228 2183
-Original Message-
From: Danesh Daroui [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November
Gents,
Upgrading to Mysql 4.1.7 from 4.0.18... I get the following error when
trying to start:
./bin/my_print_defaults: error while loading shared libraries:
libcprts.so.5: cannot open shared object file: No such file or directory
OS = Mandrake 9.2
Which RPM am I missing?
well i´m having another problem now... I changed innodb_force_recovery
for 1 and mysql is not running due the following error:
041124 14:13:18 Innodb: fatal error: cannot allocate 2147500032 bytes of
innodb: memory with malloc! total allocated memory
innodb: by inndodb 16975556 bytes. Operating
../var/lib/mysql/mysql.sock.
I've been round the houses with this following the thread but I can't
get past this error despite all the chmod and chown modifications,
installed MySQL admin and it still won't start.
Am I best to chuck it in the bin or uninstall the lot and start again?
This
Is the MySQL server running and you can not connect? Or are you not able
to start the MySQL server?
Morris, Andrew wrote:
../var/lib/mysql/mysql.sock.
I've been round the houses with this following the thread but I can't
get past this error despite all the chmod and chown modifications,
Hello,
The mysql sock file is used for Unix Domain Sockets communication.
In essence, it is used for interconnection between processes running
on the same system. They function just like ordinary-over-the-net
sockets. They are just faster for interprocess communication.
I am not sure I
Hello.
There is a list in which you can expect to have your question answered: [EMAIL
PROTECTED]
Hagen Hoepfner [EMAIL PROTECTED] wrote:
Dear list,
perhaps there is some one who can help me ;-) I currently try to
understand the structure of .frm-Files. As I understood the
Hello.
I think we may open a bug, but still we have to try to find at least
the command line options with which mysqld has been started. You should find
a place in your startup scripts where mysqld is invoked. Start it with
--log[=file] --log-error[=file] options. Some clues could be found
Hello.
See:
http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
How can I reset the permissions on my database? I have no clue when I did
it (at least several months ago), haven't used it until today but I cannot
for the life of me figure out how I can create a new user
Hello.
Have you tried official binaries?
Willem Roos [EMAIL PROTECTED] wrote:
Hi list,
We have apps that try to open 700 simultaneous connections to our
4.0.20-max mysql server running on RH7 (Linux kernel 2.4.20). We get
many 'Can't create a new thread (errno 11)' errors
Hello.
Citing Egor Egorov as of http://lists.mysql.com/mysql/166245:
Check that it's not max_allowed_packet or wait_timeout issue:
http://dev.mysql.com/doc/mysql/en/Gone_away.html;
After that, when i tried to reconnect it, it's hang up
!
Your Red Hat server machine hangs up?
Hello.
ERROR 2002: Can't connect to local MySQL server through socket
I guess you've got such error while executed mysql command line client program.
The documentation had a little info. Tried all that; didn't work.
What did you tried exactly? Have you looked at:
Carlos,
041124 14:13:18 Innodb: fatal error: cannot allocate 2147500032 bytes of
innodb: memory with malloc! total allocated memory
innodb: by inndodb 16975556 bytes. Operating system errno: 8
innodb: Cannot continue operation!
innodb: check if you should increase the swap file of ulimits
Last week I got this message:
Cannot connect DBI:mysql:formmail;myhost.net: Host 'myhost.net' is
blocked because of many connection errors. Unblock with 'mysqladmin
flush-hosts'
I couldn't find the errors anywhere. Not in any of the apache logs and
not in the mysql error log:
041103 20:09:11
Well i didn´t change nothing at no config file. Any suggestions?
thanks.
Sorry all for those lots of questions... i´m new at mysql and I need
it very much at my job.
and sorry for the english too.
On Wed, 24 Nov 2004 16:20:57 -0200, Ronan Lucio [EMAIL PROTECTED] wrote:
Carlos,
041124
Carlos,
I asked you to post the COMPLETE .err log. Do NOT cut anything off.
Regards,
Heikki
- Original Message -
From: Carlos Augusto [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, November 24, 2004 7:38 PM
Subject: Re: Innodb corrpution. Very Urgent
well i=B4m
My master has two databases: channel and hardware. I'm only interested
in replicating hardware, so I set up replicate-do-db=hardware on the slaves.
However, I am having problems because of giant LOAD DATA operations
performed nightly on channel. Replication blows up with max packet
exceeded
i probably should have mentioned: both master slave are running 4.0.20
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jon Drukman wrote:
My master has two databases: channel and hardware. I'm only interested
in replicating hardware, so I set up replicate-do-db=hardware on the slaves.
However, I am having problems because of giant LOAD DATA operations
I am curious about doing something simular to this... does anyone have an idea
On Wed, 24 Nov 2004 00:43:32 -0500, list 123. list wrote:
Using mySQL 4.0, I would like to know how I can code a query that will change
the value of Participants.Active from Y to N is for three or more CONSECUTIVE
Geoffrey R. Thompson wrote:
I have an interesting problem that I cannot find any clues to in the MySQL
documentation. The following query works in 3.2.3, but does not work in
4.1.7:
You would increase your chances of getting a useful answer if you would take
the time to reformat your query to be
Michael Stassen wrote:
You would increase your chances of getting a useful answer if you would
take
the time to reformat your query to be easily readable, as I have done for
you below.
SELECT Product.Product,
AssignedToAgent.AgentName AS AssignedTo,
sum(Inquiries) AS
what is the maximum number of entries that table can hold?
i have been experimenting with php and mysql.
i created a script that records iipaddress, browser info and timestamp
once the table reaches 127 entries it stops, is there a way to
increase this number?
i read thru the administrators
At 21:53 -0600 11/24/04, tom miller wrote:
what is the maximum number of entries that table can hold?
i have been experimenting with php and mysql.
i created a script that records iipaddress, browser info and timestamp
once the table reaches 127 entries it stops, is there a way to
increase this
I wish you all a very good and cherishable 'Thanks Giving' to all the people in
this list and and all the contributors to MySQL all over the World.
Once Again Thanks :)
Warm Regards,
Nikhil.
-Original Message-
From: Scott Hamm [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 24,
I have got few duplicate record in my DB as follows.-
Let's say record_no is the unique id of duplicate records.
So I have fields ID, record_no , X and Y. (ID is a dif filed and is a
primary key)
To find duplicates I do following -
select record_no,count(record_no) from mytable group by
62 matches
Mail list logo
