We’ve already shown you how to create a backup of your MySQL server from the command line, but it’s very important to know how to restore that data just in case you should need to recover from a failure. You should also make a point of testing out your recovery process on another box, just to make sure it’s working properly.
It’s very important to keep your database server backed up, and Linux makes this a trivial task from the command line. You should really put this into a cron job and run it daily (or more often), but for our purposes today, this is how to actually do the backup.
For every database, you should set the root or sa passwords to something other than the default, unless you want to get hacked. For mysql, the system administrator user is usually called root, but sometimes it’s called admin or something else.
In our previous article, we showed you the fastest way to go from a simple list of users to their creation in Active Directory. However, you’ll frequently get a list of users that will have extra data fields. Since we can’t write a script ahead of time for every possible scenario, we’ll show you how to take our user creation PowerShell script and modify it to suit your purpose.
Creating users through the AD Users and Computers snap-in is a very easy process, but you’ll frequently face the situation where you need to create accounts for a whole group of people at once. There’s no need for this to be a time consuming process for you though, and we’ve done all the heavy lifting so you don’t have to.
First, connect to the database:
Another great feature of Server 2008, is how the Delegation of Control Wizard simplifies adding rights for common tasks to groups or administrators.
There’s a quick way to do searches in Active Directory right from your start menu. We’ll show you how.
One of the first things to do in a new network is to create Users, also called User Objects. As long as you know the information about the user you need to create, the process will take no time at all.
If you’re a system administrator or power user, you may find yourself accessing Administrative Tools quite a bit. Today we show you how to access them faster by adding them to the Start Menu.
Sometimes you don’t have the time to sit in front of your monitor and click the Next button. Using an answer file to do new installs saves time, and we love saving a little time.
Installing a new Forest in Server 2008 is a breeze, mostly involving clicking the “”Next” button a lot. We’ll show you how.
The Shutdown Event Tracker is a great tool for enterprise admins to keep track of server shutdowns. There’s been more than one experience where we’ve been troubleshooting a downed server, and it would have been extremely useful to know what was going through the mind of the person who shut it off. But if you are not running an enterprise, or you just find it more annoying that useful, here’s how to shut it off.
If you are new to the world of Linux, you probably unzip your tar.gz files first, and then extract them from the tar file… at least, if you are even bothering to use the command prompt at all. It’s easy to gunzip or even bunzip2 the files with a simple command-line switch.
Creating a new user on Ubuntu server is easy—just sudo your shell to root, or run the following command:
Windows Server 2008 R2 is the latest version of Microsoft’s Windows Server operating system. Microsoft tries their best to make each task as simple as possible, and Server 2008 R2 is a shining example of that goal in action. We’re going to take you through a basic install and show you just how easy it is.
Finally another Friday has arrived and you’re sick of dealing with your IT department because they never fix anything. Today take a look at Server Quest II which is a fun game from Microsoft’s TechNet that puts you in the roll of an IT professional.
Want an easy way to share documents, photos, and other files with people over the web? Now you can with Opera Unite which is a new service to be included with the Opera 10 browser. Today we take a look the new Unite feature and what it has to offer.
This weekend we finally upgraded the HTG backend system to WordPress 2.8 from an ancient 2.0 installation, thanks to the hard work of Shawn, our new programming wizard.
This article was written by MetroTek Geek from Metrotek Solutions, a provider of Computer Help in the DC area.
One of the most talked about annoyances in Windows Vista are the UAC prompts that constantly pop up when you are trying to make system changes. It’s especially irritating when you often need to run a particular tool that requires administrator mode in order to run. Thankfully there’s a simple hack that you can do to create an administrator mode shortcut that doesn’t prompt for UAC.
One of the reasons we started the How-To Geek Blogs was to give bloggers the chance to focus on other topics that we don’t cover as regularly here. If you are interested in Windows Home Server, our very own Gmedia blog has been running a series covering the addition of a new server in his already impressive home media setup.
Editor’s Note: Online-Tech-Tips is a great site covering a wide variety of topics, and is well worth subscribing to.
Have you ever tried to unzip a file to the Program Files directory in Windows 7 or Vista? You’ll get all sorts of permission denied errors, and generally be unsuccessful. So how do we open up the zipfile as an administrator? For that matter, how do you open any file as administrator?
As regular readers know well, I’m a huge fan of using AutoHotkey to automate my entire computing experience… but in Windows 7 and Vista there’s a serious limitation since you can’t run a script as Administrator by default. This means that your hotkeys can’t interact with windows running in Admin mode… so how do we get around this?