Base de Conocimientos

Install LAMP on CentOS 6.5 (Linux, Apache, MySQL,PHP) ================================ Update system ================================ yum update chkconfig --list chkconfig iptables off if enabled chkconfig ip6tables off if enabled chkconfig --list vi /etc/sysconfig/selinux if enabled change to disabled ================================= Install MySQL Server ================================= yum install mysql mysql-server chkconfig --levels 235 mysqld on service mysqld start mysql_secure_installation ================================== Install httpd server ================================== yum install httpd chkconfig --levels 235 httpd on service httpd start ================================== Install PHP ================================== yum install php /etc/init.d/httpd restart vi /var/www/html/info.php service httpd restart phpMyAdmin 4.5 Released. It is web-based client written in php for managing MySQL and MariaDB databases. It provides a user friendly web interface to access a...

Backup multiple SQL databases This is a query I use to backup all of my lab databases. I use System Center 2012 Orchestrator (SCORCH) to kick off a runbook which executes this query againsy my SQL servers to backup all of the databases. You know as well as I do, there are many ways to accomplish this task...some even easier, however, in attempts to use SCORCH more frequently, I decided to make a RunBook to which performed the job for me. Using SCORCH's "Query Database" activity, I pasted the following code in the query window and set the connection parameters and off it went. You can copy the code below and run it in a SSMS query window and it will work as well.     ]------ Begin Code ------[ --declaring variables DECLARE @dbname VARCHAR(100) -- database name DECLARE @bupath VARCHAR(100) -- path for backup location DECLARE @filename VARCHAR(100) -- filename used for backup files DECLARE @datestamp VARCHAR(25) -- date used for backup file timestamp -- spec...