Yep.. this is very feasible.. And there are some packages to do this
already.
http://www.firstworks.com/sqlrelay.html
Is a good package and library/API to implement what you want to do. We
have done this in the past for a large community based website.
-Original Message-
From: John Ma
Ok, that worked. I started MySQL. I still don't know how to shutdown
mysql, or if that was my problem. Unfortunately, that is the ONLY way
I can log into mysql. Anyway, that would be fine, only now I have an
ASP script but I am a privelegas idiot, so I don't know how to set a
UID and Passw
At 1:19 PM -0500 3/7/02, Chuck \"PUP\" Payne wrote:
>But who wants to pay. Get a clue that's why PHP, PERL, and other Open Source
>Lang., are widely more used.
If you do a true comparison in features, you'll see that a PHP-based
solution (with commercial add-ons) costs over three times the cost
Dear sir
I have a problem to install MySQL for windows on my standalone PC.
When I run 'WINMYSQLADMIN.EXE' from dos prompt or windows explorer then it
did not run and gives and error message
'Access violation at address 00040298D in module 'WINMYSQLADMIN.EXE'. Read
of address '
when I pr
Situation: mass virtual website hosting, with php/perl/python. One
master mysql server, one or more replicated slaves.
Question: would it be possible/feasible to write a daemon that accepts
connections on behalf of mysqld, and depending on what type of query it
is (updating or selecting) farm th
hi,
I am resending this query.
Anyone who has information on installing the MySQL binaries on solaris
please help me with some information. The product doc doesnt seem to
help.
I am NOT too keen on building MYSQL by down loading the source code.
Any help on installation of binaires?
Thanx
Anis
Hi,
I need help in turning on the slow query log option on the my.ini file.
I've tried uncommenting it and when I tried to run the nt-max it says it
couldn't recognize the option. Here's what I have for my.ini file, any
other way I have to type it? Please advise.
slow query log#=c:/slowquerylog
rep1 would gain FILE access to all ( not sure what the really entails )
it would not have SELECT access, so can not read from it
mind you if they have enough info to get in with rep1 access, then they
could just replicate everything on thier own server and read till thier
hearts content
-Ori
You have this table:
id data
3 2
2 1
1 3
This query:
SELECT @var, data, @var:=data+(IFNULL(@var,0)) FROM table
What would result would you expect the first time you execute the query?
I would expect this:
NULL, 2, 2
2, 1, 3
3, 3, 6
But this is what you get the first time:
NULL, 2, 2
NULL, 1, 1
Those of you using PHP with MySQL who may be looking for alternatives
may be interested in this white paper just released.
Enjoy!
CC
FOR IMMEDIATE RELEASE
March 7, 2002
BLUE WORLD ANNOUNCES LASSO VS PHP WHITE PAPER
Report highlights differences in performance
On Thursday, March 7, 2002, at 12:38 AM, Jeremy Zawodny wrote:
> Are the Web servers doing write operations on the database, or
> read-only?
read-only now.
Can you talk a bit about how Yahoo Finance does it as far as # of web
servers to MySQL servers ? Apache & PHP tuning ?
- Sam.
Is there a way for me to NOT have a default value for a column in a table
that I define as NOT NULL?
EXAMPLE SQL:
mysql> CREATE TABLE FOO (foo1 int NOT NULL);
Query OK, 0 rows affected (0.05 sec)
mysql> DESCRIBE FOO;
+---+-+--+-+-+---+
| Field | Type| Null |
Hi all,
I have just installed MySQL recently. I already set the root password and
some databases testing and everything worked fine. However, I accidentally
changed the root to anonymous yesterday. After that, I couldn't add new
users and do some administration tasks even change password myself.
Hi
I am just installing a new MySQL server at the moment.
We are using PHPMyAdmin witch is ok as we can limit what each user can do,
but
some tables do not work with it.
We have 2.1.0 at the moment.
Do I
1. Just go for the latest PHPMyAdmin
2. Use MySQL GUI (can I restrict what each user
Thank you all for your insight. Here's the query I'm using and it works
great!
mysql> SELECT log.id,
> if (empnum.fname > '', log.id, 'No Record') AS 'fname',
> if (empnum.lname > '', log.id, 'No Record') AS 'lname',
> SUM(log.hours) AS 'hours'
> FROM log LEFT OUTER JOIN empnum
> ON log.id = emp
Hi,
On Wed, 2002-03-06 at 15:50, Scalper wrote:
> If I create a temporary heap table from a select statement, does the new
> table also inherit the indexes (indices?) from the original table. Or will
I think that every CREATE [...] TABLE [...] SELECT does not inherit any
indexes (doesn't mat
For $26 a month! That'll buy some excellent reference material instead :)
>>On Thu, 7 Mar 2002 11:47:51 -0500, Keith Elder <[EMAIL PROTECTED]> wrote:
>>Hi Gavin,
>>
>>I didn't know if you knew this or not but there is a site which
>>provides lives PHP / MySQL support. Take a look at http://
On Thu, Mar 07, 2002 at 09:57:54AM -0700, Sasha Pachev wrote:
> On Thursday 07 March 2002 12:42 am, Jeremy Zawodny wrote:
> >
> > Do you have any feel for how much slower a debugging version of
> > MySQL is compared to a normal version? ?I ask because my
> > replication heartbeat monitor has noti
ds,
If I understand you correctly, that also means that the user repl can access
the mysql database where all the privilege info is stored and see the
permissions, passwords, and such. Yes/No?
Thi
-Original Message-
From: ds [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 11
On Thursday 07 March 2002 12:42 am, Jeremy Zawodny wrote:
> My 4.0.2 slave has run through about 14 million queries and it's going
> well.
Good news
>
> Do you have any feel for how much slower a debugging version of MySQL
> is compared to a normal version? ?I ask because my replication
> heart
On Wed, 2002-03-06 at 14:26, Thi Cao wrote:
> When I grant privileges as follows, the slave gets updated:
>
> GRANT FILE ON *.* to repl@'%' identified by 'some_password';
>
> Could someone please tell me why I must grant the FILE privilege on all
> databases for the repl (slave) to be able to up
Jeremy,
I'm not sure I follow. What information from that command would the app be
looking for specifically. Maybe you're saying the app should look at the
position of the master's binary log file. Is that what you suggest?
Thi
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL P
Hi Gavin,
I didn't know if you knew this or not but there is a site which
provides lives PHP / MySQL support. Take a look at http://www.phphelpdesk.com . It
is a live PHP support site which helps you get real time answers to PHP problems.
Keith
* Gavin Philips-Page ([EMAIL PROTECTED]) wrote
I actually wound up pulling down a deb-src and changing
myisam/ftdefs.h
#define MIN_WORD_LEN 2
Compiled a .deb out of it and put it in. Seems to be working. Thank
goodness they made this a varible in 4.0.
K.
* Paul DuBois ([EMAIL PROTECTED]) wrote:
> Date: Thu, 7 Mar 2002 09:33:09 -0600
> T
On Thu, Mar 07, 2002 at 08:37:00AM -0600, Thi Cao wrote:
> All,
>
> How can I notify an application running on the slave server that the
> slave database has just updated itself by means of replication. The
> reason I ask is that I know MySql currently doesn't support
> triggers, but my applicat
$sql="select * from table where blah=$blah";
$x=mysql_query($sql);
while ($data=mysql_fetch_array($x)) {
echo "$data[columnName]";
}
I think is what your trying to do...
On Thu, 7 Mar 2002, Gavin Philips-Page wrote:
|Could anybody please help:
|
|In the query I have includ
Bonjour,
Did you try to connect to the server from network ?
Try to force mysql client not to use the socket (what is does when
it's connecting to localhost).
Try to connect from another server or even from the same server but
with the --host=xxx.xxx.xxx.xxx where xxx.xxx.xxx.xxx
Hello all,
I am new to linux. I was told that I need DBI::DBD to connect to Mysql
using perl. So I go to http://www.mysql.com/downloads/api-dbi.html and
downloaded DBI-1.18.tar.gz, Msql-Mysql-modules-1.2216.tar.gz. Using gunzip,
I unziped the two files. Now I have DBI-1.18.tar and
Msql-Mysq
Bonjour,
I have a problem with Mysql and access rights :
I have a user who has rights to access tables in the database
'membres' :
#/> mysqlaccess 192.168.0.1 myuser membres
Could not open outputfile ~/mysqlaccess
Could anybody please help:
In the query I have included a limit string which allows me to display
individual records page by page. The limit string variable is
incremented/decremented using hyperlinks. I feel it would be better if I
could somehow manually step through the returned
$query_data = m
Ahmed,
Forget about it. I tried to do this, I tried for about two weeks, then got mad
and downloaded the src and compile it mysql. It works great.
-chad
if you do get it working let me know
On Thu, 07 Mar 2002 09:14:58 -0700
"Ahmed S K Anis" <[EMAIL PROTECTED]> wrote:
> Hi members,
>
Hi members,
This is my first query :)
My query is about installing MySql on Solaris.
I am interested in downloading and installing the stable version of
MySql on solaris 2.6.
I downloaded mysql-3.22.25-solaris7-x86.pkg.tgz and MySQL 3.23.
I tried to install the first one (used GNU tar) . I foll
Hello all,
Just wanted to say thank you to all of your responces on how to import .sql
file into a database. It helped me a lot.
Mysql -u user -p password dbname < filename.sql
Thanks,
Josiah Wallingford
Email = [EMAIL PROTECTED]
Mailing lists:
PHP General - [EMAIL PROTECTED]
BBEdit Talk
Can the data directory reside on a different machine than the mysql program
itself, such as on a maxattach storage device.
Thanks,
stephen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
htt
At 9:35 -0600 3/7/02, Paul DuBois wrote:
>At 12:06 +0200 3/7/02, Egor Egorov wrote:
>>Josiah,
>>Thursday, March 07, 2002, 8:18:58 AM, you wrote:
>>
>>JW> I know how to inport a .sql file into mysql by using mysql -u username -p
>>JW> password < filename.mysql(sql) but how do you import one that
>
At 12:06 +0200 3/7/02, Egor Egorov wrote:
>Josiah,
>Thursday, March 07, 2002, 8:18:58 AM, you wrote:
>
>JW> I know how to inport a .sql file into mysql by using mysql -u username -p
>JW> password < filename.mysql(sql) but how do you import one that is
>made to go
>JW> into a database you already
At 9:59 -0500 3/7/02, Keith Elder wrote:
>Hello,
>
>I don't know if this is possible but I need to change the
>ft_min_word_len variable from 4 to 2. The machine mysql is running on
>is Debian so I would like to try to do this without recompiling it if
>possible.
That's a MySQL 4.x feature.
>
>T
* oe-ander
> How do i check if a column(name) do not exists in a table before i add it?
> Like: alter table fruit add aple varchar(20) not null if aple do not
exists
As far as I can see, you have two options:
- Do a "describe fruit", and check the "Field" column
- Do the "alter table...", and ch
InnoDB!
--Walt
-Original Message-
From: Dominique DUTENDAS [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 8:02 AM
To: MySQL
Subject: Lock row
Hi, I want to lock a row in a table, and just the row I have selected
what's the solution under MySQL
Thank's
Dominique
-
Thursday, March 07, 2002, 4:49:57 PM, you wrote:
d> Ok people, I'm desperate for the help. I'm going to try to be as detailed
d> as possible, because I need the two year old explanation. I recently
d> installed MySQL on my Cobalt Raq3. I was running fine, created a db, table
d> created a user,
Hi, I want to lock a row in a table, and just the row I have selected
what's the solution under MySQL
Thank's
Dominique
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.co
Hello,
I don't know if this is possible but I need to change the
ft_min_word_len variable from 4 to 2. The machine mysql is running on
is Debian so I would like to try to do this without recompiling it if
possible.
Thanks,
Keith
###
Ok people, I'm desperate for the help. I'm going to try to be as detailed
as possible, because I need the two year old explanation. I recently
installed MySQL on my Cobalt Raq3. I was running fine, created a db, table
created a user, gave some permissions, and thought I was rolling along.
Somew
All,
How can I notify an application running on the slave server that the slave
database has just updated itself by means of replication. The reason I ask
is that I know MySql currently doesn't support triggers, but my application
needs to be notified when an update on the slave has just taken p
Hi Monty and Sasha,
Just a quick not to say that's such a great idea that Monty even
thought of it before! Monty and I discussed this last September, I
hope we could get something like this in 4.1
Just a vote!
Thanks Ken
- Original Message -
From: "Sasha Pachev" <[EMAIL PROTECTE
On Wed, 6 Mar 2002, Sergei Golubchik wrote:
> > mysql> SELECT doc FROM plaintext WHERE MATCH(bgetxt) AGAINST('placi*' IN
> > BOOLEAN MODE);
> > Empty set (0.00 sec)
>
> It is a bug.
>
> You can - either create a repeatable test case, to be sure,
> the bug will be fixed in 4.0.2, ...
Hello Sergei
> Alexander,
>
> go ahead and use those fields of type TEXT. Retrieval works like a
> charm.
> Building the index on large tables may be slow, but the manual gives
> some
> tricks how to speed things up. As soon as you have VARCHAR fields you
> are
> into variable record lengths anyway. And you c
On Thu, 7 Mar 2002 12:03:05 -
"DL Neil" <[EMAIL PROTECTED]> wrote:
> Hi Alexander,
>
> > I am interested if there any URL I can read more about text type
> fields
> > in MySQL.
> > I had an argument with a friend who said that if I use text type in
> a
> > table it will make the system to wo
Hi Alexander,
> I am interested if there any URL I can read more about text type
fields
> in MySQL.
> I had an argument with a friend who said that if I use text type in a
> table it will make the system to work to slow.
> But I realy needed this text field because I wanted to store text more
> t
Hi!
How do i check if a column(name) do not exists in a table before i add it?
Like: alter table fruit add aple varchar(20) not null if aple do not exists
Best regards
Oyvind
mysql
-
Before posting, please check:
http://
Hi "MySQL",
> I record some stock data into MySQL, I'm looking for the correct
> syntax for a SELECT statement.
>
> SELECT min(Tmin) FROM quotes WHERE low=min(low)
>
> In short, I want the time of the occurance of the low for the day,
> Tmin is time column. Once the low is achieved, all the rema
Hi there,
I am interested if there any URL I can read more about text type fields
in MySQL.
I had an argument with a friend who said that if I use text type in a
table it will make the system to work to slow.
But I realy needed this text field because I wanted to store text more
than 256 symbols.
Hi!
On Mar 07, Thomas Spahni wrote:
> On Wed, 6 Mar 2002, Sergei Golubchik wrote:
>
> > > mysql> SELECT doc FROM plaintext WHERE MATCH(bgetxt) AGAINST('placi*' IN
> > > BOOLEAN MODE);
> > > Empty set (0.00 sec)
> >
> > It is a bug.
> >
> > You can - either create a repeatable test case, to be
> Hi
>
> In mysql I found a problem with between query.
>
> For example
> select * from bugdetail where
> dbugcreate_date between from_days(to_days('2002-03-01')) and
> from_days(to_days('2002-03-04'))
>
> this query shows only those records up to '2002-03-03' instead of
> '2002-03-04'
Are all
Hi
In mysql I found a problem with between query.
For example
select * from bugdetail where
dbugcreate_date between from_days(to_days('2002-03-01')) and
from_days(to_days('2002-03-04'))
this query shows only those records up to '2002-03-03' instead of
'2002-03-04'
pl. help
Manish
Rutledge,
Wednesday, March 06, 2002, 10:01:56 PM, you wrote:
Reoen> In my application I would like to update a MySQL record where one
Reoen> column
Reoen> is the largest value. Do I have to create a separate SELECT sql query
Reoen> statement
Reoen> to get that value and then update it? Or,
The first query shown in the log is the one I actually tells ADO.Open to run...
however just after that one it runs two more (the
two tables includes in the first query) select * queries... Why??
This slows down the ADO a lot. Even Jet4.0 doesn't do that on the same query and is
therefore about
ld99ba,
Thursday, March 07, 2002, 11:22:15 AM, you wrote:
l> please tell me how to install mysql for sco unix 5.0.5???
l> need file???
You can find info how to install MySQL binary distribution at:
http://www.mysql.com/doc/I/n/Installing_binary.html
Check also the following link. You can fi
José,
Thursday, March 07, 2002, 3:08:13 AM, you wrote:
JHFT> I've already installed MyODBC and configured the driver correctly
JHFT> (accoriding a book I'm reading) at ODBC User DNS. But, when I run Database
JHFT> Desktop and gonna make a "New Table" the option of MySQL does not appear
JHFT> (acc
Josiah,
Thursday, March 07, 2002, 8:18:58 AM, you wrote:
JW> I know how to inport a .sql file into mysql by using mysql -u username -p
JW> password < filename.mysql(sql) but how do you import one that is made to go
JW> into a database you already have created? Would the command by mysql -u
JW> us
Erik,
Thursday, March 07, 2002, 12:58:26 AM, you wrote:
ES> Trying to figure out how to convert Sybase ASA syntax to MySQL. Need to
ES> select alpha ranges as in:
ES> SELECT *
ES> FROM table
ES> WHERE name LIKE '[A-Z]%'
ES> but this doesn't work.
You should use REGEXP instead LIKE. REGEXP has
>
> We have 10 of the 3ware cards, and while the drive is GPLd and in
> the kernel, we have not been satisfied with the stability of the
> system
Is there anything that I can avoid while still using the card (ie; specific
RAID config)?
>
> We haven't had a chance yet to qual th
please tell me how to install mysql for sco unix 5.0.5???
need file???
thank you !!!
__
===
ÐÂÀËÃâ·Ñµç×ÓÓÊÏä (http://mail.sina.com.cn)
ÐÂÀË·ÖÀàÐÅÏ¢£º¶þÊÖÊг¡×ßÒ»×ߣ¬¸Ã³öÊÖ
I record some stock data into MySQL, I'm looking for the correct
syntax for a SELECT statement.
SELECT min(Tmin) FROM quotes WHERE low=min(low)
In short, I want the time of the occurance of the low for the day,
Tmin is time column. Once the low is achieved, all the remaining data
for the day ha
Bonjour,
I have a problem with Mysql and access rights :
I have a user who has rights to access tables in the database
'membres' :
#/> mysqlaccess 192.168.0.1 myuser membres
Could not open outputfile ~/mysqlaccess
On Wed, Mar 06, 2002 at 11:06:18AM -0800, Sam Iam wrote:
>
> We have a very high volume site (3 million page views a day) that's
> run on 16 Apache / PHP web servers & 2 MySQL servers. We are using
> PHP with persistent connections. Each MySQL serves 8 web servers &
> is supposed to act as a failo
On Thursday, 7. March 2002 07:18, Josiah Wallingford wrote:
Would the command by mysql -u
> username -p password < dbname filename.sql(mysql)
>
No, just use
mysql dbname -uusername -ppaswwod < filename.sql
Regards
Georg
-
Be
101 - 167 of 167 matches
Mail list logo
