Re: Moving MySQL database(s)

2001-04-05 Thread Steve Werby
"Graham Nichols" <[EMAIL PROTECTED]> 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 Stop the mysql server on the intranet and FTP the files in the MySQL data directory to the MySQL data directory

Re: Moving MySQL database(s)

2001-04-05 Thread Roel Vanhout
$ mysqladmin -u -p create and then $ mysqldump -h -u -p | mysql -h -u -p or $ mysqldump -h -u -p > dbdump.sql $ mysql -u -p < 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 ser