Export MySQL

This tutorial tackles on how to export MySQL database into .csv/CSV file using PHP/MySQLi. Usually, we export MySQL database using our phpMyAdmin and it is in .sql format but if you want it in CSV format, this tutorial will help you on how to achieve this. CSV stands for Comma-separated Values which is a simple file format used to store tabular data such as database.

Importing or Exporting a MySQL database sometimes using phpMyAdmin is a bit problematic especially if the size of your database exceed the maximum limit of PHP upload.