Archive for the ‘MySQL’ Category
Steps to Install MySQL & Configure Max_Packate_Size
Posted by: intelbot on: February 17, 2009
- In: MySQL
- Leave a Comment
1. Install mysql-5.1.31-win32.msi 2. Install mysql-gui-tools-5.0-r16-win32.msi 3. Open Start >Programs >MySQL > MySQL Administrator 4. press control, click on skip 5. Select Startup Variables 6. Select Advanced Networking Tab 7. Under Data /Memory Size check Max.packet size & change 1 M to 100 M 8. Apply Changes Click to Download MySQL.
Row ID in Mysql and Using it for Serial Number
Posted by: intelbot on: September 6, 2007
- In: MySQL
- 4 Comments
SET @rownum := 0;select @rownum :=@rownum + 1 AS rank,EmpID,EmpName,EmpCity from employeedetails where empname =’kiran’ Carry over a value from previous row.
Mysql service Error 2: the system cannot find the file specified
Posted by: intelbot on: June 21, 2007
Yesterday i tried to work on Mysql, but found that the mysql service was not started so i tried to figure it out the problem, i started the service from services mmc in windows xp i encountered an error: “Error 2: the system cannot find the file specified“. I googled and didn’t find solution to [...]
Enabling InnoDB Support in Mysql installed with XAMPP
Posted by: intelbot on: June 2, 2007
- In: Configuration | InnoDB | MySQL
- 1 Comment
Recently i installed XAMPP in my system to work on a project. I was creating a table with a foreign key in it,then i came to know that InnoDB Engine is not enabled and i tried to find how to enable it but i didn’t get a clear info at one place so i thought [...]
