User:Saul/notes

MySQL notes:
connecting to MySQL,
-u USERNAME -p
(change USERNAME to whatever you put as your user name when setting up mySQL)
then type your password.

exporting a file in mySQL,
mysqldump -u USERNAME -p DATABASENAME > FILENAME.sql
(change USERNAME,DATABASENAME and FILENAME to what there supposed to be!)

setting up localhost:
(you need to be in root and it will ask you about the mySQL user name and password make sure you remember them)
apt-get install php5-mysql
apt-get install mysql-server
apt-get install apache2
cd /var/www
mv index.html index-old.html
cd ..
mv wwwinfo.php into www/index.php
Then you go to localhost in your browser and if it comes up with a php page saying lots of info of your version it worked if not you did a step incorrectly