Archived Boards and Threads... > SMF Feedback and Discussion

Question: Will there be a backup database feature

<< < (4/4)

dschwab9:

--- Quote from: [Unknown] on August 10, 2003, 05:14:16 PM ---If I saw that in Windows:

"Dump Windows"

I would freak out and get scared of that stupid button.

--- End quote ---

I think pushing it would be a great idea   ;D

NV:
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:


--- Quote ---<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 />
--- End quote ---

php.ini looks like this:
max_execution_time = 300000
max_input_time = 240
memory_limit = 400M

Anyone any ideas??

Compuart:
Large databases are indeed a pain to backup. For my own databases I made a tool that splits up the dump into chunks based on an execution time threshold. I might be able to convert it to the SMF [/s]dump[/s]backup database function.

Navigation

[0] Message Index

[*] Previous page