Hi Tarun, I would suggest changing to bash or csh and doing it at that level. Did you look up phpdump? Mike J. -----Original Message----- From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx]On Behalf Of ~Tarun~ Sent: Monday, February 12, 2007 6:47 AM To: php-objects@xxxxxxxxxxxxxxx Subject: Re: copy database from one server to another 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
