3 messages in com.mysql.lists.mysqlRe: Moving MySQL database(s)
FromSent OnAttachments
Graham Nichols05 Apr 2001 09:06 
Roel Vanhout05 Apr 2001 09:42 
Steve Werby05 Apr 2001 09:53 
Subject:Re: Moving MySQL database(s)
From:Roel Vanhout (ro@2e-systems.com)
Date:04/05/2001 09:42:44 AM
List:com.mysql.lists.mysql

$ mysqladmin -u<username> -p<username> create <databasename>

and then

$ mysqldump -h<yourmachine> -u<user> -p<password> <databasename> | mysql
-h<remotehost> -u<user> -p<password> <databasename>

or

$ mysqldump -h<yourmachine> -u<user> -p<password> <databasename> > dbdump.sql

<copy file to remote server, login to that server>

$ mysql -u<user> -p<password> <databasename> < dbdump.sql

cheers,

roel

On Thu, Apr 05, 2001 at 05:06:24PM +0100, Graham Nichols wrote:

I've developed my mysql databases/tables on a local intranet server. What's involved in correctly copying them to an online linux machine please?