How to delete a database in phpMyAdmin
Deleting a database in phpMyAdmin is pretty easy and straightforward, but also very dangerous. Make surea backup is available before
Read More
phpmyadmin
How to add a foreign key in phpMyAdmin
Adding a foreign key in phpMyAdmin is pretty simple, but the option might be difficult to find. Open the table
Read More
How to import an Excel file in a MySQL database in PHPMyAdmin
It is sometimes easier to work on some data in Excel, before importing in a MySQL database. In order to
Read More
PHPMyAdmin table content not displaying, table marked as crashed and should be repaired, client hasn’t closed the table properly – InnoDB tables
When tables are not getting displayed anymore, and the trick for MyISAM tables isn’t working (repair the tables from the
Read More
PHPMyAdmin table content not displaying, table marked as crashed and should be repaired, client hasn’t closed the table properly – MyISAM tables
After an operation on the MySQL database with PHPMyAdmin, for example complicated search queries that didn’t bring any result and
Read More
Create a MySQL table with automatic creation date and modification date fields in PHPMyAdmin
Creating fields with time stamps that contains the creation and / or the last modification dates in MySQL using PHPMyAdmin
Read More
XAMPP Apache cannot start Port 80 in use
Getting this issue when trying to start Apache on XAMPP ? 13:47:10 [Apache] Problem detected! 13:47:10 [Apache] Port
Read More
Import a large SQL file in PHPMyAdmin
If you are wondering how to be able to import a larger SQL file in PHPMyAdmin[1], the solution is pretty
Read More