Unfortunately the additional parameters didn't solve my problem. But
thanks for your response!
ssh [EMAIL PROTECTED] \
mysqldump -u XYZ --verbose --password=XYZ --quick
--single-transaction --net_buffer_length=1G --max_allowed_packet=1G
dbmail | /bin/gzip \
I have a new setup with mySql version 4.1 and myODBC version 3.51
running on Windows 2k3 standard
In the database we have something like And this is £200 and when we
write this out in ASP we get And this is ?200 The same happens for
some other symbols like the copy write symbol (c in a
Hi List,
Anybody knows a tool for viewing mysql server general query log in
linux.
Thanks
Ashok
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a table of bookmarks that have keyword searching.
Fields
+-+--+--+--+
| bookmark_id | bookmark_title | bookmark_url |
bookmark_keyword |
I see one conflict that could be causing your lost connection message -
you are specifying a 1 GB max_allowed_packet for the client, but the
server is configured to only support 64 MB.
You should adjust the max_allowed_packet = 64M setting on the server to
match or exceed what you specify on the
insight, parenthesis highlighting)
- File Compare Tool
... and much more ...
Download a trial at: http://www.upscene.com/download.htm
What's new?: http://www.upscene.com/products/dbw/whatsnew30.htm
Full list of features and fixes: http://www.upscene.com/news/20070924.htm
Order now and get a 20
Hi Kevin,
Kevin Waterson wrote:
I have a table of bookmarks that have keyword searching.
Fields
+-+--+--+--+
| bookmark_id | bookmark_title | bookmark_url |
bookmark_keyword |
Kevin Waterson schrieb:
I have a table of bookmarks that have keyword searching.
Fields
+-+--+--+--+
| bookmark_id | bookmark_title | bookmark_url |
bookmark_keyword |
Hi Sebastian, Kevin,
Sebastian Mendel wrote:
Kevin Waterson schrieb:
I have a table of bookmarks that have keyword searching.
Fields
+-+--+--+--+
| bookmark_id | bookmark_title | bookmark_url |
Baron Schwartz schrieb:
Hi Kevin,
Kevin Waterson wrote:
I have a table of bookmarks that have keyword searching.
Fields
+-+--+--+--+
| bookmark_id | bookmark_title | bookmark_url |
bookmark_keyword
Baron Schwartz schrieb:
SELECT
child.bookmark_id,
child.bookmark_title,
child.bookmark_url
FROM
bookmarks AS child
WHERE
child.bookmark_keyword IN (
SELECT
parent.bookmark_keyword
FROM
bookmarks AS parent
WHERE
parent.bookmark_url =
I've found the following resources to be very helpful when dealing with
character set issues:
http://www.cs.tut.fi/~jkorpela/chars.html
http://www.joelonsoftware.com/articles/Unicode.html
HTH, HAND
JT
-Original Message-
From: Critters [mailto:[EMAIL PROTECTED]
Sent: Monday,
From: Critters [mailto:[EMAIL PROTECTED]
Sent: Monday, September 24, 2007 5:24 AM
To: MySQL General
Subject: Problem with characters
I have a new setup with mySql version 4.1 and myODBC version 3.51
running on Windows 2k3 standard
In the database we have something like And this is £200
[EMAIL PROTECTED] wrote:
Howdy,
I'm trying to add a second slave, slave2, running MySQL 5.0.22 on
CentOS5
to our system that currently has one master and one slave, slave1,
running
4.0.24, and somehow slave2 somehow ends up with too many records in many
of the 30 tables in the
I found that using version 5.1 of the ODBC connector solved our problem with
Chinese characters. It might solve the problem with the pound sterling sign.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX:
This one may end up dead in the water, but I figured I'd run it past the
group as I've seen some pretty creative solutions in my time here.
Let's say I have a table like this:
++---+
| id | parent_id |
++---+
| 1 | 0 |
| 2 | 0 |
| 3 | 2 |
| 4 |
Boyd Hemphill wrote:
I have executed a strategy for backup where I stop a slave and do a mysqldump
with --master-data. Both master and slave are 4.1.20
My assumption was that the log coordinates in the dump file would provide me with the place to replay the log for a point in time recovery.
Hi,
I need to match anything that start with foo then followed by a string
containing letter/number/underscore/dot but NOT end with the string
linux. When I use the pattern 'foo[(a-z|0-9|_|.)]+(?!linux)' , I got
ERROR 1139 (42000): Got error 'repetition-operator operand invalid'
from regexp.
Mike,
What I'd love to do is pull all children (and grandchildren, etc) per
each, such that I'd end up with the following result set or something
See http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html
for theory examples.
PB
Mike Johnson wrote:
This one may end up dead in
This one time, at band camp, Baron Schwartz [EMAIL PROTECTED] wrote:
I wish to select all bookmark_title and bookmark_url that have the same
keywords as
the bookmark_url 'http://www.redhat.com. I do this..
mysql SELECT child.bookmark_id, child.bookmark_title, child.bookmark_url
FROM
Kevin Waterson wrote:
This one time, at band camp, Baron Schwartz [EMAIL PROTECTED] wrote:
I wish to select all bookmark_title and bookmark_url that have the same
keywords as
the bookmark_url 'http://www.redhat.com. I do this..
mysql SELECT child.bookmark_id, child.bookmark_title,
21 matches
Mail list logo