[Spce-user] Permanent Contacts after upgrade from 2.8 to 3.8.6

[Alex Lutay]

You have file db_backup.sql.gz

It is a MySQL dump which is also contains table location.
You can open it using 'zless' or unpack it from archive.

There will be plain SQL INSERTs inside which you can parse using
console tools, while I prefer to create and new temporary MySQL database
and insert values there, then select only necessary parts.

On 05/18/2016 05:45 PM, Robert Cuaresma wrote:
> On server with issue (v3.8.6) I have on backup directory:
> 
> # ls -la /var/backup/ngcp-mr3.8.6
> drwxr-xr-x 2 root root     4096 May 12 16:42 apt
> -rw-r--r-- 1 root root       30 May 12 16:42 db_backup_done
> -rw------- 1 root root 24388176 May 12 16:42 db_backup.sql.gz
> -rw-r--r-- 1 root root       30 May 12 16:42 db_backup_started
> drwx------ 4 root root     4096 May 10 20:38 ngcp-config
> -rw-r--r-- 1 root root  1307192 May 12 17:15 upgrade.log
> 
> ¿It's possible that the table with permanent contacts are here?
> 
> ¿Can you explain me procedure for restore this backup on database?
> 
> Thanks!


-- 
Alex Lutay