Database

How to connect PHP to MySQL database on another server using PDO and MySQLi

If normally the source code and database are on the same hosting server, you only need to set the server name to localhost. However, in many cases where we need to use an additional database or have an external server IP range, a little setup is required on this additional server. When connecting via IP […]

Read more...

Some useful MySQL query commands

This article lists some MySQL commands that may be helpful for you. I. MySQL commands 1. COUNT and GROUP BY If you want to display a list of how many tutorials are written by each user, you can use COUNT and GROUP BY. For example, we have the Blogs table as follows:     SELECT operator_id, count(*) as count […]

Read more...

Move large mysql database to new server

We all know the importance of a database in every system, in this article we ask you to back up, move database to another server. This will be easily handled if your db has a small number of records. And if the number of records is too large (a few million records or more) then exporting […]

Read more...

Optimize your MySQL Database Performance

MySQL is a free database management system widely used in PHP. When creating tables in MySQL there are many types of Storage Engine to choose from. MyIsam & Innodb & Memory are three popular types. Choosing a store tool is extremely important before you design the database, helping to improve query performance. If the store engine […]

Read more...

Automatically backup MySQL database with Batch file on Windows

Data backup is always very important in the way each system operates. In Linux you can easily automatically install the Crontab command, so what about Windows? We need to write code in Batch file and setup Task Schedule in Windows operating system. Very simple and fast. Task Schedule is available in Windows operating system. You […]

Read more...