Downloading Mysql Database

[Missfostret_Tellus]

How to backup a huge database that time out in Phpmyadmin.
I don't wan to run some putty ssh shit on linux through a console. I want a simple tool for windows with an GUI.
Is it possible to Upload a php-script via that downloads the DB to the ftp-server for later retrieval?

[Martin Allen]

What I did for the old forum was to download 10,000 rows at a time from the largest table. As it would not work any other way.

[Missfostret_Tellus]

Yes, but we are talking about a huge database here, not just a few hundred megabytes.
It has to be automated somehow.

[voidSkipper]

If it's timing out on the script that is converting the rows to text, you can temporarily hack around it by putting a line in the loop in phpmyadmin that affects the timeout counter of php.ini. This will cause the running timer to reset and prevent the script ever timing out.

Obviously you'll want to remove it afterwards.

The last time I used this method was in order to parse a very large json feed (120mb), and the specific line of code I used was "ini_set('max_execution_time', 3600);" where 3600 was the current execution time in my php.ini, at the end of the while loop that was traversing the feed.

[Missfostret_Tellus]

Freespace, I don't have access to the php.ini files nor the Phpmyadmin files.
I just have access to phpmyadmin through the Hosting company.

[voidSkipper]

Oh yuck, shared hosting.

I have never really dealt with a hosting environment where I didn't have access to the timeout, but this article seems to have some pointers. It would be really easy if you can get SSH access, but if you can't you might have to look into those migration scripts it mentions.

EDIT: Yeah, didn't read that you didn't want to fiddle with SSH. This looks promising.

[Missfostret_Tellus]

That looks promising. I'll try it. Thanks.