User:Saul/notes

MySQL notes

connecting to MySQL,

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 apache2 mysql-server php5-mysql

cd /var/www

mv index.html index-old.html

echo "<?php phpinfo(); ?>" > index.php

Then you go to localhost in your browser and if it comes up with a php page saying lots of info that looks like this then it worked, if not you did a step incorrectly