Skip to main content

Posts

Showing posts from September, 2012

How To Enable Binary Logs In MYSQL Server In Linux

The binary log contains events that describe database changes such as table creation operations or changes to table data. It also contains events for statements that potentially could have made changes (for example, a DELETE which matched no rows). The binary log also contains information about how long each statement took that updated data. The binary log has two important purposes: For replication, the binary log is used on master replication servers as a record of the statements to be sent to slave servers. The master server sends the events contained in its binary log to its slaves, which execute those events to make the same data changes that were made on the master. Certain data recovery operations require use of the binary log. After a backup has been restored, the events in the binary log that were recorded after the backup was made are re-executed. These events bring databases up to date from the point of the backup. Step:1 Stop the mysql service using below...

How To take backup and restore mysql databases in Linux

To backup(dump) single mysql database to a file , first we need to open the terminal and use the below syntax # mysqldump -u <username> -p <databasename> > backup.sql Username = this is your database username databasename = the name of your database which you want to backup backup.sql = the filename for your database backup Example: # mysqldump -u root -p plist > /root/backuplist.sql where -u is for username, -p is for mysqldump to ask for password, plist is the name of the database backuplist.sql is the file to dump the database. To restore back mysql database from dumpfile: Method:1 Open the terminal , use below command # mysql -u root -p plist < /root/backuplist.sql -u and -p are similar to above, plist is the name of the database and backuplist.sql is the name of the dumpfile. Method:2 From inside mysql console where we have to access mysql console first: mysql> source backuplist.sql ...

Configure NTP (Network Time Protocol) on Windows Server 2008

The Network Time Protocol ( NTP ) in Windows 2008 provides your server with the ability to control the system clocks on your Windows client machines. This keeps all machines on the network synchronized with the same system time. This is beneficial for Windows administrators who need to schedule time-sensitive services on the network. You set the Windows 2008 NTP service in the registry. Step 1- Click the Windows 2008 “ Start ” button and enter “ regedit ” into the search box. Press Enter to open the Windows registry editor. Step 2- Navigate to the “ HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\ Services\W32Time\Config\ “. registry key Step 3- Double click the key value labeled “ AnnounceFlags ” in the center detail pane. Step 4- Enter “ A ” into the DWORD value text box. Click “ OK ” to save your settings. Close the Windows registry editor. Step 5- Click the Windows “ Start ” button and enter “ cmd ” into the text box. Press Enter to open the command prompt. Enter...

How To Install and Configure a File and Print Server in Windows Server 2003

You can create a Windows Server 2003 file server and print server manually, or you can use the wizards that are provided in the Configure Your Server Wizard administrative tool. How to Install a File Server on Windows Server 2003 by Using the Configure Your Server Wizard Click Start , point to Administrative Tools , and then click Configure Your Server Wizard . Click Next . Click Next . Click File server in the Server role box, and then click Next . On the “File Server Disk Quotas” page, configure any quotas you need to control disk-space usage on the server, and then click Next . On the “File Server Indexing Service” page, click the indexing configuration that is appropriate for your server, and then click Next . Click Next . Click Finish . The Share a Folder Wizard starts. Click Next . Click Browse , locate the folder that you want to share, and then click OK . Click Next . Type a share name for the folder, and then click Next . Click one of the basic permissions f...