Try
net start mysql
at a command prompt
> Hi Team,
>
> Pls help, I'm new to mysql.
>
> I got the latest ver installed on NT2000 workstation. Upon I
> tried the activate the daemon, under c:\mysql\bin\mysqld,
> it won't work. Any advise.
>
> Thanks & Regards
> KA
--
heh, my ($id) = $dbh->selectrow_array("SELECT MAX(id) FROM tbl;");
xris wrote:
>
> > Woops sorry about that last message.
> > Try using the following:
> > my $id = $sth->{insertid};
> > That is what I had to change it to, to get it working.. despite what the
> > documentation says.
>
> Actually
> Woops sorry about that last message.
> Try using the following:
> my $id = $sth->{insertid};
> That is what I had to change it to, to get it working.. despite what the
> documentation says.
Actually, I can't use that. The script dies, it's not like it just warns me
that it doesn't work, but it
Woops sorry about that last message.
Try using the following:
my $id = $sth->{insertid};
That is what I had to change it to, to get it working.. despite what the
documentation says.
GL.
ryan
> > My ISP recently updated one of their servers to 3.23.38, and all of a
> sudden
> > a BUNCH of my
I had the same problem when upgrading... and I found that using
> My ISP recently updated one of their servers to 3.23.38, and all of a
sudden
> a BUNCH of my code stopped working. I use a number of insert queries
(new
> items, new search caches, etc), where I insert a blank record, and then
t
Hi Team,
Pls help, I'm new to mysql.
I got the latest ver installed on NT2000 workstation. Upon I tried the activate the
daemon, under c:\mysql\bin\mysqld,
it won't work. Any advise.
Thanks & Regards
KA
My ISP recently updated one of their servers to 3.23.38, and all of a sudden
a BUNCH of my code stopped working. I use a number of insert queries (new
items, new search caches, etc), where I insert a blank record, and then take
notes of its id (usually "int unsigned auto_increment primary key"),
unrelated:
many times an error reported will say unable to connect me
@localhost... what do i do to use a remote host? e.g.,
[EMAIL PROTECTED]
thank you.
At 11:27 PM +0200 6/22/01, Benjamin Pflugmann wrote:
>Hi.
>
>On Fri, Jun 22, 2001 at 09:04:14PM +0200, [EMAIL PROTECTED] wrote:
>> How do
Win running winzip on the mysqlgui download I am receiving errors. I have already
tried downloading it two times and both times I get the following errors:
Errors were detected -- see below for details
Testing ...
testing: mysqlgui-win32-static-1.7.4-2/ OK
testing: mysqlgui-win32-static-
Hi Folks,
I just started a create table ... select from ...left-join query from my
laptop. It seems to take a while?
What happens if disconnect my client from the mysql daemon running on
another machine. Will the interupted mysqld-client crosstalk abrupt the
query, or will it continue to run on t
Hi,
While trying to index a 77million row table (I know, I'll shut up), I
started to fiddle with the mysql variables to get it done in under 3
weeks. Finally, I happened upon the myisam_max_sort_file_size and
myisam_max_extra_sort_file_size variables.
Messing with these allowed the indexing to go
"Alberni-dot-Net Tech Mailing Lists" <[EMAIL PROTECTED]> writes:
> What sort of support for transactions and table/record locking is
> there in MySQL right now? I had heard that only table locking was
> supported, and limited support for transactions.
It varies, depending on table type - look a
I get two info boxes.
The first says "ODBC-call failed"
The second says "[TCX][MyODBC]Access denied for
user: '@dhcp85.lannet.com.au' to database 'Treasury' (#1044)"
In the TDX mysql Driver default configuration dialog box from Control
Panel->ODBC Data Source (32bit) the user name is set as LAN
On Fri, 22 Jun 2001 15:17:18 -0700, "Alberni-dot-Net Tech Mailing Lists"
<[EMAIL PROTECTED]> wrote:
>>What sort of support for transactions and table/record locking is there in MySQL
>right now? I had heard that only table locking was supported, and limited support
>for transactions.
we've
Quoting Cal Evans <[EMAIL PROTECTED]>:
> Regular keys are just indexes, not necessarily unique, not necessarily on
> fields that don't accept nulls. Their primary function is to speed up data
> retrieval. Use them sparingly as they can have a negative impact on
> inserting and updating records.
It's sad that your MySQL crashes. But still, it's even more sad that there
exist human beings that rely on system administrators not being able to kill
a process under linux ;) (don't take that too hard, just kidding)
ps aux | grep mysqld
get the PID of the process
kill -9 PID
Make sure you h
At 1:39 PM -0800 6/22/01, Joshua J. Kugler wrote:
>I have read the manual about GRANT/REVOKE syntax. I have set up several
>queries that worked to grant privileges, but then I sent this query to the
>MySQL server:
>
>REVOKE ALL PRIVILEGES ON *.* FROM 'testuser'@'xxx.xxx.xxx.xxx'
>
>testruser is a
*deep breath* - database,sql,query,table!!! *sigh*
> Have look in the fine manual for more details.
ooops... thanks :)
> Bye,
>
> Benjamin.
>
Daniel Åkerud
-
Before posting, please check:
http://www.mysql.com/m
What sort of support for transactions and table/record locking is there in MySQL right
now? I had heard that only table locking was supported, and limited support for
transactions.
Aaron
-
Before posting, please check:
h
Occasionally, MySQL seems to lock up on the Linux box and just sit there. It
did it today for three hours before we realized it. When this happens, the
only thing we know of to do is restart it, and this time it wouldn't shut
down so we had to reboot the Linux box. Does anyone have any idea what
I have read the manual about GRANT/REVOKE syntax. I have set up several
queries that worked to grant privileges, but then I sent this query to the
MySQL server:
REVOKE ALL PRIVILEGES ON *.* FROM 'testuser'@'xxx.xxx.xxx.xxx'
testruser is a user that has an entry in the user table, as well as s
Hi.
On Fri, Jun 22, 2001 at 09:48:50PM +0200, [EMAIL PROTECTED] wrote:
> Anyone has any experience with mySQL in combination with data
> replication? Are there products available out there that allows
> this?
MySQL has built-in support for replication to another MySQL
server. Have look in the fi
Hi.
On Fri, Jun 22, 2001 at 09:04:14PM +0200, [EMAIL PROTECTED] wrote:
> How do you force mysql to use either TCP/IP Sockets or UNIX Sockets?
> And how do you know which one it uses?
"localhost" uses UNIX sockets, "" uses TCP/IP sockets.
You can indirectly determine what connection was used by
I am using two versions of MySQL, on two different platforms, and having the
same problem on both. One very odd aspect of this problem is that it behaves
precisely the same way on both platforms, down to which records are garbled
onscreen and how they are garbled. Anyone with any ideas? Than
At 9:04 PM +0200 6/22/01, Daniel Åkerud wrote:
>How do you force mysql to use either TCP/IP Sockets or UNIX Sockets?
>And how do you know which one it uses?
>
>It is for a performance analysis.
>
>Thanks!
>
>Daniel Åkerud
If you connect to "localhost", MySQL will use a UNIX socket if possible.
If
Hi.
On Fri, Jun 22, 2001 at 05:31:32PM +0100, [EMAIL PROTECTED] wrote:
> Hi,
> Is there a way to retrieve the field values in the
> same order as during insertions based on something
> like rowid or so??
No. Insertion order is not kept anywhere. Use an AUTO_INCREMENT column
to obtain an key to O
Ok, so maybe I'm just lazy, but I was wondering
if there was any way to load data into a table
from a CSV file that has more fields per line
than the table that I want to load it into.
Can this be achieved using mysqlimport or the
LOAD DATA command?
Example;
INPUT.CSV
field1,field2,field3,field4
At 10:00 PM -0800 2/10/01, Thomas DeMartini wrote:
>I've been looking for a way to disable logging to mysql_history on a
>global basis. Does anyone know of a way to do this? If so, please
>e-mail me at this address (I don't check the list). If not, can
>someone tell me how to submit a featur
William Clifford <[EMAIL PROTECTED]> writes:
> Hi all. I recently downloaded the source distribution of MySQL version 3.23.39
> and am trying to compile it so that it installs it's files in the same manner
> as the binary RPM version does.
Just download the lastest SRPM from rawhide, and rebuild
Hi.
In a relational database you may _not_ rely on internal order. It is
completely up to the RDBMS how it handles insertions. The internal
order is "undefined" by definition according to the SQL standard.
Therefore you should have no interest at all on where insert go to.
Use SELECT ... ORDER B
Anyone has any experience with mySQL in combination with data replication? Are there
products available out there that allows this?
Thanks
Daniel Åkerud
How do you force mysql to use either TCP/IP Sockets or UNIX Sockets?
And how do you know which one it uses?
It is for a performance analysis.
Thanks!
Daniel Åkerud
On 22-Jun-01 Martin Quevedo wrote:
> Hi all,
>
> When I perform a delete command and then I insert a new row, this new
> row is placed in the row just deleted. Is it possible to place newly
> inserted rows always at the end of the table???
>
There is no 'end' (or 'begin' for that matter) to a
Hi all. I recently downloaded the source distribution of MySQL version 3.23.39
and am trying to compile it so that it installs it's files in the same manner
as the binary RPM version does. Does anyone have an idea what the prefix
directory and datadir directories are supposed to be set to? I'm run
On 22-Jun-01 VVM Ravikumar Sarma Chengalvala wrote:
> Hi,
> Is there a way to retrieve the field values in the
> same order as during insertions based on something
> like rowid or so??
> Eg:
> Insertion order into a table for a text field:
> bbb
>
> abaa
> aa
>
> Retrieval order:
>
On 22-Jun-01 Webmaster wrote:
> I have weis in my mysql data directory, and I was hoping someone could tell
> me what they were...
>
> I understand that most tables will have 3 files associated with them (in my
> mysql setup anyway): .ISM, .ISD and .frm
> files.
>
> However, I have files like t
Sounds like you could be a reference site for Microsoft!! Only 2 corruptions
using Access multi-user. That's incredibly good. I've supported systems with
only 3 concurrent users who suffered corruption on a nearly daily basis.
- Original Message -
From: "John Meyer" <[EMAIL PROTECTED]>
To
On 22-Jun-01 Colm McCartan wrote:
> Hello all,
>
> apologies if this has been posted before but I can't find it in the FAQ,
> docs or
> anywhere...
>
> Subject says it all: before closing down for a backup or whatever, how do I
> find
> out who is logged into the server (as opposed to just ge
Try
mysql_query("INSERT into mybtd(co_pe) values('Johsua''s Brother')");
or
mysql_query("INSERT into mybtd(co_pe) values('Johsua\\'s Brother')");
Daniel Åkerud
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 22, 2001 7:15 PM
Subject: Error for th
On 22-Jun-01 Jean-Philippe Cote wrote:
>
>
> Hello,
>
> Suppose I want to update n rows (where n is a possibly large number)
> using the mySQL C API. I can create n separate UPDATE
> statements and send each of them to the server with mysql_[real_]query(),
> but that doesn't seem particularly
You need to escape your strings.
> INSERT into mybtd(co_pe) values('Johsua\'s Brother'); cannot run...
[EMAIL PROTECTED] wrote:
>
> Dear sir;
> I have find a big error from MySQL. I have one fields like that;
> co_na(Fields) = Johsua's Brother;
> mybtd is the data name, co_
The manual also states that INDEX is a synonym for KEY, which means that
they have identical funcationality.
Daniel Åkerud
- Original Message -
From: "Cal Evans" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Marco Bleeker" <[EMAIL PROTECTED]>
Sent: Friday, June 22, 2001 6:27 PM
Subject:
On 22-Jun-01 Carsten H. Pedersen wrote:
> Has anyone successfully passed the get_lock()
> and release_lock() commands to a MySQL
> server using PHP? If so, how did you go about it?
Yes;
mysql_query("SELECT GET_LOCK('signups',20)");
fillsignups();
mailsignups();
mysql_query( "S
On Fri, 22 Jun 2001 11:28:19 -0500, "Cal Evans" <[EMAIL PROTECTED]> wrote:
If your using Perl w/DBI, you may want to check out the use of place holders and
bind_columns. Create your create your insert statement outside the loop, then do
the execute() within the loop using placeholders or bind_
At 12:17 PM -0400 6/22/01, Trond Eivind Glomsrød wrote:
>Batara Kesuma <[EMAIL PROTECTED]> writes:
>
>> Hello,
>>
>> I think it might not be a right mailing list for this question, but I
>> don't know where else should I post it.
>>
>> If I run Perl DBI's $dbh->connect() without $dbh->disconne
Auto_increment is one of the options
--Ravi
--- Martin Quevedo <[EMAIL PROTECTED]> wrote: > Hi
all,
>
> When I perform a delete command and then I insert a
> new row, this new
> row is placed in the row just deleted. Is it
> possible to place newly
> inserted rows always at the end of the table??
Sorry for the delayed reply.. the list marked my reply as spam ! ;)
-- Forwarded message --
Date: Fri, 22 Jun 2001 02:48:14 -0700 (PDT)
From: Seth Northrop <[EMAIL PROTECTED]>
To: Wouter de Jong <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED]
Subject: Re: RAID advice :>
> Let's say
> ERROR 2002: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)
>
> and how you fix it?
It means you have no local socket for mysql to connect through. Meaning,
something/someone either deleted or mangled /tmp/mysql.sock or mysqld
isn't running to begin with.
Try to co
Dear sir;
I have find a big error from MySQL. I have one fields like that;
co_na(Fields) = Johsua's Brother;
mybtd is the data name, co_na is the fields;
I cannot insert the data by using the php commands;
mysql_query("INSERT into mybtd(co_pe) values('Johsua's
It only corrupted your database twice?
On Friday 22 June 2001 09:50, Patrick Calkins wrote:
> MySQL can handle infinately more concurent connections to it, and handle a
> much bigger load than MDB can even dream of doing. A few years back I used
> to write database apps in visual basic and MDB.
On Friday 22 June 2001 09:22, [EMAIL PROTECTED] wrote:
> MySQL has is used by alot of major players and there are pre made setup for
> building database driven websites like PHP-Nuke. Unsure on the strings
>
> I use Win2K and Mysql PHP and PHP Nuke with Apache for my site and it's
> working great!
I think you must start the mySQL server to connect
- Original Message -
From: "Trond Eivind Glomsrød" <[EMAIL PROTECTED]>
To: "Arnor Sigfusson" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 22, 2001 5:07 PM
Subject: Re: Problem starting mysqlGui
> Arnor Sigfusson <[EMA
It is my understanding that the first syntax is faster in mysql.
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: "Dvoøáèek Michal" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 22, 2001 11:48 AM
Subject: insert
> Hi,
>
KEY is used to build other indexes. It's not short for Primary Key. There
are PRIMARY KEY indexes, candidate key indexes (these COULD be a primary key
but for one reason or another , are not) and just regular indexes.
All tables should have a primary key. (I'm partial to adding an
auto_incremen
Hi,
Is there a way to retrieve the field values in the
same order as during insertions based on something
like rowid or so??
Eg:
Insertion order into a table for a text field:
bbb
abaa
aa
Retrieval order:
I want to have the retrieval order also the same.The
output of the query on tha
On 22 Jun 2001 [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:
>
> database,sql,query,table
>
> If you just reply to this message,
I have weis in my mysql data directory, and I was hoping someone could tell me what
they were...
I understand that most tables will have 3 files associated with them (in my mysql
setup anyway): .ISM, .ISD and .frm files.
However, I have files like this in my directory: B-431a.ISM, B-431a.ISD,
Batara Kesuma <[EMAIL PROTECTED]> writes:
> Hello,
>
> I think it might not be a right mailing list for this question, but I
> don't know where else should I post it.
>
> If I run Perl DBI's $dbh->connect() without $dbh->disconnect(), MySQL (or
> is it the Perl DBI module) will run rollback()
Hi all,
When I perform a delete command and then I insert a new row, this new
row is placed in the row just deleted. Is it possible to place newly
inserted rows always at the end of the table???
Martin
-
Before posting, please
Arnor Sigfusson <[EMAIL PROTECTED]> writes:
> Hi
> I was trying MySQL on a RedHat 7.0 for the first time using
> MySQLGUI. But when I try to connect I get:
Have you applied all updates, and can you connect through the mysql
CLI client?
--
Trond Eivind Glomsrød
Red Hat, Inc.
---
I want to connect to mySQL via perl...
I have to install DBD::mysql?
is there a rpm for mysql drivers
I´d just installed the perl DBI.rpm but it seams didn´t wrork
in
dir /usr/lib/perl5/site_perl/
I have:
5.6.0 and i386-linux dirs
help
- Original Message -
From: "Michael Ott" <[EMAIL
Well, that all depends on what language your apps are written in. VB?
Delphi? C? PHP? Perl? and what database architecture are you using within
the language (ie, in VB are you using ADO, or ODBC, or DAO, etc)...
Also, for a good comparison of databases, look at this:
http://www.mysql.com/informat
First off, I wouldn't really want to call Access a database, as its little
more than just a file with 1/2 of a program trying to access it. And second,
I would say that MS SQL is both over-priced, and way too bloated, buggy,
slow, etc, etc. (but then again, everyone has their own opinion on this).
Try something like
SELECT fid, Family_Last_Name, Phone, playertable.Family_ID
FROM familytable
LEFT OUTER JOIN playertable ON playertable.Family_ID = familytable.fid
AND playertable.SportRegistered = 'O'
GROUP BY fid
ORDER BY Family_Last_Name ASC;
The rows from familyt
Hi,
is better to create insert query for better performance this way:
INSERT INTO table VALUES(val1, val2, val3), (val4, val5, val6), (...);
or in this way:
for (i = 0; i < 3000; i++) {
INSERT INTO table VALUES(val[i][1], val[i][2], val[i][2]);
}
Michal Dvoracek
On Fri, Jun 22, 2001 at 04:54:17PM +0800, eagle wrote:
> mysql
> hello all.
> I install mysql 3.23.32 on red hat 6.0 .
> I have a c program source as bellow:
> //*
> gcc -I /usr/local/include/mysql mysql_test.c -L /usr/local/lib/mysql -lmysqlclient
>-lz
Hello,
I think it might not be a right mailing list for this question, but I
don't know where else should I post it.
If I run Perl DBI's $dbh->connect() without $dbh->disconnect(), MySQL (or
is it the Perl DBI module) will run rollback() with an error message:
Issuing rollback() for database ha
MySQL has is used by alot of major players and there are pre made setup for building
database driven websites like PHP-Nuke.
Unsure on the strings
I use Win2K and Mysql PHP and PHP Nuke with Apache for my site and it's working great!
My Linux Server has the same and also does excellent.
Cheers
Hi
I was trying MySQL on a RedHat 7.0 for the first time using MySQLGUI. But
when I try to connect I get:
Can't connect to local MySQL server through socket '' (111)"
Arnor Sigfusson
Arnor Sigfusson Tel:+354 5574488
FutureMedTecMobile: +354 8949960
Storhofda 17
Hello all,
apologies if this has been posted before but I can't find it in the FAQ, docs or
anywhere...
Subject says it all: before closing down for a backup or whatever, how do I find
out who is logged into the server (as opposed to just getting connections
information)?
Many thanks for any
can´t find rpm DBI in RH 7.0 installation cdrom 1 & 2
help
- Original Message -
From: "Michael Ott" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 22, 2001 4:06 PM
Subject: Re: Fw: Fw:
hallo yann!
> are you shore there is a rpm for DBI in R
Try also mysql_navigator (latest 1.2.3). You'll need qt 2.2.x (and a
little work with compillig :-).
Nice, simple, powerfull. I'm very happy with this GUI.
http://sql.kldp.org/mysql
Malmo
Malmo> If I only got 20$
hallo yann!
> are you shore there is a rpm for DBI in RH 7.0 installation cdrom 1 & 2?
yes, one is called perl-DBI and is at the powertools-cd and the other,
which you mean is at
ftp://ftp.redhat.com/pub/contrib/libc/i386/perl-DBD-msql-mysql...
but you must copy some files after installation
cp
Hello.. Friends
I have just installed my OpenBSD 2.9 with mysql 3.23.37 and when i wanted to
startet i can do it first time, but if i have to restart the server. I
cannot start it again, why?
i come with this error.
w3# safe_mysqld
/usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20: No
Hello, I am learning MySQL and have a question. I know about the importance
of the PRIMARY KEY statement, but I also see a KEY statement being used
when creating a table. Is this just short for PRIMARY KEY, or what's the
difference?
Second question, when I have a large table, but with only 2 s
I got the message when I try to run mysqld.
mysqld: Can't change dir to '/usr/local/mysql/var/' (Errcode: 2)
010622 10:35:41 Aborting
010622 10:35:41 mysqld: Shutdown Complete
-Michael Kirschenbaum
Rolf Hopkins wrote:
> You just crashed the mysql server. Just restart it.
>
> - Origin
Can I show records from my SQL statement where records both have a match and
do NOT have a match. I'm having trouble with the syntax for "no matching
records" in a related table, my current SQL statment looks like this:
SELECT fid,Family_Last_Name,Phone FROM familytable,playertable WHERE
player
Hello,
Suppose I want to update n rows (where n is a possibly large number)
using the mySQL C API. I can create n separate UPDATE
statements and send each of them to the server with mysql_[real_]query(),
but that doesn't seem particularly efficient to me. Is there a better
way to do it ? Can I
como faço p/ desligar o servidor mysql remotamente?
estou usando win98 e o Mysql esta em uma maquina NT
falow
valeu
You just crashed the mysql server. Just restart it.
- Original Message -
From: "Michael Kirschenbaum" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 22, 2001 21:24
Subject: deleted mysql.sock
> Hi,
> I accidentaly deleted the mysql.sock file, does anyone know how to
> r
Can anybody help with the question about which one is the best to handle database
driven webpage, Since, we are running on ACCESS DB, and MS SQL for a long time, but,
We just have our new Lynex server it is running MySQL, my question is:
1) What's the different between MDB and MySQL. I mean th
mysql
hello all.
I install mysql 3.23.32 on red hat 6.0 .
I have a c program source as bellow:
//*
//insert_test.c
#include
#include
#include "mysql.h"
int main(int argc, char *argv[]) {
MYSQL my_connection;
int res;
my
Hello.. Friends
I have just installed my OpenBSD 2.9 with mysql 3.23.37 and when i wanted to
startet i can do it first time, but if i have to restart the server. I
cannot start it again, why?
i come with this error.
w3# safe_mysqld
/usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20: No
Hi,
I accidentaly deleted the mysql.sock file, does anyone know how to
restore it? Thanks.
-Michael Kirschenbaum
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi.
There may be some internal order, but according to the SQL
specification, you may not rely on it. The order of records of a query
without ORDER BY is undefined on purpose.
Bye,
Benjamin.
On Fri, Jun 22, 2001 at 01:43:33PM +0100, [EMAIL PROTECTED] wrote:
> Hi,
> I wonder to know if
Hello.
I am not using PHP, so take my comment with a grain of salt.
PHP doesn't need explicit support for GET_LOCK and RELEASE_LOCK as
they are both just simply SQL functions. So I am not sure what you
problem is, just execute the following query:
SELECT GET_LOCK('whatever')
from PHP the usual
Hi,
I wonder to know if mysql follows any order in
retrieving the data from a table.i.e Is it based on
ascending row order or descending row order.
--Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or
Hello.
Have a look at the transaction safe table types (InnoDB, BDB, ...). I
did not try them myself, but from what I read on the list, there is a
good chance that they will return to a consistent state themselves.
Bye,
Philemon.
PS: Of course, the better solution would be a back-up p
Rich Duzenbury writes:
> And of course, right after I clicked send, I remembered reading about the
> mysql gui client. I installed a copy, and it works great. I only had to
> tweak it (options dialog) to use the socket name (/tmp/mysql.sock), rather
> than it trying to use the IP address.
>
are you shore there is a rpm for DBI in RH 7.0 installation cdrom 1 & 2?
- Original Message -
From: "Michael Ott" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 22, 2001 11:59 AM
Subject: Re: Fw:
hallo!
With reference to [EMAIL PROTECTED] on 22
Ricardo Striquer Soares writes:
> does enyone knows a GUI to use with mysql wich is verry friendly one?
>
> thanks advanced.
>
> _
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
Hi!
Try our mysqlgui.
New
David Freeman writes:
> I am having a problem with mysql. I am running a php web site that uses a (mysql
>Ver 11.15 Disturb 3.23.39 for pc-linux-gnu (i686))database. Whenever i get a load of
>about 100 simultaneous users, mysql begins to spawn D stat processes and the site
>dies. Everything w
Intekhab Choudhury writes:
> Hi
>I have installed/configured Oracle under HPUX, but
> thinking of moving to mySQL. But finding that a
> little difficult.
>
> First of all, document talks about (including
> throughout the Internet) a depot file (i.e.
> mysql.full) to be run with swinstall
On 22-Jun-01, Wouter de Jong said something totally profound about RAID advice :> that
made me ponder...
WdJ> We are planning to use RAID for backing-up MySQL-data. Is it adviced that
WdJ> we put the OS on the RAID-array too, or just the data ?
WdJ>
WdJ> Let's say your OS crashes (Linux...bad l
hallo!
With reference to [EMAIL PROTECTED] on 22.06 10:49:
>
> - Original Message -
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Sent: Friday, June 22, 2001 10:00 AM
>
>
> I´m trying to install:
> perl -MCPAN -e'install DBD::mysql'
> in RH 7.0 to conect to mysql with perl
> i
Hi,
i'm standing before small problem. Which type of table i will use for
my application.
I will need row-locking and speed (maybe transaction)
What type of table do you prefer ? I prefer InnoDB
Michal Dvoracek [EMAIL PROTECTED]
-
Is this what you are looking for?
RENAME TABLE tbl_name TO new_table_name[, tbl_name2 TO new_table_name2,...]
Just take a look at the manual!
Cheers, Nessi
At 09:22 22/06/01 , you wrote:
>how do i change a table's name without recreating it?
>
>
Has anyone successfully passed the get_lock()
and release_lock() commands to a MySQL
server using PHP? If so, how did you go about it?
PHP does not seem to implement these functions
despite the fact that they have been around since
sometime in March/April 1998.
/ Carsten
--
Natural selection s
1. mysql> SHOW databases;
2. mysql> USE MessageNotification;
3. mysql> SHOW TABLES FROM MessageNotification;
hth
At 10:58 AM +0200 6/22/01, Tiwonge Nathan Kawonga wrote:
>How can I query the database to know that a specific table exists in a
>given database.
>
>for example my database is Messag
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
and how you fix it?
thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
1 - 100 of 124 matches
Mail list logo
