NYCPHP Meetup

NYPHP.org

[nycphp-talk] moving MySQL Tables

Daniel Convissor danielc at analysisandsolutions.com
Fri Feb 27 11:46:49 EST 2004


Hi Chris:

On Fri, Feb 27, 2004 at 11:39:36AM -0500, Chris Bielanski wrote:
> 
> I'm stumped on getting a MySQL table moved from one server to another. I was
> under the (possibly false) impression that it's pretty much a straight copy.
> Am I incorrect? I copied over the data folder and all the files contained
> therein, bounced mysql on the new machine (both are W2K).

Were both servers off when you did the move?  Are they both the same 
version of MySQL?

Regardless, it seems safer to me to use mysqldump rather than doing file 
copies.

--Dan

-- 
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
            data intensive web and database programming
                http://www.AnalysisAndSolutions.com/
 4015 7th Ave #4, Brooklyn NY 11232  v: 718-854-0335 f: 718-854-0409



More information about the talk mailing list