By wellsy on

The problem I am having is this.

I am trying to move my site to a new host and at the same time upgrade to 4.7.0 (when it is ready)
I have a 14mb database which is hell to transfer reliably via phpMyAdmin.

I do not have Telnet/SSH access to my webserver.
The techs at the new host will however load database for me if asked but I would like to somehow get around that.

Is it possible to use some mySQL magic to "synchronize" two remote databases?

Does anyone know if some third party software is available to do that?
Can drupal do that?

Also how do I duplicate a database on the same server?
The update process to 4.7.0 beta2 nuked the last 2 databases I managed to migrate to a new location and I really do not wish to do the same with the current one.

Thanks in advance for any help!
wellsy

www.orchidsonline.com.au

⋅ Categories: Drupal 4.6.x

Comments

markus_petrux’s picture

markus_petrux commented

http://www.ozerov.de/bigdump.php

Doubt is the beginning, not the end of wisdom.

wellsy’s picture

wellsy commented

I will give that a go and report back here if it is the answer for me

wellsy

orchidsonline.com.au

wellsy’s picture

wellsy commented

that is the best and easiest to use free software I have seen for quite some time. (Apart from drupal)

The one and only problem encountered was when it found a problem in a table (node_geo) where the field "long" is misinterpreted by mySQL as a "type" not a field name.

That problem was gotten around and all went flawlessley.

Oh for others info....you do need to go to phpMyAdmin and "Drop" all the tables created up to the error so the bigDump script does not complain that the tables already exist.

Thanks again to markus_petrux... a spot on solution!

Maybe this should be documented in the handbook?

wellsy

orchidsonline.com.au

reikiman’s picture

reikiman commented

In my case I have my own server, and have ssh access. So what I do is

mysqldump [params] dbname | mysql [params] newdbname

The "params" in each case identify the host/user/password of the two database connections.

But the navicat client application also has a database copy function. The problem is using navicat you're copying the database through your computer, so the data has to come into your computer, through your internet connection, and then navicat sends that same data back to the other database, again through your internet connection.

I have the Mac version of navicat, but I think they also support windoze.

- David Herron - http://7gen.com/

+ David Herron - 7gen.com/, The Long Tail Pipe, davidherron.com/drupal-blogging-hints

paschalia’s picture

paschalia commented

Does anyone know how synchronize two database with C#.Net?