Databases

MySQL and MariaDB databases, phpMyAdmin, and database troubleshooting.

7 guides in this section.

How to Repair a Database in phpMyAdminRepair crashed MyISAM tables in phpMyAdmin, check which storage engine your tables use first, and find out what to do...

phpMyAdmin

How to Delete a Database Table in phpMyAdminDrop an unwanted database table in phpMyAdmin safely, taking a backup first, and decide whether emptying or renaming...

How to Edit a Database Table in phpMyAdminChange a single value in a database table with phpMyAdmin, such as a WordPress site title or URL in wp_options,...

How to Export a Database in phpMyAdminExport a whole MySQL or MariaDB database or a single table to a .sql file in phpMyAdmin, compress it, and check the...

How to Import a Database in phpMyAdminImport a .sql or compressed dump into an existing database with phpMyAdmin, work around the upload size limit, and...

How to Import and Export a Database with phpMyAdminExport a MySQL database to a .sql file and import one back with phpMyAdmin on any control panel, and move large...

How to Optimize a Database in phpMyAdminOptimizing a database rebuilds its tables so that the space left behind by deleted and updated rows is reclaimed and...