MySQL Forums
Forum List  »  MySQL Workbench

Re: Oversized database
Posted by: Mike Lischke
Date: July 20, 2015 12:49AM

Albert,

I assume by "oversized" you mean the tables grew very large. This problem however can hardly be solved with MySQL Workbench. Installations like Joomla require a certain set of database objects. You cannot simply delete some of them or your risk breaking the installation. Instead you should use the installations pruning feature (if there's one) to e.g. remove old postings, comments etc. Or, alternatively, create a new installation and take care to avoid what originally caused the db to grow that large (big attachments come to mind).

Independent of that you can of course connect to your Joomla installation using MySQL Workbench (or any MySQL client for that matter). Determine your credentials (server address, user name + password, port) and use them to set up a connection in MySQL Workbench as shown in my tutorial video: https://www.youtube.com/watch?v=DCgRF4KOYIY.

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/

Options: ReplyQuote


Subject
Views
Written By
Posted
1020
July 18, 2015 06:08PM
Re: Oversized database
449
July 20, 2015 12:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.