carpenoctem Posted October 13, 2005 Share Posted October 13, 2005 i am trying to do a database restore.... which i have done many times from the oscommerce control panel. But now when i try and do it from a recent backup it times out, and gives me an error message. i tried using an older backup and the same thing happens.... Please Help ASAP!!!!! Mark Link to comment Share on other sites More sharing options...
VectorSix Posted October 13, 2005 Share Posted October 13, 2005 i am trying to do a database restore.... which i have done many times from the oscommerce control panel. But now when i try and do it from a recent backup it times out, and gives me an error message. i tried using an older backup and the same thing happens.... Please Help ASAP!!!!! Mark Post the error and as much detail as you have. Link to comment Share on other sites More sharing options...
Guest Posted October 13, 2005 Share Posted October 13, 2005 try via phpmyadmin or mysql control center Link to comment Share on other sites More sharing options...
carpenoctem Posted October 13, 2005 Author Share Posted October 13, 2005 try via phpmyadmin or mysql control center This is the error that i get 2013 - Lost connection to MySQL server during query drop table if exists address_book, address_format, banners, banners_history, categories, categories_description, configuration, configuration_group, counter, counter_history, countries, currencies, customers, customers_basket, customers_basket_attributes, customers_info, languages, manufacturers, manufacturers_info, orders, orders_products, orders_status, orders_status_history, orders_products_attributes, orders_products_download, products, products_attributes, products_attributes_download, prodcts_description, products_options, products_options_values, products_options_values_to_products_options, products_to_categories, reviews, reviews_description, sessions, specials, tax_class, tax_rates, geo_zones, whos_online, zones, zones_to_geo_zones [TEP STOP] how do i restore using phpmyadmin? Link to comment Share on other sites More sharing options...
Guest Posted October 13, 2005 Share Posted October 13, 2005 open phpmyadmin, select the database you are working with, then click sql and browse to the file you want to restore Link to comment Share on other sites More sharing options...
carpenoctem Posted October 13, 2005 Author Share Posted October 13, 2005 open phpmyadmin, select the database you are working with, then click sql and browse to the file you want to restore if that is the only way to resolve this issue then i will do it...... is there another solution? Link to comment Share on other sites More sharing options...
alark Posted October 20, 2005 Share Posted October 20, 2005 I am trying to restore my old database into a new osc install. I tried via the admin panel in osc. When I try from phpmyadmin, I select the sql file I want to import and I get this error: Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/read_dump.lib.php on line 91 Any help is greatly appreciated. Thanks, Stephen Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted October 20, 2005 Share Posted October 20, 2005 I am trying to restore my old database into a new osc install. I tried via the admin panel in osc. When I try from phpmyadmin, I select the sql file I want to import and I get this error: Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/read_dump.lib.php on line 91 Any help is greatly appreciated. Thanks, Stephen you can have your host raise the max execution time for you. Some will do it, some won't. :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... 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.