Looking to Build/Redesign a Website or Blog ?

To speak to Rakshit, call +91 968 704 2303

August 7, 2013

1 Comment

mysql-database-freelancer-developer-1

#144 – Table ‘.\phpmyadmin\pma_history’ is marked as crashed

All of sudden, when today morning i open phpmyadmin, it show me this error. #144 – Table ‘.\phpmyadmin\pma_history’ is marked as crashed and last (automatic?) repair failed. This error was continuously showing for every database i select and go to any table of that database.

June 12, 2013

1 Comment

mysql-database-freelancer-developer-2

[MySql] Import-Export Database command using Putty

I was working with one client who want to migrate MySql 4 to MySql 5. It can be easily done using the Export and Import feature of phpmyadmin. Problem here is with size of database. Size of the database is over 900mb. so phpmyadmin does not allow to import or export the database.

October 25, 2012

1 Comment

mysql-database-freelancer-developer-1

Import Large sql file from phpmyadmin

I was trying to import a 500mb file in phpmyadmin using import tab in phpmyadmin. When i select file and start import it shows me below error.
“You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.”

January 7, 2011

4 Comments

mysql-database-freelancer-developer-2

Differance between Clustered indexes Vs Non-clustered indexes

A clustered index is a special type of index that reorders the records in the table are physically stored. In non-technical way, you are telling the database to store close values to one another on the disk. This means, a table can have only one clustered index. This has the benefit of rapid scan / retrieval of records on any operation with clustered index values.

November 19, 2010

3 Comments

mysql-database-freelancer-developer-1

Difference Between Primary Key and Unique Key

Everybody knows about difference between Primary key and Unique key who is/was working with SQL. This is silly question but still in lots of interview, interviewer asking this question starting from Fresher post to Experience post. This is a basic question and you must be aware with all the differences. You may know the difference but may be not know all.

November 3, 2010

No Comments

mysql-database-freelancer-developer-2

Multiple MYSQL Database Connection in PHP

Do you want to make a MYSQL connection with multiple database in PHP? I am working on project where i need to use two database. I prefer not to make separate MYSQL connection for two database if both database is on same server and accessible by same user. You can simply use the database name before table name. Look at below code.

November 2, 2010

1 Comment

mysql-database-freelancer-developer-1

Multiple MYSQL Database Connection with Zend Framework

Do you want to make a connection with multiple database in Zend Framework? Today i worked on multiple MYSQL database connection in Zend Framework as my client wants separate database to reduce the load of site. Its very easy to manage multiple database connection with ZF. You just need to add below code in bootstrap.php file and use the db object accordingly.

October 29, 2010

2 Comments

mysql-database-freelancer-developer-2

Find a Lat/Long with in x miles/kilometer Radius

You are at the right place if you are looking for solution to get or check latitude and longitude is with in x miles of radius with given latitude and longitude. This is very easy with a single equation. Get all lat/long list from database if current lat/long is with in x miles of radius.

October 25, 2010

3 Comments

mysql-database-freelancer-developer-1

MYSQL Split/Explode function

Do you know any MYSQL split function or Explode function ? I guess no, as MYSQL does not have any function for split string or explode string. Today i need to explode one of my database field which contains latitude and longitude.

October 6, 2010

No Comments

mysql-database-freelancer-developer-2

Search MySql records Group By Year from DateTime

I am working with Mobile Ad networking site for one of my client and i wanted to get the yearly records from datetime field. Actually i am transferring hourly data in to different table to reduce load time of reporting page. For this, i need to combine records by yearly from date or datetime field