> > > > Are there any standard MySQL tools available for doing that (I mean > > > MySQL > > > > Administrator/Query Browser etc.) > > Have you looked at mysqldump and mysqlhotcopy?
I know about standard mysqldump utility but I actually needed something with GUI interface. > > 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! > > That is exactly what mysqldump does for you. Yes, but again it has no GUI. > > > I haven't used MySQL Replication but I know it exists and is > documented in > > > the MySQL manual. > > Replication would be a possible solution if you needed to keep the two > databases in synch. Since this is only a periodic update, replication is > probably overkill for this issue. Agree. > I seriously think you should check out mysqldump. For one-off or > infrequent transfers, I think it works just fine. Especially since you > already said that you think that writing the schema and data to a SQL file > was a preferable idea.... Yes, it is also a good idea because there is phpMyAdmin installed on the remote server, so I can just run this SQL file with it. > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
