On Mon, 28 Oct 2002, Alice Tan wrote:
> run in the DOS, i got this error ..
> am i doing wrongly ?
>
> C:\mysql\bin>mysqladmin shutdown
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'ODBC@localhost' (Using password: NO)'
Hi,
mysqladmin -u root -p shutdow
run in the DOS, i got this error ..
am i doing wrongly ?
C:\mysql\bin>mysqladmin shutdown
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'ODBC@localhost' (Using password: NO)'
- Original Message -
From: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent
On Mon, 28 Oct 2002, aman mysql wrote:
> Hi all
> How do I access a remote MySQL server (on LINUX platform), from a windows
> application.
> What drivers I need to download and from where?
Hi!
You don't need any special drivers. Just the MySQL command-line client will
do the job. It can be downl
Hi all
How do I access a remote MySQL server (on LINUX platform), from a windows
application.
What drivers I need to download and from where?
How do I set permissions on the mysql server to let be accessed by the
remote windows machine.
Thanks alot
Aman
On Thu, Oct 24, 2002 at 12:14:44PM +0530, Akash wrote:
> Hi,
> I have prepared a RING Architecture in MySQL using three MySQL servers.
> I name these MySQL servers as A, B and C.
> My configuration is like this :
> A is the Master to B, B is the Master to C, and C is the Master to A.
>
Try a "touch /var/lib/mysql/mysql.sock"
Although it is a special file it may just work this way. Also make
the permissions to "chmod 777 mysql.sock" and "chown mysql.mysql
mysql.sock"
Bye.
On Mon, 28 Oct 2002, Dennis Herndon wrote:
> I just upgraded to Linux-Mandrake 9.0 and installed
"mysqladmin shutdown"
On Mon, 28 Oct 2002, Alice Tan wrote:
>
>
> How to stop the mySQL service instead of right click the traffic light and
> stop it ?
> is there any exe can stop the mySQL service ?
> i tried the mySQLShutDown.exe, but it didn't actually stop the service.
> i want to stop the
How to stop the mySQL service instead of right click the traffic light and
stop it ?
is there any exe can stop the mySQL service ?
i tried the mySQLShutDown.exe, but it didn't actually stop the service.
i want to stop the mySQL service so that the mysqld-nt.exe wouldn't hold my
database,
which th
Pada Mon, 28 Oct 2002 00:12:14 -0500
Dennis Herndon <[EMAIL PROTECTED]> menulis:
> I just upgraded to Linux-Mandrake 9.0 and installed mysql via the RPM
> files. Everything installed just fine and dandy except when I try to
> run mysql it can't find /var/lib/mysql/mysql.sock file. I'm read how t
Is there a way to take a mysql database and import it into access
retaining all the rules and relationships setup within the mysql
databse?
---
Aaron Axelsen
AIM: AAAK2
Email: [EMAIL PROTECTED]
URL: www.amadmax.com
"It said, ""Insert disk #3,"" but only two will fit!"
"One picture is worth 128K
I just upgraded to Linux-Mandrake 9.0 and installed mysql via the RPM
files. Everything installed just fine and dandy except when I try to
run mysql it can't find /var/lib/mysql/mysql.sock file. I'm read how to
protect that file, but where does it come from?
Apologies in advance: I have not been able to find any sort of overview
information on how MySQL operates internally. I am trying to understand
the philosophy behind the table handler mechanism, and what state is
managed above and below that interface.
I am slowly making my way through the co
Hi
If this is the full code you are missing the final } to close the function
I find it helps to comment the closing brackets
HTH
Peter
function dtb_qry_tbl_dsp($qry, $qry1, $qry2)
{
$result = mysql_query($qry);
$result1 = mysql_query($qry1);
$result2 = mysql_query($qry2);
$i = 0;
Try again.
-Original Message-
From: [EMAIL PROTECTED] [mailto:mysql@;lists.mysql.com]
Sent: Sunday, October 27, 2002 9:17 PM
To: John Meyer
Subject: Re: RE: plz help...tables getting corrupted...
Your message cannot be posted because it appears to be either spam or
simply off topic to ou
Another issue that is easy to overlook is your indexing. If you have a lot of
indexing and keep increasing the database, expect to see a significant
slowdown during inserts into a well populated db, compared to an empty one.
Since you were trying on local machine first, and networked later, it
> corrupted. The most common error messages which I encountered are : "Can't
> open file: 'tablename.MYD'. (errno: 145)" and "Got error 127 from table
> handler".
> I rectified it by shutting down the MySQL Server and using "myisamchk"
> with the options -r and sometimes -o.
145 = Table was ma
Can someone please tell me what is wrong with this function? I can't for
the life of me see an error. But, for some reason I keep getting the
following error:
PARSE ERROR: parse error, unexpected $ in
"d:\web.root\xx_db\inc\functions1.inc on line 28
function is:
function dtb_qry_tbl_dsp($qry,
Last try, if this doesn't go through, screw it.
On Sun, 2002-10-27 at 21:31, [EMAIL PROTECTED] wrote:
> 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:
>
>
Hi, I've got a client that I'm trying to convince to store the file path in
the database rather than the file itself into the database. Is there any
statistical data to show how much of a hit you take doing it as a BLOB vs. a
filepath?
sql,query
Hi,
Can anyoe suggest tutorial which is simple to understand
programming in c or c++ for odbc connections with mysql?
Bye.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lis
At 21:03 -0700 10/25/02, Andre Kirchner wrote:
Hi there,
I would like to know, if it's possible in the mysql to
use two tables as if they were one and have an index
that would use columns of these two tables?
Possibly. Read about MERGE tables in the MySQL manual and see
if the constraints unde
sql,query
At 15:50 -0600 10/25/02, Jeff Mathis wrote:
Paul DuBois wrote:
>(2) drop all indexes on your table(s). rebuild them after loading (this
>alone can give orders of magnitude improvement)
For ISAM or MyISAM, that works. It has no effect for InnoDB.
Do you actually observe a rep
>Description:
Under some pretty specific conditions, adding a "LIMIT" clause to a query
will cause incorrect results.
>How-To-Repeat:
This bug is NOT present in 4.0.3.
CREATE TABLE `history` (
`id_pic` int(11) unsigned NOT NULL auto_increment,
`id_cam` smallint(11) unsigned NOT NULL default
In the last episode (Oct 25), Jeff Mathis said:
> I'll agree to this somewhat:
>
> (1) always bind your variables. whatever code you are using to do your
> inserts, the fewer prepared statements you can make the better.
>
> for example:
> insert into TableName (col1, col2, col2, col4) values (?,?
In my mysql.db file, I have some lines like:
%.private | somedb | someuser | Y | Y | Y | Y | Y | Y | N | Y | Y | Y
So, I have an internal domain called private, those hosts are in an
internal DNS, and can be reverse resolved. The only way I can manage to
connect to "somedb" as "someuser" is t
On Thu, Oct 17, 2002 at 08:50:43PM +0200, Corin Langosch wrote:
> the table has about 12.000 rows total but the query should return
> a max of about 100. mysql should split the query into two queries
> and merge the results.
> may be this could be done by joining the same table two times
> and quer
I looked in mysql.h and saw
#ifdef USE_OLD_FUNCTIONS
..
mysql_connect(..)
etc.
#endif
, shouldn't it work then - even if they are
deprecated? Well, I'll try with mysql_real_connect.
Thanks.
/nikolajg
--- Ed Carp <[EMAIL PROTECTED]> wrote:
> > Iv'e been using gcc 2.96-10 to compile a database
Hi,
I came across a strange problem in MySQL. Some of the tables are getting
corrupted. The most common error messages which I encountered are : "Can't
open file: 'tablename.MYD'. (errno: 145)" and "Got error 127 from table
handler".
I rectified it by shutting down the MySQL Server and usin
28 matches
Mail list logo
