backup disappear

[ahmedhoukry]

Dear All

whenever i do a backup to my database using the backup utiliy in phpadmin

 

after a couple of days , my backup doesnt show in the "import" tab

 

and i also had a backup file in another place , when i tried to put in the directory to import , it did not show up to import tab

[MrX]

What do you mean by it doesn't show up in the "import" tab? Do you mean not listed when you press the "browse" button?

 

How're you putting in the directory to import? Did you type the path of that directory into the textbox or did you use the "browse" button?

[ahmedhoukry]

I mean when i press on the import tab, i get "there are no backup files to import" , although i did backup a couple of days before,

 

the second thing

I am trying to backup the file but i get this message

 

Fatal error: Maximum execution time of 60 seconds exceeded in W:\home\admin\www\phpMyBackupPro\functions.inc.php on line 514

[MrX]

What are you using? phpMyAdmin or phpMyBackupPro?

 

The maximum execution time limit is a safety feature to prevent poorly written scripts from tying up the server, but sometimes it can also prevent good scripts from performing tasks that take a very long time to complete.

 

Anyway, you can change the maximum execution time by opening W:\home\admin\www\phpMyBackupPro\.htaccess (it isn't there by default so you'll have to create it) in notepad and adding "php_value max_execution_time " to it, is the number of seconds a script is allowed to run before it is terminated. Something like 300 should work, but if you're still getting that error, keep increasing it by 60 until the error's gone

 

Just remember that by increasing the maximum execution time, you'll be allowing scripts to use more resources on your server

Edited June 29, 2006 by MrX

[ahmedhoukry]

I am using phpMybackupPRO

icreated a file .htaccess

and did put this line "# php_value max_execution_time 200"

 

but it did not work why ?

 

also , why do older files get deleted

 

Dear Sir

I found out why it deletes the files in the extended config tab

 

but now i cannot backup due to time limit, maybe because the database is large

[ahmedhoukry]

i solved it

i fount the timelimit in extended config

sorry for wasting your time

[MrX]

Who gave you the idea to comment that line by adding a # in front of it? By commenting something, you're telling Apache to ignore it.

 

Also, what do you mean by extended config? Do you mean W:\usr\local\php\php.ini? If you do, I recommend that you don't modify that as you'll make it apply to the entire server. phpMyBackupPro might not be a poorly written script, but there certainly are some of those out there and who knows, you might just use one. Putting the config in the .htaccess file will make that setting only apply to phpMyBackupPro, which we know needs such a long time to complete as you have a big database and not because it is poorly written.

 

Unless you're only going to use phpMyBackupPro with Uniform Server, I hope that you'll consider what I have said, change the php.ini setting back to what it was and use .htaccess instead.

[olajideolaolorun]

So what was the problem....?