It supports almost whole set of relational databases as well as few of the No SQL databases.ĭue to the number of features it provides, it is widely used on Linux, Mac and Windows based systems. It makes database management easier, faster and much efficient for users. TablePlus is a simple, lightweight and powerful GUI based database management tool. Start the mysql program, and then try to drop the affected database or databases using the DROP DATABASE command.In this article, I will take you through the steps to install TablePlus Database Management Tool on Linux. Mysqldump -all-databases -add-drop-database -add-drop-table -routines > databases.sql

Type the following command to export all of the databases to the databases.sql file: Save the changes to the my.cnf file, and then restart the MySQL server using the appropriate command for your Linux distribution: In the my.cnf file, locate the section.Īdd the following line to the section:.On Debian and Ubuntu, the my.cnf file is located in the /etc/mysql directory.

On CentOS and Fedora, the my.cnf file is located in the /etc directory.

The location of the my.cnf file depends on your Linux distribution:

Use your preferred text editor to open the my.cnf file on your server.

If you are using the InnoDB storage engine for a database table, you can run the InnoDB recovery process. Restart the MySQL server using the appropriate command for your Linux distribution: To try to repair a table, type the following command, replacing table with the name of the table that you want to repair: TMD files listed, type the following command to delete them: rm */*.TMD To do this, change back to the /var/lib/mysql directory, and then type the following command: ls */*.TMD If the previous command does not work, you can try deleting temporary files that may be preventing myisamchk from running correctly.

Tableplus ubuntu