Some times MySQL replication creates problems and slave could not sync properly from master. It may cause with lots of reason. Here is a way to fix it. Warning: After using this tutorial, All of your bin-log files will be deleted, So if you want, you may take a backup of bin-log files first and … Read more
We provide Asterisk Support in all over INDIA • Installation / maintenance / configuration • Inbound/outbound/predictive dialing solution for small and large call centers • Vicidial Install, Vicidial Support, Vicidial Configuration and Customization • Go Autodial Install, Go Autodial Support, Go Autodial Configuration and Customization • PRI Line Configure & Support • PRI Card Configure … Read more
Why we use DNS? To know this follow the link http://t4test.com/blog/etchosts-the-host-file/ Because of sheer numbers of hosts on the Internet, we can’t use host’s file (/etc/hosts) them. The ineternet has centralized file in its teens, but its maintenance because so painful that Berkeley had to step in with the Domain Name System (DNS). DNS is a … Read more
LAMP is a combination of operating system and open-source software stack. The acronym LAMP is derived from first letters of Linux, Apache HTTP Server, MySQL database, and PHP/Perl/Python. Installation of Apache Apache is an open-source multi-platform web server. It provides a full range of web server features including CGI, SSL and virtual domains. To install … Read more
Very often we need to extract last 30 days, 7 days data from mysql DB. Here we will show easy way to get the data of given interval. SELECT DATE_FORMAT(create_date, ‘%m/%d/%Y’) FROM mytable WHERE create_date BETWEEN CURDATE() – INTERVAL 30 DAY AND CURDATE() Also note that CURDATE() returns only the DATE portion of the date, so … Read more
Hindi Songs app gives you some of the best collection of Hindi singers/films. You can download and install the Hindi songs android application from here. or http://blog.eduguru.in/Hindi+video+songs+watch+online.apk DISCLAIMER: The content provided in this app is hosted by http://hindivideosongsonline.blogspot.in/ and is available in public domain. And registered users can add the link of Hindi video here.. We … Read more
World top 10 games 1. Grand Theft Auto 5 2. The Last of Us 3. Tomb Raider 4. Bioshock Infinite 5. FIFA 14 (next-gen) 6. Resogun 7. Batman: Arkham Origins 8. Pikmin 3 9. Forza Motorsport 5 10. Assassin’s Creed IV: Black Flag
MySQL interval values are used mainly for date and time calculations. INTERVAL {value of unit} {types of interval} INTERVAL is a MySQL keyword and this is case sensitive. This should be used in CAPITAL Later Only {value of unit} is a expression or value like 1,2,3,4 or any expression which result in value. {type of … Read more
Very often we need to extract last 1 month, 2 months data from mysql DB. Here we will show easy way to get the data of given interval. SELECT * from testtable WHERE startdate BETWEEN DATE_SUB(NOW(), INTERVAL 1 MONTH) AND DATE_SUB(NOW(), INTERVAL 2 MONTH) The above query will return records whose order date is between one and … Read more