On Wed, 30 Mar 2005, Denis Gerasimov wrote: > >> > >> > Hello list, >> > >> > I have two MySQL 4.1 servers, one local and one remote. I need to >> transfer >> > database from one server to another. What actually is the best way of >> > handling this task? >> > >> > Are there any standard MySQL tools available for doing that (I mean >> MySQL >> > Administrator/Query Browser etc.) >> > >> It's not clear from your question whether you want to transfer the data >> once >> only or if you want to transfer it repeatedly, perhaps daily or weekly. If >> you mean the latter, you may want to look into MySQL Replication, which >> enables all the changes made to the data on one server to be automatically >> made to the other server as well. > >Well, I need this only time to time, just for transferring data when I need. > > >I assume that that is a bad idea to copy db files from one server to >another. mysqldump is not an exciting option too... > >But there is a simple solution when using MySQL Administrator: make backup >of desired data to SQL file, then connect to another server and restore it!
The perl package 'mysqlhotcopy' looks good. I didn't try it yet. > >> >> I haven't used MySQL Replication but I know it exists and is documented in >> the MySQL manual. >> >> Rhino >> >> >> >> -- >> No virus found in this outgoing message. >> Checked by AVG Anti-Virus. >> Version: 7.0.308 / Virus Database: 266.8.3 - Release Date: 25/03/2005 >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]