$ 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?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
