Difference between revisions of "PowerDNS (with SolusVM ) mysql"
(Created page with "Some examples for solusvm mysql db Solusvm DB name looks like some ID. mysql show databases; use <solusvmDBname_likeID> ; show tables; show all servers with IP like s...") |
|||
| Line 11: | Line 11: | ||
show all servers with IP like specified: | show all servers with IP like specified: | ||
select vserverid, mainipaddress, hostname from vservers where mainipaddress like '185.31%'; | select vserverid, mainipaddress, hostname from vservers where mainipaddress like '185.31%'; | ||
| + | |||
| + | show all servers with ip like specified and not disabled: | ||
| + | select vserverid, mainipaddress, hostname, cachestatus, disabled from vservers where mainipaddress like '%185.31%' and disabled='0'; | ||
change some record example: | change some record example: | ||
UPDATE vservers SET mainipaddress = '10.10.10.143' WHERE ctid=5342; | UPDATE vservers SET mainipaddress = '10.10.10.143' WHERE ctid=5342; | ||
Revision as of 15:20, 12 August 2014
Some examples for solusvm mysql db
Solusvm DB name looks like some ID.
mysql
show databases; use <solusvmDBname_likeID> ; show tables;
show all servers with IP like specified:
select vserverid, mainipaddress, hostname from vservers where mainipaddress like '185.31%';
show all servers with ip like specified and not disabled:
select vserverid, mainipaddress, hostname, cachestatus, disabled from vservers where mainipaddress like '%185.31%' and disabled='0';
change some record example:
UPDATE vservers SET mainipaddress = '10.10.10.143' WHERE ctid=5342;
