Mysql

/Mysql
­
6 06, 2018

How to Update WordPress Site URL and Home URL via Command Line?

By |June 6th, 2018|CommandLine, Database servers, HomeURL, Mysql, SiteURL, SQL, Wordpress|0 Comments

It's very easy to update the WordPress site's site URL and home URL via phpMyAdmin from control panels like Cpanel and Plesk. What to do if the Wordpress hosted sites doesn't have a control panel. The only way is to update the site URL and home URL via command line. For that, we need [...]

16 03, 2018

How To Secure MySQL In cPanel Servers?

By |March 16th, 2018|CPanel, Mysql, Server Management|0 Comments

MySQL is a kind of database management system and it is widely used in servers and especially for web servers with cPanel or Plesk installed. Server security is an inevitable aspect of server management and securing MySQL is imperative. For cPanel server, MySQL is pre-installed. MySQL is very robust and widely used in many [...]

20 02, 2018

How To Setup MySQL Replication In CentOS?

By |February 20th, 2018|Articles, Installations, Mysql, Server Administration, Server Management, Server Support, SQL|0 Comments

MySQL replication process enables you to conveniently maintain multiple copies of a MySQL data. This facilitates a way to copy MySQL data from a master to a slave database. The important application of MySQL data is to spread the read access across multiple servers thereby improving the scalability. Apart from that, it is also used to analyze data [...]

29 07, 2016

MySQL Database Replication

By |July 29th, 2016|Mysql|0 Comments

MySQL Database Replication Today Database system are very important to business and organization which provide an efficient method to handle multiple types of data such as employee records, student information, accounting information, inventory details and library books. It is important to prevent total data loss. One solution is database replication which keeps a copy of [...]

3 03, 2015

MyIsam: Storage Engine repair

By |March 3rd, 2015|Articles, DMS, Mysql|0 Comments

A database engine/storage engine is the underlying software component that a DBMS uses to create, read, update and delete data from a database. Most of us are aware about the storage engines commonly used in Mysql: MyIsam and InnoDB The main differences between InnoDB and MyISAM are support for "referential integrity" and "transactions". If you [...]

Load More Posts