Posts

Showing posts from January, 2016

http://askubuntu.com/questions/30072/how-do-i-fix-a-problem-with-mergelist-or-status-file-could-not-be-parsed-err

The computer gave me this output in a window: E: Encountered a section with no Package: header E: Problem with MergeList /var/lib/apt/lists/archive.ubuntu.com_ubuntu_dists_natty_main_binary-i386_Packages E: The package lists or status file could not be parsed or opened.      These terminal commands should solve your problem: First remove the Merge List by opening a terminal (Press Ctrl + Alt + T to launch) and run this command*: sudo rm -vf /var/lib/apt/lists/* Next, generate a new one by running a simple update: sudo apt-get update

Howto: Ubuntu Linux convert DHCP network configuration to static IP configuration

Howto: Ubuntu Linux convert DHCP network configuration to static IP configuration My friend wanted to know how to change or convert DHCP network configuration to static configuration. After initial installation, he wanted to change network settings. Further, his system is w/o GUI system aka X Windows. Here is quick way to accomplish the same: Your main network configuration file is /etc/network/interfaces Desired new sample settings: => Host IP address 192.168.1.100 => Netmask: 255.255.255.0 => Network ID: 192.168.1.0 => Broadcast IP: 192.168.1.255 => Gateway/Router IP: 192.168.1.254 => DNS Server: 192.168.1.254 Open network configuration file $ sudo vi /etc/network/interfaces OR $ sudo nano /etc/network/interfaces Find and remove dhcp entry: iface eth0 inet dhcp Append new network settings: iface eth0 inet static address 192.168.1.100 netmask 255.255.255.0 network 192.168.1.0 broadcast 192.168.1.255 gateway 192.168.1.254 Save and c

Barracuda

mysql > select version (); + ------------+ | version () | + ------------+ | 5.5.21 - log | + ------------+ 1 row in set ( 0.00 sec ) mysql > show variables like "%innodb_file%" ; + --------------------------+----------+ Variable_name | Value | + --------------------------+----------+ | innodb_file_format | Antelope | | innodb_file_format_check | ON | | innodb_file_format_max | Antelope | | innodb_file_per_table | ON | + --------------------------+----------+ 4 rows in set ( 0.00 sec ) mysql > SET GLOBAL innodb_file_format = barracuda ; Query OK , 0 rows affected ( 0.00 sec ) mysql > show variables like "%innodb_file%" ; + --------------------------+-----------+ | Variable_name | Value | + --------------------------+-----------+ | innodb_file_format | Bar

How to Back Up and Restore a MySQL Database

How to Back Up and Restore a MySQL Database If you're storing anything in MySQL databases that you do not want to lose, it is very important to make regular backups of your data to protect it from loss. This tutorial will show you two easy ways to backup and restore the data in your MySQL database. You can also use this process to move your data to a new web server.     Back up From the Command Line (using mysqldump)     Back up your MySQL Database with Compress     Restoring your MySQL Database     Backing Up and Restoring using PHPMyAdmin Back up From the Command Line (using mysqldump) If you have shell or telnet access to your web server, you can backup your MySQL data by using the mysqldump command. This command connects to the MySQL server and creates an SQL dump file. The dump file contains the SQL statements necessary to re-create the database. Here is the proper syntax: $ mysqldump --opt -u [uname] -p[pass] [dbname] > [backupfile.sql]     [uname] Your database username  

Ubuntu - Mount or unmount USB Drive

Image
Solution 1 : Try the Disks program (if you run Ubuntu with a GUI ). (check that the gnome-disk-utility package is installed) (make sure that udisk2 package is installed) Hit SUPER A to open the Application Lens and type Disks in the Search Applications field. ( SUPER is probably the key with the Windows icon.) In Disks you can play with the automount options. For example: You have to click on the little icon with the two gears and choose 'Edit Mount Options'. Solution 2 : Using the CLI (for a headless installation) Step 1. Check the blockdevices and the file systems that are assigned to those block devices. lsblk Here you see the blokdevice sdb with partition /sdb1. But it's not mounted. There's no file assigned to it. Step 2. What kind of device is sdb? sudo lshw or sudo lshw | less So the USB stick - the block device /sdb - has the logical name /dev/sdb. And the FAT32 filesystem on that stick has the logical name /dev/sdb1. Step 3. Mounting

Follow step by step guide to install webmin on Ubuntu 14.04 LTS Server

Follow step by step guide to install webmin on Ubuntu 14.04 LTS Server Step 1: Install all the dependencies of webmin . sudo apt-get install perl libnet-ssleay-perl openssl libauthen-pam-perl libpam-runtime libio-pty-perl apt-show-versions python Step 2 : To install always stable and latest release of webmin, use the following given URL. Here, we will download by using wget command in server. wget http://www.webmin.com/download/deb/webmin-current.deb Step 3 : Now install the downloaded webmin package. sudo dpkg -i webmin-current.deb Step 4 : In this section , we will learn how to manage the webmin service. To start webmin sudo service webmin start To stop webmin sudo service webmin stop To restart webmin sudo service webmin restart To check status of webmin sudo service webmin status Step 5: Set root password of Ubuntu system. For this you have to become superuser first and set the password. sudo su - passwd root Step 6: To access the webmin