Installing phpmyadmin to VPS/linux

You can manipulate your users and databases with SSH access, but then again its nicer and easier on the brain to make it trough visual interface (for most, some will probably work it faster in prompt). But for that you still need to install phpmyadmin through lines of SSH access.

Extracing tar files (without and with gzip or bzip) on Linux

When importing data you will probably be extracting or unpacking a tarball File
To unpack or extract a tar file, type:

tar -xvf file.tar

To save disk space and bandwidth files are saved using compression program such as gzip or bzip2. To extract / unpack a .tar.gz (gzip) file, enter (note -z option):

Archiving your files for migration /with folder exclussion

If you need to archive your files and you want to exclude some folders, for example "files" folder or some subfolders of files. You can use gzip for it

tar --exclude=sites/default/files/* --exclude=cache/* -cf file.tar . && gzip file.tar

And you will have a nice zip archive without folders you maybe don't want to transfer.

VPS LAMP stackscript additional settings to make it work

If you have some stackscript, like you might have on VPS like Linode, where you have automaticly installed some linux distribution like Debian, and then Apacher, PHP and MySQL are also installed, this will not work out of the box, you will still need to add some extra stuff on your VPS so you could install some drupal sites.

Database repair with phpMyAdmin

Sometimes your drupal DB will have problems, and it will cause slow queries, especially when having many nodes. Log to you phpMyAdmin and select all tables in DB and click optimize or repair, this could fix many problems and make your site run smooth again.