Place of all tech articles

techarticles

  • Home
  • About
  • aStore
  • Contact Info
  • Tools
    • SEO Page Audit
    • SEO Keyword Rank
    • google pagerank checker
    • whois

Category Archives: Uncategorized

SSH login without password in Linux

13th May, 2017 · techinf1 · 1 Comment

For many reasons we need to access remote server automatically without providing password. Specially when you need to copy file through script or programming from one server to another server. We know that SSH is a secure protocol to access remote server. Here we will show how we can access remote server without providing password.

Read More…

Posted in Uncategorized |

How to write automated FTP script in Linux

7th November, 2015 · techinf1 · Leave a comment

In this article I will show you how to write automated FTP script in Linux. File Transfer Protocol (FTP) is typically used to copy files from one computer to another. The automated FTP script is mostly useful when you are a server administrator and you are maintaining many servers and you need to take backup

Read More…

Posted in FTP, Linux, Uncategorized |

fixing mysql replication error automatically

14th March, 2015 · techinf1 · 3 Comments

This article is written for those who have already read article “MySQL Replication skip error” . In that article I explained how to find out replication error and how to solve it step by step. Sometimes , the steps need to be executed several times until there is no error found at heading “Last_SQL_Error:”. Here I

Read More…

Posted in Uncategorized |

MySQL Replication skip error

13th December, 2014 · techinf1 · 7 Comments

MySQL Replication skip error There are two ways you can configure MySQL replication : normal and GTID based replication. From MySQL 5.6 GTID based replication is started. However, you can again explore how to setup MySQL Replication on the the following links replication-howto replication-gtids-howto Sometimes, replication on Slave server is stopped for many a reasons

Read More…

Posted in Database, MySQL, Uncategorized |

Remove Duplicate Rows in MySQL

24th November, 2014 · techinf1 · Leave a comment

Remove Duplicate Rows in MySQL Remove duplicate rows in MySQL is a common query for many initial MySQL user. I  have been working on MySQL  for more than six years and in my initial starting I had to search over the internet for  this easy thing.  Though there are a lot of articles on the

Read More…

Posted in Uncategorized |

Optimize MySQL table_open_cache

21st September, 2014 · techinf1 · 6 Comments

Optimize MySQL table_open_cache The number of open tables for all threads. Increasing this value increases the number of file descriptors that mysqld requires. You can check whether you need to increase the table cache by checking the Opened_tables status variable.  If the value of Opened_tables is large and you do not use FLUSH TABLES often

Read More…

Posted in Uncategorized |

Android App to challenge math ability
MathQuiz

Top Posts

  • Optimize MySQL tmp_table_size
  • Optimize MySQL table_open_cache
  • MySQL Replication skip error
  • Optimize MySQL query_cache_size
  • Optimize MySQL innodb_buffer_pool_size

Recent Posts

  • Recover MySQL 5.7 root Password in Redhat/CentOS 7
  • SSH login without password in Linux
  • How to write automated FTP script in Linux
  • Installing Nginx with PHP support
  • How to access HTML5 local storage

Follow US

Follow US

Categories

© Techinfobest is the house of tech articles
  • About
  • aStore
  • Contact Info
  • google pagerank checker
  • SEO Keyword Rank
  • SEO Page Audit
  • Tools
  • whois