I'm trying to set up MySQL backup & restore using mysqldump and binary
logs, so we can run mysqldump infrequently and use binary logs for the
daily backups (because mysqldump makes the production database unusable
for too long a time to run every night).
- I can make full dumps using mysqldump
-
On 4/25/07, mos <[EMAIL PROTECTED]> wrote:
At 02:36 PM 4/25/2007, you wrote:
>On 4/25/07, Daevid Vincent <[EMAIL PROTECTED]> wrote:
>>
>>A co-worker sent this to me, thought I'd pass it along here. We do tons
of
>>failover/replication and would be eager to see mySQL implment the Google
>>patches
At 02:36 PM 4/25/2007, you wrote:
On 4/25/07, Daevid Vincent <[EMAIL PROTECTED]> wrote:
A co-worker sent this to me, thought I'd pass it along here. We do tons of
failover/replication and would be eager to see mySQL implment the Google
patches in the stock distribution. If anyone needs mission
On Wed, April 25, 2007 23:10, Jørn Dahl-Stamnes wrote:
> Please, I nedd help!!
>
> I have two tabels:
>
> table1:
> id
> value
>
> table2:
> id
> value
>
> Both tables has a lot of records with identical IDs. I need to update the
> table1.value with the table2.value where t
Please, I nedd help!!
I have two tabels:
table1:
id
value
table2:
id
value
Both tables has a lot of records with identical IDs. I need to update the
table1.value with the table2.value where the id are identical.
But I cannot find any UPDATE query that can do th
On 4/25/07, Daevid Vincent <[EMAIL PROTECTED]> wrote:
A co-worker sent this to me, thought I'd pass it along here. We do tons of
failover/replication and would be eager to see mySQL implment the Google
patches in the stock distribution. If anyone needs mission critical,
scaleable, and failover c
A co-worker sent this to me, thought I'd pass it along here. We do tons of
failover/replication and would be eager to see mySQL implment the Google
patches in the stock distribution. If anyone needs mission critical,
scaleable, and failover clusters, it's Google -- so I have every confidence
their
Hi Dan,
Thanks for this, fixed the problem perfectly when we applied it.
Andrew
On Thu, 2007-04-12 at 10:45 -0500, Dan Nelson wrote:
> In the last episode (Apr 12), Andrew Simpson said:
> > One server had a problem while creating a backup last week. The routine
> > normally takes about 30 seco
Hi James, all,
James Tu wrote:
What do you guys think of this approach...
Always query on all 5 columns...and then create a multicolumn index
using all 5 columns?
From a database point of view, that would be best -
but I am not sure whether it fits your application and the users.
Some poi
Finaly I use ord().
Thank you.
Jerry Schwartz wrote:
The multi-byte extension doesn't seem to include one, but it appears
that somebody put one together and posted it in the notes on chr().
http://us2.php.net/manual/en/function.chr.php#69082
Regards,
Jerry Schwartz
Global Information Inco
The multi-byte extension doesn't seem to include one, but it appears that
somebody put one together and posted it in the notes on chr().
http://us2.php.net/manual/en/function.chr.php#69082
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.6
Jerry do you know if there is a php command that returns ascci number of
a letter?
I'll want to use chr() command because I want to transfer via link the
letter to next page but greek characters transformed to something like
"%CE%9C".
Thank you
Jerry Schwartz wrote:
It would depend upon the c
It would depend upon the collating sequence for the field.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: nikos [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 25, 2007 10
Try just 'storage-engine'
- Original Message -
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Sent: Wednesday, April 25, 2007 5:26:40 AM (GMT-0500) America/New_York
Subject: default-storage-engine not working?
Hi, we have just upgraded from mysql 4.1 to 5.0 and th
IBM, MySQL team up on database software
BOSTON (Reuters) - International Business Machines Corp. plans
to start selling products from smaller rival MySQL AB, a developer of an
open-source database that is used to help run Web sites,
Executives at IBM, the world's No. 2 software maker, and MySQL
Re: "webserver2-relay-bin.{some#}"
Because you've deleted the master.info file found in the SLAVE server
therefore these files( relay logs) are no longer needed. Mind you, you
will not be able resume or restart replication. Replication at your site
will have to be setup from 'scratch'.
Thanks
It was my first thought Jerry, but it didn't work to me...
Thanks anyway!
Jerry Schwartz wrote:
Aren't all of the Greek characters distinct from all of the English
characters? If so, you could test just the first letter of the field against
an IN condition, where the IN (...) lists all of the Gr
Seems that work in v. 4.1.21
but not in 5.0.27
Thank you Dusan
Dus(an Pavlica wrote:
I'm not sure, but I think that greek characters are sorted after
English chars so try this:
SELECT DISTINCT LEFT(title,1) FROM odigos_details WHERE LEFT(title,1)
> 'z' ORDER BY title
HTH,
Dusan
nikos naps
Aren't all of the Greek characters distinct from all of the English
characters? If so, you could test just the first letter of the field against
an IN condition, where the IN (...) lists all of the Greek characters. If
it's easier to type, you could use a NOT IN (...) test and list the English
lett
I'm not sure, but I think that greek characters are sorted after English
chars so try this:
SELECT DISTINCT LEFT(title,1) FROM odigos_details WHERE LEFT(title,1) >
'z' ORDER BY title
HTH,
Dusan
nikos napsal(a):
Hello list.
I want to select discinct the first letters of titles in a UTF8 tabl
At 8:44 AM -0400 4/25/07, Kebbel, John wrote:
I've been developing Perl/ PHP and MySQL applications on a small
scale for years, reworking my small core of knowledge over and over
again. I recently decided to hit the books and shoot for
certification as a MySQL CMDEV. Most of my questions have a
Hello list.
I want to select discinct the first letters of titles in a UTF8 table
but only the greek ones.
There are both english and greek charakter titles.
How can I exclude the english from selection?
My table is:
CREATE TABLE `odigos_details` (
`id` int(11) NOT NULL auto_increment,
`cat`
I've been developing Perl/ PHP and MySQL applications on a small scale for
years, reworking my small core of knowledge over and over again. I recently
decided to hit the books and shoot for certification as a MySQL CMDEV. Most of
my questions have answers in my books and on web sites, but I occa
Hi All,
This is my procedure, i am using cursor to access data one row by one. The
cursor is looping twice, though i have only one row data in the DB
table(playersloginfo). Can any body tell me why cursor is looping twice and
how can i control it, And please explain me what is this " declare cont
Hi, we have just upgraded from mysql 4.1 to 5.0 and this far I only have one
problem. I can't get default-storage-engine to work.
I have "default-storage-engine = INNODB" under my [mysqld] in my.cnf which is
loaded by the daemon (tested with password=xxx). I have also tried
default-table-type,
25 matches
Mail list logo
