,
especially on high-volume sites?
Any insight would be greatly appreciated!
-Erich-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
be returned. The issue is that the
second record does not have an entry in the votingapi_cache table. I
used a right join on that table, expecting to get the record back with a
NULL in the vote_average column, but that didn't happen.
How can I get both records to be found?
-Erich-
Craig,
Thank you for your insight. Having never worked with clustering
solutions, what kinds of headaches might one see with that solution?
Does anyone know of any white papers that might shed some light into the
pros and cons of each solution?
-Erich-
Craig Huffstetler wrote:
I highly
s are most welcome.
-Erich-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
week_number_R char(3) NOT NULL default '',
PRIMARY KEY (date_stamp),
KEY day_of_week (day_of_week),
KEY day_in_month (day_in_month),
KEY day_in_month_R (day_in_month_R),
KEY month_day (month_day),
KEY month_day_R (month_day_R),
KEY month (month),
KEY year_day (year_day),
KEY year_day
umns like:
select table1.name as foo, table2.name as bar ...
but I need all the columns from each table and that will be very
tedious. Is there a way to set a prefix for each table so that the
results come out like tablename.column?
-Erich-
--
MySQL General Mailing List
For list archives: htt
doing so.
-Erich-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ET ALL PARAMETERS
'Open the MySQL database connection
conn.Open
'Sanity check - verify we have a connection to the database
If conn.State <> 1 Then
'{
MsgBox "Error connecting to the database")
'}
Else
'{
MsgBox(&q
t; in
start)
/usr/local/server/mysql/bin/mysqld_safe --old-passwords &
;;
stop)
/usr/bin/killall -TERM mysqld
/usr/bin/killall -TERM mysqld_safe
;;
*)
echo "Usage: `basename $0` (start|stop)">&2
;;
esac
exit 0
And make a corresponding entry in /etc/rc.co
don't need to throw the baby out with the bathwater.
If you decide to keep your ASP code, then I would keep your IIS setup,
as opposed to running something like Chilisoft and Apache.
--
Erich Beyrent
--
http://www.beyrent.net
--
MySQL General Mailing List
For
| 0 |
| 25 | 156|
+++
Thanks in advance!
--
Erich Beyrent
--
http://www.beyrent.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Erich Beyrent <[EMAIL PROTECTED]> wrote on 10/25/2005 12:06:28 PM:
[EMAIL PROTECTED] wrote:
"Jim C." <[EMAIL PROTECTED]> wrote on 10/25/2005 11:10:50 AM:
Where can I get tips on how to manually set up MySQL for MythTV?
MythTV's site w
can get as I am sure there are others out there that can
help but don't have the slightest clue what you are talking about.
Sorry!
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
MythTV is a kick-ass PVR application that runs under Linux. Like an
D,
Avails.InvID,
Avails.OpenWhen;
Is there anything I can do to get this query to run - is there a size
limit for the temp tables that can be tweaked?
I am sure I can do the sorting in PHP if that will help the situation...
-Erich-
--
MySQL General Mailing List
For list
limit variable, but it
appears that my host does not have this enabled.
Thanks for the tips.
-Erich-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
|
| version| 3.22.32 |
| wait_timeout | 28800 |
++---+
Please note that this database is on a host, and the version of the DB
is out of my control.
-Erich-
--
MySQL Gen
Hi all,
This is perhaps off-topic, but I need to dump my MySQL database into a
format that FileMaker Pro will understand. Does anyone have any tips for
doing this?
Thanks in advance,
Erich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
of
fields, but rather for the schema of the database?
>
> Thanks!
If you use DBDesigner by fabForce (open source), it will connect to your
MySQL database and reverse engineer it for you, building both the sql and a
graphical representation of the database.
Pretty cool stuff... A
[[snip]]
> Have you looked into using the MySQL Administrator yet? It's a GUI program
> that should do most of what you want (I know it doesn't diagram but it's
> somewhere to start). You will have to search around to find some other
> ER-based GUI administrator tools because I can't think of an
code?
Best regards,
Erich Beyrent
Information Technology Services
Plymouth State University
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
red in MyODBC 3.53 (coming soon...).
>
> J.R.
I did read that in the manual, but I was confused as to why I get the error
on one pc and not the other. I am also somewhat confused as to why I have
3.51.10 on one pc, but cannot find it anymore for my other. Did it get
pulled from the websi
following error:
Client does not support authentication protocol requested
by server; consider upgrading MySQL client
I can only assume it's because of the older driver?
Best regards,
Erich Beyrent
Systems Administrator
Information Technology Services
Plymouth State University
(603) 535
trying to do not supported? I am using version 4.1.7 on
FreeBSD 5.3.
Best regards,
Erich Beyrent
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have seen people dump the database with mysqldump and then use a cpio
command to write the files to the tape device...
-Erich-
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Monday, September 06, 2004 4:35 AM
To: [EMAIL PROTECTED]
Subject: Re: Backing up
, and then assign a
group to a user. Would this be easier and more manageable?
I am looking for feedback as to whether this is an appropriate design,
or perhaps some suggestions for a better design, pitfalls to watch out
for, etc.
Best regards,
-Erich-
--
MySQL General Mailing List
For
around that?
Thanks for your insight!
-Erich-
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 04, 2004 11:51 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Design Question
As posted, your data structure supports two one-to-many rela
categories table.
My current table definition for the listings already has the foreign key
of CategoryID.
What you are saying is that the categories table should have a field for
ListingID?
Thanks!
-Erich-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
list of CategoryIDs, but something doesn't
feel right about this solution.
What would be a good approach to this problem?
-Erich-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ould not be quick to help him in the future...
I, for one, would like to thank each and every person on this list who
has helped me in the past - you are all extremely knowledgeable, and
it's a real honor to learn from you all.
-Erich-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ween '0' and '9'
then left(cost,1)
when substring(cost,3,1) between '0' and '9'
then left(cost,2)
...
else 'Z'
end
, cast(
case
when substring(cost,1,1) between '0' and '9'
t
doesn't seem to be the case. I suppose my insert could return the last
id...
-Erich-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rom my PHP script, I get a value of 0.
Any clues as to how to resolve this?
Thanks!
-Erich-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
and/or Order By clause(s). I am sure my error is fairly
basic, but I don't have enough experience with MySQL to figure it out.
Does anyone have any insight into the problem?
-Erich-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
search against that?
This is probably the most obvious answer, but I wasn't sure if there was a
mechanism for searching directly in the files.
Thanks!
-Erich-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
Hi there,
I am running a website on a host who has blocked access to mysqldump.
Is there any way I can show all the sql commands for creating and
populating a table from within mysql? Again, I don't have access to
mysqldump.
Thanks!
-Erich-
--
MySQL General Mailing List
For list arc
3))
...
else 9
end
as integer)
I never was able to get it to work the way I wanted though... Perhaps
it will trigger some ideas from the talented people on this list.
HTH
-Erich-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
at file into MySQL. I believe you can also
export your contacts directly to Access and FileMaker Pro. Of course,
you mentioned that you want to move your contacts to a real database, so
MySQL is the way to go!
Look up in the MySQL documentation how to import CSV files.
HTH,
-Erich-
--
MySQL Gene
e database (content-disposition
>header).
Hi Kurt,
I have been using MySQL to store links to PDFs which live in other
directories.
Is there an advantage to storing the PDFs directly into the database?
-Erich-
--
MySQL General Mailing List
For list archives: http://lists.mysql
ull scan for NOT NULL, it would seem that my
co-worker is correct. Being new to MySQL (and databases in general), I
was wondering what the rest of you thought about this topic.
-Erich-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
es v
where
e.VenueID = v.VenueID;
Works beautifully!
Thanks all!
-Erich-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
NULL |2 | |
| v | ALL | NULL | NULL |NULL | NULL |2 | |
+---+--+---+--+-+--+--+---+
Which tells me nothing. What have I done wrong here?
-Erich-
--
MySQL General Mailing List
For list archives: http://lists.mysq
}
My question is, is this the best way to be doing this? I would love
some feedback and suggestions as to perhaps better methods to do this.
The database is on a hosted account, so I don't have access or privs to
change configurations or add real MySQL users.
Thanks!
-Erich-
| |
+-+---+--+-+
This seems really efficient, since the only large number of rows to
search against is the main listings table, if I read this right. Is
there any further optimization that I can do, or this as good as it
gets? Believe me, I am NOT complaining!!!
Thanks again!
-Erich-
> If every record in
Hi Evelyn,
How would I do that - would something like this be what you had in mind?
left join categories o on o.CategoryID = l.CategoryID
This goes in the WHERE clause, right?
Thanks!
-Erich-
-Original Message-
From: Schwartz, Evelyn [mailto:[EMAIL PROTECTED]
Sent: Friday
or
l.CatalogNumber like '%$Criteria%'
AND
l.PublisherID=p.PublisherID and
l.ComposerID=c.ComposerID and
l.ArrangerID=a.ArrangerID
ORDER BY
o.Alias";
How can I rewrite this query to be efficient (and functioning!) - I am
fairly new to MySQL and could use lots of
their categories (all listings in category x
displayed together, all listings in category y displayed together, etc).
My problem is that I don't even know where to start. Can it be done
with MySQL, or does it need to be done on the PHP side?
-Erich-
PS: If you want to see all of this in a
their categories (all listings in category x
displayed together, all listings in category y displayed together, etc).
My problem is that I don't even know where to start. Can it be done
with MySQL, or does it need to be done on the PHP side?
-Erich-
PS: If you want to see all of this in a
> Yes, the transaction was committed. I was using MyCC at the same time
> the anomaly occurred, also. Could this have had anything to do with
> it?
I am new to MySQL - do you *have* to commit the transaction after the
insert?
What is the benefit of the commit - does it do anything
Hi there,
Does anyone have some tips or advice for creating backups of all the tables
and data contained therein? Do you use custom solutions or perhaps
open-source projects?
-Erich-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
composers table. I know I can solve this by making the fields unique, but
I'd have to do that for every table in the database, when what I'd really
like to do is find out why the insert is happening twice.
Any ideas?
-Erich-
--
MySQL General Mailing List
For list archives: http://lists
Does anybody have an idea how to select data from a local database into another
host server ?
For information, I'm currently using mySQL 3.23.
Eric Huwaert
Kind regards - Bien cordialement - Vriendelijke groeten - Mit freundlichen
Grüßen ,
---
Does anyone know how to "allow" other hosts to connect to a MySQL database?
I have a pretty good GUI (DBTools) that will supposedly let you do this, but
whenever I try to connect to a MySQL Server that is not local, is says that
access is denied. I cant find it anywhere in Xinetd so I am assuming
; /* the state of the stream */
unsigned char _file; /* UNIX System file descriptor */
unsigned__orientation:2; /* the orientation of the
stream */
unsigned __filler:6;
};
#endif /* _LP64 */
#ifdef __cplusplus
}
#endif
#endif /* _STDIO_IMPL_H */
--
Erich
nm"
ltconfig:1709: gcc -o conftest -fno-builtin -fno-rtti
-fno-exceptions confte
st.c conftstm.o 1>&5
configure:2250: checking for a BSD compatible install
configure:2308: checking for bison
configure:2341: checking for pdftex
configure:2369: checking return type of sprintf
--
Erich N
s declared in
include/dbug.h
it seems that this compile rund does not find the header files in the
include dir
any advice?
--
Erich Neuwirth, Computer Supported Didactics Working Group
Visit our SunSITE at http://sunsite.univie.ac.at
Phone: +43-1-4277-38624 Fax: +43-1-4277-9386
55 matches
Mail list logo
