On 2/20/07, ~Tarun~ <tarun.virgo@xxxxxxxxx> wrote: > > > hii there, > > actually i was in an idea of developing a script in php , which connects both the databases, and transfers the data from one database to another. > > taking backups of database scripts are available, but the problem occurs when uploading back if the item is too heavy. > > can u give me some idea for fetching the blob objects, and saving it in variable. and then transferring it to another DB. > > because if we run the same from some php script it can definately make a copy of one database to another in jsut a few seconds. > > because the size of variable is limited and blob can be of large size. > > Regards > > Tarun Backup data partially (use LIMIT). And continue to the end. -- -husain-