Last Updated: February 25, 2016
·
297
· 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

323.9K
47

Splitting Strings with MySQL

315K
0

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

121.3K
9

Have a fresh tip? Share with Coderwall community!

Post
Post a tip
Best #Mysql Authors
corysimmons
322.3K
#mysql
#HTML
#CSS
fstrube
314.4K
#mysql
#PHP
#Linux
timfernihough
128.6K
#mysql
#mamp
#unix
nicolaskempfpro
107.6K
#mysql
#javascript
#HTML
moezzie
76.96K
#mysql
#Shell
#PHP
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#