Re: couldnt backup database

On Tuesday 21 December 2004 07:44, Sagar C Nannapaneni wrote: > I've a table in my database with 1 lakh records using a disk space of > around 50Mb. I wanted to download the records. I used phpmyadmin (coz my > hosting provider doesnt allow remote access to my db) to export the > database but its not working for larger databases. I thought that it might > be a problem with the max execution time. So i thought i wud manually store > the records in a text file so that i can download it. But when i tried that > its not creating the file beyond 10Mb. And what error do you get? > I've tried these things out.. > > ini_set ( max_execution_time, "300"); The quotes go around the first parameter, the second parameter being an integer does not need quotes. > ini_set ( mssql.connect_timeout, "300"); mssql == M$ SQL Server !== MySQL > ini_set ( memory_limit, "5000000"); > > but not working.... > > can anyone help me out with this problem.. If you have access to the shell then using mysqldump would be a far quicker and more robust solution. Otherwise try breaking your backup into smaller chunks. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general ------------------------------------------ /* With a rubber duck, one's never alone. -- "The Hitchhiker's Guide to the Galaxy" */