Hi,
another backup related question
I have a 90Mb forum database and the messages table take up most space, naturally.
When i started the board I used the mysqldump command , but as my database grew I had to 'pipe' it right into a gz-file otherwise I would conflict with settings from the provider.
Now my database has become so large that even this 'piping' trick no longer seems to work.
So I had a look at the lastest edition of PhpMyAdmin that allows you to export your database.
This also resulted in some problems:
- i edited the IIS-setting (working from W2K environment) concerning cgi timeout problems and
- i have edited the php.ini file concerning the timeout settings.
Now i'm faced with another problem: after 8Mb of exporting through PhpMyAdmin it stops and the last line of the created file says:
<b>Fatal error</b>: Maximum execution time of 300 seconds exceeded in <b>d:\inetpub\wwwroot\phpMyAdmin2\libraries\mysql_wrappers.lib.php</b> on line <b>124</b><br />
php.ini looks like this:
max_execution_time = 300000
max_input_time = 240
memory_limit = 400M
Anyone any ideas??