[Spce-user] MySQL DB

[Jon Bonilla (Manwe)]

El Wed, 1 Apr 2015 11:12:51 +0000
Mele Giovanni <giovanni.mele at nagra.com> escribió:

> Hello,
> 
> Thx for info. Do you have the list of cfg file to update to be able to
> connect on a remote DB?
> 
>

1: Dump the DBs and import them into another server
2: Dump the grants:

  mysql  --skip-column-names -A -e"SELECT CONCAT('SHOW GRANTS FOR
  ''',user,'''@''',host,''';') FROM mysql.user WHERE user<>''" | mysql
  --skip-column-names -A | sed 's/$/;/g' > grants.sql

  Replace localhost with the IP of the provider
  Remove root related grants
  Remove debian-sys-main grants
  Add a localhost grant for procedures: GRANT ALL PRIVILEGES ON *.* TO
  'sipwise'@'localhost' IDENTIFIED BY PASSWORD 'REPLACE THIS' WITH GRANT OPTION;

  Import the edited file into the new server and flush privileges

3: Edit constants.yml and adapt the db host. Then apply via ngcpcfg


-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 819 bytes
Desc: Firma digital OpenPGP
URL: <http://lists.sipwise.com/pipermail/spce-user_lists.sipwise.com/attachments/20150401/5d37a484/attachment-0001.sig>