How to install MYSQL

DOwnload installer of MYSQL for Windows

unzip the file in any kind of directory(d: or c:)

create a folder name mydata then copy the data from mysql folder to mydata folder

create a file in windows my.ini or my.cnf

[mysqld]

# set basedir to your installation path

basedir=D:/mysql

# set datadir to the location of your data directory

datadir=D:/mydata/data

-----Insert this on the my,ini or my.cnf
-----Edit d: if it is on c: the directory of your mysql

ENjoy

How to install mysql

download a installer of MYSQL for windows

..after downloading unzip the file in d: or c: or nay directory

just follow the next steps provided by the installer

Then install

LOG

LOG

Error Log

[Error log is like an indicator if the mysql was started or stopped, and the critical error that occur while the server is running. It is like a notification,  that will notify what is the current status of mysql or what is currently happening to the mysql. ]

General Query Log

[It is like your record of what the mysqld is doing. The process General Query Log will be like a record book where all the transaction, actions in mysql is recorded]

Binary Log

[Here, binary log is like where you can see the events that describe the database changes, also the statements that potentially could have made change. We can also see the information about the information of the time for an statement took to update data]

www.mysql.com - source of information

Optimize,Check,Repair,Table

OPTIMIZING, CHECKING, REPAIRING, ANALYZING TABLE

Optimize Table

***SYNTAX***
OPTIMIZE TABLE [tablename];

[To a pc, it needs defragmentation inorder for the memory spaces will compress, in mysql optimizing is an effective way of defragmenting the table. By the use of optimize table the allotted memory spaces for those table that have been deleted and the spaces of the existing tables will compress ]

Check Table 

***SYNTAX***
CHECK TABLE [tablename];

[check table is used for checking errors in the table. These errors might occur because of the storage format for a data type has changed, or the order has changed]

Repair Table

***SYNTAX***
REPAIR TABLE [tablename];

[This will help or used in repairing those corrupted table. This will help repair those particular table that has been corrupted so that is can use well and properly.]

Analyze Table

***SYNTAX***

ANAYZE TABLE [tablename];

[By analyzing the table will help to decide what should be a specific index to use or not use. We need to analyze tables because of lot of modification of a table, the optimizer might not chose the best index to be used. By this updated index information will be generated and will improve the performance]

www.mysql.com - source of information

What to define

Define me is about answer or uses of the syntax used in MYSQL or other related fields