portability - MySql portable version

Question

anyone know a portable version of mysql?

I know xampp but it comes with PHP and Apache together

anyone know how to isolate the mysql?

Answer 1

You can download the MySQL Essentials version and make a few small changes to directories in the my.ini file to use relative paths instead of absolute paths. Then you can run the server directly without having to install or use a Windows service.

1. Download a MySQL .zip file (instead of an .msi, though you could get the .msi and use 7Zip or Orca to extract the files from it).

2. Extract the files. At a minimum you need the bin and share directories (actually, in bin, you really only need mysqld.exe as the absolute minimum to run a server).

3. Edit my.ini to change the basedir and datadir paths to something relative. For example:

   basedir=".."
   datadir="/MySQLdb"
   

4. If you do not have an existing database, then create one:

   mysqld --bootstrap
   

5. Run the server (you may need to use the --skip-grant-tables switch to get it running until you have set up your MySQL user):

   mysqld
   

   • To avoid the server being run in the current command-prompt, you can use the following to have it run in its own console which should disappear once it is running:

     start mysqld
     

   • If you get errors, delete the log files (e.g., logsib_logfile*) and run it again.