Hi, Try to zip/gzip the database dump (SQL file), how is the size? Usually zip/gzip can reduce the file onto 10-50% of the real size. And then upload it (the zip/gzip file). phpmyadmin can handle compressed file. If your phpmyadmin can't detected compressed file, maybe you must download newest phpmyadmin. Oh yeah, if you can't access phpmyadmin from your server configuration (ex. cpanel), why you don't install it by yourself? :). I do that, so my client (which, of course, can't access my hosting cpanel) can reach the database by phpmyadmin. LuckyGuy354 IT Beginner http://www.wiwid.org ----- Original Message ----- From: "~Tarun~" <tarun.virgo@xxxxxxxxx> To: <php-objects@xxxxxxxxxxxxxxx> Sent: Saturday, February 17, 2007 11:05 AM Subject: Re: copy database from one server to another > Hello Caprecerevisi2005 > > > Thanks for taking interest in my problem. > > But my problem is that i am not able to upload the database due to big > size i.e. 150 mb. I hope u know what is 150 MB database. Where it has just > 4 tables, and the phpmyadmin allows only 56 mb to get upload. > > in these 4 tables one table is 90 mb. > now i have problem in tranferring that one table. > > if you can solve this problem with help of some php coding i will really > appreciate your help and kindness. > > My server admin is not helping me out,. in my view i have to change the > server but i cannot do this right now. it will take some times for me to > shift the whole site. > That is a self developed site , but the fault happened when my client > addded too much images in that,. because the images are saved in BLOB. > > Now i have to solve this problem buddy. > > please if you can solve this i will be really really thankful. > > Regards > > Tarun
