4 messages in com.mysql.lists.win32Re: Copy Table From One DB To Another
FromSent OnAttachments
Michael Avila15 Dec 2005 19:13 
SGr...@unimin.com15 Dec 2005 22:18 
Joelle Tegwen19 Dec 2005 07:31 
Annemarie Mayer-Retar22 Dec 2005 08:08 
Subject:Re: Copy Table From One DB To Another
From:Joelle Tegwen (tegw@umn.edu)
Date:12/19/2005 07:31:58 AM
List:com.mysql.lists.win32

I am coming up on a similar conundrum except I will need to move data from our test server to our production server (different machines, different instances of MySQL, the whole bit) My current plan is to write a web script that will do all of the changes, but this got me thinking. Is there a way to do that within MySQL?

Joelle

Michael Avila wrote:

What is the quickest way to copy each record of a table from one DB to another? I have a production database that I want to put on a website and (in most cases) I want to copy the whole record from prod to web.

Is the fastest way to save it to a file and then use the utility to load the table or is there a faster way?

Thanks.

------------------------------------------------------------------------