On Tue, May 1, 2007 22:15, Brown, Charles wrote:
Because I am running on batch mode therefore I'm trying to direct my
session output to a file -- meaning stdout. But I'm having a problem.
For instance this input: use test_db gave me no output but this input
show tables gave me an output.
I have upgraded a website from drupal 4.7.4 to drupal 5.1 (I have also moved
website from one server to another), now when I try to login I'm getting
following error.
user warning: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '=' query:
On Wed, May 2, 2007 08:55, Mogens Melander wrote:
On Tue, May 1, 2007 22:15, Brown, Charles wrote:
Because I am running on batch mode therefore I'm trying to direct my
session output to a file -- meaning stdout. But I'm having a problem.
For instance this input: use test_db gave me no
I went to the MySQL documentation pages and read up on using COLLATE. I
knew SELECT was case-insensitive, but I was sort of surprised that using
a character class didn't override that. Anyway, I next tried the
status command to see if it gave me any characterset information.
Client characterset:
Hi
my table have three fields that, if selected, are shown like:
area1, value_one, thing_one
area1, value_two, thing_32
area1, value_three, thing_ dd
area2, value_ten, thing_6w
area2, value_ff, thing_l
can I obtain a recordset like this?
area1, value_one, thing_one
//, value_two,
Hi,
spacemarc wrote:
Hi
my table have three fields that, if selected, are shown like:
area1, value_one, thing_one
area1, value_two, thing_32
area1, value_three, thing_ dd
area2, value_ten, thing_6w
area2, value_ff, thing_l
can I obtain a recordset like this?
area1, value_one,
Hi,
Ofer Inbar wrote:
There's a system variable called expire_logs_days that lets you set a
number of days to keep binary logs, and automatically delete logs
older than that. I've heard rumors that using this feature is
problematic. I notice that in the MySQL documentation about binary
-Original Message-
From: Mogens Melander [mailto:[EMAIL PROTECTED]
Sent: 01 May 2007 21:44
On Tue, May 1, 2007 21:36, Afan Pasalic wrote:
Hi,
I'm looking for database modeling tool form MySQL. Anybody used the
MySQL Workbench? I know the Workbench is in Alpha production, though
-Original Message-
From: Baron Schwartz [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 02, 2007 7:55 AM
To: Ofer Inbar
Cc: mysql@lists.mysql.com
Subject: Re: expire_logs_days
Hi,
Ofer Inbar wrote:
There's a system variable called expire_logs_days that lets you set a
number
I have a huge MySQL table, 2.1 million records, 200MB. Once a week I
need to dump it in CSV format and zip the file.
This is not on my server, and it's in production, so I don't want to
risk testing different methods and possibly hanging up their server
for a period of time, so I wanted to
[snip]
I have a huge MySQL table, 2.1 million records, 200MB. Once a week I
need to dump it in CSV format and zip the file.
This is not on my server, and it's in production, so I don't want to
risk testing different methods and possibly hanging up their server
for a period of time, so I
I'd be interested to hear other options though...
Edward, we develop a commercial Windows tool named Database Workbench that
supports MySQL.
It does not yet do diagramming, but it's being worked at for v3, as well as
many
other features.
Have a look at www.upscene.com
Martijn Tonies
Database
I use a script like this:
#!/bin/bash
DATE=`date +%A`
DESTFILE=/home/mysql-backups/mysql-dump-$DATE
/usr/bin/mysqldump --skip-extended-insert -uroot -ppassword
mydatabase $DESTFILE.sql
/usr/bin/zip -qjTm $DESTFILE.zip $DESTFILE.sql
I end up with:
mysql-dump-Friday.zip
A few observations:
1 - if the table is in the InnoDB format, you aren't going to lock up their
server, as InnoDB doesn't do table locking. SHOW TABLE STATUS LIKE
'tablename' will tell you.
2 - Ryan's mysqldump script looks useful - also, there's a little-used
option with mysqldump that lets
can I obtain a recordset like this?
area1, value_one, thing_one
//, value_two, thing_32
//, value_three, thing_ dd
area2, value_ten, thing_6w
//, value_ff, thing_l
SET @prev='';
SELECT
IF(area = @prev, '', @prev := area) AS area,
... other columns ...
FROM c ...
PB
spacemarc
I have a client that needs to be able to remotely connect to port 3306
securely. I have tried to suggest an SSH Tunnel, but they do not want their
clients to have SSH access. Another problem is that even if we do tunnel,
it needs to go thru one server that is connected to the Internet and into
[snip]
I have a client that needs to be able to remotely connect to port 3306
securely. I have tried to suggest an SSH Tunnel, but they do not want
their
clients to have SSH access. Another problem is that even if we do
tunnel,
it needs to go thru one server that is connected to the Internet and
The table is MyISAM, does that matter?
On May 2, 2007, at 7:28 AM, Dan Buettner wrote:
A few observations:
1 - if the table is in the InnoDB format, you aren't going to lock
up their server, as InnoDB doesn't do table locking. SHOW TABLE
STATUS LIKE 'tablename' will tell you.
2 -
Hello, list --
No problem, yet. ;-)
Wondering if anyone would have a suggestion to ensure better performance, or
could point out any likely errors in the database outlined below.
Basically, I have digital pictures, scanned text/forms and emails that all
relate to information indexed in a
MyISAM does table level locking, which is to say that read (select) and
write (insert/update/delete) cannot happen at the same time. One will wait
for the other.
If your select takes 10 seconds, then any write operations will block for
those 10 seconds. Other read processes should be
Michael, this looks pretty decent overall.
I'm a big fan of fully descriptive table and column names, avoiding
abbreviations except where truly needed, so I personally would spell out
claim and claimant for example. I also like to separate words in table
and column names with underscores, which
2007/5/2, Peter Brawley [EMAIL PROTECTED]:
Works for me. Please post a CREATE TABLE stmt enough INSERTs to
demonstrate the problem.
This is the dump (MySQL: 5.0.38): the table is not final version, just
to test the query.
CREATE TABLE `products` (
`area` varchar(25) NOT NULL,
`text`
Right, give the computed column an alias differeing from the column name, eg
SET @prev='';
SELECT
IF(area = @prev, '', @prev := area) AS AreaHdr,
text,amount
FROM products
ORDER BY area DESC;
PB
spacemarc wrote:
2007/5/2, Peter Brawley [EMAIL PROTECTED]:
Works for me. Please post a
I was experimenting with Character Classes because they were covered in
MySQL Crash Course. There are probably substitutes for all the character
classes--such as ^[a-z] for [:lower:]--that I probably should stick with
instead of wandering off into foreign territory.
Fooling with Character Classes
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Michael, this looks pretty decent overall.
I'm a big fan of fully descriptive table and column names,
[8] (All good suggestions, thanks.)
One performance suggestion: add an index on each table for
the claim_id
At 5:33 AM -0400 5/2/07, John Kebbel wrote:
I went to the MySQL documentation pages and read up on using COLLATE. I
knew SELECT was case-insensitive, but I was sort of surprised that using
a character class didn't override that. Anyway, I next tried the
status command to see if it gave me any
On linux, one could do a port forward:
EXTIF=eth0 # Or whatever the interface that faces internet is called.
iptables -A FORWARD -i $EXTIF -p tcp -s client-ip --dport 3306 -j ACCEPT
iptables -A PREROUTING -t nat -p tcp -s client-ip \
-d linux-fw-ip --dport 3306 -j DNAT --to internal-ip:3306
Using ROLLUP in my GROUP BY, I have been able to get MySQL to insert
sub-total lines, which is great. However, it would be even better if I
could determine the text on those subtotal lines. Here's my query:
SELECT Sc.State, St.Description, Count(*)
FROM InvHead I
JOIN Schools Sc on
2007/5/2, Peter Brawley [EMAIL PROTECTED]:
Right, give the computed column an alias differeing from the column name, eg
SET @prev='';
SELECT
IF(area = @prev, '', @prev := area) AS AreaHdr,
text,amount
FROM products
ORDER BY area DESC;
ok, now it works! thanks!
One last thing: you set, at
Baron Schwartz [EMAIL PROTECTED] wrote:
Actually, the manual does mention the variable, but it doesn't work
for us. We run a nightly cron job that just runs [purge master logs]
When you say it doesn't work for us do you mean that you tried it?
In what way did it not work?
Tim Lucia [EMAIL
One last thing: you set, at first, a parameter called @prev with Null
(' ') value: right?
No, I set it to a string containing one space char. Use anything that
does not occur as data in the column.
And, after, you use, instead IF ELSE statement, another syntax: is it
trinary operator? if yes,
Hi,
I'm experience using expire_log_days and don't work. I set this parameters
in the CNF and when the time of ( for example 5 days) is in, don't delete
anything.
On my expirience, this parameters don't work ( 5.0.27).
Regards
Juan
On 5/2/07, Ofer Inbar [EMAIL PROTECTED] wrote:
Baron
Does anybody have a copy of the MySQL Reference Manual,
refman-5.0-en.pdf, for the *exact* version 5.0.30 (as stated on p. 2 of
the doc), that they could please send me? MySQL itself says it doesn't
archive docs.
The reason is, 5.0.30 is the version of the MySQL software we're
shipping
I'm confused by a bit of the documentation here:
http://dev.mysql.com/doc/refman/5.0/en/show-slave-status.html
In the section on Seconds_Behind_Master, first it says:
When the slave SQL thread is actively running (processing updates),
this field is the number of seconds that have elapsed
Ofer Inbar wrote:
Baron Schwartz [EMAIL PROTECTED] wrote:
Actually, the manual does mention the variable, but it doesn't work
for us. We run a nightly cron job that just runs [purge master logs]
When you say it doesn't work for us do you mean that you tried it?
In what way did it not work?
You might benefit from drawing your layout as a picture, if you haven't
already. Use arrows to connect the fields in each table with the fields in
other tables that they will hook to. That will give you an idea of which
fields to index and JOIN on. You JOIN on those fields, and you index the
ones
I seem to have problems receiving from this list.
I hadn't seen this answer come through until I was searching google again
today. :)
I just can't get my head around the mysql config system. If you can provide me
with instructions, It would be greatly appreciated.
Ray
There is a sql log that
In the last episode (May 02), Jesse said:
Using ROLLUP in my GROUP BY, I have been able to get MySQL to insert
sub-total lines, which is great. However, it would be even better if I
could determine the text on those subtotal lines. Here's my query:
SELECT Sc.State, St.Description,
Juan Eduardo Moreno wrote:
Hi,
I'm experience using expire_log_days and don't work. I set this
parameters
in the CNF and when the time of ( for example 5 days) is in, don't delete
anything.
On my expirience, this parameters don't work ( 5.0.27).
I am testing this now (on 5.0.40) and will
Thanks to everyone who answered, think I've got enough info now to
handle it. :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mark Leith wrote:
Juan Eduardo Moreno wrote:
Hi,
I'm experience using expire_log_days and don't work. I set this
parameters
in the CNF and when the time of ( for example 5 days) is in, don't
delete
anything.
On my expirience, this parameters don't work ( 5.0.27).
I am testing this now
Hi Jeff,
There isn't really a clear winner in any case, but the tests done in the
article linked to are highly suspect. It would be much more interesting
to see real tests done with real hardware...
Nonetheless, the usual answer I would have is to lean towards ease of
administration and
Mark Leith [EMAIL PROTECTED] wrote:
Do keep in mind that expire_logs_days only gets triggered at a) server
start up b) the time a binary log has to roll over.
If your binary logs do not roll over for quite a period of time (i.e are
lower load systems) that still stay up for long periods -
Ofer Inbar wrote:
Mark Leith [EMAIL PROTECTED] wrote:
Do keep in mind that expire_logs_days only gets triggered at a) server
start up b) the time a binary log has to roll over.
If your binary logs do not roll over for quite a period of time (i.e are
lower load systems) that still stay up for
At 8:46 PM -0400 5/2/07, Baron Schwartz wrote:
Ofer Inbar wrote:
Mark Leith [EMAIL PROTECTED] wrote:
Do keep in mind that expire_logs_days only gets triggered at a)
server start up b) the time a binary log has to roll over.
If your binary logs do not roll over for quite a period of time
For disaster recovery, it's good to have copies of your database dumps
that you can easily conveniently access, that are outside the data
center where the database lives. Since we do a weekly full dump and
use binary logs for incrementals, I also wanted copies of our binary
logs in the same
Ofer Inbar a écrit :
I'm confused by a bit of the documentation here:
http://dev.mysql.com/doc/refman/5.0/en/show-slave-status.html
In the section on Seconds_Behind_Master, first it says:
When the slave SQL thread is actively running (processing updates),
this field is the number of
Mathieu Bruneau [EMAIL PROTECTED] wrote:
In the section on Seconds_Behind_Master, first it says:
When the slave SQL thread is actively running (processing updates),
this field is the number of seconds that have elapsed since the
timestamp of the most recent event on the master
48 matches
Mail list logo
