Thank you very much Jørn
Blessed Be
Phillip
"Never ascribe to malice what can be explained by incompetence"
-- Hanlon's Razor
On Mon, Jan 31, 2011 at 1:18 PM, Jørn Dahl-Stamnes
wrote:
> Jørn
.
So looking for something that works a bit better.
Any suggestions?
Blessed Be
Phillip
"Never ascribe to malice what can be explained by incompetence"
-- Hanlon's Razor
Greetings Michael,
Thanks for the info.
I am on a Linux box running Ubuntu.
Blessed Be
Phillip
"Never ascribe to malice what can be explained by incompetence"
-- Hanlon's Razor
On Thu, Oct 28, 2010 at 1:55 PM, Michael Dykman wrote:
> Phillip,
>
> give us a starti
options for setting up a D/S/P environment with the MySQL
database that will be used by us for the site.
Any suggestions would be helpful.
Thanks.
Blessed Be
Phillip
"Never ascribe to malice what can be explained by incompetence"
-- Hanlon's Razor
Product_id | Category_id
1| 1
1| 3
2| 2
3| 3
3| 4
Result would look like
Product A, Admin, Support
Product B, Marketing
Product C, Support, IT
I believe this is a one to many using an index table?
Blessed Be
Phillip
result that has
Product A one category other category
Product B other category
Thanks in advance.
Blessed Be
Phillip
If you try to protect idiots from themselves, even if you succeed, you just
wind up filling the world with idiots.
- - Doug Casey
e? I don't
remember the particular tablesize at that time, but it could easily get
to be around 1 gig or more.
Any suggestions?
Your friendly neighborhood SA,
phiLLip
Paul DuBois <[EMAIL PROTECTED]>
11/03/2005 12:11 AM
To
[EMAIL PROTECTED], mysql@lists.mysql.com
cc
Subject
Re: o
in advanced
Your friendly neighborhood SA,
phiLLip
Egor Egorov wrote:
"Phillip Mangwiro" <[EMAIL PROTECTED]> wrote:
I'm getting an Error 1130, ("MyDNSName is not allowed to connect to this
machine"), whenever I try to connect to MySQL server from any client by
using its IP or "friendly" DNS name ot
I'm getting an Error 1130, ("MyDNSName is not allowed to connect to this
machine"), whenever I try to connect to MySQL server from any client by
using its IP or "friendly" DNS name other than 127.0.0.1 or localhost.
This has happened on three machines so far, is there something I forgot to
enable/d
in
table one.
Make sense??
Thanks
Phillip
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
perl-5.00503-2
libdb.so.3(GLIBC_2.1) is needed by cyrus-sasl-1.5.24-C4
libdb.so.3(GLIBC_2.1) is needed by sendmail-8.10.2-C4
[root /JON]#
Any help would be appeciated :)
--
Best Regards, Phil
Phillip
How do I write a SQL call to take the results of a select statement and
plug them into a new table in the DB?
Thanks
Phillip
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
ectly.
The system the employees use is located on localhost, while the other isn't.
Do you think this would make a difference, how about different versions of
the client libs?
Any ideas?
Phillip Salzman <[EMAIL PROTECTED]> said:
>
>
> Hello,
>
> I just setup replic
table and do a 'load table from master', and it will update the
changes to each row, but won't add new rows to the slave.
Has anyone seen this before? I've been looking online and cannot seem to find
anything. Any assistance would be very much appriciated.
Thanks,
I can not find anywhere that says that mysql supports table name synonyms.
For example, I have two databases (test1 and test2) in the same mysql instance.
In test1 schema, there is a table called "table1"
I would like to create a synonym whereby I could refer to test1.table1 as
test2.table1 wh
Greetings all,
I have a users table in the DB.
I am importing allot of existing data from various places into this users
table.
There is a strong likelihood of the same user getting entered twice.
Though each record will have a separate and unique ID, I want to be able to
query the table and lo
Hold the phone - I've just realised that those tables 'missing' .ISM files are
actually supposed to be MyISAM - (I have complete MYD and MYI files) - not ISAM (ISM,
ISD) - how do I tell MySQL this is the case?
TIA (Again)
/Phil
On Sun, 02 Jun 2002 21:28:17 +0100
"Ph
Hi,
In haste to change some server hardware I copied the /var/lib/mysql directory directly
assuming this would suffice in order to carry the data over. I'm pretty certain I
stopped mysqld, but regardless I now seem to be missing nearly all the respective .ISM
files for my databases.
Now, I'm
On Sat, 2 Feb 2002, Sinisa Milivojevic wrote:
> Subject: Re: Core dump with mysqld-3.23.47-log
>
> Phillip Porch writes:
> > >Description:
> > The problem I am having is on a SCO Openserver 5.0.6a system. I
> > compiled mysqld-3.23.47-log myself as well
-pthreads-3.8 but still
get the same problem.
>Submitter-Id:
>Originator:Phillip Porch
>Organization:
Phillip P. Porch <[EMAIL PROTECTED]> NIC:PP1573 finger for
http://www.theporch.com36 05 45 N 86 50 20 W GnuPG key
>
>MySQL support: none
>Synopsis
Hi,
Simple question. What is the largest hardware implementation
that is know for mysql to run on? How well does mysql scale
on large platform systems such as Sun E10k, HP Superdome as
an example.
--
*** Phillip B. Bruce
rp -R mysql /usr/local/mysql
shell> cp support-files/my-medium.cnf /etc/my.cnf<=== Here is
the step you left out
shell> /usr/local/mysql/bin/safe_mysqld --user=mysql &
--
*** Phillip B. Bruce ***
The biggest reason is that coping data while the database server is up and
running can cause corruption of
the data as open files are an issue. But I know there are other application
that help in getting around this.
I'm not near famil
Hi,
How can I import a text file database in which delimiters are "|"
character field
separated into mysql database?
--
****
*** Phillip B. Bruce ***
*** http://pbbruce.home.mind
;w");
if (!f) exit(1);
fprintf(f, "%d\n", sizeof(char));
exit(0);
}
I would appreciate any ideas on this. I have compiled mysql 3.20 version
in the past with
no problem but wondered if this is a bug?
--
;w");
if (!f) exit(1);
fprintf(f, "%d\n", sizeof(char));
exit(0);
}
I would appreciate any ideas on this. I have compiled mysql 3.20 version
in the past with
no problem but wondered if this is a bug?
--
Make sure you have permissions to connect to the remote site from your
current server or host. Permissions need to be set for that user to connect
from your server host
- Original Message -
From: "Hamzat Kamal" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 03, 2001 8:2
this cmd line
/usr/local/mysql/bin/safe_mysqld --user=mysql --memlock -O key_buffer=256M
-O table_cache=512 \
-O sort_buffer=32M -O record_buffer=8M &
Thanx!
>On Wed, Sep 19, 2001 at 04:37:03PM -0400, Phillip Spademan wrote:
> > Hello All.
> >
> > I am working with a
Hello All.
I am working with a rather large MySQL DB, it seems that it likes to swap
ALOT, even after the operations are done, i have bumped up my cache sizes, i
have tones of .bin files in my var dir, any ideas?
Thanx!
_
Get you
Hello:
I am runnin' a mysql DB with about 90mil entries. on a 1Ghz system with 1G
ram, it takes forever to get anything out, i have even tryed selecting the
data into a file. Is there any tricks/tips anyone can give me for managing
large DB's? It also likes to crash tables every month or so t
I have a simple table I created that was made from parts of other tables
that just has 2 fileds. The first field is an ID number and the second is a
score. Now each ID can have from 1 to 15 scores and what I need to do is for
each ID, get the average of the top 6 scores.
Is there a way to do this
I have compiled 3.23.38 without problems. I ran the test suite and mysqld
passed all 117 tests (I think it was 117). mysql client works fine but I
tried to use mysqldump and received a core dump (segmentation violation). I
also receive this if I try and run mysqlshow. As far as I can tell,
everyth
>Description:
When I try and run mysqldump, I get a core dump.
>How-To-Repeat:
it repeats anytime I try and run mysqldump.
>Fix:
I have not found a fix yet.
>Submitter-Id:
>Originator:Phillip Porch
>Organization:
Phillip P. Porch <[EMAIL PROTECTED]> N
Please unsubscribe me from the list.
-Original Message-
From: Michael Widenius [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 10:35 AM
To: [EMAIL PROTECTED]
Cc: Arne Claassen; Heikki Tuuri; [EMAIL PROTECTED]
Subject: Re: Signal 11 on Innobase table range queries
Hi!
> "Jere
Hi,
This is the first time I have ever used or attempted to install my sql. I am
using a Sun Ultra 5 with Salaris 5.8. I have downloaded
mysql-3.23.34-sunsalaris2.7-sparc.tar.gz and have attempted to unzip this
with the command:
gunzip < mysql-3.23.34-sunsalaris2.7-sparc.tar.gz | tar xvf -
All
/libp
Any ideas why this stupid Config is not working? Any help
would be appreciated.
--
******
*** Phillip B. Bruce**
*** http://pbbruce.home.mindspring.com
to this or is this a bug?
--
******
*** Phillip B. Bruce**
*** http://pbbruce.home.mindspring.com **
*** [EMAIL PROTECTED] **
**
-
Bef
at you are trying to do but in any
case
check out the blob column type in the mysql manual. Also, you are
probably
better off storing the image on disk and only store the URL in the
database.
Whichever the case, good examples can usually be found at
www.devshed.com
- Original Message -
From: \
How do I save an images to a unix file that is saved in mysql? I know how to view the
image with PHP and I know how to write a file to unix. I just can't get the data from
mysql into a format that will allow me to read it then write it.
--
Hello,
I am working on loading data into a table from a text file. I've read
the documentation on the LOAD DATA command. But I noticed that it only
works with some kind of delimited file. Is there any way to load a
fixed width file???
Thanks in advance!
ph
41 matches
Mail list logo