MySQL Forums
Forum List  »  MySQL Administrator

Re: How to copy a database from 1 website to another
Posted by: Scott Nemes
Date: January 23, 2012 05:32PM

Use 'mysqldump' with the '--no-data' parameter to dump the schema without the data, and then run it against the second MySQL server.

http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html

--
Scott Nemes
MySQL DBA

http://www.linkedin.com/in/scottnemes
http://www.twitter.com/ScottNemes

Options: ReplyQuote


Subject
Written By
Posted
Re: How to copy a database from 1 website to another
January 23, 2012 05:32PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.