console

Apache

Check status, start, stop, restart and reload:

/etc/init.d/apache2 status
sudo /etc/init.d/apache2 start
/etc/init.d/apache2 stop
sudo /etc/init.d/apache2 restart
sudo /etc/init.d/apache2 reload

Enable/disable modules:

sudo a2enmod module
sudo a2dismod module

Enable/disable virtual hosts:

sudo a2ensite test.my
sudo a2dissite test.my

MySQL

Start, stop, restart:

sudo service mysql start
sudo service mysql stop
sudo service mysql restart

To import sql dumps it's commonly used PhpMyAdmin. However, if the dump is too large, there some problems can appear such as file size limit, exceeding script execution time, memory shortage and so on.

So the best solution in this case (and the proper one) is to use mysql client utility via the console. For import sql dump we should use "source" statement.

tulvit@tulvit-desktop:~$ mysql -uroot -proot;
Welcome to the MySQL monitor.  Commands end with ; or \g.
mysql> use my_db;
Database changed
mysql> source ~/dump.sql;
...