Pam Astor schrieb:
Hi,
I have about a half dozen small databases associated with a
couple of small shopping carts, discussion forums, etc. All six databases have
usernames and
passwords associated with them, and all the databases are connected to the php
based forums and shopping carts, no
Hi all.
How can we manage the history of changed rows in the database. I have some
idea but not yet implemented. By using triggers to make a copy of the row
being changed to the another table in the same db. Is there any way to only
save the changed fields data and field name? Any other idea?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi @all,
ich have configured in /etc/my.cf as follow:
[...]
log=/var/log/mysqld.log
[...]
Now, mysqld writes every query to the log file. How can I avoid the
queries in the log file? I want to see any action done by mysql, but not
the queries.
No problem.
I do this using three triggers on Insert, Update and Delete. Then
update a log file who's schema starts:
CREATE TABLE ?_log (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
transact ENUM ('I','U','D') NOT NULL,
key_from_table ??? NOT NULL,
KEY (key_from_table),
field_1 ??
Hi
Is there a way to find out when the MySQL Slave has been restarted.
Thanks and Regards
Kaushal
Hi List,
I get strange Data truncated for column Description warnings
when loading a tab separated file with special characters.
The definition of the target table is:
CREATE TEMPORARY TABLE tmp
( Code CHAR(8) NOT NULL,
Description TEXT NOT NULL,
KEY Code (Code)
) ENGINE = MyISAM
connectiong from shell means connecting as localhost by default, connecting
from PHP can be some different server and/or PHP uses the full IP
address/hostname of the server
check/compare the privileges for your users for 'localhost' and '%'
I ran “SELECT * from mysql.user;” the command
I`ve resolved my problems without hardware manipulation.
Thanks to all.
-Mensaje original-
De: Francisco Rodrigo Cortinas Maseda
Enviado el: miércoles 16 de abril de 2008 18:57
Para: mysql@lists.mysql.com
Asunto: RV: Performance problem
Hi all,
im new on the performance tuning of
C K wrote:
Hi all.
How can we manage the history of changed rows in the database. I have some
idea but not yet implemented. By using triggers to make a copy of the row
being changed to the another table in the same db. Is there any way to only
save the changed fields data and field name? Any
Pam Astor schrieb:
connectiong from shell means connecting as localhost by default, connecting
from PHP can be some different server and/or PHP uses the full IP
address/hostname of the server
check/compare the privileges for your users for 'localhost' and '%'
[...]
The seventh line shows
Hi
Is there a way to find out when the MySQL Slave has been restarted.
Thanks and Regards
Kaushal
You can determine the server actions by looking through the slave log
file.
David
-Original Message-
From: C.R.Vegelin [mailto:[EMAIL PROTECTED]
Sent: Friday, April 18, 2008 8:42 AM
To: mysql@lists.mysql.com
Subject: data truncation warnings by special characters
Hi List,
I get strange Data truncated for column Description warnings
when loading a tab separated file
A user in MySql is not just a username, but a username and a host.
The host of '%' denotes all hosts accept 'localhost'.
Therefore you usually require two entries for each user:
CREATE USER ben@'%' INDENTIFIED BY 'ben';
CREATE USER ben@'localhost' INDENTIFIED BY 'ben';
Does this help?
Ben
-Original Message-
From: C.R.Vegelin [mailto:[EMAIL PROTECTED]
Sent: Friday, April 18, 2008 8:42 AM
To: mysql@lists.mysql.com
Subject: data truncation warnings by special characters
Hi List,
I get strange Data truncated for column Description warnings
when loading a tab separated file
I'm attempting to create a MySQL stored procedure, however, when I attempt to
create even a simple Hello, world procedure, I get the following error:
ERROR 1307 (HY000): Failed to CREATE PROCEDURE test_procedure_k
which is listed as:
Error: 1307 SQLSTATE: HY000 (ER_SP_STORE_FAILED)
Message:
On Fri, Apr 18, 2008 at 7:06 PM, Ben Clewett [EMAIL PROTECTED] wrote:
Check the error.log on both server and client, should show where connected
and disconnected.
Or write a small program to execute SHOW SLAVE STATUS every minute and log
the results. Which I belive is done for you in the
Check the error.log on both server and client, should show where
connected and disconnected.
Or write a small program to execute SHOW SLAVE STATUS every minute and
log the results. Which I belive is done for you in the MySql dashboard
program suit.
Ben
Kaushal Shriyan wrote:
Hi
Is there
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
would be much more easier if you would send this output here (with faked
names, passwords and hosts ...)
OK...here it is:
SELECT * from
A user in MySql is not just a username, but a username and a host.
The host of '%' denotes all hosts accept 'localhost'.
Therefore you usually require two entries for each user:
CREATE USER ben@'%' INDENTIFIED BY 'ben';
CREATE USER ben@'localhost' INDENTIFIED BY 'ben';
Does this
just comment this parameter, all actions done by mysql will be in
hostnam.err file
On 4/18/08, Uwe Kiewel [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi @all,
ich have configured in /etc/my.cf as follow:
[...]
log=/var/log/mysqld.log
[...]
Now, mysqld
can u please try this a root user
mysql -uroot
regards
anandkl
On 4/18/08, kabel [EMAIL PROTECTED] wrote:
I'm attempting to create a MySQL stored procedure, however, when I attempt
to
create even a simple Hello, world procedure, I get the following error:
ERROR 1307 (HY000): Failed to
Pam Astor wrote:
A user in MySql is not just a username, but a username and a host.
The host of '%' denotes all hosts accept 'localhost'.
Therefore you usually require two entries for each user:
CREATE USER ben@'%' INDENTIFIED BY 'ben';
CREATE USER ben@'localhost' INDENTIFIED BY 'ben';
On Friday 18 April 2008 10:26:16 Ananda Kumar wrote:
can u please try this a root user
mysql -uroot
regards
anandkl
Same result, unfortunately.
kabel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
userId long
picture MeduimBlob
datePosted DateTime
A userId can have many pictures posted. I want to write a
query that returns a distinct userId along with the most
recent picture posted. Can someone suggest an elegant and
fast query to accomplish this?
Latest pic for user N:
SELECT
In the last episode (Apr 18), tech user said:
My mysql table has been created for long time, it increases day by
day, and become huge. Right now a full scan to the table for the
first time is very slow. So I was thinking to optimize it. This table
is stored in many non-sequential disk
CK,
How can we manage the history of changed rows in the database.
Point-in-time architecture. For a bit of discussion see
http://www.artfulsoftware.com/infotree/tip.php?id=547
PB
-
C K wrote:
Hi all.
How can we manage the history of changed rows in the database. I have some
idea
On Fri, 18 Apr 2008, Francisco Rodrigo Cortinas Maseda
[EMAIL PROTECTED] wrote:
im new on the performance tuning of this database (MySQL 5.0.45,
rpm-based installation), and i have one performance problem on our
new installation:
...
We are experiencing problems about the performance of
Hi,
Has anyone got mysql master-slave replication setup on v4.1. Were you able
to get tables with auto_increment update properly to slave ?
If yes, please let me know. I need some advise on how to set it up to work
well. I get stuck at duplicate errors quite often, and those are not real
Hi;
The python code works properly, so I assume this is a strictly MySQL
question now :)
If I grab an image in the database thus:
sql = select pic1 from products where id=' + str(id) + ';
cursor.execute(sql)
pic1 = cursor.fetchall()[0][0].tostring()
# pic1 =
The ANSI-SQL syntax is to just use GRANT to create users. You will
still need to use GRANT twice for both users: joe@'%' and joe@'localhost'.
But I find the MySql syntax for creating user with CREATE USER and then
GRANT easier to follow:
CREATE USER joe@'%' IDENTIFIED BY
On Fri, Apr 18, 2008 at 8:13 AM, Peter Brawley [EMAIL PROTECTED]
wrote:
CK,
How can we manage the history of changed rows in the database.
Point-in-time architecture. For a bit of discussion see
http://www.artfulsoftware.com/infotree/tip.php?id=547
PB
I have used this convention and
Hi Jerry,
Sorry, I should have mentioned that I use Windows XP with MySQL 5.0.15nt.
The script giving errors now is used once a year, and last year without any
warning.
Since last year all I changed was adding in my.ini:
# in [client] part
default-character-set=utf8
# in [mysqld] part
I have some php code I use to import data that is a bit more flexible
and robust than the load data statement in MySQL If you use php I can
share the code with you.
C.R.Vegelin wrote:
Hi Jerry,
Sorry, I should have mentioned that I use Windows XP with MySQL 5.0.15nt.
The script giving
Thanks Chris,
Well the script in question is a MySQL script to load a MySQL database.
Currently I use only PHP only for database retrieval.
But after trial and error I managed to find a 'work around', as follows:
a) CREATE TABLE tmp with ENGINE = MyISAM CHARSET = LATIN1;
b) LOAD DATA INFILE
This isn't really a problem with MySQL; MySQL just trips on it.
Let me caution you that this discussion applies to Windows. I did observe
this in my applications on Linux, but the problem will show itself only when
reading a file, whether uploaded or not; there will be no problem if the
data is
One more thing, I have already created these users and don't want to mess
their
passwords up or break their associated php scripts access.
So how do I grant users, who already have a password, localhost
access?
just copy the row in the mysql table
--
Sebastian Mendel
Not sure
36 matches
Mail list logo