Moving Large MySQL Databases

I was upgrading my client’s vbulletin forum from one shared hosting server to another. The old server’s control panel was cpanel and new one is plesk. so I had to manually move the database (which is around 2 GB in size). I tried phpmysql but phpmysql doesn’t support large SQL files, so the alternate option was to try using SSH. But unfortunately both the old and new servers doesn’t support SSH too. It took a lot of search using Google to get a utility named bigdump, I managed to execute the entire script in some easy steps using this utility. Open this in notepad or some other editor, change the connection settings and specify the SQL dump file. Upload bigdump.php and the SQL file to the new server. Open a browser and point where bigdump.php is located in your server. That’s all; this will execute the script in batches. Thanks to Alexey Ozerov for providing this wonderful script.

Language Integrated Query – Part 1

Microsoft Language Integrated Query (LINQ) offers developers a new way to query data using strongly-typed queries and strongly-typed results, common across a number of disparate data types including relational databases, .NET objects, and XML. By using strongly-typed queries and results, LINQ improves developer productivity with the benefits of IntelliSense and compile-time error checking.

LINQ to SQL is an object-relational mapping (ORM) framework that allows the direct 1-1 mapping of a Microsoft SQL Server database to .NET classes, and query of the resulting objects using LINQ

LINQ provide data access via the developers choice of language without using SQL. With in the context of the .Net plateform, LINQ is a set of extensions to the .Net Framework that encompass language integrated query, set, and transform operations.

LINQ is divided into three areas :

  1. LINQ to Objects – For in memory operations.
  2. LINQ to ADO.Net – For Database operations, This again divided to three.
    1. LINQ to SQL – For working with SQL Server Data
    2. LINQ to Dataset – for working with datasets, thus supports any database engine if it is supported by Dataset.
    3. LINQ to Entities – for working with Microsoft’s Entity Framework.
  3. LINQ to XML – for working with XML Data.

The main namespace for LINQ is System.Linq, which provides classes and interfaces that supports queries that use LINQ.

The name space System.Data.Linq provides classes and interfaces that facilitates LINQ to SQL, and System.Xml.Linq facilitates LINQ to XML.

A key feature of LINQ is that it supports complete query capabilities for any collection that implements IEnumerable or IQueryable.