HowTo: Manual Backup & Restore of FullIPTV Database

HowTo: Manual Backup & Restore of FullIPTV Database

Login to your Server with PuTTY:

 

1. create backup (it will be save to /root ):

pg_dump -U postgres fulliptvxx > fulliptvxx.sql

2. download the Database Backup and open the Database Backup with good Texteditor like
    Notepad++, search and Replace the old (server) ip with the new one

3.  install the CMS on your Server,

4. delete the current installed Database from Server:

dropdb -p 5432-U postgres fulliptvxx

5. create again a new Database:

createdb -p 5432-U postgres fulliptvxx

6. upload your Backup to the new Server in to the Folder /root

7. restore the Database:

psql -U postgres fulliptvxx < fulliptvxx.sql

Also Read