Category Archives: mysql

Database basics: Connect to a Mysql Database

This tutorial is part of the Tutorial Series Database basics !, Let us learn and try to understand how connecting a mysql database works in PHP

Before learning how to connect to a database we should know how to create a database , For creating a database there are several methods that we can use , Some of the most common methods are Phpmyadmin , Cpanel Mysql database panel and Command line.

Let’s learn the method of connecting to the database, For this create a file called db_operations.php and put these contents there



Continue reading Database basics: Connect to a Mysql Database

BigDump — Mysql importer–Ideal for big wordpress blogs

As a wordpress consultant we come across many issues that require us to import or export large mysql database sets. And usually the clients don’t have ssh access.

Phpmyadmin is a great tool , But is a big fail when it comes to handle huge amount of mysql data. Usually ssh or some exporting tool is used for it.

Continue reading BigDump — Mysql importer–Ideal for big wordpress blogs