Larskovitch Posted March 8, 2003 Share Posted March 8, 2003 My shop (www.consumax.nl) has been working fine now for a couple of months :D . But all of a sudden my back-up feature "admin/backup.php?action=backupnow" ends up with a "page cannot be displayed error" :!: :?: For as far as i know, it worked flawlessly and now this...... Does anybody recognise this problem? I allready tried a more recent version of backup.php, but so far all my efforts seem a waist of time. I use snapshot 29092002 with php 4.3.0/mysql on server Local i do not experience this problem. Could this be a ISP error? They say nothing has changed.... Thanx in advance, Lars Life is good...... but not for me ;-) Al Bundy Link to comment Share on other sites More sharing options...
Larskovitch Posted March 9, 2003 Author Share Posted March 9, 2003 OKay, let me put it otherwise: Is there a function in Mysqladmin that generates the exact same kind of backup as the phpbackup function in OSC? As i am not really a SQL expert, i tried several functions, but neither one of them seem to gereate the same kind of backup. They all seem te be al little different in a way. Would be very happy with an answer :) Life is good...... but not for me ;-) Al Bundy Link to comment Share on other sites More sharing options...
huwcole Posted March 11, 2003 Share Posted March 11, 2003 hi there if you phpmyadmin then you could use the export function to backup your whole database or single individual tables to your harddrive. re osc backup facility: I had a similar problem. it all worked fine until my database got bigger and bigger. it just didn't work anymore. that was an ISP problem because my database was on a server with 1000 of other people. I changed to a dedicated server and and the problem was gone. Link to comment Share on other sites More sharing options...
Larskovitch Posted March 11, 2003 Author Share Posted March 11, 2003 Thnx huwcole, for your reply..... maybe i'd better switch to a dedicated server then... Backing up in phpmyadmin: does it affect the database in anyway, so that i cannot restore the database from within OSC? Life is good...... but not for me ;-) Al Bundy Link to comment Share on other sites More sharing options...
huwcole Posted March 11, 2003 Share Posted March 11, 2003 hi if you use the export function in phpmyadmin you save the database as database.sql or if you want as a zipped file to your hard drive which is then your backup. should you have to restore your database you would go back to phpmyadmin click on the SQL text link at the top. you then will find a textfield where there is a Browse button next to it, click on that and try to locate your database.sql file. Compression leave as None. Though if you saved it as a zip file you then would have to tick gzipped. next click on GO and bob is your uncle. at the end of the process phpmyadmin will tell you whether it was successful or not. Though depending on the size of you database, your connection and probably your ISP it might time out in the middle of the process. if that happens you would have to export each table individually. if you are not quite clear on phpmyadmin let me know. i just assume that you know what i am talking about. if not no probs but you have to let me know. huw Link to comment Share on other sites More sharing options...
Larskovitch Posted March 11, 2003 Author Share Posted March 11, 2003 Thnx for your outstanding help and your valuable time huwcole! :D Okay, lets see......first of all i (or actually my ISP) runs Mysqladmin. Don't know if it makes a big difference, but most likely most features will end up doing the same, don't they? Here's what i come across in Mysqladmin: First of all i can watch/export (and save) a dump of the database with the following options: - Just structure - Structure and data - Just data I suppose i best use Structure and data? Second i can choose from a couple of options which i cannot quite figure out: - Add drop table (i have to translate it from Dutch :? - Complete inserts - extended inserts - use backquotes with table and field names - Or use neither one of them...... Then finally i can choose weather i want to zip or not......that's the part i understand best :D Could you please tell me which options to use? I again would be very gratefull ! Lars Life is good...... but not for me ;-) Al Bundy Link to comment Share on other sites More sharing options...
huwcole Posted March 11, 2003 Share Posted March 11, 2003 hi re options: go for structure and data Add drop table: add this option if you want to delete the old table of the same name. basically it checks whether there is a table with the same name. if there is it deletes it and then inserts the new one. - Complete inserts: no clue - extended inserts: choose this option if you want all the table data inserted in one go (dump(file) will be smaller). usually you have an insert statement for each table data - use backquotes with table and field names: no clue as they are options they are not that important. most important is the first one: structure and data huw Link to comment Share on other sites More sharing options...
Larskovitch Posted March 12, 2003 Author Share Posted March 12, 2003 Thank you so much huw, i feel much more sure of what i'll be doing now! :D Lars Life is good...... but not for me ;-) Al Bundy Link to comment Share on other sites More sharing options...
singspiel Posted March 12, 2003 Share Posted March 12, 2003 I have dedicated server and my database has got big, my backup button does exactly the same thing, page cannot be displayed. Its the only site on the server. So it can't be speed. As you guys mention i can use phpmyadmin no probs, but I liked the clean way oscommerce did it. Any ideas, maybe it's a setting in php.ini. Nev Link to comment Share on other sites More sharing options...
cybersam Posted March 25, 2003 Share Posted March 25, 2003 I have similar problem with the Admin backup/restore. The ***.sql backup file is 5.8 meg; the admin restore tool times out after 30 seconds. I blieve it is setup this way in the admin tool. I just do not know where to look.?? From my experience with Oracle, this file size is considered very small. I am new to MySQL, is it different here. Link to comment Share on other sites More sharing options...
mtnlyon001 Posted April 1, 2003 Share Posted April 1, 2003 I'm having the same problem - I've changes the apache timeouts as well as the timeout in backup.php - no luck. Link to comment Share on other sites More sharing options...
Druide Posted April 3, 2003 Share Posted April 3, 2003 you all should check the function: http://www.php.net/manual/en/function.ini-set.php and if your server/host does allow it check in (php config) then you can change the time in the backup file ini_set('max_execution_time', '300'); Robert We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
mtnlyon001 Posted April 3, 2003 Share Posted April 3, 2003 Thanks for the suggestion Robert. I set the timeout value in backup.php to 10000 and it didn't make a difference. MS knowledgebase stated that the only way to increase the timeout value of IE was to hack the registry and I don't want to do that. I guess I'll use mysqlhotcopy instead even though I really liked OC's backup function. Link to comment Share on other sites More sharing options...
Luna Posted June 6, 2003 Share Posted June 6, 2003 Since a few days i have the same problem. (page not found at the moment of backup_now) My backup is only 1.5 MB. Another strange thing is that my other shop has backup.php,v 1.9 2001/09/19 09:11:33 is on the same webserver and uses the same MySql server and has no problems. The backup.php that causes this problem is backup.php,v 1.57 2003/03/22 02:44:53 Does anybody found a solution ? Link to comment Share on other sites More sharing options...
mitti Posted December 4, 2003 Share Posted December 4, 2003 Got a fix for this: http://www.oscommerce.com/forums/index.php?sho...=0entry268364 Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.