After getting table replication to work by including the USE database on the
creation scripts, I have run into a rather large problem. We have 5 databases
on the server which get replicated to another server. We call them databases,
A, B, C, D, and E. we have two other databases F and G which
> -Original Message-
> From: Gary Smith
> Sent: Friday, July 10, 2009 5:26 PM
> To: Gary Smith; mysql@lists.mysql.com
> Subject: RE: Crazy replication problem
>
> One quick follow up note:
>
> In the top of the big script, I'm doing:
>
> CREATE DATABASE x;
> CREATE TABLE x.whatever (..
One quick follow up note:
In the top of the big script, I'm doing:
CREATE DATABASE x;
CREATE TABLE x.whatever (...);
Reading into the various bug reports, do I need to issue a USE x; ? I'm
assuming that MySql isn't picking up the replica because there is no current
database specified, even th
Here is steps take to get to the problem. Version is 5.1.35
To be on the safe side, I did this prior to executing the scripts. I deleted
the mysql directory and the mysql-log directory, recreated them, chowned them,
ran mysql_install_db, chowned them again. So, I know at least I'm working wit
> -Original Message-
> From: russbucket [mailto:russbuc...@nwi.net]
> Sent: Friday, July 10, 2009 11:09 AM
> To: mysql@lists.mysql.com
> Subject: MySQL Windows version
>
> I have been using the Linux version of MySQL for five years, also used
> it on
> a Windows ME system even though doc
This is more of an application architecture question than a mysql question.
Though I'll offer my two cents:
What are you going to do with the XML file? Write it to disk, so you can later
read it, and parse it just to get your result set back? That sounds a lot
slower than fetching it from my
Chris;
From my understanding of your question, your message (included
below in its entirety) is better sent to the MySQL General list, which
I've CC'd on this reply. If you haven't yet, please subscribe there
at mysql-subscr...@lists.mysql.com to follow the thread for responses.
If I
On 10 Jul 2009, at 17:18, mos wrote:
Is there a Windows application that works like
phpMyAdmin? I tried MySQLAdmin on my Linux system, but I could not
cut and
paste SQL Commands into the editor.
You could run php (and thus phpmyadmin) on windows - in contrast with
earlier versions, 5.3 is
At 11:08 AM 7/10/2009, russbucket wrote:
I have been using the Linux version of MySQL for five years, also used it on
a Windows ME system even though documents said you couldn't. Recent a friend
asked me to help him get it up and running on a Windows Vista system.
I was looking for the system co
I have been using the Linux version of MySQL for five years, also used it on
a Windows ME system even though documents said you couldn't. Recent a friend
asked me to help him get it up and running on a Windows Vista system.
I was looking for the system configuration requirements but could not fi
On 10 Jul 2009, at 03:44, sangprabv wrote:
SELECT count(sql_id) AS total, DATE_FORMAT(insertdate, '%H:%i' ) AS
mydate FROM momt WHERE 1=1 AND insertdate BETWEEN DATE_ADD(NOW(),
INTERVAL - 1 HOUR) AND NOW() AND (sms_type = 1 OR sms_type =2) GROUP
BY
mydate ORDER BY insertdate
Firstly do an
11 matches
Mail list logo
