Tim, > I have several databases currently located on my local machine that I need > to copy to a remote server.
You can dump the contents of your databases with mysqldump, and load those contents on your other server, using the mysql client program or another tool like phpMyAdmin. You can even combine that, e.g.: shell> mysqldump --host=localhost --all-databases | mysql --host=remotehost Note that you may have to specify a number of other options, like username and password (on both sides), and options like --add-drop-table if you want to overwrite existing tables on your remote server. Please check out http://www.mysql.com/doc/en/mysqldump.html which lists all the available options to mysqldump (don't panic, you'll need only a few of those!). Moreover, that page has some good examples how to use mysqldump (also in combination with mysql). Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
