In a previous post, I explained how to schedule a reboot on a Linux server. Today, we will learn how to do exactly the same thing on a Windows server.
The reasons are the same. If your Windows dedicated server has just finished a system update and needs to reboot, you do not want to pull the plug in the middle of the day when your traffic is at its highest. Instead, you should wait until off hours to minimize the ...
July 3rd, 2010 | Posted in How to, Knowledge, Tutorials, Windows solutions | No Comments
In a previous post, I explained an easy method for scheduling tasks on a Linux server using cron jobs. On a Windows server, there is a similar process that allows you to schedule programs to run at specified times.
Task automation is a very important part of running a dedicated server because it minimizes the amount of routine manual work you have to perform. For example, if you need to routinely copy DNS files from virtual private servers, you can setup ...
July 3rd, 2010 | Posted in How to, Knowledge, Windows solutions | No Comments
Cron is a Linux service that runs in the background. On a dedicated server, cron is extremely valuable because you can automate repetitive commands and tasks. For example, if you want a certain log to be purged every day, you can create a script to perform the task and then tell cron to run the script daily.
There are two primary ways to tell cron when to run something. The first is to edit /etc/crontab and enter the exact day ...
July 3rd, 2010 | Posted in How to, Knowledge, Linux system | No Comments
On the slave we first have to create the database exampledb:
mysql -u root -p
Enter password:
CREATE DATABASE exampledb;
quit;
If you have made an SQL dump of exampledb on the master and have transferred it to the slave, then it is time now to import the SQL dump into our newly created exampledb on the slave:
mysql ...
June 26th, 2010 | Posted in Apache server, How to, Knowledge, Linux system | No Comments
This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on ...
June 26th, 2010 | Posted in Apache server, How to, Knowledge, Linux system | No Comments
SqlSync lets you compare two databases to see which tuples have been added, removed, and changed. You can also use SqlSync to make one database a clone of another and maintain its contents to be that way. One benefit of using SqlSync to perform synchronization is that you can perform heterogeneous syncs -- for example, from MySQL to PostgreSQL.
No SqlSync packages are available in the standard repositories for Ubuntu, Fedora, or openSUSE. For the article I'll build from ...
June 26th, 2010 | Posted in Apache server, How to, Knowledge, Linux system | No Comments
Moodle is a course management system (CMS) - a free, Open Source software package designed using sound pedagogical principles, to help educators create effective online learning communities. You can download and use it on any computer you have handy (including webhosts), yet it can scale from a single-teacher site to a 50,000-student University. Moodle is also easy to install on Opensuse. Lets begin…
1. First you will need to install XAMPP, an easy to install LAMPP stack with apache, mysql, and ...
June 26th, 2010 | Posted in Apache server, How to, Knowledge, Linux system | No Comments