tar -xzOf your_db_dump.sql.tar.gz | mysql -u USERNAME -pPASSWORD your_database
Here is a quick VirtualHost generator I made! It should provide you with a good VirtualHost + PHP setup, which includes:
- open_basedir folder restriction
- Separated access and error logs
- www and non-www aliases for domains
dpkg -S unxz
So the unxz binary belongs to the xz-utils package!
vmstat -S m
It’s a farily common occurrence to have a server only accessible through another server. So I was happy that Royal TS provided an easy way of handling this via their “Key Sequence” setting.
The basic idea is that we first connect to our jump server (ip 18.104.22.168), then we setup a Key Sequence that writes an SSH command to get into the internal server (ip 22.214.171.124)
So this is what the resulting key sequence should look like:
This requires you to first allow passwordless logins, via ssh-copy-id.
php -i | grep "PHP Version"
PHP Version => 5.5.3
Great collection of commands to make dmesg more useful:
Edit the file
Uncomment the line starting with #prepend domain-name-servers and set your dns servers. Below is an example using the Google Public DNS.
prepend domain-name-servers 126.96.36.199, 188.8.131.52;
(Note removal of hash sign at beginning and two comma-separated DNS servers.)
Reboot and you should be set. You can verify the servers in use by running
The IP for the DNS server will be at the bottom of the output, like this:
;; SERVER: 184.108.40.206#53(220.127.116.11)