Re: copying MySQL databases

You should use the mysqldump program that ships with mysql. Something like this: mysqldump -u root database_name > text_file.sql Then load it up on another server like this: mysql -u root < text_file.sql -jeremy brand Jeremy Brand :: Sr. Software Engineer :: 408-245-9058 :: jeremy@nirvani.net http://www.JeremyBrand.com/Jeremy/Brand/Jeremy_Brand.html for more - - - - - - - - - - - - - - - - - - - - - - - - - I am pleased to see that we have differences. May we together become greater than the sum of both of us. -- Surak of Vulcan, "The Savage Curtain", stardate 5906.4 On Sun, 26 Nov 2000, David P. Schwartz wrote: > Date: Sun, 26 Nov 2000 02:10:58 -0700 > From: David P. Schwartz <davids@desertigloo.com> > To: php-general@lists.php.net > Subject: [PHP] copying MySQL databases > > I've been developing an application on a localized server. I've got the PHP > scripts working pretty solidly and the MySQL database ok. Now I want to be able > to duplicate it on another server. > > Copying the scripts and directory structure is a piece of cake, but the database > structures are another thing. (I don't need the data, just the tables and > indices in the database.) > > Does anybody have any recommendations on tools to accomplish a copy of a MySQL > database from one server to another? > > Thanks > -David > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >