Uncategorized

quick commands to work with servers

sudo apt-get install php5 apache2 libapache2-mod-php5 mysql-server php5-mysql service apache2 restart mysql_secure_installation mysql -u -root -p import : mysql -u username -p databasename < filename.sql show tables INSERT INTO table_name1(fields you want) SELECT fields you want FROM table_name2 INSERT INTO database.tablename SELECT * FROMdatabase.tablename TRUNCATE TABLE `wp_posts` show columns from database.tablename

Uncategorized

Important links to work with your Vega and themes

1- my monitor  this link is very important for disable monitor of laptop and adjust my monitor with it’s resolution http://ubuntuforums.org/showthread.php?t=1243541 Have to create a script in /etc/X11/Xsession.d/ called “45custom_xrandr-settings” in my case I wrote EXTERNAL_OUTPUT=”VGA” INTERNAL_OUTPUT=”LVDS” xrandr –output $INTERNAL_OUTPUT –off –output $EXTERNAL_OUTPUT –auto in sudo gedit /usr/sbin/lightdm-session cvt 1680 1050 xrandr –newmode “1920x1080_60.00” 173.00 1920… Continue reading Important links to work with your Vega and themes

Uncategorized

virtual host on ubuntu

1- copy file from old one sudo cp /etc/apache2/sites-available/oldwebsite.com.conf /etc/apache2/sites-available/newwebsite.com.conf 2- edit it and replace all oldwebsite to new website and change the path sudo gedit /etc/apache2/sites-available/newwebsite.com.conf 3- enable it sudo a2ensite newsite.com.conf 4- restart apache sudo service apache2 restart 5- sudo gedit /etc/hosts you know what will you do . Right ? example of… Continue reading virtual host on ubuntu