joope Posted June 16, 2010 Share Posted June 16, 2010 Ok I'm needing to change my site to a new data base. What is the procedure to make such a change? Or is that possible? Link to comment Share on other sites More sharing options...
mytheory. Posted June 16, 2010 Share Posted June 16, 2010 Can't you just make a dump file of all the tables from your current db, and then create a new db on your new server. Import that dump file (.sql file), and then in the BO (Tools >> Database) setup the details to point to your new server/db (ie. username, password, ip, etc.)This is usually did when I had to reinstall PS, I just installed my existing PS to a new database, and when I had a fresh shop I then imported my dump file into that db.HTH! Link to comment Share on other sites More sharing options...
MrBaseball34 Posted June 16, 2010 Share Posted June 16, 2010 Is it possible to just upgrade a database without all the data? Kind of like running a series of update scripts based on the version you are on up to the current version? Link to comment Share on other sites More sharing options...
mytheory. Posted June 17, 2010 Share Posted June 17, 2010 What do you mean by update without the data? Are you trying to update to a newer version of mysql? Or do you want to create a new database without any data, which sounds like just doing a clean install. Which would be quite easy... but most people try to keep their data. Link to comment Share on other sites More sharing options...
MrBaseball34 Posted June 17, 2010 Share Posted June 17, 2010 What I mean is the DB changes like adding of columns, etc... Link to comment Share on other sites More sharing options...
mytheory. Posted June 18, 2010 Share Posted June 18, 2010 OIC... Ithink it would be possible to update the necessary fields or add tables to the database to match up with the new version (new version of PS, right?). I'm not the expert in doing those updates or sql scripts. You would have to know exactly what tables need to be updated with new fields (which I don't think there is any of), but more importantly I think the new version had an additional table that was added to it. So you would need to know that table and its contents (fields) exactly... but I think especially, if you weren't going to keep your data, it makes more sense to just start anew.HTH! Link to comment Share on other sites More sharing options...
MrBaseball34 Posted June 19, 2010 Share Posted June 19, 2010 In a later version, there in the install folder, there are the updates. Link to comment Share on other sites More sharing options...
Recommended Posts