Mini Servers: Introduction: Difference between revisions

m
no edit summary
mNo edit summary
Line 54: Line 54:
!Comments
!Comments
|-align="center" style="background:#ffffff"
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: Apache 2.2.9 Portable|Server 1]]||Portable||451KB||1MB||2.2.9|| || ||8081|| 
|align="left"|[[Mini Servers: Apache 2.2.9 Portable|Server 1]]||Portable||416KB||870KB||2.2.9|| || ||8081|| 
|-align="center" style="background:#ffffff"
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: Apache 2.2.9 Service|Server 2]]||Service||402KB||821KB||2.2.9|| || ||8082|| 
|align="left"|[[Mini Servers: Apache 2.2.9 Service|Server 2]]||Service||402KB||821KB||2.2.9|| || ||8082|| 
|-align="center" style="background:#ffffff"
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: Apache 2.2.9 Portable - Authentication|Server 3]]||Portable||475KB||1.17MB||2.2.9|| || ||8083||align="left"|Includes htaccess, authentication and mod-rewrite
|align="left"|[[Mini Servers: Apache 2.2.9 Portable - Authentication|Server 3]]||Portable||441KB||1.22MB||2.2.9|| || ||8083||align="left"|Includes htaccess, authentication and mod-rewrite
|-align="center" style="background:#ffffff"
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: Apache 2.2.9 Portable - Authentication SSL| Server 4]]||Portable||1MB||2.89MB||2.2.9|| || ||8084/444||align="left"|As server 3 with added protection of SSL
|align="left"|[[Mini Servers: Apache 2.2.9 Portable - Authentication SSL| Server 4]]||Portable||995KB||3.02MB||2.2.9|| || ||8084/444||align="left"|As server 3 with added protection of SSL
|-align="center" style="background:#ffffff"
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: Apache 2.2.9 Portable - Authentication SSL Standalone|Server 5]]||Portable||1MB||2.87MB||2.2.9|| || ||8085||align="left"|As server 4 SSL Standalone no main server on port 8084
|align="left"|[[Mini Servers: Apache 2.2.9 Portable - Authentication SSL Standalone|Server 5]]||Portable||995KB||2.99MB||2.2.9|| || ||8085||align="left"|As server 4 SSL Standalone no main server on port 8084
|-align="center" style="background:#ffffff"
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable|Server 6]]||Portable||2.02MB||5.87MB||2.2.9||5.2.6|| ||8086||align="left"|Includes Guest Book
|align="left"|[[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable|Server 6]]||Portable||2.01MB||6.29MB||2.2.9||5.2.6|| ||8086||align="left"|Includes Guest Book
|-align="center" style="background:#ffffff"
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: Apache 2.2.9 PHP 5.2.6 Service|Server 7]]||Service||2.27MB||6.59MB||2.2.9||5.2.6|| ||8087||align="left"|Includes Guest Book
|align="left"|[[Mini Servers: Apache 2.2.9 PHP 5.2.6 Service|Server 7]]||Service||2.27MB||6.59MB||2.2.9||5.2.6|| ||8087||align="left"|Includes Guest Book
|-align="center" style="background:#ffffff"
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support|Server 8]]||Portable||2.47MB||7.93MB||2.2.9||5.2.6|| ||8088||align="left"|Includes Guest Book, PHP Mini SQL Admin and MySQL support enabled.
|align="left"|[[Mini Servers: Apache 2.2.9 PHP 5.2.6 Portable - MySQL Support|Server 8]]||Portable||2.44MB||8.24MB||2.2.9||5.2.6|| ||8088||align="left"|Includes Guest Book, PHP Mini SQL Admin and MySQL support enabled.
|-align="center" style="background:#ffffff"
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: Apache 2.2.9 Perl 5.10 Portable|Server 9]]||Portable||953KB||2.54MB||2.2.9|| ||5.10||8089|| 
|align="left"|[[Mini Servers: Apache 2.2.9 Perl 5.10 Portable|Server 9]]||Portable||918KB||2.66MB||2.2.9|| ||5.10||8089|| 
|-align="center" style="background:#ffffff"
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: Apache 2.2.9 Perl 5.10 Service|Server 10]]||Service||904MB||2.36MB||2.2.9|| ||5.10||8090|| 
|align="left"|[[Mini Servers: Apache 2.2.9 Perl 5.10 Service|Server 10]]||Service||904MB||2.36MB||2.2.9|| ||5.10||8090|| 
|-align="center" style="background:#ffffff"
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: MySQL 5.0.51b Portable|Server 11]]||Portable||1.85MB||10.2MB|| || || ||3311||align="left"|MySQL 5.0.51b Server running on port 3311
|align="left"|[[Mini Servers: MySQL 5.0.67 Portable|Server 11]]||Portable||1.87MB||10.4MB|| || || ||3311||align="left"|MySQL 5.0.67 Server running on port 3311
|-align="center" style="background:#ffffff"
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: MySQL 5.0.51b Service|Server 12]]||Service||1.85MB||10.2MB|| || || ||3312||align="left"|MySQL 5.0.51b Server running on port 3312
|align="left"|[[Mini Servers: MySQL 5.0.67 Service|Server 12]]||Service||1.85MB||10.2MB|| || || ||3312||align="left"|MySQL 5.0.67 Server running on port 3312
|-align="center" style="background:#ffffff"
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: MySQL 4.1.22 Portable|Server 13]]||Portable||1.46MB||6.38MB|| || || ||3313||align="left"|MySQL 4.1.22 Server running on port 3313
|align="left"|[[Mini Servers: MySQL 4.1.22 Portable|Server 13]]||Portable||1.46MB||6.57MB|| || || ||3313||align="left"|MySQL 4.1.22 Server running on port 3313
|-align="center" style="background:#ffffff"
|-align="center" style="background:#ffffff"
|align="left"|[[Mini Servers: MySQL 4.1.22 Service|Server 14]]||Service||1.46MB||6.37MB|| || || ||3314||align="left"|MySQL 4.1.22 Server running on port 3314
|align="left"|[[Mini Servers: MySQL 4.1.22 Service|Server 14]]||Service||1.46MB||6.37MB|| || || ||3314||align="left"|MySQL 4.1.22 Server running on port 3314
Line 260: Line 260:
'''''[[#top | Top]]'''''
'''''[[#top | Top]]'''''


