database
hey - what are you doing:-)
anke
__
Darf es ein bisschen mehr sein? Mehr Speicher, mehr Mail, mehr Erlebnis,
mehr Prämie, mehr WEB.DE. Der WEB.DE Club - http://club.web.de
---
On Tue, Jan 08, 2002 at 08:03:07PM -0500, Dennis wrote:
> At 07:07 PM 01/08/2002, you wrote:
> >Dennis,
> >
> >You may want to look into using InnoDB tables. I believe InnoDB tables
> >are immune to the 2gb limit (which usually comes from the filesystem).
> >Also, InnoDB claims that the innodb ta
Hi Tim,
You can get around that proble using AddSlashes() function in PHP. So is you
have a text box where the users enter their inputs, say assigned to the
variable $feedback then , before entering it into mysql, you will have to
apply AddSlashes() on it. So do something like
$feedback=AddSlash
single quotes must be proceded by "\" -- use PHP's addslashes function on
the field before insert:
field = addslashes(field);
see http://www.php.net/manual/en/function.addslashes.php
- Original Message -
From: "Tim Thorburn" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, Ja
I'm just guessing here, but I suppose most of the char(1) fields are y/n
fields. If that's the case you should consider using a single BIGINT and
flag those bits instead. That would considerably reduce the size of the
table on one hand and I guess it should improve things speed-wise as well.
Obvi
I've been experimenting with Apache, mod_perl, the DBI module, and mySQL
3.23.42 on a Mac OS X server 10.1. Everything is working pretty well at
this point and I'm able to serve dynamic webpages very smoothly.
The only fly in the ointment is that, although I can manually start mySQL
with the safe
Hi,
I don't think that you are missing anything.
If there is a select in progress, then an insert will block until it has
been completed.
If there are several selects pending, then the insert will take its place in
the queue, unless you are using low-priority-updates, in which case is will
wait
Hi,
I've been experiencing some sporadic problems with a few web forms written
in PHP 3.0.16 and MySQL 3.23.31 with text fields (both single lines and
rows). Generally if any of the text in these forms contains an apostrophe
- either nothing is entered into the database, or nothing after the
OTC News Alerts' Last 3 Picks have gained 358%!
Here is our next Hot Pick!
Single Source Financial Services Corp. (OTCBB : SSFL)
URGENT BUY AT $ .75 PER SHARE!
SELL TARGET $4.50 PER SHARE!
SSFL is the fastest growing, publicly-traded credit card transaction
processor through its contractual ag
Maybe he likes Pascal. I would check the Borland web site. I seem to
remember reading something about this.
mg
On Tuesday 08 January 2002 13:34, Alex Daniloff wrote:
> Hello Prabu,
> Is it really nessesary to use proprietary Kylix environment (is it
> using Pascal as a core language?) to wri
At 07:07 PM 01/08/2002, you wrote:
>Dennis,
>
>You may want to look into using InnoDB tables. I believe InnoDB tables
>are immune to the 2gb limit (which usually comes from the filesystem).
>Also, InnoDB claims that the innodb tables are faster than MyISAM tables
>in some cases. See www.innodb.c
We have a box that is primarily read at a rate high enough that a
particular table has a SELECT outstanding about 99.9% of time 24x7.
This box is set up as a replication slave, and the table in question
is replicated from another box. It appears as though the slave thread
doing the writes has a
If it is on a Linux machine (yes, yes) look into the file size
limitation of the OS! (assuming you are talking about a single
table?)...
On Tue, Jan 08, 2002 at 06:30:59PM -0500, Dennis wrote:
>
> We have a database that seems to have grown too large, and now any
> operation fails on it. How ca
Dennis,
You may want to look into using InnoDB tables. I believe InnoDB tables
are immune to the 2gb limit (which usually comes from the filesystem).
Also, InnoDB claims that the innodb tables are faster than MyISAM tables
in some cases. See www.innodb.com or
http://www.mysql.com/doc/I/n/InnoD
On Tue, Jan 08, 2002 at 04:16:49PM -0700, Dan Jordan wrote:
> Hi Jeremy,
>
> I just noticed your name today on the mysql mailing list and
> recognised your name. I'm a new user of MySQL and saw that you will
> soon have a new book out.
Well yes, not the book that you think. :-)
I'm working on
On Sun, Dec 30, 2001 at 04:38:02PM -, Andy Woolley wrote:
>
> Well, it certainly seems to be pointing to MySQL.com alright.
>
> Although the domain name registrant is still NuSphere and DNS still
> appears to be handled by NuSphere's command the IPAddress it
> resolves to is definitely that o
We have a database that seems to have grown too large, and now any
operation fails on it. How can we fix this?
Dennis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Hi Jeremy,
I just noticed your name today on the mysql mailing list and recognised your
name. I'm
a new user of MySQL and saw that you will soon have a new book out. I've
scanned other books on MySQL but found that they were either somewhat dated
or of limited value. So,
I look forward to seei
Yesterday I posted a question yet got response. The question
is regarding to how Query works. Now I repost it in a more
specific way.
I am just wondering how MySQL API functions work. Let's look
at following two functions:
1. mysql_query(),
2. mysql_fetch_array()
To my understanding, mysql_q
Greetings all!
I'm new to the list, and looking for a bit of help.
I have searched the documentation on mysql.com about the
functions CAST() and CONVERT() - I found them, but I can't
seem to get the commands to work. I have both 3.23 and 4.0 versions; same
result with both versions.
Does anyon
Prabu Subroto <[EMAIL PROTECTED]> wrote:
>>Dear Friends,
>>
>>I am trying to develop an application with Kylix
>>ver.1, MySQL ver.11.15 distrib 3.23.41 for suse linux
>>(i686).
>>I am using MySQLConnection object to connect my MySQL
>>database server (and with so :
>>libmysqlclient.so.10.0.0).
>
Hi,
Thanks ... I got to work, briefly .. then it logged me
out. I got MysqlTool running reliably.
Regards, Mike
--- Sinisa Milivojevic <[EMAIL PROTECTED]> wrote:
> EDA Peach writes:
> > Hi,
> >
> > gcc and the libstdc++ are already loaded.
> libstdc++
> > is in /usr/local/lib should
Steve,
> what is wrong with this statement?
>
>
> mysql> create table message (messageId AUTO_INCREMENT, timePosted
> VARCHAR(25),
> -> userEmail VARCHAR(30), messagePosted MEDIUMBLOB);
>
> ERROR 1064: You have an error in your SQL syntax near 'AUTO_INCREMENT,
> timePoste
> d VARCHAR(25),
Newbie here!
How to change characterset from default "latin1" to "danish" on a remote site
connecting through SSH Secure Shell?
Case locally:
* MySql installed on Win2k
* has changed character from default "latin1" to "danish" by creating "c:\my.cnf" -
works great!
Case remote on a shared web
* Marco Frazzoli
> I need to syncronize two indentical MySQL databases.
>
> The A database is on a server permanently connected to the Internet
> trough an ADSL connection, while the B database is on a server equipped
> with an ISDN connection.
>
> How can I keep the two databases identical?
By n
On Tue, Jan 08, 2002 at 04:56:52PM -0500, Steve Bearss wrote:
>
> what is wrong with this statement?
>
>
> mysql> create table message (messageId AUTO_INCREMENT, timePosted
> VARCHAR(25),
> -> userEmail VARCHAR(30), messagePosted MEDIUMBLOB);
>
> ERROR 1064: You have an error in your SQL s
On Tue, Jan 08, 2002 at 10:49:32PM +0100, Marco Frazzoli wrote:
> Jeremy Zawodny wrote:
>
> > On Mon, Jan 07, 2002 at 11:36:54PM +0100, Marco Frazzoli wrote:
> >
> >>Hi!
> >
> > Have you looked at MySQL's built-in replication?
>
> Yes. But it seems to be created for a permanent connection betw
what is wrong with this statement?
mysql> create table message (messageId AUTO_INCREMENT, timePosted
VARCHAR(25),
-> userEmail VARCHAR(30), messagePosted MEDIUMBLOB);
ERROR 1064: You have an error in your SQL syntax near 'AUTO_INCREMENT,
timePoste
d VARCHAR(25),
userEmail VARCHAR(30), mess
Jeremy Zawodny wrote:
> On Mon, Jan 07, 2002 at 11:36:54PM +0100, Marco Frazzoli wrote:
>
>>Hi!
>
> Have you looked at MySQL's built-in replication?
Yes. But it seems to be created for a permanent connection between two
databases... or can I make a replica using a dial-up connection (such as
make sure mysql owns the database directory and all its files.
[EMAIL PROTECTED] wrote:
>>Description:
>>
>Empty table returned when qureying for "show databases;" right
>after installation. It shows a table with 10 rows, with empty fields in
>each, and writes in the total, 11 databases.
>When u
Hi,
I've got a table with a 5 milion records and with 10 records adding
every day.
My problem is that when I try to delete old records from this tables at
some point I receive the following error
ERROR 1034: Incorrect key file for table: 'logs'. Try to repair it.
and the query execution stop
Greer, Darren (MED) writes:
> If I move the status to another table, and then wanted to get a count of
> everyone who is of status 'A', how would that be any quicker? Would I
> join the tables?
Communication error - reattempting.
I meant that if you want to get the count of the number of 'A's
Ilic writes:
> SELECT count(distinct ip) FROM pole_voti
>
> It does'nt work. Why ?
What's your MySQL version? Check the docs to see what version is
required for count(distinct). I think it was added in 3.23.early,
so it might be time to upgrade.
//C
--
Carl Troein - Círdan / Istari-PixelMa
select a.* from a left join b on a.id = b.id
where b.id is null;
Ken Kinder wrote:
>
> Is there a way I can filter OUT records referenced in another table?
>
> With Subselects it would be this, but I'm using 3.23:
>
> select
> a.*
> from
> a
> where
> a.id not in (select id from b)
>
At 16:50 08/01/2002 +, Los Morales wrote:
Hi!
>Hi,
>
>Would like to know if there is a "preferred" way of setting up the data
>directory for mySQL. The default for a database would be in C:\mysql\data.
>Is this the preferred way or should this be set up in another directory
>outside of the
>Description:
Empty table returned when qureying for "show databases;" right
after installation. It shows a table with 10 rows, with empty fields in
each, and writes in the total, 11 databases.
When using a newly created database, doesn't show created tables (on show tables),
what can be the probl
Hello,
No there's no thread in my application,
the program use fork but of course a new connection is create after each fork()
Today before running another test I do the following
- drop then create the tables
- increase the limit for opened file from 1024 to 4096
I run a test for 2
Serge Thibault writes:
> Hi everyone,
>
> I yould like to write a database server using MySQL. Before I begin,
> I would like to know:
>
> 1. Is this possible to write, in C, a Macintosh client to this MySQL
> server application?
>
> 2. Even if we already use Linux and Windows NT servers, is th
On Tue, Jan 08, 2002 at 10:04:40AM -0500, Michael D. Stackhouse wrote:
> We run MySql on our Freebsd server, and on our Win2K server.
>
> We have several clients, and would like to store the databases in the
> clients' root directory. Is this possible?
Under UNIX, all of the separate databases
Hi everyone,
I yould like to write a database server using MySQL. Before I begin,
I would like to know:
1. Is this possible to write, in C, a Macintosh client to this MySQL
server application?
2. Even if we already use Linux and Windows NT servers, is this a
good alternative to write the MySQL
Is there a way I can filter OUT records referenced in another table?
With Subselects it would be this, but I'm using 3.23:
select
a.*
from
a
where
a.id not in (select id from b)
You get the idea.
-
Before posting, please
Hi Gary,
Finally I can access the server. You are my hero. I am new to mysql. It takes me a
month to try it.
Thank you very very much!
Cindy
>>> <[EMAIL PROTECTED]> 01/08 11:14 AM >>>
from your bindir type:
./mysql
-Original Message-
From: Cindy Yu [mailto:[EMAIL PROTECTED]]
Sent: T
Hi,
I have a table that contains something like follows:
id prop_name status action_date
prop_type address
1 name1 ok 2001-12-12
1 addy1forname1
2 name2
At 09:31 08/01/2002 -0700, John Meyer wrote:
Hi!
>Can I have different instances of winmysqladmin start instanciating
>different mysql's? i want to run one for the stable version, and one for
>mysql 4.0
Unlucky no. By the way the Windows Server currently doesn't have
support for to run several
Hi.
I am using MySQL 3.23.44-MAX. with InnoDB
I have create two tables (one of them parent, other child).
All seems Ok. But when I am trying to insert new record into the table I am getting key
violation.
It happened when I am trying insert null value into field that have foreign key.
(column c
Jeremy,
Apart from this perl of wisdom, how about defining two columns: one a 'temporary' text
field and the other the
'real date column - as proposed, and importing the date-data into MySQL in the
temporary-text field (and leaving
the other/real one empty). Then copy the data out of the tempor
Which is the fastest way to add FULLTEXT index to a database table with
1.500.000 rows ?
Please also reply to my E-Mail address.
Regards Jacob
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
My suggestion (using a bigint and flagging the bits instead of using 40
char(1) fields) is only valid if you don't use any of those fields in WHERE
clauses in SELECT's. Not that you wouldn't be able to retrieve the entries
based on the respective field, but I don't think it would be indeed faster
Dennis Jacobfeuerborn <[EMAIL PROTECTED]> writes:
> We are running MySQL version 3.23.43 on one of our servers and have some
> stability
Where did you get that? The MySQL site?
> Some info about the system:
> Dell PowerEdge 8450
> 4 x Xeon 700
> 4GB of RAM
> Intel GBit e
The server is not telling you that mysql is not found.
The shell is telling you that mysql is not found because the the current
directory
is not included in the PATH searched by the shell.
try ./mysql
or
/usr/local/bin/mysql.
Cindy Yu wrote:
>Hi Simon,
>
>I appreicate your help.
>
>Our serve
from your bindir type:
./mysql
-Original Message-
From: Cindy Yu [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 12:07 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: RE: RE: Mysql connection problem
Hi Simon,
I appreicate y
On Mon, Jan 07, 2002 at 11:36:54PM +0100, Marco Frazzoli wrote:
> Hi!
>
> I need to syncronize two indentical MySQL databases.
>
> The A database is on a server permanently connected to the Internet
> trough an ADSL connection, while the B database is on a server
> equipped with an ISDN connectio
At 09:04 08/01/2002 -0700, Dan Jordan wrote:
Hi!
Go to start Menu and remove the Icon of WinMySQLAdmin.
Regards,
Miguel
>Each time that I reboot and logon to my windows 98 server, WinMySQLAdmin
>starts and
>then starts mysqld. I do not want this behavior (acting like a service).
>
>What do I n
Hi Simon,
I appreicate your help.
Our server is a Solaris 5.6 server. After I cd to the mysql bin directory
bindir=/usr/local/bin and connect to mysql server by using mysql or mysqladmin, the
server shows me mysql not found and mysqladmin not found. Can you give my some clue?
You have much
The syntax is: SELECT DISTINCT
http://www.mysql.com/doc/S/E/SELECT.html
Xi2
-Original Message-
From: Ilic [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 9:48 AM
To: [EMAIL PROTECTED]
Subject: count(distinct
SELECT count(distinct ip) FROM pole_voti
It does'nt work. Why ?
P
Through the responses, links, and a little concern (and a really smart and
helpful web
Host, he did most of the hard stuff), I got MyODBC working like a charm.
Made up a file DSN and can use it in Visual C++, Visual Basic, and Access.
Also thanks to whomever put MyODBC out there...
database,sq
EDA Peach writes:
> Hi,
>
> gcc and the libstdc++ are already loaded. libstdc++
> is in /usr/local/lib should it be somewhere else?
> Please advise. Thanks.
>
> Regards, Mike
>
It could be anywhere you like as long as that directory is in LD_LIBRARY_PATH.
--
Regards,
__ ___
Dennis Jacobfeuerborn writes:
> Hi,
>
> We are running MySQL version 3.23.43 on one of our servers and have some
> stability
> problems the occur about every 1-2 days. When it happens everythings keeps
> working
> but the load goes up to about 80. After stopping and restarting MySQL
> everything
On Sun, Dec 16, 2001 at 09:49:29AM -0600, Philip Molter wrote:
> On Sun, Dec 16, 2001 at 02:00:58AM -0800, Jeremy Zawodny wrote:
> : On Mon, Dec 10, 2001 at 01:25:07PM +0800, Ares Liu wrote:
> : >
> : > So, could you give me some advice that if it is feasible ? Or show
> : > me your successful ca
I don't have MySQL on the computer I am on to test this but you might try
rewriting it this way:
select count(distinct(ip)) from pole_voit
Original Message Follows
From: Ilic <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: count(distinct
Date: Tue, 8 Jan 2002 18:47:43 +0100
SELEC
Hi Back!
>
> Hi!
>
> This is a bug that we shall soon sort out ...
OK Great, just wanted to make sure you knew about it, or that find
out what I did not understand. (So which is the correct number?)
>
> You are evidently using our BK tree ...
Well, not on that one, that is 4.0.1-alpha from
%% John Cichy <[EMAIL PROTECTED]> writes:
jc> I'm doing some experimenting with debian, has anybody created any .deb
jc> packages for MySQL?
Go to http://www.debian.org, on the left menu bar pick "Debian
Packages", then in the search box enter "mysql" (make sure the
distribution is set corr
Ken Menzel writes:
> >From show status (in mysql 4.0.1)
> | Com_select | 192446|
> | Questions| 121881|
>
> Why are there more selects than the total number of questions? Is
> that correct?
>
> There are of course Insert, deletes and other Com_ variables as
If I move the status to another table, and then wanted to get a count of
everyone who is of status 'A', how would that be any quicker? Would I
join the tables?
-Original Message-
From: Carl Troein [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 11:34 AM
To: [EMAIL PROTECTED]
Hi,
gcc and the libstdc++ are already loaded. libstdc++
is in /usr/local/lib should it be somewhere else?
Please advise. Thanks.
Regards, Mike
--- Sinisa Milivojevic <[EMAIL PROTECTED]> wrote:
> EDA Peach writes:
> > Hi Gerald,
> >
> > Sorry ... the OS is Solaris 7, running on a Sun
>
Roel Van den Bergh writes:
> After a long day of trying and reading all sorts of manuals and faqs and
> newsgroups
> I still can't create tables with the mySQLgui (1.7.5.2 windows) running in
> win 2000 pro standalone feature
>
> I can read the test database (empty of course)and the users dbase
>
Elgaard Sorensen, Karsten writes:
> Hi All.
>
> Has anybody from the MySQL source distribution successfully build a working MySQL ?
>
> I have done it using Compaq's C and C++ compiler - But I would like to have build
>instructions when using GNU C.
>
> Regards and thanks,
> Karsten Elgaard S
is WinMySQLAdmin in your Windows START folder?
-Original Message-
From: Dan Jordan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 10:04 AM
To: [EMAIL PROTECTED]
Subject: Prevent WinMySQLAdmin from auto startup when windows 98 reboots
Each time that I reboot and logon to my w
SELECT count(distinct ip) FROM pole_voti
It does'nt work. Why ?
PhpMyAdmin says: You have an error in your SQL syntax near 'distinct ip)
FROM pole_voti' at line 1
Why ?
Where is the error ?
Ilic.
-
Before posting, please c
Jean-Luc Fontaine writes:
> I would need those to finish the on-line help in my mystatus and myvars
> moodss modules for the 4.0.1 server.
> Please let me know if this is not the right place to post this.
>
[skip]
>
> I also take this opportunity to wish a very successful new year to the
> M
Hi all,
I'm doing some experimenting with debian, has anybody created any .deb
packages for MySQL?
TIA,
John
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hello Prabu,
Is it really nessesary to use proprietary Kylix environment (is it
using Pascal as a core language?) to write your application?
I'm not a specialist in Kylix but why don't you look into possibility
of using open source programming languages and editors?
For example, using just a plain
#!/your/path/to/perl
open(OLD, "yourbigfile.txt");
open(FIXED, ">newfile");
while ($line = )
{
$line =~ s/(\d{2})-(\d{2})-(\d{4})/$3-$1-$2/g;
print FIXED $line;
}
Michael
On Tue, 8 Jan 2002, Jeremy Johnstone wrote:
>
> I have a flat text file that is about 820mb I need to import into a d
On Mon, Jan 07, 2002 at 10:43:57PM -0600, Jeff Williams wrote:
>
> We have been using LDAP for our user database for some years. We
> are now getting into MySQL, and I would like to be able to grant or
> deny access within MySQL based on LDAP user information, rather than
> having to maintain a s
I didn't think/read far enough. One more attempt is due.
> > Correction on the query: SELECT count(*) as count FR
> OM userdata WHERE
> > status = 'A';
I didn't see that it was on that column you had an index,
so forget I said 'of course'. Have you used EXPLAIN to
figure out if the index is act
Hi,
We are running MySQL version 3.23.43 on one of our servers and have some
stability
problems the occur about every 1-2 days. When it happens everythings keeps
working
but the load goes up to about 80. After stopping and restarting MySQL
everything
goes back to normal (load average about 0.5).
Dear Friends,
I am trying to develop an application with Kylix
ver.1, MySQL ver.11.15 distrib 3.23.41 for suse linux
(i686).
I am using MySQLConnection object to connect my MySQL
database server (and with so :
libmysqlclient.so.10.0.0). But I found some ridiculous
problem :
1. Have setup/determ
Hi,
Would like to know if there is a "preferred" way of setting up the data
directory for mySQL. The default for a database would be in C:\mysql\data.
Is this the preferred way or should this be set up in another directory
outside of the mysql directory? Does moving the data directory affec
You are correct, they are simple Y/N fields. I am not familiar with the
process you mentioned, but will do some digging. If you have any
information you could give me that doesn't require too much of your
time, I would appreciate it.
Thanks,
Darren
-Original Message-
From: Bogdan Stan
Personnaly I found no particular spam on this list, in the beginning of the
year I found article dated to the 01/01/2003 and not the 01/01/2002, this
message was refused cause it doens t contain
words like sql
I thinks that my mail client wich doesn work well (hum outlook).
a+.
---
Greer, Darren (MED) writes:
> Correction on the query: SELECT count(*) as count FR
OM userdata WHERE
> status = 'A';
Ah. That does make a difference. MySQL is of course
forced to go through all of your data, counting the
number of rows with status 'A'. I don't believe an
index would do you much
Correction on the query: SELECT count(*) as count FROM userdata WHERE
status = 'A';
Sorry.
-Original Message-
From: Greer, Darren (MED)
Sent: Tuesday, January 08, 2002 10:20 AM
To: '[EMAIL PROTECTED]'
Subject: General Query time question
Hello all. I have a database which is around 1
Can I have different instances of winmysqladmin start instanciating
different mysql's? i want to run one for the stable version, and one for
mysql 4.0
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
Alex,
looks like a memory overwrite. A trx undo log object contains a random
field.
Did you do anything special with the database when this happened?
Regards,
Heikki
Innobase Oy
.
Bonjour,
Any idea ?
I will try to make the server crash one more time and tell you if
Hello all. I have a database which is around 10million rows. The
structure is as follows:
id int(11) NOT NULL- Auto Increment
address char(90) NOT NULL
status char(2) NOT NULL
country char(2)
state char(2)
areacode char(3)
...about 40 char(1) fields.
I have an unique index on address,
I'm having difficulty handling data and time with access. I'm using the ODBC
driver from the MySQL site to link the tables, and I can view and manipulate
the data. the problem comes when I save a time, it is displayed incorrectly
in access. Is this a known problem? If so, how do I work around this
Just take the shortcut out of the startup menu
-Original Message-
From: Dan Jordan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 10:04 AM
To: [EMAIL PROTECTED]
Subject: Prevent WinMySQLAdmin from auto startup when windows 98 reboots
Each time that I reboot and logon to my w
Each time that I reboot and logon to my windows 98 server, WinMySQLAdmin
starts and
then starts mysqld. I do not want this behavior (acting like a service).
What do I need to do to prevent this, including uninstalling WinMySQLAdmin,
which I have
not figured out how to do? When I remove my.ini f
Reported to SpamCop.net
At 15:54 2002-01-08, Carl Troein [EMAIL PROTECTED] [RegSoft/mysql] wrote:
>[EMAIL PROTECTED] writes:
>
>>
>
>I'm getting seriously sick of the amount of spam on this list.
>I don't know what MySQL employee is responsible for managing
>this list, but assuming that there i
Thanks - but my real question is where is this data stored on my system? Do I have
control to locate the databases for each client in different locations?
Mike
Simon Green wrote:
> There are two things you can do when running MySQL for other people.
> One: Use GRANT and let every one know abo
Bonjour,
Any idea ?
I will try to make the server crash one more time and tell you if I
find the query.
Regards,
Alex.
020108 9:43:58 InnoDB: Started
/opt/mysql/libexec/mysqld: ready for connections
InnoDB: Error: undo->id is 2860816
InnoDB: Assertion failure in thread 54 in file
Rezal wrote:
> hello,
> i got a really long text to put in mysql
> n when i use longtext field, it isnt enuff
>
> Can u help me pls ??
>
> thx in advance
> feroze
Sheesh! Over 4 GB in a single row? That doesn't make much sense.
Why not store the text in a file on the filesystem instead?
And jus
There are two things you can do when running MySQL for other people.
One: Use GRANT and let every one know about but not see each others
databases.
Two: Run more than one copy of MySQL on your sever...this also means that
they can be set up for each persons needs
Hope this helps...
Simon
--
>From show status (in mysql 4.0.1)
| Com_select | 192446|
| Questions| 121881|
Why are there more selects than the total number of questions? Is
that correct?
There are of course Insert, deletes and other Com_ variables as well.
I can provide the whole list
I prefer
'MySQL' by Michael Kofler (Apres ISBN 1893115577)
D Bamud wrote:
>
> Which is the **best, easy, compact** book available on MySQL. Delhi India.
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.
We run MySql on our Freebsd server, and on our Win2K server.
We have several clients, and would like to store the databases in the
clients' root directory. Is this possible?
Thanks!
-
Before posting, please check:
http://w
EDA Peach writes:
> Hi Gerald,
>
> Sorry ... the OS is Solaris 7, running on a Sun Ultra
> Sparc 5. I downloaded the Sun Solaris 2.7 Sparc
> static binary of MySQLGUI 1.6
> (mysqlgui-solaris-2.7-sparc-static-1.6.gz). I
> gunzipped the file and attempted to execute it and got
> this error messag
[EMAIL PROTECTED] writes:
>
I'm getting seriously sick of the amount of spam on this list.
I don't know what MySQL employee is responsible for managing
this list, but assuming that there is such a person, could
he/she _please_ do something about the problem? When every
other list owner can fig
Matthew Darcy writes:
>
> Hi,
>
> my laptop is running windows 2000 and is called jaguar.
> I have mysql running on a linux server called jordan.
>
> when I fire up mysqlui and tell it to connec to jordan as root I get
> prompted for a password. I enter the password (that I have tested and is
>
* Osnat Rabi
> My table has 3 columns: id, name, timestamp.
>
> When I use the MySQL command line client,
> (a) insert into table values(1,'xxx') fails for
> insufficient number of values.
I don't know if this will help you, but this is valid:
insert into table set id=1, name='xxx';
-
1 - 100 of 129 matches
Mail list logo