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

[Robert Cuaresma]

Hi Alex, 

First, thank you very much for your time.

Second, I have a server with v2.8. I can clone this server and try to upgrade to v3.8.6, question is: if I delete root password for MySQL and try the upgrade, it's possible that I haven't this issue with permanent contacts?

Saludos, 
Robert Cuaresma
Dpto. Ingeniería de Clientes 


-----Mensaje original-----
De: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] En nombre de Alex Lutay
Enviado el: miércoles, 18 de mayo de 2016 23:42
Para: spce-user at lists.sipwise.com
Asunto: Re: [Spce-user] Permanent Contacts after upgrade from 2.8 to 3.8.6

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

_______________________________________________
Spce-user mailing list
Spce-user at lists.sipwise.com
https://lists.sipwise.com/listinfo/spce-user