GoFuckYourself.com - Adult Webmaster Forum - View Single Post - How do you move MySQL database to different server?

psili · 02-07-2006, 02:59 PM

server1>mysqldump --user=root --pass=pass --opt database > db.backup.sql
server1>sftp db.backup.sql server2.com

create the empty database on server 2

server2>mysql -u root -ppass database < db.backup.sql

i'm sure there's easier ways, but that's one of them in a nutshell

02-07-2006, 02:59 PM
psili Confirmed User Join Date: Apr 2003 Location: Loveland, CO Posts: 5,526	server1>mysqldump --user=root --pass=pass --opt database > db.backup.sql server1>sftp db.backup.sql server2.com create the empty database on server 2 server2>mysql -u root -ppass database < db.backup.sql i'm sure there's easier ways, but that's one of them in a nutshell __________________ Your post count means nothing.