Jump to content



Photo
- - - - -

Replace DB


  • Please log in to reply
3 replies to this topic

#1   grandpaj

grandpaj
  • Members
  • 905 posts
  • Real Name:John
  • Gender:Male
  • Location:New Zealand

Posted 24 April 2016 - 07:20

Hi

 

I am wanting to replace the existing DB on my "test site" How do I remove/replace it and upload the replacement DB..

 

 

Many thanks

 

Grandpa



#2   Fiber

Fiber
  • Members
  • 48 posts
  • Real Name:Bert
  • Gender:Male
  • Location:Nederland

Posted 24 April 2016 - 10:21

Go to phpmyadmin select you're existing DB en export if you have done it already, empty the tables (select all) in the db not you're db itself en import the replacement .sql



#3   14steve14

14steve14
  • Members
  • 4,361 posts
  • Real Name:Steve
  • Gender:Male
  • Location:Dorset UK

Posted 24 April 2016 - 10:59

The sql to create a database can be found in the install files for what ever version you are wanting to use. Either create a new database, or drop all the tables from your old one. It may be safer to create a new one and then change the database files in both configure files to match the new database. What ever you do remember to create a backup of the old one in case you should decide to go back and use it.


REMEMBER BACKUP, BACKUP AND BACKUP

 

Find information about the bootstrap community version here

 

Success is the ability to go from one failure to the next without any loss of enthusiasm


#4   grandpaj

grandpaj
  • Members
  • 905 posts
  • Real Name:John
  • Gender:Male
  • Location:New Zealand

Posted 24 April 2016 - 21:25

@14steve14

@Fiber

 

Thanks guys, will see what happens.

 

Cheers

 

Grandpa