I have similar (not identical) tables in two different db's. I want to
merge all the data from one into the other, and will be dropping the
original. There will be some duplication of keys so some rows will
need to be ignored. Problem is these are on two different servers on
different machines. How's the easiest way to handle this?

OK, I have all my data on the new machine in a SQL file with 664,000
insert statements. But when I try to run it like this from the mysql
command line:

source filename.sql;

It starts to work, but after a few seconds the server freezes up with
"too many connections". How do I avoid this?

Hi Brian

tough to say without looking at the script
http://www.php.net/function.mysql-connect
suggests allowing the current thread to sleep a bit to wait for the resource
to become available

M--
----- Original Message -----
Wrom: CLBDXRQBGJSNBOHMKHJYFMYXOEAIJJPHSCRTNHGS
To: <mysql@lists.mysql.com>
Sent: Wednesday, December 12, 2007 5:18 PM
Subject: Re: Move data from one db to another?


> OK, I have all my data on the new machine in a SQL file with 664,000
> insert statements. But when I try to run it like this from the mysql
> command line:
>
> source filename.sql;
>
> It starts to work, but after a few seconds the server freezes up with
> "too many connections". How do I avoid this?
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=mgainty@hotmail.com
>
>