Some useful php scripts

Some useful php scripts
https://github.com/lornajane/PHP-Web-Services
I hope it helped. Feel free to comment...

Extract .tar unbuntu/linux terminal

tar -xvf filename.tar

I hope it helped. Feel free to comment...

Import / Export MySQL Database using Ubuntu terminal

To import .sql file into MySQL database

mysql -u mysql_user -p dabase_name < /path/import_file_name.sql

It will ask for the password, enter the mysql password and your sql script will be executed.

To export a database and gzip it, use

mysqldump -h localhost -u mysql_user -pMysql_password database_name | gzip > /path/export_file_name_$(date +%m-%d-%Y).sql.gz

$(date +%m-%d-%Y) is optional. It inserts today's date in the file name. You can also use this export command without   $(date +%m-%d-%Y)

 mysqldump -h localhost -u mysql_user -pMysql_password database_name | gzip > /path/export_file_name_$(date +%m-%d-%Y).sql.gz

I hope it helped. Feel free to comment...

check memory ubuntu terminal

 egrep --color 'Mem|Cache|Swap' /proc/meminfo

I hope it helped. Feel free to comment...

Extract sql.gz file from ubuntu terminal

 gzip -d file.sql.gz

I hope it helped. Feel free to comment...

Linux useful 20 tools

http://www.cyberciti.biz/tips/top-linux-monitoring-tools.html

I hope it helped. Feel free to comment...

Download a file using terminal in Linux

 wget "http://downloads.bitnami.com/files/stacks/lampstack/5.3.25-0/bitnami-lampstack-5.3.25-0-linux-x64-installer.run"

I hope it helped. Feel free to comment...