Re: Global search and replace utility

2008-10-09 Thread Rob Wultsch
On Thu, Oct 9, 2008 at 4:21 PM, mike cantor <[EMAIL PROTECTED]> wrote: > Does anyone know of a utility that can go through a set of tables (or every > table) in a MySql database and preform a global search and replace (i.e. > replace every instance "string1" in a text field with "string2"). Or is

Global search and replace utility

2008-10-09 Thread mike cantor
Does anyone know of a utility that can go through a set of tables (or every table) in a MySql database and preform a global search and replace (i.e. replace every instance "string1" in a text field with "string2"). Or is there a super clever query that accomplishes this? I have seen a few Win

Re: Cannot login into mysql server

2008-10-09 Thread Claudio Nanni - TomTom
Try using the '-h localhost' flag, shell>mysqladmin -u root -h localhost -p Aloha Claudio SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: [EMAIL PROTECTED] To: mysql@li

Re: "Copying" tables between databases

2008-10-09 Thread Rob Wultsch
Assuming that both databases are on the same mysqld instance setting triggers to keep the table up to date should do what you want... On Thu, Oct 9, 2008 at 10:34 AM, Eric Anderson <[EMAIL PROTECTED]> wrote: > > I've got two databases Foo and Bar. Both databases have a table called > 'zoop_t'. F

"Copying" tables between databases

2008-10-09 Thread Eric Anderson
I've got two databases Foo and Bar. Both databases have a table called 'zoop_t'. Foo's is the "master" copy (i.e. the one that gets updated) and Bar needs to be updated if/when changes are made. Currently, I'm mysqldump'ing that table from Foo at midnight via cron and feeding it back into

Cannot login into mysql server

2008-10-09 Thread dimand
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Cannot login into mysql server >Description: After starting the serv

Re: How could i check the following values in MySQL Server 5.0

2008-10-09 Thread Amit Sharma
Hi Sudhir, #show table status command will give you most of what all is required. Have a look at the results & post any further query if you have. Regards, Amit Sharma On Thu, Oct 9, 2008 at 6:44 PM, Sudhir Menon <[EMAIL PROTECTED]> wrote: > Hi all, > > I would like to check or set the followi

How could i check the following values in MySQL Server 5.0

2008-10-09 Thread Sudhir Menon
Hi all, I would like to check or set the following values in MySQL Server . How can that be done ? 1. MySQL Database Free Space for any database. 2. Maximum Database size allowed. 3. Calculate Index Size. 4. Maximum table size 5. Free table space 6. Free Index space 7. Calculate Table size T

Re: Master-master setup

2008-10-09 Thread Simon J Mudd
[EMAIL PROTECTED] ("Carl") writes: > I am running 5.0.24a on Slackware Linux. I would like to set up a > master-master replication process so that I can use both servers as master as > add/delete/update records on both servers from different application servers > (Tomcat.) I suspect the inser

Re: DB Crash: Wrong bytesec: 0- 0- 0 at 0;

2008-10-09 Thread Oto Buchta
On Wed, Oct 08, 2008 at 06:43:46PM -0400, Michael Dykman wrote: > Assuming all of these databases reside on the same filesystem, it > looks to me like your disk is failing. Do you have backups you can > restore from? YOu might wnt to swp out your disks for new hardware > before you try. I know t