Difference between revisions of "PowerDNS (with SolusVM ) mysql"

From vpsget wiki
Jump to: navigation, search
Line 17: Line 17:
 
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;
 +
 +
select all servers with ip like specified and join with clients table:
 +
 +
SELECT clients.emailaddress, clients.clientid, vservers.clientid, vservers.vserverid, vservers.mainipaddress, vservers.hostname,
 +
vservers.disabled
 +
FROM vservers
 +
JOIN clients ON clients.clientid=vservers.clientid
 +
WHERE vservers.mainipaddress like '%185.31%' and disabled='0' ;

Revision as of 17:16, 9 September 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;

select all servers with ip like specified and join with clients table:

SELECT clients.emailaddress, clients.clientid, vservers.clientid, vservers.vserverid, vservers.mainipaddress, vservers.hostname, 
vservers.disabled 
FROM vservers
JOIN clients ON clients.clientid=vservers.clientid
WHERE vservers.mainipaddress like '%185.31%' and disabled='0' ;