Dear Jay,
1st possibility:
a) mysqldump --all-databases > all_that_dump.sql
b) FTP all_that_dump.sql to remote machine
c) [on remote machine:] mysql < all_that_dump.sql
2nd possibility: Like above, but using PhpMyAdmin (www.phpmyadmin.com)
for writing to (a) and reading from (c) dump file. You won't have to ftp
the dump file as you can read it from the local machine.
3rd possibility: ftp the database directories from local to remote
machine. You need to have MyISAM tables (extensions: .MYI and .MYD), not
ISAM tables if there are different operating systems on those two
machines. Datadir for all databases is usually /var/lib/mysql on Linux
machines and C:\mysql\data on Windows machines.
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
----- Original Message -----
From: "Jay McGarry" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 25, 2001 4:57 PM
Subject: Mysql
> what's the easiest way to transfer a local database to a remote one?
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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
