SEO

#1 (**permalink**) 04-29-2008, 08:28 PM

Hi,

Does anybody know how to copy records from one mysql-database to
another on another server?
I use PHP and mySQL.

Regards.
MD

#2 (**permalink**) 04-29-2008, 08:28 PM

On Sun, 27 Apr 2008 14:29:41 -0700 (PDT), weer1@gmx.net wrote:
> Hi,
>
> Does anybody know how to copy records from one mysql-database to
> another on another server?
> I use PHP and mySQL.

Very easy then. Open two database connections, select a set of data from
one, and while you loop through the rows of results, generate inserts
over the other connection.

--
The greatest dangers to liberty lurk in insidious encroachment by men of
zeal, well-meaning but without understanding. -Justice Louis D. Brandeis

#3 (**permalink**) 04-29-2008, 08:28 PM

weer1@gmx.net wrote:
> Hi,
>
> Does anybody know how to copy records from one mysql-database to
> another on another server?
> I use PHP and mySQL.
>
> Regards.
> MD
>

I wouldn't even bother with PHP. Just dump the table(s) on the first
server with mysqldump, upload the file to the new server and use the
mysql command line utility ("source" command) to add the data to the new
database.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

#4 (**permalink**) 04-29-2008, 08:28 PM

Thanks all.
I open the connections just before te right database-actions now, with
functions. Functions in wich the connection-info resides.
This because keeping 2 connections open didn't work.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Query 2 databases cross-server