I'm using MySQL Ver 14.7 Distrib 4.1.9, for pc-linux-gnu (i686) on
RedHat Linux 9
and found this weird thing
I create first table
CREATE TABLE `t_keycode` (
`keycode_id` int(11) NOT NULL auto_increment,
`keycode_val` varchar(255) NOT NULL default '',
`keycode_desc` varchar(255) NOT NULL
I'm using MySQL Ver 14.7 Distrib 4.1.9, for pc-linux-gnu (i686) on
RedHat Linux 9
and found this weird thing
I create first table
CREATE TABLE `t_keycode` (
`keycode_id` int(11) NOT NULL auto_increment,
`keycode_val` varchar(255) NOT NULL default '',
`keycode_desc` varchar(255) NOT NULL
Thanks (to) Brent and Alexey ...
The solution to speed up my query was the compound index on Hash+Year.
With this compound key the query time dropped dramatically.
From 30 minutes to 14 seconds !
Cor Vegelin
Business Explorer BV
- Original Message -
From: Brent Baisley [EMAIL
Nice to meet you.
My name is katakura.
I might want to ask the replication.
It is that whether the slave side has synchronized though show master
status is done
on the side of ..show slave status.. mastering on the slave side and
Read_Master_Log_
Pos and Position agree that Rows in the value of
Nice to meet you.
I am andou.
Slave DB : though is several-time re-synchronization. It is sure to have
entered the state that the process of the slave stops because of the same
error.
Excerpt from show slave status(a part of Fge)
Last_error: error 'unexpected success or fatal error' on query
Hi.
Ruslan Zakirov wrote:
On 10/25/05, Luke Vanderfluit [EMAIL PROTECTED] wrote:
Hi.
I have upgraded RT from 3.0.11 to 3.4.4. Mysql 4.0.18, Apache 1.3.27
(with static modperl module).
The database we are using is quite large.
The main problem we are having is when a user needs to comment
Hi!
While ago we perform in our company short experiment in the framework of
mysql tests.
One of our databases is mysql-4.0.15 on i386 Linux. It is MyISAM-based.
Traffic on it consists of mix of selects (quite big share of count
aggregates) and dml operations with quite high share of the
Hi People,
it is strange, i am using MySQL version 4.1 (so dont
expect some bugs) on Windows 2000, and if i create a
field (e.g. temperature) as
temperature decimal(4,3)
if i wanna insert the value 100, it is storing as
99.999
does anybody knows the reason why doesnt show it as
100.000 but as
Hello.
I also tried modifying the mediumtext to longtext in the dumpfile but it
produces a column
with a -1 size for some reason.
Please, could you provide a snip from your dump file.
When I try to input it back into the new 5.0 database, it gives me this error
(1406 data
too long for
Hello.
I changed the log level to 'alert' but got output in the log file.
Stopped and started the (apache) server and mysql server.
Any particular level that I should set it to?
You should enable slow log in mysql configuration file. See:
Hello.
Manual says that --replicate-do-db:
Tells the slave to restrict replication to statements where the
default database (that is, the one selected by USE) is db_name.
Note that this does not replicate cross-database statements, check
what is your default database, when you're running
Hello.
You might be interesting a bit about this:
http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html
Ed wrote:
Hi all,
I am doing a tutorial to make a shopping cart. I need to make a mysql db or
convert an sql db to mysql.
Can anyone give me any pointers
Hello.
What exact version of MySQL are you using? Please could you provide a
repeatable test case.
Scott Klarenbach wrote:
Must be a bug of sorts:
If you add an ORDER BY clause to the view itself, then mysql allows
the caller to override with their own ORDER BY clause and it works
Hello.
Are you able to connect to the server and found the states of its
threads with SHOW PROCESSLIST statement?
Mysql 4.1 and 5 will NOT seem to play nice with french characters so I
have tried to
revert back to 4.0.
I am trying to install 4.0 on a Win2003 Dell PowerEdge 2850
Has anyone here successfully managed to install mysql
4.1.15 on a RedHat 7.3 box? RedHat 7.3 seems to be
using
the glibc 2.2.5 libraries and mysql seems to insist on
using glibc 2.3. Am I out of luck?
how are you trying to install this?
--
MySQL General Mailing List
For list archives:
Dear Heikki,
we change the system's environment. now we use RAID0 disk to store the InnoDB
data file,and other disk to store log file.
follow is system's information:
CPU: 4X2.8GHz
RAM: 1G
Disk: 4X36G
the SHOW INNIDB STATUS\G result is:
=
051021 10:51:59
how are you trying to install this?
actually
# mysql -u root -pxx
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.15-max
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql exit
Bye
[EMAIL PROTECTED] data]#
The short answer: no.
http://dev.mysql.com/doc/refman/4.1/en/innodb-configuration.html states:
The autoextend attribute and those following can be used only for the last
data file in the innodb_data_file_path line. autoextend is available
starting from MySQL 3.23.50 and 4.0.2.
You could use
I have solved this problem, I was missing a slash in the path to the data
directory
Thanks,
James
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, October 26, 2005 4:41 AM
Subject: Re: Mysql 4.0 cpu usage
Hello.
Are you able to
I have since uninstalled 5.0 and installed 4.0
I have found that 4.1 and 5.0 have a VERY hard time with french characters
and there are MANY problems assosiated with french characters.
The problem with this one seemed to be when the dump would get put back in,
it would throw this error on all
** Low Priority **
Thanks Kevin.
I id run : 'perl Makefile.PL' followed by the other steps you mentioned
below. When I cut and pasted it on the mail I missed out the first
line.
I cannot finish this order. I get the error message after running
'make'. In other words:
'perl
Compiling from source:
Platform is RHEL 4.0
# gcc -v
Reading specs from /usr/lib/gcc/i386-redhat-linux/3.4.4/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-shared --enable-threads=posix
--disable-checking --with-system-zlib
- Original Message -
From: Tatjana Cukic [EMAIL PROTECTED]
To: MYSQL ANSWERS mysql@lists.mysql.com
Sent: Wednesday, October 26, 2005 4:05 AM
Subject: Problem with decimal values
Hi People,
it is strange, i am using MySQL version 4.1 (so dont
expect some bugs) on Windows 2000, and
I am unsure how to write this query, can someone help?
I have two tables.
One has a list of retailers (tbl_retailer):
retailerid
name
postcode
e.g.
1 Sprocket Supplies CH23 4PY
The other has the sales by month for each retailer:
retailerid
month_2
sales
e.g.
1 2004-01 100
1
Ziaul Mannan wrote:
Thanks Kevin.
I id run : 'perl Makefile.PL' followed by the other steps you mentioned
below. When I cut and pasted it on the mail I missed out the first
line.
I cannot finish this order. I get the error message after running
'make'. In other words:
'perl
Oops, I stand corrected.
-Sheeri
On 10/25/05, Jason Martin [EMAIL PROTECTED] wrote:
On Tue, Oct 25, 2005 at 04:22:01PM -0400, sheeri kritzer wrote:
What you need is the table schemas and the data. Oracle doesn't have
SHOW CREATE TABLE like mysql does. Furthermore, Oracle also doesn't
The
Hi, I am a brand new newbie...two questions.
Question 1
What is the best configuration for using MySQL and PHP from the three
following combinations:
#1 OS: Linux
WebServer: Apache
#2 OS:Windows XP SP2(Family edition)
I don't want to speak out of turn, but here is the real question...
What are you more comfortable with?
If you feel that you are more comfortable with Windows, then use Windows and
Windows 2000/2003 Server.
If you want to stretch your comfort level and think outside the box, Linux
is your
So follow the installation directions appropriate for the flavor of Linux
you are using. That's where MySQL lives, in the OS, not the application
As far as I can tell, there are none. At least not for Mandriva. The
attitude seems to be that MySQL is just the backend. :-/
Jim C.
How do I create a trigger in MySQL similiar to the trigger created for mssql:
CREATE TRIGGER DEL_DE ON KRONOS
AFTER DELETE
AS
DELETE FROM
DE_Metrics
WHERE
KID=(
SELECT
ID
Hey! Those are some pretty handy looking links. :-)
Thanks!!
Did you see this:
http://www.mythtv.org/docs/mythtv-HOWTO-6.html
And also:
http://wilsonet.com/mythtv/tips.php (see the section on Front Ends)
And lastly:
http://dipper.info/project/ivtv/
signature.asc
Hi
Thank you for the answer
You can still connect with your laptop to Linux, and it would help you to
learn WHY things work, not just HOW they work.
How will I do that ? Laptop run on Windows os.
-Message d'origine-
De : J.R. Bullington [mailto:[EMAIL PROTECTED]
Envoyé : 26 octobre
Hello Scott,
How do I create a trigger in MySQL similiar to the trigger created for
mssql:
CREATE TRIGGER DEL_DE ON KRONOS
AFTER DELETE
AS
DELETE FROM
DE_Metrics
WHERE
KID=(
SELECT
ID
FROM
DELETED
);
I already read online mysql TRIGGER, CREATE TRIGGER and USING TRIGGER
to no
Just because your webpage and your MySQL server are running on Linux doesn't
mean that you cannot connect to it using Windows.
If you need to transfer files back and forth, you can use SAMBA
(http://www.samba.org) or FTP (see your Distro's man pages for more info).
Most notably, if you are using
Dan,
...Total sales for ever would be a simple GROUP BY query with a
sum on the sales - but I cant see how I am going to get this info.
Do I need to use nested queries?
You don't need nested queries. It's a crosstab or pivot table query.
The trick is to sum into one column per desired
news [EMAIL PROTECTED] wrote on 10/26/2005 09:46:49 AM:
I am unsure how to write this query, can someone help?
I have two tables.
One has a list of retailers (tbl_retailer):
retailerid
name
postcode
e.g.
1 Sprocket Supplies CH23 4PY
The other has the sales by month for
Thank you for your precious help
-Message d'origine-
De : J.R. Bullington [mailto:[EMAIL PROTECTED]
Envoyé : 26 octobre 2005 11:18
À : mysql@lists.mysql.com
Objet : RE: Best configuration OS WebServer
Just because your webpage and your MySQL server are running on Linux doesn't
mean
I am a newbie as well, and I have had very nice results using Debian. The
big advantage in Debian is because there is a tool to manage the packages
(apt-get) so there is not pain installing the web server, the MySQL server
and PHP. In other distributions there are nice package management tools,
Since 4.1.8a, I've been unable to compile all new releases (including both the
4.1.x and 5.x versions) on Solaris 8 using gcc 3.4.2.
Problem seems to be with zlib (I have version 1.2.3 installed). configure is
run with --with-zlib-dir=/usr/local
Problem comes in linking libmysqlclient.so, with
Rhino wrote:
- Original Message -
From: Ed mailto:[EMAIL PROTECTED]
To: mysql@lists.mysql.com mailto:mysql@lists.mysql.com
Sent: Tuesday, October 25, 2005 6:40 PM
Subject: Problem with syntax 4 creating 1 table
Shawn green was very kindly helping me ouy trying
Hi,
I want to set up a different timezone that my operating system for MySQL
upper to 4.1. According to this article[1], timezone system variable was
changed since 4.1.3. I'm using mysql 4.1.11a from Debian sarge.
I was tried to set system_time_zone into /etc/mysql/my.cnf
unsuccessfully. The only
Peter Brawley wrote:
Dan,
/...Total sales for ever would be a simple GROUP BY query with a
sum on the sales - but I cant see how I am going to get this info.
Do I need to use nested queries? /
You don't need nested queries. It's a crosstab or pivot table query. The
trick is to sum into one
Daniel Bowett wrote:
Peter Brawley wrote:
Dan,
/...Total sales for ever would be a simple GROUP BY query with a
sum on the sales - but I cant see how I am going to get this info.
Do I need to use nested queries? /
You don't need nested queries. It's a crosstab or pivot table query.
The
Michael Stassen wrote:
Daniel Bowett wrote:
Peter Brawley wrote:
Dan,
/...Total sales for ever would be a simple GROUP BY query with a
sum on the sales - but I cant see how I am going to get this info.
Do I need to use nested queries? /
You don't need nested queries. It's a crosstab or
news [EMAIL PROTECTED] wrote on 10/26/2005 04:02:33 PM:
Michael Stassen wrote:
Daniel Bowett wrote:
Peter Brawley wrote:
Dan,
/...Total sales for ever would be a simple GROUP BY query with a
sum on the sales - but I cant see how I am going to get this info.
Do I need to use
Dan,
If you don't want the query to stop with the current month, drop the
WHERE clause.
PB
Daniel Bowett wrote:
Michael Stassen wrote:
Daniel Bowett wrote:
Peter Brawley wrote:
Dan,
/...Total sales for ever would be a simple GROUP BY query with a
sum on the sales - but I cant see
Daniel Bowett wrote:
Michael Stassen wrote:
Daniel Bowett wrote:
Peter Brawley wrote:
Dan,
/...Total sales for ever would be a simple GROUP BY query with a
sum on the sales - but I cant see how I am going to get this info.
Do I need to use nested queries? /
You don't need nested
Ady,
NO ACTION actually means the same as RESTRICT. That is, the foreign key
constraint is still enforced. The name 'NO ACTION' is from the SQL standard.
I agree that the name is confusing, but I cannot help it, because it is in
the standard.
Regards,
Heikki
Oracle/Innobase
- Original
Hi folks.
Just installed 4.1.15 on OS X (Tiger 10.4) and am having issues.
With permissions, have they changed since 4.1.14? It seems 4.0.x had the
following permissions on the data folder:
775 for root/wheel
Now, what works for me on this new version, is:
770 for mysql/wheel
Also,
Rich wrote:
Hi folks.
Just installed 4.1.15 on OS X (Tiger 10.4) and am having issues.
With permissions, have they changed since 4.1.14? It seems 4.0.x had the
following permissions on the data folder:
775 for root/wheel
No changes I'm aware of. Is it possible you're simply
Hi.
Jesse Vincent wrote:
On Tue, Oct 25, 2005 at 04:14:46PM +0930, Luke Vanderfluit wrote:
Hi.
I have upgraded RT from 3.0.11 to 3.4.4. Mysql 4.0.18, Apache 1.3.27
(with static modperl module).
The database we are using is quite large.
The main problem we are having is when a user needs
Another developer told me his data folder had root/wheel as user/group.
Also 775 as the permissions.
Just changed it to 700 and it works.
As for the kayak issue, it's Safari. It doesn't want to see the web sharing
on the very same machine it's on. Very temperamental.
Cheers
Michael Stassen:
well, i've got /var/lib/mysql:
[EMAIL PROTECTED] mysql]$ ll /var/lib/mysql/
total 20524
-rw-rw 1 mysql mysql 10485760 Oct 24 18:38 ibdata1
-rw-rw 1 mysql mysql 5242880 Oct 24 19:54 ib_logfile0
-rw-rw 1 mysql mysql 5242880 Oct 24 18:38 ib_logfile1
-rw-rw 1 mysql root
Hi Tom
Looks like you had an earlier version that had a
datadir=/usr/local/mysql/data. The new version was expecting the data
directory to reside in /var/lib/mysql (that can be seen on your mysqld
processes and also the mysql_install_db output).
You can change this in the /etc/my.cnf
Why the UPPER and LOWER functions don't have any effect in the following
statements?
SELECT UPPER(DAYNAME(NOW()));
SELECT LOWER(DAYNAME(NOW()));
While other String related functions such as LENGTH produce the expected result?
If you know, please let me know.
Thank you
Giorgio Frondoni
AVP,
Hi Giorgio,
Works for me mysql 4.0.22 on Solaris 9.
localhost.(none)SELECT UPPER(DAYNAME(NOW()));
+---+
| UPPER(DAYNAME(NOW())) |
+---+
| THURSDAY |
+---+
1 row in set (0.04 sec)
localhost.(none)SELECT
David,
I have mysql 5.0.15 on Windows. I'm porting an Oracle application to mysql
5.0.x.
I guess I have to submit a bug report.
Thank you for the quick answer.
Giorgio Frondoni
AVP, Chief of System Development
TransCore
San Diego, CA
phone: (858) 826-4750
cell: (760) 214-4092
Hi Giorgio,
Looks like a bug in v5. Worked ok in 4.1.3 as well (I just checked)
Yes, time to report it 8-)
mysql SELECT UPPER(DAYNAME(NOW()));
+---+
| UPPER(DAYNAME(NOW())) |
+---+
| Thursday |
+---+
1 row in set (0.01
Rich wrote:
Another developer told me his data folder had root/wheel as user/group.
Also 775 as the permissions.
Well, that would work if mysql were in the wheel group, but that's not the
normal setup http://dev.mysql.com/doc/refman/5.0/en/installing-binary.html.
I'm not sure why you'd make
59 matches
Mail list logo