debian-banner

Debian wheezy is a Debian distribution and development codename that was released after Squeeze to develop and update a lot of packages in order to make use of security build flags through dpkg-buildflags. Its function is to allow several protections over security concerns like predictable locations of memory values, stack smashing and more. Wheezy is the current aliases for testing distribution which packages that is testing is unstable and not completely fit and not ready for release yet. Wheezy distribution also contains modern packages and it is being updated constantly until it enters the frozen state and ready to be released.

This Debian distribution’s security updates are being provided by Debian testing security team. It is an automatically generated type of Debian distribution that is produced from uneven distribution by some sets of scripts that try to move packages that are on the verge of lacking critical bugs release. In order for a specific version of a package to move into testing or Wheezy distribution it should be in unstable stage for either 2, 5 or 10 days hinging on the upload’s urgency; it should be brand new and compiled on every architecture; it should not have release critical bugs that does not apply to the version that is currently in testing; its dependencies should be satisfiable by either by group of packages that are going to be installed or packages that are already in testing and lastly it is important that the operation for installing the package to testing does not break or damage any packages that is currently in testing.

This is a visual walk-through of an installation of Debian Wheezy. In this post I will show you how to install Debian Wheezy and I will use screenshots.

1. First download a Debian Wheezy installer from here:

http://cdimage.debian.org/cdimage/wheezy_di_rc1/i386/iso-cd/debian-wheezy-DI-rc1-i386-netinst.iso

Then burn that image to a CD and boot from it.
wheezy1

2. Choose the language to be used for the installation process.

w2

3. Select your location:

This will be used to set your time zone. You should choose the country where you have the server.

w3

4. Select your keymap: Continue Reading…

In this article I will show you some MySQL commands with examples.

1. MySQL Set Root Password

You can set the mysql root password from command line like this:

mysqladmin -u root password your_password

You can also change mysql root password if you forgot it using this tutorial: How to Recover MySQL Root Password

2. Change MySQL Users Passwords from the command line

mysqladmin -u mysql_username -h mysql_host -p password 'new_mysql_password'

3. How To Connect to Local MySQL Server

This is how you connect to your local MySQL server from the command line:

mysql -u root -p

4. Create a MySQL Database

The following command will create a new MySQL database after you are connected:

create database debiantutorials_db;

5. Backup MySQL Database with mysqldump

Backup a database to a .sql file:

mysqldump -u root -p debiantutorials_db > debiantutorials_db.sql

You can also compress the database with gzip on the fly while you are dumping:

mysqldump -u root -p debiantutorials_db | gzip -v > debiantutorials_db.sql.gz

6. Mysqldump and Skip Table

You want to dump a mysql database with one or more crashed tables and you get an error like this? Continue Reading…

When you will start using the Bash shell more often, you will appreciate these shortcuts that can save you very much typing time:

Shortcut Description

Up/Down Arrow Keys

You can scroll back to an old command, hit ENTER, and execute the command without having to re-type it.

history command

Show your complete command history.

TAB Completion

If you type a partial command or filename that the shell recognizes, you can have it automatically completed for you if you press the TAB key.
Search your command history with

CTRL-R

Press CTRL-R and then type any portion of a recent command. It will search the commands for you, and once you find the command you want, just press ENTER.
Scrolling the screen with Shift- PageUpandPage Down Scroll back and forward through your terminal.

CTRL + P

Does the same as the up arrow
CTRL + N Does the same as the down arrow

CTRL + G

Terminates the search function (escape does the same thing)
CTRL+ S Searchs forward in the command history.
CTRL + A Move cursor to start of line
CTRL+ E Move cursor to end of line
CTRL +B move backward within a line
CTRL + F move forward within a line
CTRL +D deletes characters and moves down the line
CTRL + K deletes the entire line
CTRL + X + backspace deletes all characters from cursors current position back
CTRL + T transpose text moves character down the li
ESC then c will convert the letter above the cursor to upper case
history –c will clear all of your history. Good for if your trying to hide command line passwords enetered.

These are some other commands that you will find very useful:

 

Command 

Description

clear

Clear the screen. This command clears  your  screen if this is possible.

echo

Display text on the screen. Mostly useful when writing shell scripts.

more

More is a filter for paging through text one screenful at a time.

less

An improved replacement for the more command. Allows you to scroll backwards as well as forwards.

grep

Search for a pattern in a file or program output.B y default, grep prints the matching lines.

lpr

Print a file or program output. lpr uses a spooling daemon to print the named files when facilities become available.

sort

Sort a file or program output.  Writes sorted files concatenated.

su

su – Switch User is the command that allows you to switch to another user account.

You will use these commands to find out and display some informations about your system or about users:

 Linux Command Description

ps

This will show a list with all currently running process (programs). The most often used command is ps -aux

w

This is showing what users are logged on and what they are doing.

id

This command prints your user ID and your group ID’s.

Example: for root the output looks like this: uid=0(root) gid=0(root) groups=0(root)

df

Report filesystem disk space usage. You will use the most the df -h (human readab) command.

du

This is called estimate file space usage and is used for disk usage for folders. du -s is the command that provides a summary for the current directory.

top

This command displays Linux tasks. Displays CPU processes in a full-screen GUI and is  a great way to see the activity on your computer in real-time. To quit you need to type Q.

free

Displays amount of free and used memory in the system.
cat /proc/cpuinfo
Displays information about your CPU.
cat /proc/meminfo
Display lots of information about current memory usage. Like free but with much more details.

uname -a

This command prints system information like kernel version, machine type, hostname, hardware platform, and others. use man uname for more details.
Page 2 of 41234