parasite Posted February 9, 2005 Share Posted February 9, 2005 Hi There! I have installed oscommerce on my werb server, but need to change the database that it resides on. Is there anyway to move the shop system over to a new database on the same server without editing each individual file with the new database name? The username and password will remain the same, only the name of the database will change. Any help much appreciated! I already tried to search for an answer but couldn't find one, so maybe someone can point me to a previous topic?? Cheers, Armin Link to comment Share on other sites More sharing options...
WiseWombat Posted February 9, 2005 Share Posted February 9, 2005 Hi There! I have installed oscommerce on my werb server, but need to change the database that it resides on. Is there anyway to move the shop system over to a new database on the same server without editing each individual file with the new database name? The username and password will remain the same, only the name of the database will change. Any help much appreciated! I already tried to search for an answer but couldn't find one, so maybe someone can point me to a previous topic?? Cheers, Armin <{POST_SNAPBACK}> Dont quote me on this but .Rename your data base and save it for later if you want then Install and create your new database server and run your latest db_file from your shops backups folder in mysql. ( WARNING ) I think I know what Im talking about. BACK UP BACK UP BACK UP BACK UP Link to comment Share on other sites More sharing options...
Guest Posted February 9, 2005 Share Posted February 9, 2005 Dont quote me on this but .Rename your data base and save it for later if you want then Install and create your new database server and run your latest db_file from your shops backups folder in mysql. <{POST_SNAPBACK}> You should be able to export the mysql database from sql and save it as a text file for later use hope this helps Link to comment Share on other sites More sharing options...
parasite Posted February 9, 2005 Author Share Posted February 9, 2005 Dont quote me on this but .Rename your data base and save it for later if you want then Install and create your new database server and run your latest db_file from your shops backups folder in mysql. <{POST_SNAPBACK}> Thanks for the suggestion! I'm wondering if I try what you suggested, will i still need to change the DB login on each of the PHP files that make up OSc? cheers, Armin Link to comment Share on other sites More sharing options...
AllyM Posted February 9, 2005 Share Posted February 9, 2005 You should just change the database references in the config files: catalog/includes/configuration.php catalog/admin/includes/configure.php :thumbsup: Link to comment Share on other sites More sharing options...
parasite Posted February 16, 2005 Author Share Posted February 16, 2005 You should just change the database references in the config files:catalog/includes/configuration.php catalog/admin/includes/configure.php :thumbsup: <{POST_SNAPBACK}> Thanks everyone for your suggestions! The database change over worked a treat! The only problem I encountered was with phpMyAdmin limiting the amount of data I could upload at any one time. Cheers, Armin 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.