Site hosting news, tutorials, tips, How Tos and more

Making a MySQL database backup using MySQL Workbench

banner-howto

Note: The manual methods in this tutorial are great, but if you’re looking for a “set-it-and-forget-it” automated backup solution, we offer a site backup service that can also back up your MS SQL and MySQL databases. Read about it on our site, or activate it in Control Panel. It’s easy, it’s inexpensive and it’s cool. What more could you ask for?

Making a backup in MySQL workbench is a pretty easy task once you know what to do, but it can be a little confusing the first time around. Allow us to save you some time with these simple instructions.

Version 6.3.7 is shown here, and of course future versions may differ. Download MySQL Workbench here (you’ll need a free Oracle account if you don’t already have one – just click the “Register” link in the upper right corner of that download page).

First thing you’ll need to do in Workbench is connect to your database.

workbench1

If everything is correct you’ll see the successful connection box.

workbench2

Go ahead and close that, and click the connection that you just set up.

workbench3

Click “Data Export.”

workbench4

There are a lot of options on the next screen. For the purposes of this how-to we’re just making a simple backup of the entire existing database, so we’re not going to use most of those options. But as you can see, you can do a lot more than just a simple database dump here.

workbench5

If everything goes according to plan you’ll see the “Export competed” dialog, and you’ll be all set. Your database is backed up for development use or simply for safe keeping.

workbench6

That’s all there is to making a backup.

But check out the “Data Import/Restore” link right under the “Data Export” link. As you might have guessed, you use that link to restore a locally stored backup up to the MySQL server here at Winhost. We’ll talk about that in a future article.



Control Panel layout changes

banner-announcements

We interrupt this blog to bring you an announcement regarding a few layout changes in Control Panel.

1. The Account ID moved to the very uppermost navigation – next to Account & Billing:

whcp01

2. The Related KB links on the right side column moved to the bottom – right above the footer:

whcp02

3. For most of the control panel sections, we expanded the main section to span the entire control panel width.

That is all.

Please proceed to have a great weekend.



How to Secure Your Primary Domain for Free When Ordering an SSL Certificate

banner-howto

When you order an SSL certificate from us, your primary domain name will be secured for free. So, if you order an SSL certificate for www.HostingAccountDomain.com, then HostingAccountDomain.com.com will be added as a Subject Alternative Name automatically.

So you can secure both www.HostingAccountDomain.com and HostingAccountDomain.com with just one certificate.

This works for any subdomain, not just for the www. prefix. You can order a certificate for login.HostingAccountDomain.com and HostingAccountDomain.com will be added to the certificate.

Here’s a sample certificate where you see both the subdomain and the primary domain secured:

Certificate Example

Note that this is only applicable to single-level domains. For example, www.test.HostingAccountDomain.com will not secure test.HostingAccountDomain.com.

This works for all of the certificates available through Winhost!



SQL 2016 is now available

banner-announcements

Today we’re announcing the availability of SQL 2016. It’s available now in the MS SQL Manager of Control Panel.

The new stretch database feature is enabled and you can learn more here. Some other new features include Query Store, Temporal Tables, and JSON Support.

And of course, there are no extra fees for SQL 2016 hosting.

SQL2016

 

 



New top level domain extensions are available

announcementsToday we are introducing 5 new domain extensions into the mix: .cloud, .club, .pro, .store, and .xyz. You can check out our website for domain pricing, or go to Control Panel right now to order a new domain name.

We plan to introduce more domain extensions, so if you have any suggestions, please let us know.



ASP.NET Core 1.0 is available now

announcementsWe have updated our Windows 2012 servers to support ASP.NET Core 1.0. This is the latest rewrite of ASP.NET from Microsoft (which they had previously called .NET 5). Learn more about .NET Core here.

If you want to use .NET Core 1.0 but your site is not on a Windows 2012 server, we can migrate you to a newer server. Just log in to the support portal and open up a ticket. We’ll take it from there. You can see the web server your site is running on in the Site Info section of Control Panel, under “Web Server.”



Upgrading DotNetNuke

howtoIt’s important to keep your web applications up-to-date. This prevents known vulnerabilities from being exploited and wreaking havoc on your site. That goes for any third-party software you might use on your site, but today we’re going to talk about updating DotNetNuke.

The most important thing before upgrading is to back up your current DotNetNuke site. Also, if you are using any third-party themes or modules, please contact the author(s) before upgrading to make sure they are still supported in the latest version of DNN.

Backing up the MS SQL database

This will place the backup of your MS SQL database within the App_Data directory with the file extension “.bak.”

Backing up your web site files via FTP

Downloading the upgrade files and Extracting

Important: you must know your SuperUser account login in order to upgrade.

You can download the Upgrade files through DNN’s download page.

Uploading the updated files

Upgrading



Summer Updates

banner-announcements

The latest versions of the following applications are now available through our App Installer tool: