How to insert CSV data into MySQL database using Python in different ways

Introduction This example will show you how to insert CSV data into MySQL database table directly. So I am going to create insert SQL statement for inserting data individually or I will also load the csv data directly into the MySQL table. CSV means Comma Separated Value, so it’s a plain text data. Each line of the file is data…

How to Backup and Restore MySQL Database in CentOS

Backup and Restore This guide will show you how to backup and restore MySQL database using command line tool in VPS server on CentOS 7 and PhpMyAdmin. You need to take backup of your MySQL database on a daily basis to have minimal impact on your web site’s data loss. Similarly for some inconsistent situations you may need to restore…

Infinite dynamic Multi-level nested category with Codeigniter and MySQL

Introduction Here I will show you how to create infinite multi-level nested categories with Codeigniter and MySQL. In my previous tutorial¬†Infinite dynamic Multi-level nested category with PHP and MySQL , I wrote how to build a nested multilevel categories. So I am again going to write the same tutorial but this time with Codeigniter 3 framework. Prerequisites Codeigniter 3.1.11, PHP…

MySQL Event Scheduler

This tutorial will show you how we can use MySQL Event Scheduler to schedule or automate some tasks periodically at a particular interval. MySQL Events are tasks that run according to a schedule. Therefore, it is sometimes referred to as scheduled events. When we create an event, we are creating a named database object containing one or more SQL statements…

Find Full Path For Nested Categories In MySQL

Path For Nested Categories This tutorial shows how to find the entire or full path from root to child for nested categories and subcategories. Let’s say you have a table in database server in such a way that it contains an unlimited level of categories and you have another column in the same table which should contain the entire path…