Backing up your database is essential for safeguarding your data. There are three (3) primary methods to accomplish this task. The first involves using MySQL commands, where you log into your server and execute specific commands. The second method is through a graphical interface like phpMyAdmin, providing an intuitive way to export your database. Lastly, […]
How to Backup Database Read More »
We all know that PHP 5.3.29 is an outdated version, and it is strongly recommended to use a more recent and supported version of PHP due to security and performance reasons. If you specifically require PHP 5.3.29, please note that installing it on a modern Ubuntu 20.04 system may not be straightforward. The purpose of
How To Install PHP 5.3.29 in Ubuntu 20.04 Read More »
For this article, I will be using VS Code to run the node.js application for the entire process then transitioning to the MySQL database UI. Upon opening the VS Code application access the terminal and install the following packages. After installing this packages, start by calling the MySQL module. Then, establish a connection to a
How To Load Data Into MySQL Database? Read More »
phpMyAdmin is a popular web-based application used to manage MySQL databases. However, forgetting the password for your phpMyAdmin account can be a frustrating experience. This blog post will provide a step-by-step guide on resetting your forgotten phpMyAdmin password in Ubuntu. By following these instructions, you can regain access to your MySQL databases. Step 1: Access
Resetting forgotten phpmyadmin password in Ubuntu Read More »
Log into phpMyAdmin. On the left-hand side of the phpMyAdmin dashboard, it shows the list of all databases available then click on the database you want to export. 3. Click the Export tab on the top menu bar. 4. phpMyAdmin has two export options: Quick and Custom. If you’re not familiar with SQL tables or want the simplest way, select Quick.
How to export database from phpMyAdmin XAMPP Read More »
STEP 1: Go to phpMyAdmin, click Databases in the top menu, and create a database. STEP 2: Click the database that you have created, then click on the Import button located at the top center. STEP 3: Under File to Import, click Choose file and select the database file you want to import. This is an .sql or .zip-file. STEP
How do I import a database to phpMyAdmin? Read More »
STEP1: Go to phpMyAdmin. In the left side column, there is a list of databases that are available or you have created. STEP2: Choose a database that you want to delete, here I want to delete the it_website database to guide you. When I click on it_website it will show all the existing tables within it. STEP3: Now
How to Delete Database in phpMyAdmin Read More »