You can try with MySQL-Front. It has a very handy tool (Extras-Transfer) you can use for the task or You can copy the files in MySQL's data directory, I've done it befor and it works fine (remember to check and repair the table before using it in the new server) I hope that helps. Fernando Murrieta On 2/12/07, ~Tarun~ <tarun.virgo@xxxxxxxxx> wrote: > > Hello Mike, > > i tried to make a php script which used to fetch data in array from one server and then i saved the value in variable.. > > then i inserted the value in the INSERT values script to another database . > that worked but the problem was that it does not copy blob part. > > even i tried one more option i.e. CREATE TABLE db2.table_name SELECT * FROM db1.table_name , this script too worked but didnt copied the data contain in tables ....just created table, but if i try tihs same create table for same server than it works out but not for diff database and usernames. > > Please suggest further. > > or if u can provide me a script that can help me out. by some php script > > Regards > > Tarun > > ----- Original Message ----- > From: Mike Johnston > To: php-objects@xxxxxxxxxxxxxxx > > Sent: Monday, February 12, 2007 6:46 PM > Subject: RE: copy database from one server to another > > You can try phpdump. > I generates a SQL file than can be used as a script on the > second server. > Mike J. > > -----Original Message----- > From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx]On > Behalf Of Tarun > Sent: Friday, February 09, 2007 11:08 AM > To: php-objects@xxxxxxxxxxxxxxx > Subject: copy database from one server to another > > Dear sir. > > i have a problem that i have database stored on my internet server in > mysql. > > I am trying to copy that database to another site. I have control over > both the sites. > > i am getting problem to copy data between diff servers. i.e. i want to > copy data from one server and transfer it to another server. > > when i copy it gets possible for general character fields but it is > not getting physible for BLOB fields. > > please help to solve out this problem > > Warm Regards > > Tarun Agarwal > >
