In a replication setup, a master MySQL server updates one or more slaves. Transactions are committed sequentially, and a slow transaction can cause the slave to lag behind the master. This means that if the master fails, it is possible that the slave might not have recorded the last few
If your MySQL connection is failing and returning the message ERROR 2002 (HY000): Can’t connect to local MySQL server through socket, then chances are your MySql.sock file is missing or has been deleted. By following these steps, you’ll be able to diagnose and determine which actions must be taken to
How to View a Table in a SQL Server Database Need to know how you can view a table within a SQL server database? Using the Enterprise Manager, this can be achieved with just a few simple steps. First, you’ll need to open Enterprise Manager and expand the registered SQL
To restore a database on SQL Server using .mdf, .ldf, or .ndf files, rather than performing a restore, you will actually need to attach the database. There are two ways to do this. Using Enterprise Manager To attach a database using Enterprise Manager, follow these instructions: Expand the registered
Executing a SQL Script in 6 Easy Steps Need to know how to execute a SQL script in MSSQL? Just follow these 6 simple steps: To execute a .sql file, you’ll first need to open the “Query Analyzer” tool. To do this, navigate to the Start menu -> Programs ->
Overview You can change an account holder’s password, if required. This is usually only necessary when an account holder cannot remember their password as they can change their password if they know their current password. Steps To access the Account Functions Menu, click on Account Functions, on the main
Overview WebHost Manager (WHM) enables you to list all subdomains on your server. This function will display all subdomains and parked domains, sorted by domain name. Steps To list out your subdomains using WHM, just follow these steps: To access the Account Information Menu, click on Account Information, on
Overview This function allows users to display all domains that are parked on top of other domains. Steps To see a list of all parked domains, just follow these steps: To access the Account Information Menu, click on Account Information, on the main screen of your WebHost Manager interface.
Overview With WebHost Manager, you can restore multiple backups at the same time. You can only restore multiple backups of the same type: daily, weekly, or monthly. Steps To restore multiple backups, follow these steps: To access the Backup Menu, click on Backup, on the main screen of your
Collectively, preinst, postinst, prerm, and postrm files are all executable scripts which Debian automatically runs before or after package installation. Along with a file named control, all of these files are part of the “control” section of a Debian archive file. The individual files are: preinst This script executes before
Udev provides users with a dynamic device directory containing only the files for actually present devices. It creates and removes device node files usually located in the /dev/ directory, and renames network interfaces. As part of the hotplug subsystem, udev is executed if a kernel device is added or removed