Copying a mysql database using a network transfer

You can copy a mysql database to another server using the following command:

mysqldump –opt –database mydatabase | mysql -h database.otherdomain.com

This will make a copy of mydatabase on the server named database.otherdomain.com

For more information or tech support on MySQL call us at 410-838-5100 or email us at experts@expertsinunix.com Skype: pts.support

 
copying_a_mysql_database_using_a_network_transfer.txt · Last modified: 2010/08/23 10:31 by admin
 
Recent changes RSS feed Creative Commons License Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki