"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
$ 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