When we originally installed MySQL, we used all the default locations. After a while, we realized that the default location of the data files were not on our largest partition, so we wanted to relocate where the files were kept. Making this move was relatively easy, once we figured out the right steps.
First, stop the MySQL server:
sudo /etc/init.d/mysql stop
Then, move your files (your
Do you need to use Money to keep the books for both your personal financial affairs and those of a small corporation or investment you own? You’ll probably want to segregate the data by putting each business into its own data file.
Do you need to use Money to keep the books for both your personal financial affairs and those of a small corporation or investment you own? You’ll probably want to segregate the data by putting each business into its own data file.
When to segregate your data into separate files
You would always want to use separate [...]
A local database file can be included as a file in a project. The first time you connect your application to a local database file, you can choose between creating a copy of the database in your project or connecting to the existing database file in its current location. For more information, see Local Data Overview. If you choose to connect to the existing file, then a connection is created just as if you were connecting to any remote database, and the database file is left in its original location. If you choose to copy the database into your project, Visual Studio creates a copy of the database file, adds it to your project, and modifies the connection so that it now points to the database in your project. Existing data connections in Server Explorer are modi
In a previous post, I wrote how you can backup your computer data to various media such as CDs, DVDs, external hard drives or online storage, but all of these methods require a good amount of effort on the part of the user having to go through many different folders and copying that to the backup media. And if this is done on a regular basis, you can end up spending hours just backing up your data!Luckily Windows has a built-in application that you can use to automatically schedule backups of your computer and it only requires you to choose the folders you want backed up ONE TIME. This makes backing up your data a lot less tedious and will make it much more likely to actually be done!So here are the steps to use Windows Backup Utility.1. Click on Start, All Programs, Accessories, System Tools, and then Backup.2. You will be prompted to go through the backup and restore wizard. This is useful for beginners, so we'll go ahead and stick with it instead of going to advanced mode. Go ahead
Making sure you back up your data is one of those really important, but not so urgent type of things that we hear about in self-help books! Unfortunately, since many of us have tons of personal, work-related, and business data on our computers, it is EXTREMELY important to back up your data!! Here's a short guide that I'll update later which will help you get started if you're one of those people who has no idea on how to go about backing things up!First thing to understand is that you can essentially back up two types of items: either the operating system and its associated files OR your data which is usually separately stored on another drive or in your My Documents or Desktop. First we're going to talk about backing up your data because that's usually more important than the OS. We'll talk about the operating system in another post!However you back up your data, make sure it's not on the computer! As silly as that may sound, I have seen many people who have simply copied thei
