Nevermind -- it's working absolutely perfectly between 5.5.8 and 4.1.x.
Thanks again for the push.
-Hank
On Tue, Jan 4, 2011 at 5:14 PM, Hank wrote:
>
> Also, can I do this:
>
> insert into federated_table select * from local_table?
>
> -Hank
>
>
> On Tue, Jan 4, 2011 at 4:15 PM, Shawn Green
Also, can I do this:
insert into federated_table select * from local_table?
-Hank
On Tue, Jan 4, 2011 at 4:15 PM, Shawn Green (MySQL) <
shawn.l.gr...@oracle.com> wrote:
> On 1/4/2011 15:53, Hank wrote:
>
>> Hello,
>>
>>I have a background process that runs as a combination of PHP&MySQL.
>>
Wow, that might just work! I've seen "Federated" tables mentioned about,
but I never knew that's what they are here for.. thanks.
Can I have a host (remote) table on a MySQL 4.1.x server, and the federated
table on a 5.5.8 server?
-Hank
On Tue, Jan 4, 2011 at 4:15 PM, Shawn Green (MySQL) <
s
On 1/4/2011 15:53, Hank wrote:
Hello,
I have a background process that runs as a combination of PHP&MySQL. The
end results are records in a table on server #1 (but not the entire table,
just a small subset of the table needs to move). What's the
easiest/cleanest way of moving those records
Hello,
I have a background process that runs as a combination of PHP&MySQL. The
end results are records in a table on server #1 (but not the entire table,
just a small subset of the table needs to move). What's the
easiest/cleanest way of moving those records to an identical table on
another
I'm currently evaluating ways to increase our online storage capacity for our
DB engine. The current winner is a massive external SAN/disk array.
However, I'm wondering how MySQL will handle failover when it comes to InnoDB
tablespaces.
The current plan, based on the disk array, is to have ea
Hello,
I did a mysql dump of a database between two servers we have using the
following command:
mysqldump --opt -u --password= | mysql
--host= -C -u
--password=
This command seemed to run ok as it transferred all the structure and data
from the original server to the new server database
I suspect this is more of a unix question (OS X 10.3.3) than a mysql
question, but hopefully someone will tolerate it.
I have two mysql apps running on the same machine. A mysql 3.23.x on
port 14551 (which is integral to the Lasso middleware server), and a
separate mysql 4.0.x on 3306.
They ha
I am looking into installing 2 mysql servers on the same windows 2000
PC. From what I have found, it is usually possible to have 2 different
versions on the same machine. (Usually one for testing and the other for
production). However, I am trying to run 2 production servers, one for
personal famil
Hi
Why would you need two servers running when you could just have
separate databases?? Is there a reason why these two cannot share?? Mike
- Original Message -
From: "Ola Ogunneye" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: August 7, 2003 8:46 A
To: "MySQL LIST" <[EMAIL PROTECTED]>
Sent: Tuesday, July 22, 2003 10:45 PM
Subject: Re: Two Servers on Windows and my.cnf/my.ini groups
>
> Yes, that's the problem.
> Until now I started the two servers from the command line/batch
file/service
> and each server had its ow
Yes, that's the problem.
Until now I started the two servers from the command line/batch file/service
and each server had its own my.ini. The two servers are in replication: one
master and another slave. Two days ago I read that I can use a unique my.ini
for the both servers; and MySQ
At 20:12 +0300 7/22/03, Primaria Falticeni wrote:
Hello and thank you for the info,
As I said earlier, I already did the other ways of starting multiple
servers.
But from these docs I lived with the idea that one/unique my.cnf is able to
start two servers on Windows.
Must I see that two
Hello and thank you for the info,
As I said earlier, I already did the other ways of starting multiple
servers.
But from these docs I lived with the idea that one/unique my.cnf is able to
start two servers on Windows.
Must I see that two configuration files is needed?
Iulian
- Original
At 19:37 +0300 7/22/03, Primaria Falticeni wrote:
Hello,
I run two MySQL servers on Windows with the two services.
I read in the docs that it exists a way to identify the servers in my.cnf by
groups and about a tool from Linux to manage the groups.
How can I start a server on Windows through the m
Hello,
I run two MySQL servers on Windows with the two services.
I read in the docs that it exists a way to identify the servers in my.cnf by
groups and about a tool from Linux to manage the groups.
How can I start a server on Windows through the my.cnf/my.ini 's groups?
Thanks Anticipated,
Iuli
Hi all,
I have two servers on the same machine (Windows 2000).
In the file my.ini i need to write new group for mysqld2.
1) Do i need to change the name of mysqld itself (to mysqld2)?
2) On Windows, is it enough that the port will be different between the
servers, or there is something else need
Everyone,
Im just curious if possible, I had two MySQL server...one is the replica of
the master server. And to make the database in safe and intact even if
there's a hang-up. I use auto back-up using the MySQL dump program. But if
master server is downed. All I do is redirect my front-end applic
Have you checked the network connection? You should be running at
full-duplex so you don't get collisions. But more importantly, make sure you
aren't getting errors on the line. A poor crimp or pinched wire could really
slow things down, especially if you try running at 100MB.
Try copying a single
Backgroud:
We have a process that runs on a server (APPDEV1) that writes records to a
mysql server (SQLDEV0). We attempted to move the databases from SQLDEV0 to
SQLDEV1 and have run into some sort of performance bottleneck. The server
SQLDEV0 is a Compac server with ~2GB of ram and two processors
On Tue, Apr 02, 2002 at 11:07:43PM -0800, Scott Broderick wrote:
> Does anyone know of a good place to start looking at how to mirror a
> MySQL database on two different computers?
Lookup REPLICATION in the on-line manual:
http://www.mysql.com/doc/
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTE
t;/usr/local/bin/mysqldump -u
> $localuser --password=$localpass --add-drop-table $localdatabase $localtable
> | /usr/local/bin/mysql5:32 PM
> 4/3/2002--user=$remoteuser --password=$remotepass --host=$remotehost
> $remotedatabase");
>
>
> - Original Message -
>
password=$localpass --add-drop-table $localdatabase $localtable
| /usr/local/bin/mysql5:32 PM
4/3/2002--user=$remoteuser --password=$remotepass --host=$remotehost
$remotedatabase");
- Original Message -
From: Scott Broderick
To: [EMAIL PROTECTED]
Sent: Wednesday, April 03, 2002 5:07
Does anyone know of a good place to start looking at how to mirror a MySQL
database on two different computers?
Any help would be great, Thanks
Scott
-
Before posting, please check:
http://www.mysql.com/manual.php (the
when you run mysqld, use:
/path/to/one/mysqld --bind-address=10.0.0.10
/path/to/two/mysqld --bind-address=10.0.0.11
Guillaume Monfort wrote:
>
> Hello there,
>
> i would run two distinct mysql servers on the same
> computer. i know it's possible using 2 differents ports
> but it's not what i w
Hello there,
i would run two distinct mysql servers on the same
computer. i know it's possible using 2 differents ports
but it's not what i want. the point is that i have 2 interfaces
(2 IP's) and i wish to run on instance of mysql binded to
say 10.0.0.10 and the other on to 10.0.0.11
of course,
ass a hostname other than localhost, you'll connect
through the Unix socket.
> My question is basically thisdid I somehow (probably in my first
> lame attempts) get some of my socket files mixed up and/or pid files and
> they were simply out of sync with the proper server
ng connection problems. I was able to repeat this
several times.
My question is basically thisdid I somehow (probably in my first lame
attempts) get some of my socket files mixed up and/or pid files and they
were simply out of sync with the proper server?2) Should I be able to
prop
28 matches
Mail list logo
