MySql & Ubuntu , installation & uninstall (removing)

Installing MySql on Ubuntu

sudo apt-get install mysql-client mysql-server

Uninstall & Removing MySql on Ubuntu

sudo apt-get remove -y mysql-*

sudo apt-get purge -y mysql-*




Automated Scheduled Backup, MS-SQL Server 2008

MS SQL server 2008 has integrated automatic backup solution (both full and differential). Following links explains quite easy how to setup a scheduled backup and clean up (delete old backup files).

http://weblogs.asp.net/sreejukg/archive/2010/01/20/scheduling-automated-backup-using-sql-server-2008.aspx

Different editions of SQL 2008

Different editions of SQL Server 2008 :

• Enterprise Edition
  Data management and business intelligence platform providing enterprise class scalability, high availability, and security for running business-critical applications
• Standard Edition
  Data management and business intelligence platform providing ease of use and manageability for running departmental applications
• Workgroup Edition
  Data management and reporting platform providing secure, remote synchronization, and management capabilities for running branch applications
• Developer Edition
  May be installed and used by one user to design, develop, test, and demonstrate your programs on as many systems as needed
• Web Edition
  A low-TCO, scalable, and manageable database option for web hosters and end customers looking to deploy publicly facing web applications and services
• Express Edition (FREE)
  A free edition of SQL Server ideal for learning and building desktop and small server applications and for redistribution by ISVs
• Compact Edition (FREE)
  A free, SQL Server embedded database ideal for building stand-alone and occasionally connected applications for mobile devices, desktops, and web clients
• Evaluation Edition (Temporary FREE)
  This edition may be installed for demonstration and evaluation purposes until an expiration period of 180 days.

Source : http://www.quackit.com/sql_server/sql_server_2008/tutorial/sql_server_editions.cfm

Restoring SQL database in your new wordpress

1. You make a back up file of your SQL database from your Cpanel -> PhpMyAdmin -> Export*** You need to DROP all WordPress tables in your database to make room for the restore(This is a check box when you are exporting your DB).
   
2. You upload the file in your new hosting plan/new website on your Cpanel -> PhpMyAdmin -> Import
3. Blank page ??? Check your themes. Faulty theme can cause blank page. Try changing to another theme.