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