MySQL no-install

MySQL no-install

                How to use MySQL without installing it to your computer.  I will show to how you can do it.

First download MySQL no-install, download the latest version of it.

Second extract the install archive to the chosen installation location using your preferred Zip archive tool. Some tools may extract the archive to a folder within your chosen installation location. If this occurs, you can move the contents of the subfolder into the chosen installation location.

Third you need do create an option file If your PC uses a boot loader where C: is not the boot drive, your only option is to use the my.ini file. Whichever option file you use, it must be a plain text file example notepad.An option file can be created and modified with any text editor, such as Notepad. For example, if MySQL is installed in E:\mysql and the data directory is in E:\mydata\data, you can create an option file containing a [mysqld] section to specify values for the basedir and datadir options:

[mysqld]

basedir="E:\mysql"

datadir="E:\mydata\data"

Place this option file in C:\Windows

If you would like to use a data directory in a different location, you should copy the entire contents of the data directory to the new location. For example, if MySQL is installed in C:\Program Files\MySQL\MySQL Server 5.0, the data directory is by default in C:\Program Files\MySQL\MySQL Server 5.0\data. If you want to use E:\mydata as the data directory instead.

1. create a mydata folder or directory to E: and copy the entire data folder inside it from .

And that it you can now use MySQL;

Ho to use MySQL

1.       Open your command prompt and open a server using  >mysqld  -u root

2.       Open one more command prompt and open client using >mysql –u root

And that's it

Enjoy!!!!