5 minutes per day in Cent OS - 4 - Phpmyadmin and tarball source decompressing

1. Uploading and decompressing a tar ball.

Upload to fpt or vsfpt could be more convenience, I prefer FileZilla for those purposes.

Extract tr.gz. file

To extract one or more members from an archive, enter:
tar -zxvf {file.tar.gz}
If your tarball name is backup.tar.gz, enter the following at a shell prompt:
tar -zxvf backup.tar.gz

Extracting an Entire Archive

To extract an entire archive, specify the archive file name only, with no individual file names as arguments.

tar -zxvf backup.tar.gz

2. Create a database and import data from shell

Create database could be done by mysql command

To import the .sql file to a database, just use

mysql -u USERNAME -p -h localhost YOUR-DATA-BASE-NAME-HERE < YOUR-.SQL.FILE-NAME-HERE

In this example, import a 'foo.sql' file into 'bar' database using vivek as username:

 
mysql -u vivek -p -h localhost bar < foo.sql

3. Install PhpmyAdmin: