ubuntu - install LAMP server with one click

tasksel is a good service for installing LAMP on ubuntu 12.04 and 11.10

sudo apt-get install tasksel

sudo tasksel

this can be used to install postgreSQL and many others

ubuntu - preventing apache and mysql from auto start when computer starts

• apache2 uses System V style init scripts. To disable it from boot:
  sudo update-rc.d -f apache2 remove
• However, mysql uses an Upstart job, to disable it, create an "override" file:
  echo "manual" | sudo tee /etc/init/mysql.override

To learn more about override files, see: The Upstart Cookbook

backup and restore mysql in ubuntu

although i use ubuntu with shell, you can use whatever linux's distribution, command should like the same

backup mysqlmysqldump -u [username] -p [password] [database'name] > [backup'sname]
exp: mysqldump -u root -p 123 mysite > mysite.bak.sql


restore from file backupmysql -u [username] -p [password] [database'name] < [backup'sname]

note that the only different is mysql <> mysqldump and > <> <exp: mysql -u root -p 123 mysite < mysite.bak.sql
click here for more details

happy coding!