_using mysql5
_I have a table "points" with (atleast) following fields
points_id (int, primary key), logged (datetime), sale_points(float),
available_points(float)
When a new row is inserted "available_points" is set to the value of
"sale_points"
I need to update the "available points" for
I am having similar issues. I moved a copy of mysqld_safe to init.d and
removed the old startup script, this had the effect of lowering the number
of processes from about 30 something to 7 or 8. However mysqld_safe now
appears as a subprocess of rc and under mysqld_safe is mysqld and under
t
Hi,
The two passwords are totally separate. The MySQL root users password
controls access only to the MySQL databases and tables. sudo password
will allow you access to bash scripts/programs etc.
You could test this by logging in as a user other than root having run
mysql client as a sudo command
Ok, this worked... My question is that is the password for 'root'
supposed to
match the sudo password used to grant super priveleges to the bash user?
I purposely wanted this different and changed my root password on
mysqladmin
to something else... Is it supposed to be the same as the root's
Nestor,
When I tried this... This is what I got:
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> delete from user where id='root';
ERROR 1054 (42S22): Unknown column 'id'
Hello again,
I am using OS X Tiger and MySQL 5...
Set a password, yesterday, and wish to change it
How would I go about doing this?
I tried do this:
untz$ mysqladmin -u root password dolphin
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localho
Anthony Ettinger wrote:
hmmm...google is null on that one too.
I'd suspect that it's just a false positive, in other words, better to be
safe than sorry from Norton's point of view.
On 12/1/05, Gary <[EMAIL PROTECTED]> wrote:
I have installed Apache PHP and MySQL over a year ago on a WINXP ma
hmmm...google is null on that one too.
I'd suspect that it's just a false positive, in other words, better to be
safe than sorry from Norton's point of view.
On 12/1/05, Gary <[EMAIL PROTECTED]> wrote:
>
> I have installed Apache PHP and MySQL over a year ago on a WINXP machine
> and suddenly a f
I have installed Apache PHP and MySQL over a year ago on a WINXP machine
and suddenly a file, presumably there all that time is found to be
infected by an upto date Norton anti virus program.
Norton does not say what trojan horse. It cannot quarantine nor delete
the file so I stopped the MySQL
Please see my comments below :
On Thu, 2005-12-01 at 14:06 -0600, Ross Anderson wrote:
> I have read the suggestions for optimization for innodb however I'm
> curious if anyone can help me understand which buffers are common (thus
> used by innodb action) and which are specific to myiasm. The s
Hello.
Basic instructions are available at:
http://lists.mysql.com/mysql/115620
Search in archives at http://lists.mysql.com/mysql for more examples.
Octavian Rasnita wrote:
> Hi,
>
> Is it possible to install 2 versions of MySQL on the same computer?
>
> I want to have MySQL 4
I have read the suggestions for optimization for innodb however I'm
curious if anyone can help me understand which buffers are common (thus
used by innodb action) and which are specific to myiasm. The server has
2GB of ram but runs multiple services. I have a number of different
types of conne
Hello,
5.0.11-beta-standard is already running. Now I need to install php-mysql
which requires mysql-3.23.58-15.RHEL3.1.i3.
Here is what I did and the errors I got:
$ sudo up2date -i php-mysql
Password:
Fetching Obsoletes list for channe
Hello.
If you make composite index on all fields you'll be able
to use it in searchings only on left-most prefixes of the key.
You should make a separate index for each field if you
want to search on each field, however, many indexes will slow
down inserts to the table.
Andy Pieters wro
Hello.
Have you add mysql_enable="YES" and others to /etc/rc.conf?
See the contents of /usr/local/etc/rc.d/mysql-server.sh
Tim DeBoer <[EMAIL PROTECTED]> wrote:
>Hi everyone,
>I just installed mysql50-server, -client, and -scripts from Freebsd ports.
>Everything seemed to go well, no er
Hi,
Is it possible to install 2 versions of MySQL on the same computer?
I want to have MySQL 4.1 and 5.0 installed, and use only one of them at a
time.
I have installed MySQL 5.0 over MySQL 4.1 and now MySQL 5 works fine,
however, I cannot start MySQL 4.1 although I have stopped MySQL 5 first.
In the last episode (Dec 01), Kayra Otaner said:
> Is MySQL 5.0's Index merge optimization is also available to multiple
> table joins? When I do explain on 3 table joins, only one key per
> table is used :
>
> SELECT R.* FROM L, M, R
> WHERE
> L.key1 = 1
> ANDL.key2 = M.key2
> ANDM.key1
Hello,
Is MySQL 5.0's Index merge optimization is also available to multiple
table joins? When I do explain on 3 table joins, only one key per table
is used :
SELECT R.* FROM L, M, R
WHERE
L.key1 = 1
ANDL.key2 = M.key2
ANDM.key1 = R.key1
R table has 10 rows
M table has 24 million rows
Hi everyone,
I just installed mysql50-server, -client, and -scripts from Freebsd ports.
Everything seemed to go well, no errors that I noticed anyway.
So, after installing I tried to start the mysql server.
/usr/local/etc/rc.d/mysql-server.sh start
Nothing happens. No error messages, no starting,
I tried -C (--compress), but it still took awhile, since the resulting .sql
file is 218Megs.
I am thinking I will have to write a function which logs into an ssh server
inside the local area network that the db server is on, and hopefully the
bottleneck of the internet will disappear, only locking
Hi,
Usually, 'ps -ef|grep mysqld' shows:
root 1932 1 ...
mysql 1962 1932 ...
mysql 1963 1932 ...
mysql 1964 1932 ...
...
But today I noticed it's like this:
root 1932 1
mysql 1962 1932 ...
mysql 1963 1962 ...
mysql 1964 1963 ...
mysql 1965 1963 ...
mysql 196
At 9:56 -0500 12/1/05, Barbara Deaton wrote:
All,
I'm actually looking for a RTFM reply here. I need to simulate
SQLSetPos and SQLBulkOperations in my application which is written
with the MySQL C API. I thought MySQL 5.0 was supposed to have
cursor support, but the only thing I can find in
On Thu, Dec 01, 2005 at 05:33:01PM +0100, Andy Pieters wrote:
> Hi list
>
> I have a data set that is composed of many fields (30+). The final app will
> allow the users to search records on each field.
>
> What is the best thing to index in this situation? Make an index for *all*
> fields?
Y
Hi list
I have a data set that is composed of many fields (30+). The final app will
allow the users to search records on each field.
What is the best thing to index in this situation? Make an index for *all*
fields?
With kind regards
Andy
--
Now listening to Phase - Morning Light on amar
"Barbara Deaton" <[EMAIL PROTECTED]> wrote on 12/01/2005 09:56:44 AM:
> All,
>
> I'm actually looking for a RTFM reply here. I need to simulate
> SQLSetPos and SQLBulkOperations in my application which is written
> with the MySQL C API. I thought MySQL 5.0 was supposed to have
> cursor suppo
Barbara,
Are cursors supported outside of stored procedures,
My understanding is that cursors are supported in sprocs only.
PB
-
Barbara Deaton wrote:
All,
I'm actually looking for a RTFM reply here. I need to simulate SQLSetPos and
SQLBulkOperations in my application which is writ
All,
I'm actually looking for a RTFM reply here. I need to simulate SQLSetPos and
SQLBulkOperations in my application which is written with the MySQL C API. I
thought MySQL 5.0 was supposed to have cursor support, but the only thing I can
find in the documentation is regarding server side cur
> Which component, Spider?
> with TSQLQuery try setting: ParamCheck property to false. Look in help
> for your specific component...
Mind you, setting ParamCheck only has effect for run-time assignments
to the SQL strings property.
Martijn Tonies
Database Workbench - tool for InterBase, Firebir
Hello.
Some tips from the manual could be helpful. See:
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
http://dev.mysql.com/doc/refman/5.0/en/starting-server.html
untz wrote:
> Hello there,
>
> I just downloaded the MySQL 5 Community Edition for OS X Tiger..
Hello.
Use backslashes to escape double quotes. See:
http://dev.mysql.com/doc/refman/5.0/en/string-syntax.html
LMS wrote:
> Hi,
> I can't save this:
>
>
> UPDATE [table] SET [filed]='
> id="{ID_CAMPO}">{ID_VALOR}
--
For technical support contracts, goto https://order.mys
Hello.
mysqldump has --compress option, which can help in case
the network is the main bottleneck.
>I'm using the typical --opt with mysqldump, over the internet.
>the problem I'm having is the dump takes 30 mins or so, and during that
>time, every table in the db is locked (so as not
Hi,
I have a table with consumer products. I have a row "product name"
and "brand".
If I do a full-text search in boolean mode for a term like "apple
ipod" I get results like:
Apple iPod (brand: Apple)
TuneDock for Apple iPod (brand: Belkin)
Since both of these terms
Which component, Spider?
with TSQLQuery try setting: ParamCheck property to false. Look in help
for your specific component...
To Leo's :
Delphi/dbExpress uses ':' character to specify SQL Parameters much alike
mysql uses '@' for variables :)
e.g.:
q.sql := 'select * from tbl where col1=:val1
Test USER wrote:
Can't get this to work, but i would like to specify LOAD DATA to use an INFILE
from an URL.
For example
LOAD DATA LOCAL INFILE 'http://www.testserver.com/data.csv'
But i get an error message saying file not found.
Anyone know if this is even possible ?
Hi thanks for your answer!
I would like this to be done via cron 3-4 times a day.
Quoting Peter J Milanese <[EMAIL PROTECTED]>:
> I have never seen this. Mysql would have to do a wget of the file then
> dump it. Last I knew it wasn't a web browser. There may be a way to do
> the wget inline thoug
I have never seen this. Mysql would have to do a wget of the file then dump it.
Last I knew it wasn't a web browser. There may be a way to do the wget inline
though, or at least write something in shell or perl to do it. Is this cron'd
or something, or a one time thing?
-
Sent
Can't get this to work, but i would like to specify LOAD DATA to use an INFILE
from an URL.
For example
LOAD DATA LOCAL INFILE 'http://www.testserver.com/data.csv'
But i get an error message saying file not found.
Anyone know if this is even possible ?
-
37 matches
Mail list logo
