> > > > 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! > > 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]