webspaceunlimited Posted July 13, 2005 Share Posted July 13, 2005 Hoping someone can help me out here. I am transfering the hosting of an oscommerce site. I have my existing site hosted and working - albeit the back up facility doesnt work. I can use phpmyadmin to access the mysql database of this site. I have then on a different server built the oscommerce site using the latest oscommerce release - I have set up the header tags contribution and the easy populate contribution (this isnt enabled on the existing site either) and now looking to transfer over the data. In theory it would seem sensible then to use the phpmyadmin to export the database content into an sql file - upload this file the the backup datafile on the new site and then to restore the data from here. This in practice isnt working I am getting an error when trying this so..... looking at the mysql databases the existing one is: MySQL 4.0.20-standard the new one is: MySQL 3.23.54-log If anyone has any pointers I would be pleased of the help. Many Thanks Link to comment Share on other sites More sharing options...
Guest Posted July 13, 2005 Share Posted July 13, 2005 Hoping someone can help me out here. I am transfering the hosting of an oscommerce site. I have my existing site hosted and working - albeit the back up facility doesnt work. I can use phpmyadmin to access the mysql database of this site. I have then on a different server built the oscommerce site using the latest oscommerce release - I have set up the header tags contribution and the easy populate contribution (this isnt enabled on the existing site either) and now looking to transfer over the data. In theory it would seem sensible then to use the phpmyadmin to export the database content into an sql file - upload this file the the backup datafile on the new site and then to restore the data from here. This in practice isnt working I am getting an error when trying this so..... looking at the mysql databases the existing one is: MySQL 4.0.20-standard the new one is: MySQL 3.23.54-log If anyone has any pointers I would be pleased of the help. Many Thanks <{POST_SNAPBACK}> well what is the error you get. Does the .sql file you backed up from phpmyadmin have create table statements in it, does you new database already have the tables created in it BINGO Link to comment Share on other sites More sharing options...
webspaceunlimited Posted July 13, 2005 Author Share Posted July 13, 2005 thanks for replying Mike - like an idiot I didnt make a note of the error message -but will upload the .sql file again now and will post the error message. Link to comment Share on other sites More sharing options...
webspaceunlimited Posted July 13, 2005 Author Share Posted July 13, 2005 looking at it I had saved the original file as insert. the phpmyadmin gives a variety of options Also a variety of options: Add custom comment into header (\n splits lines): Enclose export in a transaction Disable foreign key checks Database export options: Add DROP DATABASE Structure: Add DROP TABLE Add IF NOT EXISTS Add AUTO_INCREMENT value Enclose table and field names with backquotes Add into comments Creation/Update/Check dates Data: Complete inserts Extended inserts Use delayed inserts Use ignore inserts Use hexadecimal for binary fields Export type: INSERT UPDATE REPLACE I have taken another copy as update - so lets see if that works any better. Any suggestions as to which type I should be saving as? Sorry for mebeing a bit thick today - too damn hot and too many phone calls. Many thanks Link to comment Share on other sites More sharing options...
Guest Posted July 13, 2005 Share Posted July 13, 2005 I would do it with Drop Table and complete inserts (I also find the ' Enclose table and field names with backquotes' can be a bit troublesome at times, so I would try without first, the try with if it doesnt work) Link to comment Share on other sites More sharing options...
webspaceunlimited Posted July 13, 2005 Author Share Posted July 13, 2005 thanks mike just trying again now - I think you hit on the export data being where I had my problem so just doing it again - will let you know how i get on Link to comment Share on other sites More sharing options...
♥Vger Posted July 13, 2005 Share Posted July 13, 2005 Don't want to sound unkind - but don't you think you should learn how to do this before setting up as a reseller of web hosting? Vger Link to comment Share on other sites More sharing options...
webspaceunlimited Posted July 13, 2005 Author Share Posted July 13, 2005 to be honest I am more familiar with sql server and .asp than php and mysql - Also I prefer to host only for websites I have built myself. If hosting for a 3rd party then happy to provide hosting for them to do whatever - in this case for a customer to then not know what he is doing and ask for help (a client who has yet to pay) and for me then to help that client in my limited and unlearned manner then yes I think your comments are a little unkind as you say. Link to comment Share on other sites More sharing options...
Guest Posted July 13, 2005 Share Posted July 13, 2005 to be honest I am more familiar with sql server and .asp than php and mysql - Also I prefer to host only for websites I have built myself. If hosting for a 3rd party then happy to provide hosting for them to do whatever - in this case for a customer to then not know what he is doing and ask for help (a client who has yet to pay) and for me then to help that client in my limited and unlearned manner then yes I think your comments are a little unkind as you say. <{POST_SNAPBACK}> anyway, did it work? Link to comment Share on other sites More sharing options...
webspaceunlimited Posted July 13, 2005 Author Share Posted July 13, 2005 anyway, did it work? <{POST_SNAPBACK}> not yet. pulling my hair out here I have to say :) just got one of my colleagues to take a look at it and he has walked off after making his excuses... <grin> plenty of Warning session start(): open(SESSION_WRITE_DIRECTORY?sess_ etc etc... errors.... so case of trying to ignore the heat and think for a while.. Link to comment Share on other sites More sharing options...
Guest Posted July 13, 2005 Share Posted July 13, 2005 just read part of it, egads, going backwards with mysql is probably going to wreak havoc also, perhaps find a different host with a newer mysql . . . Link to comment Share on other sites More sharing options...
webspaceunlimited Posted July 13, 2005 Author Share Posted July 13, 2005 right - the info is running problems in the session .php file... thinking it throught I have to look at the fact that yes it could be the mysql / newer / older version issue... or it could be the fact that the new oscommerce site is... the new site with various contributions installed such as the header tags which does make database changes. So.... I am taking a copy of the latest site with all contribution installed and... then placing a fresh copy of the oscommerce site on the same server space and will see if it without the contributions makes a difference. Link to comment Share on other sites More sharing options...
kingkahn22 Posted July 13, 2005 Share Posted July 13, 2005 Maybe I am looking at this over-simplicticly... You have uploaded OSC and it is working. You have a baked up file with your old database. On your new server all you have to do is go into PHPMYADMIN and: 1. Select ALL 2. DROP 3. CLICK SQL TAB 4. CLICK BROWSE 5. CLICK GO Your old database will now be in your new installation of OSC. Did I miss something ?? Or have I got this wrong ? Link to comment Share on other sites More sharing options...
webspaceunlimited Posted July 13, 2005 Author Share Posted July 13, 2005 thanks for the reply - things have moved on a little since that - I had moved the data before and ended up being left with an error - so there were a few areas that could be wrong 1) my knowledge of the phpmyadmin facility 2) the version of mysql 3) the one I am looking at now - which is the impact of the "new" cart having had various contributions added to it - the epdq, and the easy populare not so much an issue - but the header tags is adifferent matter - so... now its a case of making an assumption the data is fine but the shopping cart isnt is being explored ..... If it wasnt so hot I would be having fun Link to comment Share on other sites More sharing options...
webspaceunlimited Posted July 13, 2005 Author Share Posted July 13, 2005 right looks like it isnt the mysql database version differences - looking at the content moved over it points toward the problem being updates to the database with the header tags contribution, and the upgrade to a later release of the os commerce site. still not there yet - but starting to make more sense thank you all with your patience Link to comment Share on other sites More sharing options...
webspaceunlimited Posted July 13, 2005 Author Share Posted July 13, 2005 while I am uploading all the images etc and changing the relevant pages of new osc intall wonder if anyone has anythoughts on this: Warning: session_start(): open(SESSION_WRITE_DIRECTORY/sess_3b000163a3c0e101ec16ae64be00133e, O_RDWR) failed: No such file or directory (2) in ..../sessions.php on line 67 Link to comment Share on other sites More sharing options...
Guest Posted July 13, 2005 Share Posted July 13, 2005 set your temp directories and / or set store_sessions to mysql in the configure.php files. Link to comment Share on other sites More sharing options...
webspaceunlimited Posted July 13, 2005 Author Share Posted July 13, 2005 thanks john - still uploading images here... how would I go about this setting temp directories in the configure.php file?.. sorry for such a silly question Link to comment Share on other sites More sharing options...
Guest Posted July 13, 2005 Share Posted July 13, 2005 sorry, let me reclarify temp setting is in your path in the admin/configuration store_sessions is in the configure.php files, set to mysql Link to comment Share on other sites More sharing options...
webspaceunlimited Posted July 13, 2005 Author Share Posted July 13, 2005 thanks john.. there are two configure.php files 1in the incldudes directory 1in the admin/includes directory Link to comment Share on other sites More sharing options...
webspaceunlimited Posted July 13, 2005 Author Share Posted July 13, 2005 oops ignore that - I have found it.. thank you - answer was both :) Link to comment Share on other sites More sharing options...
webspaceunlimited Posted July 13, 2005 Author Share Posted July 13, 2005 okay just checking through debugging and the final thing to resolve is: a warning missing arguament 2 for tep_get-zonename() general.php line270 Has anyone had this error?.. if so... any suggestions? Thank you 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.