Guest Posted July 17, 2003 Share Posted July 17, 2003 Ok, folks, it took me several months to get to the point of an upgrade, but I'm ready now to upgrade. I was told that because my current version of osCommerce was so old, I had no real upgrade path to the latest milestone. So, I have had my ISP set up the milestone version in a safe place to set up, and then we will copy the whole thing over in one fell swoop replacing EVERYTHING at the same time. The problem is, if I do that, I will loose all of my customer info (usernames, passwords, addresses), I will also loose all my reviews, AND my previous orders. I have tried copying a database backup from the old version (my current live store) of Osc, but found that not all of the info transfered well. In fact, it messed up the default catalog page fairly bad. Not a good thing. Is there a way to transfer JUST the customer's usernames, passwords, reviews and previous orders without messing up the main page? Is there a way to get the above info out of the database file at all??? I really hate to loose all that info and have to go back begging my customers to sign up again and to do all their reviews again. A very large pain in the backside. :( Link to comment Share on other sites More sharing options...
equilla Posted July 17, 2003 Share Posted July 17, 2003 Hi there, Firstly, if you are using the new MS2 release, I believe there are some scripts in the extras folder within the distribution which can be used to peform necessary conversion on a MS1 database to make it work properly in MS2. Failing that, hopefully you should have phpmyadmin installed. If not, it would be a good idea to do so as this makes things like this much easier. With phpmyadmin, you can choose the database tables you need to get the information out of and just save them to a file. Then you import this using phpmyadmin again (this time on the new database) to get all that information into the new build. This will work as long as the field names haven't changed in the tables between the builds (most of them should be the same). Hope this helps, Mark Mark Stephens Contribs: http://www.oscommerce.com/community/contributions,1680 http://www.oscommerce.com/community/contributions,1467 http://www.oscommerce.com/community/contributions,1422 Link to comment Share on other sites More sharing options...
Guest Posted July 18, 2003 Share Posted July 18, 2003 Well, actually it a newer version than MS1. I think it's around v2.02 or some such. But I'd be willing to bet you may have solved my problem. 8) THANKS! :D :D :D :D :D :D :D Link to comment Share on other sites More sharing options...
Guest Posted July 28, 2003 Share Posted July 28, 2003 :( This is very frustrating. I have been trying to get my ISP to work with my on manipulating these database files and either thay can't figure out how to make phpmyadmin work, or I have also been told they won't make it work because it opens up all the databases to web based manipulation. Ok everyone, please help me on this. Is there a windows based mysql database manipulator program out there ANYWHERE???!! It's a file for crying out loud! I can download the .sql file I should be able to take it into something like MS Access or Excel and manipulate this bugger somehow! :evil: :evil: AAARRRRRRRGGGG!!!!! Link to comment Share on other sites More sharing options...
equilla Posted July 28, 2003 Share Posted July 28, 2003 Hi, Well, if osc works then phpmyadmin will work. If your ISP can't get it working then if it were me I would upload it and configure it myself! In fact I have done several times in the past...... Cheers, Mark Mark Stephens Contribs: http://www.oscommerce.com/community/contributions,1680 http://www.oscommerce.com/community/contributions,1467 http://www.oscommerce.com/community/contributions,1422 Link to comment Share on other sites More sharing options...
Guest Posted July 28, 2003 Share Posted July 28, 2003 Well, if osc works then phpmyadmin will work. Well, unfortunately, I tried that and got some sort of security error I didn't understand. Access denied for user: 'root@localhost' (Using password: NO) And after asking the tech support about it, the way they have security cranked up, I couldn't make it work from that directory even if I wanted to. I can't get security clearance to run the program because they say it will open up all of the mysql databases on the system (including their user databases) to open attack. Basically, at this point, working WITH my ISP is not an option. They have stonewalled me at every turn, so now I am looking for some sort of program that I can take the .sql files I downloaded from both the old and the new versions, and be able to manipulate them by putting all the users info, past orders info, reviews, and maybe other things into the new database without disturbing the new fields that the new version of osCommerce requires. Am I boned here?? Am I going to have to put the new version of OSC up live and then ask my customers to come back and re-enter their info again!!??? :cry: I'm going to look like a total idiot if that's the case. Link to comment Share on other sites More sharing options...
Guest Posted July 28, 2003 Share Posted July 28, 2003 Let me clarify that last post a bit,,,,, I re-read it and it seems to be a bit obtuse. What I'm looking for is a WINDOWS based database manipulation program, so I can do the changes I need, then >I< can upload the file that results to my backups area so I can "restore" my new store from the new "manipulated" file. Is there such a beast?? :? Link to comment Share on other sites More sharing options...
equilla Posted July 28, 2003 Share Posted July 28, 2003 Hi again, did you edit the configuration file for phpmyadmin after you uploaded it? It seems like it is trying to connect to the database as user "root" with a blank password, which is the default for a brand new MySQL installation and clearly isn't going to work here. You need to set it up with your own user/pass details. Can anyone shed light on the ISPs attitude here? Is there some great flaw in phpmyadmin that I am unaware of? Surely the security of the database can only be ensured through good practice in the way MySQL accounts are set up on the server and the scripts you use to use these accounts should have no bearing on this at all.....standing by to be shot down in flames lol :wink: Cheers, Mark Mark Stephens Contribs: http://www.oscommerce.com/community/contributions,1680 http://www.oscommerce.com/community/contributions,1467 http://www.oscommerce.com/community/contributions,1422 Link to comment Share on other sites More sharing options...
Guest Posted July 28, 2003 Share Posted July 28, 2003 I think they are just scared of a new script. They don't understand it, therefore they fear it. Just another thought here, I just tried again to upload a database backup of my old (read: current site) to the test site. I "restored" the new site with the database from the old site. My right colum of info on the main page was completely messed up, BUT this time I poked around in the admin site of the test site a bit and found that the previous orders was not transfered. If the previous orders cannot be transfered, it's not going to work for me. Where is all that previous order info stored anyway?? Here is the quote from the messed up colum.... 1054 - Unknown column 'p.products_ordered' in 'where clause' select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10 [TEP STOP] I'm starting to think I'm just totally boned here. If I am, I just am. I'll have to get over it and bite the bullet I guess. :( Link to comment Share on other sites More sharing options...
novascream Posted July 30, 2003 Share Posted July 30, 2003 Just thought I'd mention that there is a Windows program called MySQLFront that will do basically the same thing as PHPMyAdmin without the need to go through your ISP. Download it here: http://mysqlfront.sstienemann.de/ I believe it is no longer being developed but it works great. 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.