Baron Schwartz schrieb:
> You have one final problem, which isn't really causing you trouble with
> THIS query, but will likely bite you in the future: you are selecting
> non-grouped columns in a GROUP BY query.
SELECT DISTINCT will help too, of course (at least in similar cases) only if
require
Baron Schwartz schrieb:
> SELECT parent.bookmark_url as pbu, parent.bookmark_keyword as pbk
> FROM bookmarks AS child
>JOIN bookmarks AS parent
> ON parent.bookmark_keyword = child.bookmark_keyword
> WHERE child.bookmark_url='http://www.redhat.com';
>
> [..]
no, you didn't, you just sw
After you stop the slave and start mysqldump,
execute the below on slave db.
show slave status\G.
Note down the Master_Log_File and Exec_Master_Log_Pos. This will be the
point from which you need to do the recovery.
regards
anandkl
On 9/25/07, Eric Frazier <[EMAIL PROTECTED]> wrote:
>
> Boyd
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, child.boo
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
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
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
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.
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 |
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: 860.674.8
>>> [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
> 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 i
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, Septem
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.bookma
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 |
>>
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 |
bookmark_
Kevin Waterson schrieb:
> I have a table of bookmarks that have keyword searching.
> Fields
>
> +-+--+--+--+
> | bookmark_id | bookmark_title | bookmark_url |
> bookmark_keyword |
> +-+--
Hi Kevin,
Kevin Waterson wrote:
I have a table of bookmarks that have keyword searching.
Fields
+-+--+--+--+
| bookmark_id | bookmark_title | bookmark_url |
bookmark_keyword |
+-+-
ancements (parameter 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
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
I have a table of bookmarks that have keyword searching.
Fields
+-+--+--+--+
| bookmark_id | bookmark_title | bookmark_url |
bookmark_keyword |
+-+--+-
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 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 cir
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" \
> /Backup/HD-Save/
24 matches
Mail list logo
