How do you move MySQL database to different server?

**psili** · 02-07-2006, 12: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

**Mr Pheer** · 02-07-2006, 01:02 PM

thanks man!

**Mr Pheer** · 02-07-2006, 02:52 PM

ok the importing does not work

anyone else know how to import the database on FreeBSD?

**Brujah** · 02-07-2006, 02:56 PM

That should be pretty flawless. Do you get an error ? Does it just not create the tables ? Is the mysql version different ? You may need a compatibility switch.

**Mr Pheer** · 02-07-2006, 03:04 PM

actually this works:
mysql -u admin -ppassword -D dbase < db.dbase.sql

**X37375787** · 02-07-2006, 03:30 PM

check the vBulletin documentation, it's described in detail how to move it.

P.S. I suggest you redirect the old server's traffic to the new IP immediately, before the DNS resolves to the new server.

**uno** · 02-07-2006, 03:34 PM

Use phpMyAdmin to dump the db to an sql file, then import it on the new server.

http://sourceforge.net/projects/phpmyadmin/

Easy as pie.

**xroach** · 02-07-2006, 03:34 PM

(approx)

cd /var/db/mysql/$dbname
tar cf $dbname.tar $dbname
scp $dbname.tar root@$targethost:/$targdir
ssh -l root $targethost
cd /var/db/mysql
tar xzvf <targdir>/<dbname>.tar
chown -R mysql:mysql <dbname>

**uno** · 02-07-2006, 03:35 PM

If you need help drop me an icq.

How do you move MySQL database to different server?

How do you move MySQL database to different server?

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment