If you are familiar with linux/unix, you will be very accustomed to the ability to kill (and start) processes from the command line. Linux gives you a very rich set of command line tools that simply don’t exist on Windows by default.
To interact with the services panel from the command line, Windows provides the Net utility. From the command prompt, you can use this utility to start, stop, pause and continue services. What most people don’t realize is that you can also use this to display a list of services that are running on your computer.
For this exercise, we will use the mysqldump utility the same as if we were backing up the entire database.
From a command prompt or terminal window, run this command:
Very simple, either use the clear command:
Run this command from a terminal window. This works on debian, ubuntu, and redhat. I’m sure it works on others but those are the only ones I have access to.
This approach works for any linux operating system, including Ubuntu, and is probably most often used in conjunction with web development work.
If you are doing any kind of PHP development, you’ll almost always be using Apache along with it. Here’s the quick and easy way to get PHP up and running on your Ubuntu box.
Repositories on Ubuntu are the locations that you can download software from. As a general rule, the default repositories don’t contain the right locations for most software packages that you’ll want to install. You will want to open up the /etc/apt/sources.list file, find and uncomment the following lines
There are many reasons you would want to restore a database from a backup file… But you should also test this on a test server just to make sure that your database backups are working correctly. Here’s the syntax:
Backing up your database is a very important system administration task, and should generally be run from a cron job at scheduled intervals. We will use the mysqldump utility included with mysql to dump the contents of the database to a text file that can be easily re-imported.
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 called root. You will use the mysqladmin utility from a command line to set the new password. Notice that there are two commands to be run.
By default, MySQL only allows connections from the localhost address. The configuration file is usually found in /etc/mysql/my.cnf
Simply open a new Terminal window and type in this command
Simply run this command:
Instead of having to constantly type in ‘sudo’ every time you need to make an admin change, you can use one of these commands to act as root.
The Ruby language makes it easy to create functions.
The Ruby language has a very simple control structure that is easy to read and follow.