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