== Server 11 - MySQL 5.0.51b Portable ==
== Server 11 - MySQL 5.0.67 Portable ==
A fully portable MySQL server ideal for leaning SQL it is possible to connect using phpMyAdmin. Alternatively use the built in MySQL clients '''mysqladmin''' and '''mysql'''. Automatically detects free drive letter to run on easily configured port change default 3311 to any other port not in use.
A fully portable MySQL server ideal for leaning SQL it is possible to connect using phpMyAdmin. Alternatively use the built in MySQL clients '''mysqladmin''' and '''mysql'''. Automatically detects free drive letter to run on easily configured port change default 3311 to any other port not in use.


Designed to allow multiple MySQL servers running on same PC, easy to set-up and configure.
Designed to allow multiple MySQL servers running on same PC, easy to set-up and configure.


# [[Mini Servers: MySQL 5.0.51b Portable|Introduction:]] Intro
# [[Mini Servers: MySQL 5.0.67 Portable|Introduction:]] Intro
# [[Mini Servers: MySQL 5.0.51b Portable#Specification|Specification:]] Short server specification.
# [[Mini Servers: MySQL 5.0.67 Portable#Specification|Specification:]] Short server specification.
# [[Mini Servers: MySQL 5.0.51b Portable#Support files|Support files:]] - How to download, unpack server and test.
# [[Mini Servers: MySQL 5.0.67 Portable#Support files|Support files:]] - How to download, unpack server and test.
# [[Mini Servers: MySQL 5.0.51b Portable#DOS (CMD) Prompt|DOS (CMD) Prompt:]] How to open and use a command window.
# [[Mini Servers: MySQL 5.0.67 Portable#DOS (CMD) Prompt|DOS (CMD) Prompt:]] How to open and use a command window.
# [[Mini Servers: MySQL 5.0.51b Portable#PHP|PHP:]] Test script to connect to this server and create a database.
# [[Mini Servers: MySQL 5.0.67 Portable#PHP|PHP:]] Test script to connect to this server and create a database.
# [[Mini Servers: MySQL 5.0.51b Portable#Change Virtual Drive|Change Virtual Drive:]] How to override auto detection.
# [[Mini Servers: MySQL 5.0.67 Portable#Change Virtual Drive|Change Virtual Drive:]] How to override auto detection.
# [[Mini Servers: MySQL 5.0.51b Portable#Change server default port|Change server default port:]] How to change default port 3308.
# [[Mini Servers: MySQL 5.0.67 Portable#Change server default port|Change server default port:]] How to change default port 3308.
# [[Mini Servers: MySQL 5.0.51b Portable#MySQL - Admin|MySQL - Admin:]] MySQL client to configure server.
# [[Mini Servers: MySQL 5.0.67 Portable#MySQL - Admin|MySQL - Admin:]] MySQL client to configure server.
# [[Mini Servers: MySQL 5.0.51b Portable#MySQL - Client program|MySQL - Client program:]] MySQL client allows you to enter SQL commands.
# [[Mini Servers: MySQL 5.0.67 Portable#MySQL - Client program|MySQL - Client program:]] MySQL client allows you to enter SQL commands.
# [[Mini Servers: MySQL 5.0.51b Portable#Summary|Summary]] Leading onto mini-server 12.
# [[Mini Servers: MySQL 5.0.67 Portable#Summary|Summary]] Leading onto mini-server 12.


