Last Updated: February 25, 2016
·
318
· netors

Quick MySQL database server migration

#mysql

backup:

mysqldump -h server1.domain.com -u root -p database > backup.sql

restore:

mysql -h server2.domain.com -u root -p database < backup.sql
#mysql

Written by Marduk

Say Thanks
Respond

Related protips

Uninstall all those broken versions of MySQL and re-install it with Brew on Mac Mavericks

330K
46

Splitting Strings with MySQL

316.6K
0

SOLVED: Can't connect to local mySQL server through socket /tmp/mysql.sock

122.1K
9

Have a fresh tip? Share with Coderwall community!

Post
Post a tip
Best #Mysql Authors
corysimmons
329.9K
#mysql
#HTML
#CSS
fstrube
316.5K
#mysql
#PHP
#Linux
timfernihough
129.9K
#mysql
#mamp
#unix
nicolaskempfpro
108.5K
#mysql
#javascript
#HTML
groodt
84.46K
#mysql
#Python
#Open Source
Related Tags
#mysql
Sponsored by
#native_company#
#native_desc#
#native_cta#
Awesome Job
See All Jobs
Post a job for only $299
Thanks to our sponsor
Sponsored by #native_company# — Learn More
#native_title# #native_desc#
#native_cta#