Tutorial

I wrote a tutorial in the past about optimizing a Dolphin database using phpMyadmin. This latest tutorial is based on Dolphin 7.1.x screenshots, and includes a step by step walk through video that is easy to follow along with.

It is very easy to perform, and can be completed in a matter of seconds.

How to Optimize a Boonex Dolphin Database Video Tutorial




How to Optimize a Boonex Dolphin Database



Let's assume that someone added/posted a blog on our Dolphin 7.1.x website.

It might look something like this:

Dolphin Blog Post



Maybe it happens to be spam (we all know how much spam Dolphin tends to attract.), and we decide to just delete it.

So we login to the Dolphin 7.1 Administration Panel, and proceed to delete it from:
Modules
-Blogs

Scroll to the bottom of the page. Tick/check the box for the blog that we want to remove, and click the "Delete" button.

Delete Blog Post



After you do that, it will instantly create overhead in the database. Not a lot since it is just one post, but if you delete content and posts on a regular basis it does add up over time.

To optimize and remove any database overhead that this creates just perform the following steps.


How to Optimize a Dolphin 7.1 Database with phpMyAdmin


Step 1
Login to your hosts control panel.

Click and open phpMyadmin.

phpMyAdmin



Step 2
Find your Dolphin database on the left side of the page, and click on it.

Dolphin 7.1 Database



Step 3
Scroll to the bottom of the page.

Find and click on the "Check tables having overhead" link to select all the ones with overhead.

Then, in the drop down choose "Optimize table".

Optimize Dolphin Tables



Step 4
You should see a success message after doing so.

Dolphin Tables Successfully Optimized


That's it!


Note:
You do not need to worry about a few bytes or kilobytes of overhead in your Dolphin database. This is not something that you would need to do on a daily basis. Once or twice in a given month is usually more than sufficient for most sites.

Additionally:
The process is the same for previous Dolphin versions as well.

This is not Dolphin specific. If you use other CMS database driven scripts you can apply the same steps above to optimize them as well.

Be sure to watch the video tutorial near the top of this page for a complete step by step walk through on how to do this. It's around 5 minutes long.

 
Written By
Tutorial by: Jeremy LeSarge (AKA Ray)

I am the owner and administrator of DialMe.com. I write Tutorials for Boonex Dolphin as well as tips and resources surrounding website programming and development. I enjoy working with WordPress, SEO, and Web Hosting / Servers. I also maintain a WordPress Blog here on this site where you will find a variety of technology and webmaster resources.

Actions
Recommend
Sponsored Links