I am currently evaluating the multi-user version of the popular blogging
software, Wordpress. One of the things I am not so sure about is its
schema.
To support multiple users, Wordpress creates about ten tables per user.
I have, at worst case, 4000 users who may be using this software, and
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
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:/
> I have a system with set of web pages that use PHP and a MySQL database.
>
> Apparently the old webmaster has disappeared, and a new webmaster has been
hired. She needs to know the schema of the database.
>
> So my question is: Is there a way of querying MySQL not for values of
fields, but rat
[[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]
> You need to set the OLD_PASSWORDS variable in the [MYSQLD] section of the
my.ini file.
>
> Set-variable = old_passwords=1
>
> It's not the ODBC, but your version of MySQL. 4.0.x uses 1 variant of
password hashing, 4.1.x uses a more >
> secure one that will be covered in MyODBC 3.53 (coming so
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 directly
Hi all,
I have a need to use a kind of user permission system in the database,
but because the database is a hosted solution, I do not have access to
the real user tables and permissions and such.
SO...
What we're talking about is a document management system:
1. Some users can read, write, an
n. My "historical" reports still function as the "old"
names
are still in the system, even if you can't use the the old names for any
current purposes.
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Erich Beyrent" <[EMAIL PRO
EB> My thought was to add a new field to the listings table that would
EB> contain a comma-separated list of CategoryIDs, but something doesn't
EB> feel right about this solution.
> This would break the first normalization form and is extremely bad
Okay - I thought something was off...
> First o
Hi all,
I need some advice on a project I have. Basically, I have some tables:
CREATE TABLE listings (
ListingID bigint(20) unsigned NOT NULL auto_increment,
CatalogNumber varchar(12) NOT NULL default '',
PDFLink varchar(100) default NULL,
PDFName varchar(80) default NULL,
Title varch
> Luis - you're quite polite so I'll assume that you are ignorant rather
th
> an prejudiced.
>
> You have a university email so I'll also assume you're a student who
wants > to learn.
>
> So here's your lesson for today: Don't judge people by their cover, or
by > their color, or by their name, or b
> OK, I'm sorry. The solution I gave doesn't work.
>
> You need to have some sort of conditional in the sort expression so
that
> numbers are sorted numerically and other things are sorted >
> alphanumerically.
> I'm not aware of a test for numeric vaues in MySql, so you need to use
>
> some
> tr
> Well, you don't need the distinct.
>
> Are you inserting with your PHP script? LAST_INSERT_ID(), as per the
>
> manual,
> only returns the id from the last insert on that connect. You cannot
get >the
> LAST_INSERT_ID() for another connection.
j- k-
I used distinct because otherwise
Hi there,
I seem to be having a problem retrieving the last inserted ID for a
table.
The query I am using is as follows:
mysql> select distinct LAST_INSERT_ID() as LastID from listings;
++
| LastID |
++
| 3575 |
++
1 row in set (0.00 sec)
However, when I run this from
Hi all,
I am trying to get a bunch of results, group them by category, and then
order each group of categories. My query is thus:
SELECT
l.CatalogNumber,
l.MP3Name,
l.PDFLink,
l.PDFName,
l.Title,
p.PublisherName,
c.ComposerLname,
Hi all,
This is probably a dumb question...
I am in the planning stages for a database project, where I will need to
store a bunch of documents in both PDF and MS Word format. Assuming that
the documents are stored as binary in the database, suppose I want to be
able to search the database for t
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 archives: h
> I have something like A001C, B689, B1001 etc...
I had to do something like this, and someone suggested the following:
order by
case
when substring(YourField,1,1) between '0' and '9'
then ''
when substring(YourField,2,1) between '0' and '9'
then left(YourField,1)
> Hi Everyone,
>
> Fisrtoff, I know nothing about databases and even less about web
design.
> What I do know is that I want to move my Outlook contacts (~10,000) to
a
> real database :)
> I've looked at FileMaker Pro and MyGroupWare and the likes but I just
want
> something simple where I can exp
>Use the BLOB, Luke!
>
>See your local MySQL manual for details.
>
>We're using BLOBs to store PDF in our database, and through the use of
HTTP
>headers, we're able to let user download the PDFs without having to
store a
>local copy on disk, directly from the database (content-disposition
>heade
> Chris,
> Is it faster if you remove the 'IS NOT NULL'? I know that's not the >
> results
> you want, but we have found that is NOT NULL will do a full scan. But
we
> normally use it with a join. Since you are using one table, I'm not
sure
> how it would affect it.
>
> Donny
This is an intere
You have no join criteria between your tables.
Of course. I am so stupid...
select
e.EventID,
date_format(e.EventDate, '%c/%d/%y') as EventDate,
e.EventTime,
e.EventDetails,
e.VenueID,
v.VenueName,
v.VenueID,
v.VenueURL,
v.Directions
from
events e,
venues v
where
e
Hi all,
I have a problem with a select returning duplicates, even though there
aren't any duplicates in the database.
select
e.EventID,
date_format(e.EventDate, '%c/%d/%y') as EventDate,
e.EventTime,
v.VenueName,
v.VenueID
from
events e,
venues v;
+-+---+--
Hi all,
I need some advice as to how to manage a user login system using PHP and
MySQL. Currently, I have the following table:
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+
't join tables you will create what is called a 'cross
product'
> query. If table A has 10 rows and table B has 20 rows then
querying A > and B
> will return 200 rows (every row of A will be joined with every
row of > B!).
-Origin
will create what is called a 'cross product'
query. If table A has 10 rows and table B has 20 rows then querying A and B
will return 200 rows (every row of A will be joined with every row of B!).
-Original Message-
From: Erich Beyrent [mailto:[EMAIL PROTECTED]
Sent: Fr
Hi everyone,
I am having a rough time with a query, which seems to be taking so long
it hangs the systems.
SELECT
l.CatalogNumber,
l.PDFLink,
l.PDFName,
l.Title,
p.PublisherName,
c.ComposerLname,
a.ArrangerLname,
l.Price,
l.Description,
o.Alias
F
Hi everyone,
Sorry to ask this question, because this is going to get complicated...
Okay - what I need to do is be able to search for data across multiple
fields which are organized in multiple tables. Here is a basic
description of my database schema (not quite all of the fields...):
Table lis
Hi everyone,
Sorry to ask this question, because this is going to get complicated...
Okay - what I need to do is be able to search for data across multiple
fields which are organized in multiple tables. Here is a basic
description of my database schema (not quite all of the fields...):
Table lis
> 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?
-Erich-
39 matches
Mail list logo