View Single Post

   
  #3 (permalink)  
Old 04-29-2008, 08:28 PM
Jerry Stuckle
 
Posts: n/a
Default Re: Query 2 databases cross-server

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
==================

Reply With Quote