Web Technology Experts Notes

Friday, 6 February 2015

How to delete MySQL Binary logs Files in Wamp Server?

Sometime we find our Wamp Server is talking too much space like 10GB whereas it must take less than the current size. It may be your mysql binary log files are taking too much space in data.
Binary files look like below:
mysql-bin.000001,
mysql-bin.000002,
................,
mysql-bin.000221

Before we delete the mysql binary log files permanently, we should know about these binary log files like what type of files are these and how effect our server.

Question: What is Mysql Binary logs file?
MySQL binary logs are the text file, created by mysql automatically. Default files name are "mysql-bin.000001" which located in data folder of mysqlx.x.

Question: What is purpose of Binary logs file?
It has two purpose
Data Recovery: It is used for data recovery operations.
High availability / replication: It is used on master replication servers as a record of the statements to be sent to slave servers.

Question: What is default location of binary log file?

E:\wamp\bin\mysql\mysql.x.x\data

Question: How can change the Binary log file name?
Open my.ini file under mysql.x.x folder.
In my window system:
E:\wamp\bin\mysql\mysql.x.x\my.ini

Question: Update the following "mysql-bin" name

log-bin=mysql-bin

Question: How to disable the automatic creating binary log files?
Open my.ini file under mysql.x.x folder.
In my window system: E:\wamp\bin\mysql\mysql.x.x\my.ini
Search

log-bin=mysql-bin

and replace with following

#log-bin=mysql-bin

Question: What is dis-advantage of mysql binary log files?
Its takes too much space, some times it take upto 10MB or more space.

Question: How to delete mysql bin files permanently?
It have 3 steps and are following.

Step 1: Disable automatic creating file.
open my.ini file under mysql.x.x folder.
Search

log-bin=mysql-bin

and Replace with following

#log-bin=mysql-bin

Step 2:
Restart Wamp Server

Step3 :
Now you can delete all files start with "mysql-bin.0000xx"

Never delete mysql bin files directly you must follow Step 1

Tuesday, 3 February 2015

How to add DNS Record In GoDaddy?

What is DNS Record?
DNS stands for Domain Name System, It is digital database which contains the information about every live web site. Every website has Website Name and IP Address.

IP Address is location of the website which is used to locate the web site within the DNS database.

DNS records are basically mapping files that tell the DNS server which IP address each domain is associated and how to handle the request for each domain.

Following are different types of Record type in DNS
CNAME record stands for canonical name and serves to make one domain an alias of another domain. It is associate with sub-domains with an existing domain's DNS records.
PTR record stands for pointer record and maps an Ipv4 address to the CNAME on the host.
MX record stands for mail exchange and is basically a list of mail exchange servers.
NS record stands for name server and indicates which Name Server is authoritative for the domain.
SOA record stands for State of Authority. It stores important information like when the domain was last updated.
SRV record stands for service and is used to define a TCP service.
TXT record lets the administrator insert any text they'd like into the DNS record.

How to Edit DNS from "DNS Manager" in GoDaddy.
1. Open https://godaddy.com/
2. Login / Sign In with your Go Daddy account
3. After login, you will see following page

4. Now click on Launch (If you have multiple domain then you can select "launch" of that particular domain).
5. When you click on Launch, you will see following page

6. From top header, select DNS=>DNS Manager, you will see following page

7. Now Click on Edit Zone as in above Screen.
8. Now you will see following page, It is Zone File Editor. Here you can add one or more DNS entry.