Last updated on August 9th, 2022 at 09:55 amThis script will show you how to take complete MySQL database backup by running the PHP script. Then Email the backup file as an attachment. Steps involved Take complete MySQL database backup Gzip the file Send the file as an Email attachment. Modify these variables according to […]
Category: Mysql (Page 4 of 5)
Last updated on January 10th, 2023 at 02:08 pmThis tutorial focus on how we can use PHP to generate MySQL table to PDF. Along with simple PHP code we are also using FPDF library. You need to make sure that you Download Library first. Make sure to modify the database details according to your settings. […]
How to export data from MySQL table to csv using php
Last updated on August 19th, 2022 at 09:56 amYou can export data from MySQL table to CSV using php, I am providing complete code especially using mysql_connect for PHP Version 5 and below as well as mysqli_connect for PHP latest versions (5/6/7). Here is the content of MySQL table named mydb This tutorial require 1 […]
How to Run SQL Queries and Create Backups in phpMyAdmin
Last updated on November 8th, 2024 at 12:14 pmObjective: In this tutorial, you will learn how to run a MySQL query using phpMyAdmin and also steps to take backup of the database using the export option. Step 1: Login to PHPMyAdmin and Create a database. Check this tutorial on How to enable PHPMyAdmin authentication Note:-If […]
