| compatability mode? No, as far as osCommerce is concerned, no need to use any 'mode' at all. My local server is running mysql 5, I do this import/export between my server and UH server all the time and i never even think about it. there's never been a problem. depending on which host you exported it from sometime yo do need to choose the right character set when you import it or your £ will become a question mark but that is easy to fix - change it back in the currencies table (the order total table as well for all the old orders if you care).
install products manually?? again, why? you simply extract the products related tables (products, categories, products description, categories description, products to categories, and if you have product properties (options) then a few ( 3 or 4) products options tables, and maybe the two manufacturers tables if you use them. then you just drop these tables and run/import the extracted sqls. it wont take more than a few minutes.
by the sound of it, what you actually needed to do is get the administrator table from somewhere (with a known user name and password in it or you may get into an 'egg or chicken, which first' situation). I could actually post the sql here if needs be. |