'''''[[#top | Top]]'''''
'''''[[#top | Top]]'''''


== Server 12 - MySQL 5.0.51b Service ==
== Server 12 - MySQL 5.0.67 Service ==
A MySQL server running as a service ideal for leaning SQL it is possible to connect using phpMyAdmin. Alternatively use the built in MySQL clients '''mysqladmin''' and '''mysql'''. Easily configured port, change default 3312 to any other port not in use.
A MySQL server running as a service ideal for leaning SQL it is possible to connect using phpMyAdmin. Alternatively use the built in MySQL clients '''mysqladmin''' and '''mysql'''. Easily configured port, change default 3312 to any other port not in use.


Designed to allow multiple MySQL servers running on same PC, easy to set-up and configure.
Designed to allow multiple MySQL servers running on same PC, easy to set-up and configure.


# [[Mini Servers: MySQL 5.0.51b Service|Introduction:]] Intro
# [[Mini Servers: MySQL 5.0.67 Service|Introduction:]] Intro
# [[Mini Servers: MySQL 5.0.51b Service#Specification|Specification:]] Short server specification.
# [[Mini Servers: MySQL 5.0.67 Service#Specification|Specification:]] Short server specification.
# [[Mini Servers: MySQL 5.0.51b Service#Configuring MySQL|Configuring MySQL:]] Change paths to absolute.
# [[Mini Servers: MySQL 5.0.67 Service#Configuring MySQL|Configuring MySQL:]] Change paths to absolute.
# [[Mini Servers: MySQL 5.0.51b Service#install.bat|install.bat:]] Installs the server as a service.
# [[Mini Servers: MySQL 5.0.67 Service#install.bat|install.bat:]] Installs the server as a service.
# [[Mini Servers: MySQL 5.0.51b Service#uninstall.bat |uninstall.bat:]] Uninstalls the service.
# [[Mini Servers: MySQL 5.0.67 Service#uninstall.bat |uninstall.bat:]] Uninstalls the service.
# [[Mini Servers: MySQL 5.0.51b Service#console.bat|console.bat:]] Opens a command window to run MySQL clients.
# [[Mini Servers: MySQL 5.0.67 Service#console.bat|console.bat:]] Opens a command window to run MySQL clients.
# [[Mini Servers: MySQL 5.0.51b Service#Support files|Support files:]] - How to download, unpack server and test.
# [[Mini Servers: MySQL 5.0.67 Service#Support files|Support files:]] - How to download, unpack server and test.
# [[Mini Servers: MySQL 5.0.51b Service#Test|Test:]] Quick test guide.
# [[Mini Servers: MySQL 5.0.67 Service#Test|Test:]] Quick test guide.
# [[Mini Servers: MySQL 5.0.51b Service#Change drive letter and or folder|Change drive letter and or folder:]] How to move the server.
# [[Mini Servers: MySQL 5.0.67 Service#Change drive letter and or folder|Change drive letter and or folder:]] How to move the server.
# [[Mini Servers: MySQL 5.0.51b Service#Change server default port|Change server default port:]] How to change default port 3308.
# [[Mini Servers: MySQL 5.0.67 Service#Change server default port|Change server default port:]] How to change default port 3308.
# [[Mini Servers: MySQL 5.0.51b Service#MySQL - Admin|MySQL - Admin:]] MySQL client to configure server.
# [[Mini Servers: MySQL 5.0.67 Service#MySQL - Admin|MySQL - Admin:]] MySQL client to configure server.
# [[Mini Servers: MySQL 5.0.51b Service#Change Root password|Change Root password:]] How to change root password.
# [[Mini Servers: MySQL 5.0.67 Service#Change Root password|Change Root password:]] How to change root password.
# [[Mini Servers: MySQL 5.0.51b Service#MySQL - Client program|MySQL - Client program:]] MySQL client allows you to enter SQL commands.
# [[Mini Servers: MySQL 5.0.67 Service#MySQL - Client program|MySQL - Client program:]] MySQL client allows you to enter SQL commands.
# [[Mini Servers: MySQL 5.0.51b Service#Summary|Summary]] Leading onto mini-server 13.
# [[Mini Servers: MySQL 5.0.67 Service#Summary|Summary]] Leading onto mini-server 13.


'''''[[#top | Top]]'''''
'''''[[#top | Top]]'''''
== Server 13 - MySQL 4.1.22 Portable ==
== Server 13 - MySQL 4.1.22 Portable ==
This MySQL server is the last in the 4 series however it is still widely used by service providers hence included in the mini-series allowing code to be tested. With code tested on both MySQL series 4 and 5 you reduce incompatibility problems when transferring to a service provider.
This MySQL server is the last in the 4 series however it is still widely used by service providers hence included in the mini-series allowing code to be tested. With code tested on both MySQL series 4 and 5 you reduce incompatibility problems when transferring to a service provider.