I experienced the problem with my Ubuntu 12.04 installation a couple of days ago related to the updating process. The error message was:
Could not get lock /var/lib/apt/lists/lock - open (11: Resource temporarily unavailable)
If you have the same problem here are the steps that could solve the issue
utf8_unicode_ci is based on the Unicode standard for sorting. utf8_general_ci is very close, but is NOT Unicode compliant, because compromises have been made to make it faster. Despite it is a little bit slower we recommend using utf8_unicode_ci if your site need to handle non-enlish characters.
In Unix and GNU/Linux systems, the name of the tar command is short for tape archiving, the storing of entire file systems onto magnetic tape, which is one use for the command.
However, a more common use for tar is to simply combine a few files into a single file, for easy storage and distribution.
Here are the step by step instructions for renaming a table in phpMyAdmin:
1) Log into cPanel
2) Click on the phpMyAdmin link at the bottom
3) In phpMyAdmin screen select the database that contains the table you want to modify. Tables in selected database will be listed.
4) Click the table you want to modify.
5) Click the Operations link at the top of the page
6) In the Table options, there is the field "Rename table to"
7) Enter new table name and click Go.
Here are instructions how to sort lines in Notepad++.
1) Start Notepad++
2) Go to Plugins > Plugin Manager > Show Plugin Manager
3) List with available plugins will appear
4) Find and check "TextFx Characters"
5) Click Install
6) Select rows you want to sort
7) Navigate to TextFx > TextFx Tools
8) Check or uncheck "+Sort ascending"
9) Select "Sort lines case sensitive (at column)" or "Sort lines case insensitive (at column)"