import and export MySql database via SSH

Problem to import mysql databse with phpmyadmin because of escape character, maybe time to try import via SSH then! To import your database using SSH:

mysql -u username -ppassword dbname < dbname.sql

To export your database using SSH:

mysql -u username -ppassword dbname > dbname.sql

Speed Up Wordpress - Fast Wordpress

Tips to speed up a wordpress blog:

15+ Tips to Speed Up Your Website, and Optimize Your Code!
--> here

***

Optimize the wordpress database:

Optimize your database tables without phpMyAdmin in one click for high performance.
--> WP DB Optimizer

***

Javascript compressor, CSS compressor

SQL Server Remote Connection

Free management tool: SQL Server Management Studio:

--> SQL Server Management Express

Or Toads:

--> Toad ™ for SQL Server Freeware

***

How do I configure MS SQL Express Server to allow remote connections?

--> Server Setup

***
If using a different TCP/IP port for your SQL Sever remote connection:

Sever name should use format: 192.168.1.1\SqlExpress,2301
Don't forget the comma!