by
Bianca Gubalke
How to Backup a Database
As part of our weekly or monthly Security and System Maintenance routine to keep our own websites and/or blogs up and running, we should clean out the overheads and backup the database or databases in our cpanel.
We do the same for our Customers at
Web Design Consulting who trust they can relax while the Support & Maintenance Team ensure the Top Performance of their websites and blogs.

How to Clean Overheads in a Database
Due to a number of regular requests coming in, let me show you the quick and easy steps as to How to Clean Overheads in a Database – before you back it up:
1.
Log into your cpanel
2.
Go to “Databases” and here click on “phpMyDatabase”.
3.
On the new window that opens, to the left, you see all your databases in a vertical dropdown, in alphabetical order.
Now simply tick the first of these databases, and, on the table that now opens to the right, you see the “Overheads” to the far right and added up at the bottom of that column. This is the accumulated waste you want to get rid of by optimizing the table. It will clean your blog and make it faster.
What you now do is to tick “Check tables having overhead” (it’s in blue under “sum”) and as a result you will see the corresponding tables getting ticked, so you see exactly where your overheads basically came from.
As a next step you tock the little drop down to the right of “Check tables having overhead” saying “With Selected” and here you select “Optimize Table”.
Now let it do its job! Just wait a moment…
How to Backup a Database
Once it’s done, let’s continue exactly where we are… and I show you How to Backup a Database:
4.
At the top, click on EXPORT.
Don’t touch or change anything here… what you do is…
5.
At the bottom, tick “gzipped” and then on “GO” to the far right.
6.
If you get a popup… select “Save File” and “OK”.
Now this database backup will download to your computer, to a designated folder or your “Downloads”. If you are on Firefox, you will see a note “One active download” to the bottom right of your screen. Call it up and let it do its job.
We tend not to pay too much attention to backups as there’s always sooo much to do… I know!
However, may this little Tutorial help you to rather be safe than sorry.
And besides, if you don’t want to bother with this, remember that you can have backups automatically done for you on our
Best Web Hosting Services for just $6 a year – perhaps a smart thing to do; think about it!
| Author: Bianca Gubalke, Art, Media, Publishing.
Co-Founder of YORGOO, YCADEMY and Semiomantics.
If you enjoyed reading the above, please consider following future tips and strategies by RSS reader, Email delivery, or Kindle subscription. |
Read more...
by
Bianca Gubalke
Semiomantics Consulting
Our new WP Best eShop is evolving and we are pleased to see it already well positioned on Google Top 10.

WP Best eShop
WP Best eShop for Bianca Gubalke Products already features the following Categories and Products:
- Best Web Hosting Services
- Best Domain Name registration
- Best Graphic Design
- Semiomantics Author under WP Best Themes and CMS.
We notice little items that need correction in the stylesheet. . . which we will attack soon!
WP Best eShop is gonna rock!
| Author: Bianca Gubalke, Art, Media, Publishing.
Co-Founder of YORGOO, YCADEMY and Semiomantics.
If you enjoyed reading the above, please consider following future tips and strategies by RSS reader, Email delivery, or Kindle subscription. |
Read more...
by
Bianca Gubalke
Best Web Hosting Services
We are continuing the process of building our
WP Best eShop to feature my Personalized Web Design & Publishing Services and selected Digital Products.
After providing the most affordable way to register a domain name, we offer the Best Web Hosting Services combined with professional and reachable Web Hosting Support – so crucial when you are stuck and frustrated… and anyone who’s been online for a while knows all too well that noone escapes the tricky traps of the Internet – the point is to get over it as fast as possible and here a knowledgeable and reachable Support is priceless.
If you wish to go straight through to the shop (under construction and development), please click directly on the picture below…

Best Web Hosting Services
The mission of Best Web Hosting Services is to “equip every household with hosting, every individual with a website and every online business with appropriate solutions at the most aggressive prices and with the most comprehensive support and customized, fully managed solutions”.
Cheap Hosting Starter Pack
While we include the Starter Pack option in our WP Best eShop, I recommend you go
HERE to make your choice.
Unlimited Shared Hosting
The ideal Starter Pack: Get unlimited Shared Hosting for just U$35.00 for a whole year or
Pro Hosting Packs
Alternatively, consider any of our PRO and/or Reseller packages.
- Hosting Reseller Plan (WHM)
- Semiomantics Pro Hosting for Advanced Semiomantics Publishing
- VSM 20GB Allocated Virtual Managed Server where you sell WHM Reseller Packs.
Advantages of the WHM Reseller Packs
- Increased configuration and flexibility
- Increased uptime and security
- Full Root access
- 100% Management and Monitoring (where we take care of your server and you of your sales)
- The ability to sell reseller accounts
- Based on a Dual AMD Opteron 275, 8GB ram and 20GB HD space dedicated to you.
Need a Domain Name
Important: to set up your Hosting, you will need a Domain Name – which you can either buy directly on Best Web Hosting, transfer to it, or update your name server on an existing domain accordingly.
Web Hosting Support
It’s easy and safe… but if you need some personal assistance to help you with your choice please contact me
HERE.
| Author: Bianca Gubalke, Art, Media, Publishing.
Co-Founder of YORGOO, YCADEMY and Semiomantics.
If you enjoyed reading the above, please consider following future tips and strategies by RSS reader, Email delivery, or Kindle subscription. |
Read more...
By Yorgo Nestoridis
Best WordPress Business Themes
To implement the WP Best Project we will start by setting up our site based on some important choices.
1. Hosting WordPress
While many hosts allow for easy WP set-up using Fantastico from cPanel, the hosting packs vary and do not always provide the needed quality for a feature rich WP based website.
Thinking ahead and considering the increased use of Media in connection with WP sites, we have built a hosting pack with unlimited space and bandwidth at the lowest rate ($35 per year) in collaboration with Hosting South Africa and ChiHosters.
For special needs, power-blogs and large sites needing increased Memory (64 MB or 128 MB) we are using specially set up servers with tariffs up to $34.95 per month including maintenance.
For the purpose of the WP Best Project, a $35 solution is perfect.
2. Domain
To personalize our business we use either a Business Brand or our personal Name. In the cae of the WP Best Project, I will use my existing name domain and add a sub-domain called wpbest.yorgonestoridis.com. Another idea was to call it consultant, wpconsiltant or similar.
You can now find the site HERE.
3. Best WordPress Business Themes
For years Semiomantics has built the best WP Business Themes by developing frameworks and scripts based on the work of the greatest designers and code developers out there. By associating the best web designs with the best scripts and by recoding, tuning and optimizing the frameworks, Semiomantics websites have the most extraordinary Google Top 10 performance. Semiomantics Websites are not for everybody as they come in limited editions only.
For the Purpose of the WP Best Project I have selected the latest WP Business Theme by Semiomantics.
The theme allows to present Featured work and Services on the compelling home page and to personalize it with just a few mouse clicks by filling in the blanks from the admin dashboard.
Look out for the next post, where I will show you how to make the best use of the site Theme by adding content and using the built in features.
| Author: Yorgo Nestoridis, Media Marketing & Publishing, Founder of YORGOO Publishing, YORGOO Press and Semiomantics.
If you enjoyed reading the above, please consider following future tips and strategies by RSS reader, Email delivery, or Kindle subscription. |

This page is wiki editable click here to edit this page.
Read also: