MySQL Forums
Forum List  »  Other Migration

Re: Moving table structures from dev server to production....
Posted by: pearsojd
Date: July 21, 2004 10:45AM

Hi AA,

One option would be to use mysqldump;

shell>mysqldump [options] > database_dump.sql
shell>mysql [options] --host=production_server < database_dump.sql

or through a pipe;

shell>mysqldump [options] | mysql --host=production_server [options]

Options can vary so check out the mysqldump manual pages, and of course you will probably need to specifiy connection details (username, password etc).

James

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Moving table structures from dev server to production....
2336
July 21, 2004 10:45AM


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.