At 11:13 AM 8/30/01 +0200, Carl Troein wrote:
>A quick question: How come the mailing list software
>doesn't add a reply-to header? Is this intentional to
>keep replies off the mysql list, and if so why?
>I'll try to remember to reply to the list rather than
>directly to the people who ask the que
On Thu, Aug 30, 2001 at 12:08:22PM -0700, [EMAIL PROTECTED] wrote:
> Hi People,
>
>I'm trying to execute this Simple query:
>
> SET SQL_SAFE_MODE=0;
>
> The server doesn't like it; However, SET any other option will work fine
> except this one.
>
> I'm still using mysqld v3.23.36 . If some
Hi!
> "mmokrejs" == mmokrejs writes:
mmokrejs> On Thu, 30 Aug 2001, Michael Widenius wrote:
mmokrejs> Hi,
mmokrejs> yes this patch *fixes* all of my problems, except one table which is/was
mmokrejs> probably too big? I haven't found any options that would make myisamchk to
mmokrejs> ask
Hi!
I am trying to compile mysql on one of our new servers. (RH 7.1)
Compilation stalles after these messages:
...
checking whether build environment is sane... yes
checking whether make sets ${MAKE}... (cached) yes
checking for gawk... gawk
checking for gcc... gcc
checking whether the C compi
On 31-Aug-2001 Greg Callaghan wrote:
> Hi,
>
> I have tables in which I use the mysql "AutoIncrement" facility to generate
> a new ID when creating new rows.
>
> What I typically do is to (a) create a new row and then (b) retrieve the
> associated ID directly after this by using the "SELECT I
Rory O'Connor writes:
> I want to leave one record behind, but delete all other records that
> have the same e-mail address. Is there a standard query for this or do
> I need to write a script that will do it?
Getting a list of the duplicate rows is simple enough, but
deleting them requires a
[EMAIL PROTECTED] wrote:
> Question,
>
> Could some one tell me why our mysqld daemon appears to be incrementing on time.
> For instance I get the following output when I use ps -elf. the 470 you see below
>was 460
> 30 secs ago. Is there a memory leak or ?we are using MySql 3.23.30
Hi,
I have tables in which I use the mysql "AutoIncrement" facility to generate
a new ID when creating new rows.
What I typically do is to (a) create a new row and then (b) retrieve the
associated ID directly after this by using the "SELECT ID FROM TABLE_NAME
WHERE ID IS NULL" method.
Should
Dear Future Millionaire:
I'll make you a promise. READ THIS E-MAIL TO THE END! - follow what it
says to the letter - and you will not worry whether a RECESSION is coming
or not, who is President, or whether you keep your current job or not. Yes, I know
what you are thinking. I never responded to
I want to leave one record behind, but delete all other records that
have the same e-mail address. Is there a standard query for this or do
I need to write a script that will do it?
THanks,
Rory
On Thu, 30 Aug 2001 22:35:48 -0500, "Rory O'Connor" <[EMAIL PROTECTED]>
wrote:
>Do you want to dele
I've been playing with MySQL and trying to get connected to my web-hosting
company's MySQL server that they set up for me. In trying to use the
MySQLGui and also the VCC, I get the error "Host 'junior.dsl.neticus.com' is
not allowed to connect to this MySQL server". And if I'm plugged in at work
Do you want to delete all records which have duplicates, or do you want to
delete all the duplicates but leaving one copy of each duplicated record
behind?
- Original Message -
From: "Rory O'Connor" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 30, 2001 4:50 PM
Subje
Do it this way:
Create Table copy ( sessionid int not null auto_increment,
username varchar(20 not null,
start int not null,
stop int not null,
ipaddress varchar(15),
Primary Key (sessionid),
Index altkey (username, start, stop)
);
Insert Into copy
Select NULL, username, start, s
Looking at this post and your previous one, you could just create a new
table with the same definition as the old table except to make the field you
want with the numbered field be an "int auto_increment" datatype.
Then do the following SQL:
Insert Into newtable
Select field1, field2, NULL, fiel
Snitz Forum 2000 is working great now! I don't know exactly what I did
though. It never did run the setup.asp exactly as it should. A
combination of MySQL root password privileges, GRANTS, UPDATES, just the
right chmods and trying setup.asp, setup.asp?RC=5, setup_login.asp got
it done.
I want to
At 11:54 AM -0600 8/28/01, root wrote:
> >Description:
>I downloaded, via ftp, and installed MySQL-3.23.41-1.i386.rpm.
That's the RPM that contains the server. mysqladmin is a client.
Install the client RPM.
>The user instructions at the end of the rpm -i ./*.rpm command
>proscripbed the use
You know what .. the problem with the command line switchs is they are so
hard to remember...
Take "myisamchk -Ber ..." for instance
Now if it was myisamchk -Beer ... or myisamchk -JugOfBeer ... then people
might do better maintenance!
Sid
-Original Message-
From: Rodney Broom [
From: Bill Blowitz <[EMAIL PROTECTED]>
> Try fixing all tables/indexes.
Actually, I started with
% myisamchk -Ber ...
on all tables that -e said needed to be fixed.
---
Rodney Broom
Programmer: Desert.Net
-
Before posting
Try fixing all tables/indexes.
-Original Message-
From: s. keeling [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 5:55 PM
To: mysql_mailing list
Subject: Re: Debugging: Analysis
On Thu, Aug 30, 2001 at 05:01:14PM -0700, Rodney Broom wrote:
>
> mysqld is restarting, a lot.
On Thu, Aug 30, 2001 at 07:01:35PM -0600, s. keeling wrote:
> BTW, the list filter is borken. I *have* "sql" in this post, yet
> the filter rejects it anyway.
It probably doesn't check for substrings.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408)
On Thu, Aug 30, 2001 at 05:21:57PM -0700, Igbar Foosenhopper wrote:
> Thursday, August 30, 2001, 2:13:56 AM, you wrote:
>
> CT> A quick question: How come the mailing list software
> CT> doesn't add a reply-to header? Is this intentional to
>
> Reply to All seems to work
In mutt ("g" for group-
From: s. keeling <[EMAIL PROTECTED]>
> > vio_read: error: Got error 35 during read
> Error code 35: Resource deadlock avoided
That fits with with the SIG 11 that I'm seeing in the error log.
> > vio_read: error: Got error 4 during read
> Error code 4: Interrupted system call
That mus
On Thu, Aug 30, 2001 at 05:01:14PM -0700, Rodney Broom wrote:
>
> mysqld is restarting, a lot. So I put it into debug mode, got 200KB+
> trace file, and then took mysqld out of debug mode. Now I'm trying
> to analyze the trace file. The best clue I'm finding are these
> lines:
>
> vio_read: er
Hello Carl,
Reply to All seems to work
Thursday, August 30, 2001, 2:13:56 AM, you wrote:
CT> A quick question: How come the mailing list software
CT> doesn't add a reply-to header? Is this intentional to
CT> keep replies off the mysql list, and if so why?
CT> I'll try to remember to reply to th
one thing i would like to see on the list is a subject tag.
i have most of my mail clients setup to sort, but my web based mail
doesn't:(. would be nice if the list messages had a tag so when i see a
subject: HELP! i don't have to either open the message or look for a Re:
HELP! immediately an
> > A quick question: How come the mailing list software
> > doesn't add a reply-to header? Is this intentional to
> > keep replies off the mysql list, and if so why?
I just finished writing a mail list system, so I'll give this a shot.
When the mail list software gets a message in, he has to se
At 11:13 AM +0200 8/30/01, Carl Troein wrote:
>A quick question: How come the mailing list software
>doesn't add a reply-to header? Is this intentional to
>keep replies off the mysql list, and if so why?
>I'll try to remember to reply to the list rather than
>directly to the people who ask the que
If your SLA allows for inconsistent data you're covered.
Dave
On Thu, Aug 30, 2001 at 05:41:43PM -0600, Matthew Walker wrote:
> I just got mysqldump working. And it doesn't necessarily lock the tables
> before it does the dump, so it doesn't interrupt service unless you tell
> it to.
>
> Thank
At 6:10 PM -0700 8/30/01, Daren Cotter wrote:
>i have a query that needs to do the following:
>
>in my members table, i store the member id, and the referer id of the member
>that referred them (the referer_id links to the member_id).
>
>for example, a member signs up and gets the id of 0200289, a
On Thursday 30 August 2001 11:43, you wrote:
> Mike, John;
>
> What mike is saying below seems quite true:
>
> > "For normal internal use, MySQL costs nothing. You do not have to pay us
> > (them) if you do not want to."
>
> That being said, Caldera PS has fielded clients who specifically ask f
mysqld is restarting, a lot. So I put it into debug mode, got 200KB+ trace file, and
then took mysqld out of debug mode. Now I'm trying to analyze the trace file. The best
clue I'm finding are these lines:
vio_read: error: Got error 35 during read
vio_read: error: Got error 4 during read
On Thu, Aug 30, 2001 at 04:48:16PM -0500, [EMAIL PROTECTED] wrote:
>
>
> Question,
>
> Could some one tell me why our mysqld daemon appears to be incrementing on time.
> For instance I get the following output when I use ps -elf. the 470 you see below
>was 460
> 30 secs ago. Is there a m
> A quick question: How come the mailing list software
> doesn't add a reply-to header? Is this intentional to
> keep replies off the mysql list, and if so why?
http://www.unicom.com/pw/reply-to-harmful.html
-
Before posting, pl
I just got mysqldump working. And it doesn't necessarily lock the tables
before it does the dump, so it doesn't interrupt service unless you tell
it to.
Thanks for everyone's help. I now have a working backup script.
-Original Message-
From: David Turner [mailto:[EMAIL PROTECTED]]
Sent:
i have a query that needs to do the following:
in my members table, i store the member id, and the referer id of the member
that referred them (the referer_id links to the member_id).
for example, a member signs up and gets the id of 0200289, and was referred
by 0001008. anyway, over time, when
Hi,
There was allot left un-said:-) assuming you can not
get access to the command line dump.
select * from your_table_name into outfile "your_home_dir/your_filename";
This will create a text file.
Now download these files and save them.
reverse
load data infile "your_home_dir/your_filename"
excuse me if this is too newbie...but I need to perform a duplicate
delete on my database using the e-mail address as the key. I understnad
how to use COUNT and DISTINCT together...
select count(DISTINCT email) FROM table;
but I can't seem to find any info on how to perform the actual deletio
On Thursday 30 August 2001 04:13 am, Carl Troein wrote:
> A quick question: How come the mailing list software
> doesn't add a reply-to header? Is this intentional to
> keep replies off the mysql list, and if so why?
Generally, I hit reply-All, and then just edit the To Line:-)
> I'll try to rem
At 12:30 PM -0700 8/30/01, Sujay Daniel wrote:
>I'm a newbie to Unix and MySQL. I have a few
>questions.
>
>With 'uname -a' I got the following message
>
>SunOS [EMAIL PROTECTED] 5.7 Generic_106541-06 sun4u sparc
>SUNW,Ultra-1
>
>Can i install mysql-3.23.41-sun-solaris2.8-sparc in
>it.
>
>Theres n
Curtis ...
Do you have the database/table created on the MySQL server? If so, you can
use MSAccess (need ODBC connections to both servers) to Link Tables and move
the data acros that way.
We did it that way until our programmers wrote a C++ app that replicates
server-to-server.
Gerald Jensen
-
Can I remove the rigth for one user to see one specific table in database?
for exemple:
user: bob
table: tab_secret
database: Customer_service
Bob can see any table in DB Customer_service except the table tab_secret.
--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--
François Boucher
Greetings,
We're having some problems with our one way replication "stalling".
There are no errors in the errors logs, and the status reports seem to
indicate things are still running, however, changes to the master are
not being received by our slaves.
We're running a farm of 4 slave mysql m
Question,
Could some one tell me why our mysqld daemon appears to be incrementing on time.
For instance I get the following output when I use ps -elf. the 470 you see below
was 460
30 secs ago. Is there a memory leak or ?we are using MySql 3.23.30
What can I do to resolve this???
> database,sql,query,table
So sprach =BBJaime Teng=AB am 2001-08-31 um 03:53:47 +0800 :
> Is there a "number sequence" generator/function in
you can set the INT types to auto_increment, which will do just that
when you insert rows.
Alexander Skwar
--
How to quote: http://learn.to/quote (germ
I'm new to MySQL and I'm sure this has been covered, but I can't find it so
I'll ask here. What is the best way to backup a MySQL database that is
hosted on a remote server.
Our web site is hosted by a hosting company and they configured MySQL. I
want to backup the database periodically. I've
Hi,
Every time we have run into this one, is
because somthing updating, was out of sync.
Best Regards
On Thu, 30 Aug 2001, Dave Berk wrote:
> the master has the correct permission. however the slave reports this
> error.
>
> Slave: Failed reading log event, reconnecting to retry, log
> '
the master has the correct permission. however the slave reports this
error.
Slave: Failed reading log event, reconnecting to retry, log
'mysql-bin.log' position 30
Slave: reconnected to master 'mysql@mydb203:3306',replication resumed in
log 'mysql-bin.log' at position 30
Slave: received 0 lengt
Add an auto_increment column of an appropriate int size.
Jaime Teng wrote:
> Hi,
>
> Is there a "number sequence" generator/function in
> MySQL such that if I were to execute:
> "UPDATE mytable SET id = thisfunction;"
> it will update the table mytable and set the column
> id to a numbered sequ
> Hi,
>
> I have a mysql table:
> +---+--+--+-+
> | Field | Type | Null | Key |
> +---+--+--+-+
> | sessionid | int(10) unsigned | | PRI |
> | username | char(20) | | MUL |
> | start | int(10) u
When using the Java call to executeUpdate() for an update statement, the return value
should be the number of rows affected.
mysql is returning a value of 0 on a successful update when it should return 1. The
database is being updated properly, only the response is wrong.
---
That seems like rather a bad idea to me.
Would that not leave anything else that references the sessions
looking at the wrong session?
Jaime Teng wrote:
> Hi,
>
> I have a mysql table:
> +---+--+--+-+
> | Field | Type | Null | Key |
> +---
On Thu, Aug 30, 2001 at 11:00:14AM -0600, Benjamin Krajmalnik wrote:
> OK. I tracked the problem to being out of disk space in the var partition.
> The default source installation plaved the data in the /var/db directory.
> The var partition is not that large by default, and therefore I am now ou
On Thu, Aug 30, 2001 at 02:50:47PM -0400, Ryan Shrout wrote:
> I have tried to enable slow query logging for a couple days now, with no
> success.
>
> I have tried adding the line to the my.cnf file as well as stoppign the
> service then starting it with the command line version. Both ways, the
Thanks for the response Joshua,
That is an option - however not one I would be very comfortable with. I have
a similar setup for virtual hosts generally - wanted something more flexible
and powerful for a virtual server implementation without taxing the actual
server too much.
For example, the m
Hi Ryan,
Did you look in you "hostname.err" file for the error at the end of
the file? Are you running the mysql daemon as root? Could it be the
user you are running mysqld as does not have permission to write to
/root? The ".err" file by default is in the directory with your other
logs (on
On Thu, 30 Aug 2001, Michael Widenius wrote:
Hi,
yes this patch *fixes* all of my problems, except one table which is/was
probably too big? I haven't found any options that would make myisamchk to
ask for less memory.
/usr/local/mysql/bin/myisamchk: Out of memory (Needed 4294922813 bytes)
/usr
Hi,
Is there a "number sequence" generator/function in
MySQL such that if I were to execute:
"UPDATE mytable SET id = thisfunction;"
it will update the table mytable and set the column
id to a numbered sequence "1,2,3,4,5,6,7,8,9."?
currently, i have a table with 2.5 million records and
i wa
I have a nicely sized database of about 40 records, which I have in
MS SQL but I need to move it to my production server, which is Mysql. I
was going to do it this way:
Export MS SQL database into a file and then use LOAD DATA INFILE
But I was wondering if there were a way to export into SQ
The short answer is that you can't, if you're using a named pipe
(/tmp/mysql.sock, or some such). That would require every user having their
own installation of MySQL, which may be what you want.
Why not have the users connect via TCP/IP, and just set permissions
correctly? They would be abl
i think the server does not run with privileges
to write to /root
regards
Sven Huster
Senior IT Systems Engineer
Sven Huster
Senior IT Systems Engineer
> -Original Message-
> From: Ryan Shrout [mailto:[EMAIL PROTECTED]]
> Sent: 30 August, 2001 20:51
> To: [EMAIL PROTECTED]
> Subject
You mean leading zeros? MySQL will translate as much of a string as it can into a
number when it is cast:
mysql> select ('a'+0);
+-+
| ('a'+0) |
+-+
| 0 |
+-+
1 row in set (0.00 sec)
mysql> select ('00010'+0);
+-+
| ('00010'+0) |
+-+
|
On Thu, Aug 30, 2001 at 10:22:02AM -0600, Jeff Isom wrote:
> I am fairly new to MySQL and I am unfamiliar with the term "escaped form".
This a Unix-ism. For instance:
"this line"
'this line'
this\ line
The last two are functionally equivalent. The last one has an
'escaped' space embe
Hi,
I have a mysql table:
+---+--+--+-+
| Field | Type | Null | Key |
+---+--+--+-+
| sessionid | int(10) unsigned | | PRI |
| username | char(20) | | MUL |
| start | int(10) unsigned | | M
Anyone,
I apologize for broadcasting to the group, but I've been trying to set-up a
maintenance contract
and licenses for about a month and no-one seems to be listening to the sales and
licensing
e-mail drops for MySQL AB Company.
I assume those that are 'in the know' can direct me to some 'r
I'm a newbie to Unix and MySQL. I have a few
questions.
With 'uname -a' I got the following message
SunOS [EMAIL PROTECTED] 5.7 Generic_106541-06 sun4u sparc
SUNW,Ultra-1
Can i install mysql-3.23.41-sun-solaris2.8-sparc in
it.
Theres no installation instructions for Unix/Solaris
machines in th
Thanks Gerald!!
That did the trick and everything seems to be running perfectly!
At 01:59 PM 8/30/2001 -0500, Gerald Clark wrote:
>Unfortunately, when you moved the directories, you forgot to make mysql
>the owner
>of the new directory.
>
>chown -R mysql /data/mysql
>
>
>Philip Daggett wrote:
>
Jeff Isom writes:
> I am fairly new to MySQL and I am unfamiliar with the term "escaped form".
> Can anyone point me to documentation that explains what that is and how it
> can be used.
>
> Also, I am trying to perform a backup remotely. My understanding is that
> the mysqldump and mysqlhotcop
Gerhard,
Thank you for your response.
Emphasizing that I am new to this, could you describe in a bit more detail
how I could put this in the new root structure? (client's chrooted
structure)
If this is too extensive to properly explain, is there some documentation
available which might help?
I
Evening Jay,
I'm still abit new to MySQL. Spending the last 6 months I have worked
with it more on my CGI development, than good SQL query practicing. My
technical jargon is lacking. In laymens terms ( I know no other at this
point in time ) I have a row that has '1' or '0' in it. I'm trying to
Yes.
A feature of MySQL is that it returns 1 for true and 0 for false. When you
select ... you can put logic tests and sum up the number of true values. In the
case of "bool_was_connected=0" will have a value of 1 when it is true and then
you sum up the results.
You could also do something lik
Hi People,
I'm trying to execute this Simple query:
SET SQL_SAFE_MODE=0;
The server doesn't like it; However, SET any other option will work fine
except this one.
I'm still using mysqld v3.23.36 . If someone can try it on the latest version.
Thanks.
Randy,
-
Calvin,
Maybe I'm just confused (fairly likely), but it appears that you are
confusing 'null' with zero. If you actually want to count all values
including nulls, COUNT(*) will do it. If you want to count NON nulls,
COUNT(a_field_name) does it. SUM(a_field_name) returns the sum of all
non-null
Thankyou kindly Bill. Just to verify, SUM adds up values. My data
is only 1 or 0. I used SUM as an example, the below query you recommend
will count all 'rows' which are 0, thus returning a number which
represents how many 0's were found?
Thankyou for the fast reply,
Calvin
On Thu, 30 Aug 2001,
Two problems.
The clients don't have access to the databases, the server does.
Chrooted clients will not be able to read and write the named pipe
unless it is in their new root structure.
Mustafa Hashmi wrote:
> Hi all,
>
> I am in the process of creating a Virtual Server - and pretty much all
SELECT SUM( bool_was_connected=1 ) AS was_connected,
SUM( bool_was_connected=0 ) AS was_not_connected, etc...
b.
[EMAIL PROTECTED] wrote:
> Evening Gurus,
>
> I have a small problem that I've beaten to death the past 2 days. I am
> trying to get the value of a row, and update another table
Unfortunately, when you moved the directories, you forgot to make mysql
the owner
of the new directory.
chown -R mysql /data/mysql
Philip Daggett wrote:
> Hello everyone!!
>
> I am installing the latest rpm for mysql 3-23.41 on a RedHat 7.1 box and
> want the "datadir" to be "/data/mysql/da
Evening Gurus,
I have a small problem that I've beaten to death the past 2 days. I am
trying to get the value of a row, and update another table accordingly.
The data within the row is either a 1 or 0. My issue is in trying to
increment a count for both 1's and 0's.
In other words, I want t
I have tried to enable slow query logging for a couple days now, with no
success.
I have tried adding the line to the my.cnf file as well as stoppign the
service then starting it with the command line version. Both ways, the
server refuses to restart. I have checked the syntax over and over and
Monty helped me with this, and this is my
understanding.
Regardless of what order you generate the keys,
MySQL puts the primary key first, then the UNIQUE
keys, then the others.
When you add a new UNIQUE key, it puts it after
the primary key but before the other existing
UNIQUE keys.
In your c
Well, I don't know if you can specify what order to put these in,
but mine just happen to not be in the same order:
mysql> show index from all_records;
++-+--+-+---+---
--+--++
| Non_unique | Key_name| Seq_in_inde
Webmaster Odell wrote:
> Hi
>
> I am trying to write a query that pulls all the items from a database except
> two
>
> here is what I am using:
>
> $query = 'SELECT DISTINCT Type FROM Products WHERE Type != "System,
> Upgrade"';
>
> This populates the drop down box with all including the System
Hello everyone!!
I am installing the latest rpm for mysql 3-23.41 on a RedHat 7.1 box and
want the "datadir" to be "/data/mysql/data". In my "/etc/my.cnf" file I
have the directive:
[mysqld]
datadir=/data/mysql/data
The installation completes but the daemon won't start. I do the
mysql_instal
Hi all,
I am in the process of creating a Virtual Server - and pretty much all
aspects have been completed to my liking. This includes web / mail / ftp and
ssh.
The next hurdle is virtualizing MySQL, and I would like to do this by
sharing the same MySQL server across multiple chrooted clients. T
I have been playing around with merge tables. You MUST have the columns and
indexes in the same order.
Eg. Do
SHOW INDEX FROM real_table;
SHOW INDEX FROM merge_table;
If the Column_name order is different you will get either no records or a
bunch of null records when you select on a column that
I use MySQL a number of different ways: the C API, from PHP, from the
command line, and often from shell scripts run by other users or from
crontab entries. The latter two uses present a couple of problems that
could be fixed easily through some minor changes to the code for the "mysql"
program
What about a number field w/zero fill?
On Thu, 30 Aug 2001, Adams, Bill TQO wrote:
> Date: Thu, 30 Aug 2001 08:48:11 -0700
> From: Adams, Bill TQO <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: order by number
>
> If the column is an int then it will order it
Hi,
I'm running mysql MAX 3.23.41 on LinuxPPC, everything was installed from
an RPM.
My problem is whenever I try to call mysql_connect (), from a php3
script, I got the error function not found or misconfigured
The script is a simple form, that passes the data to be added to an
empty d
> now i changed the root password just fine
> but now i have to enter it every time i run mysqladmin
> even "mysqladmin version" reqires a "-p"
>
> tell me there's a simpler way
http://www.mysql.com/doc/C/o/Connecting.html
* You can specify connection parameters in the [client] section of th
now i changed the root password just fine
but now i have to enter it every time i run mysqladmin
even "mysqladmin version" reqires a "-p"
tell me there's a simpler way
-
Before posting, please check:
http://www.mysql.com
> i think this is jeremy's not-so-subtle way of bashing your choice of email
> client.
> check this link:
> http://www.rodos.net/outlook/#messageflag
>
> -ravi.
>
Yeah, yeah - I got it. Only problem is that I DON'T have a choice (company
policy et al)...
\:^{
Jay Fesco
Magical Myst
SELECT DISTINCT Type FROM Products WHERE Type != "System" AND Type !=
"Upgrade"
-- Jason
On Thu, 2001-08-30 at 15:35, Webmaster Odell wrote:
> Hi
>
> I am trying to write a query that pulls all the items from a database except
> two
>
> here is what I am using:
>
> $query = 'SELECT DISTINC
Hi all,
I hate to bring this up in the group, but I haven't found an answer on the site. I've
got mysql-3.23.30-gamma-unknown-freebsdelf4.2-i386.tar.gz installed, but I need to
recompile a little differently. My problem is that I can't find this version in source.
Can anybody tell me where I ca
perror 28
Error code 28: No space left on device
Benjamin Krajmalnik wrote:
> I have a deployment of mySQL 3.23.26-beta running on FreeBSD 4.2-RELEASE.
> I am running 3 databases off of a single mySQL server.
> In one particular database I am unable to insert records - the process just
> han
OK. I tracked the problem to being out of disk space in the var partition.
The default source installation plaved the data in the /var/db directory.
The var partition is not that large by default, and therefore I am now out
of space.
I would like to move the data to a /usr/local/mysql/data direct
Benjamin Krajmalnik wrote:
>
> I have a deployment of mySQL 3.23.26-beta running on FreeBSD 4.2-RELEASE.
> I am running 3 databases off of a single mySQL server.
> In one particular database I am unable to insert records - the process just
> hangs.
> My intuition would tell me that maybe somethin
April Sims ([EMAIL PROTECTED]) writes:
> Is there anything I need to be doing maintenance wise on a mysql database?
> I have inherited one that was installed as follows
>
> As far as database stuff that we do, we basically
> installed the server, set up databases and tables, and use them.
>
Has anyone tested dropping a master database?
I have dropped the master database that was replicating just to see how it
would affect the slave. The slave kept its data.
What would the proper proceedure be in this case?
I wouldnt be able to snapshot the slave and then port the snapshot back into
I have a deployment of mySQL 3.23.26-beta running on FreeBSD 4.2-RELEASE.
I am running 3 databases off of a single mySQL server.
In one particular database I am unable to insert records - the process just
hangs.
My intuition would tell me that maybe something is corrupted in the index.
Since I hav
-Original Message-
From: Ravi Raman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 12:05 PM
To: Jay Fesco
Subject: RE: Licensing terms for an Intranet site
hi.
i think this is jeremy's not-so-subtle way of bashing your choice of email
client.
check this link:
http://www.ro
Hi Jay,
I'd definitely suspect Outlook (or LOOKOUT! as a few of my network support buddies
call it) as the source of the problem, rather than anything to do with Jeremy's emails.
I'm having no problems here -- but then again, I don't use any Microsoft products. :>
Good luck,
/Rob
As Rob Gla
1 - 100 of 160 matches
Mail list logo
