[Spce-user] MySQL DB
Jon Bonilla (Manwe)
manwe at sipdoc.net
Wed Apr 1 07:19:59 EDT 2015
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>
More information about the Spce-user
mailing list