"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 on the destination machine.
OR
While the mysql server is still running, use "mysqldump" to create a dump
file of SQL command that can be piped to MySQL to recreate the tables, then
FTP them to the destination machine and pipe the dump files to MySQL.
Search the list archives and manual for more info. This has been covered a
lot.
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/
---------------------------------------------------------------------
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
