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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s