AlexFaller Posted July 16, 2015 Share Posted July 16, 2015 Hi, Im installing a fresh copy of 6.0 onto a local dev server and I've exported my db from my live version via phpmyadmin to try and import the db into my dev version, but all I get are errors that admin tables exist etc. Is there a way to export and import the data an easier way as im assuming im doing it wrong? 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted July 16, 2015 Share Posted July 16, 2015 I think the correct way (or at least the way I think I did it when setting up my v6 dev!) was to make a duplicate of the v5.3 database, install v6 in a new directory and then when it asks for database details during installation, give it the username/password etc for the copied table... it then converts it into a v6 database and away you go... 0 Quote Link to comment Share on other sites More sharing options...
AlexFaller Posted July 16, 2015 Author Share Posted July 16, 2015 I think the correct way (or at least the way I think I did it when setting up my v6 dev!) was to make a duplicate of the v5.3 database, install v6 in a new directory and then when it asks for database details during installation, give it the username/password etc for the copied table... it then converts it into a v6 database and away you go... Thanks for the reply. I tried that already, both with upgrading the live one (before deciding I needed to really do these things on a staging server first after taking the entire site down oops) and now on the local one, but I get this error: Unable to complete incremental updates: Unable to import the 6.0.0 Alpha1 database file. Unable to import resources/sql/upgrade600alpha1.sql: Duplicate column name 'created_at' with both. 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted July 16, 2015 Share Posted July 16, 2015 you might try installing v6.0.1 to see if that solves it.. 0 Quote Link to comment Share on other sites More sharing options...
AlexFaller Posted July 16, 2015 Author Share Posted July 16, 2015 I have tried both the v6.0.0 and v6.0.1 Ive tried everything I can think of 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted July 16, 2015 Share Posted July 16, 2015 have you got a backup of your last v5.3 database? if so, you could use that, delete your v6 files and try again... 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.