Yoda Posted August 28, 2009 Share Posted August 28, 2009 I do back up every week. And I was able to do back up at the back office using the back up tool. But today when I try to do a back up, it does not give me any error, but the size is only 1/5 of what I normally have. And the screen goes blank. I have done a lot of modification in the inventory and categories. I can not afford to lose one week of work. Please help. Any idea what happen?Thanks. Link to comment Share on other sites More sharing options...
CYTechnologies Posted August 28, 2009 Share Posted August 28, 2009 Hey Yoda,Issues have do you... hahaWhere does the file stop? the 1/5 one - it should give you a clue to what table or aspect is causing the error. Link to comment Share on other sites More sharing options...
Yoda Posted August 28, 2009 Author Share Posted August 28, 2009 Hey Yoda,Issues have do you... hahaWhere does the file stop? the 1/5 one - it should give you a clue to what table or aspect is causing the error. Thank you for the reply. How can I OPEN the database and find out what are inside the 1/5?Thanks Link to comment Share on other sites More sharing options...
KIH999 Posted August 28, 2009 Share Posted August 28, 2009 Open phpMyAdmin.Select all tables in Database,Then select check tables from a drop-down-list..There you also can repair tables.. Link to comment Share on other sites More sharing options...
Yoda Posted August 28, 2009 Author Share Posted August 28, 2009 Open phpMyAdmin.Select all tables in Database,Then select check tables from a drop-down-list..There you also can repair tables.. Sorry for my stupid question. My DB is functional, but it just can not be back up. How can I know which table is broken and need to be repair? Link to comment Share on other sites More sharing options...
KIH999 Posted August 28, 2009 Share Posted August 28, 2009 phpMyAdmin will tell you in a report what table that is corrupt. (if any). Link to comment Share on other sites More sharing options...
KIH999 Posted August 28, 2009 Share Posted August 28, 2009 This one... Link to comment Share on other sites More sharing options...
Yoda Posted August 29, 2009 Author Share Posted August 29, 2009 This one... Got it. Thank you...Thank you....Thank you. Link to comment Share on other sites More sharing options...
first1 Posted August 29, 2009 Share Posted August 29, 2009 Does Optimize Table function in Phpmyadmin do any harm? or does it do any good? Link to comment Share on other sites More sharing options...
KIH999 Posted August 29, 2009 Share Posted August 29, 2009 No harm, and only good for a system with many records that are inserted and deleted frequently.(look at it as a defrag-tool) It removes overhead, and can result in faster query's.. Link to comment Share on other sites More sharing options...
first1 Posted August 29, 2009 Share Posted August 29, 2009 thanks, i do have over 1000 products and many many records (stats, orders..etc)I would try it out Link to comment Share on other sites More sharing options...
Recommended Posts