Making Slave MySQL Server

Making Slave MySQL Server Setting up a slave MySQL server is a very easy process, that is, if you are aware of the actual commands and the medium which is required to execute the commands.  MySQL server is used to run different commands through a suitable medium for carrying out different actions that cannot be done otherwise. These commands are also useful for keeping the data on your computer secure. It is important to keep a proper back...

Read More

Installing MySQL with Apache 2.x

Installing MySQL with Apache 2.x For the sake of local development and testing, Apache and MySQL are installed on the computer windows in order to serve for various purposes.  Installing the latest apache series: ·         For the installation of the latest Apache available few simple steps are followed. ·         While going to the official website...

Read More

Import/Export MySQL

Import/Export MySQL Generally speaking importing and exporting data in the MySQL is not a difficult task and there are three different ways specified for the efficient working. The first method is to perform it through graphical means with the help of  phpMyAdmin while the method is not highly recommended in case of uploading heavy files on system. The next method is the utilization of the SSH tunnel in which a third party is used to...

Read More

What is MySQL?

What is MySQL? MySQL is the best source to provide database system working as a server and further provide access to other databases. SQL is the abbreviation of Structured Query Language. In simple words, MySQL helps in creating a structural database on the web for sake of either storing data or an access to automotive procedures.  With the help of such system one can create a number of magnificent projects on the web. MySQL is also one...

Read More

Most Common Shell Commands

Most Common Shell Commands Here we are going to discuss a few common shell commands that are being used by the programmers to enable different functions. Beginners are confused about the set of commands that can be used and the command box through which they can execute their commands. All of the shell commands use s sensible and a logical pattern to be executed. All of the shell commands are very short and only include three or four letters....

Read More

Overview of phpMyAdmin

Overview of phpMyAdmin PhpmyAdmin can be described as the most popular application, which is being used for the MySQL database management. Basically it is a free management tool that has been developed in PHP and it is a very useful tool. As with the help of this application you can easily export, import, delete, drop, alter or create a MySQL database table. Not only this, but you can also run various MySQL queries, check tables, optimize,...

Read More

Setting up Master MySQL Server

Setting up Master MySQL Server Setting up a master MySQL server is an easy process. But for the beginners this process might get tricky as they do not know how to place different commands. Apart from knowing the exact and accurate commands required for executing different actions they also need to be typed correctly, as any wrong command will not let a required action to take place. It will actually prevent MySQL from carrying out the action...

Read More

Simple MySQL commands

Simple MySQL commands MySQL is a database system used by many sites in order to maintain a functional database for web use. The system is easy to install and further used by doing simple configuration to the system.  Below are some of the simple commands to be used in MySQL that further provides easy functioning in the system. The commands used on MySQL helps in the direct interaction with the database on the server. Such commands...

Read More