The newest version of Xampp comes with Maria. If I should update from the old Xampp to the newer version, I have MySQL databases. Are they readable and compatible with Maria?
Answer Answered by Ian Gilfillan in this comment.
Software for web development. XAMPP is an open-source web development application distributed by Apache Friends, offering an entire development stack in one package. XAMPP comes with Apache HTTP, MariaDB, and interpreters for PHP and Perl. This makes XAMPP a quick way to deploy web development solutions even on a localhost. XAMPP takes away the hassle of setting up Apache, MariaDB, PHP, Perl, PhpMyadmin, FTP and Tomcat. XAMPP is configured with all the features turned on and optimised for speed and performance. Perfect solution for setting up a web server. Great alternative to WAMP or LAMP.
You don't specify versions, but yes, it is usually very easy to upgrade, and in some cases even easier than to a newer MySQL version.
Take a look at MariaDB versus MySQL: Compatibility for details.
Specify your computer login – PLEASE DO THIS!!The standard NetBeansProjects directory is in theDocuments subdirectory of your home directory and so it is important to identify then name of your home directorywhich is dictated by your computer login.If you don't know what your login is, or that you even have such a thing,look for your login as a directory name in the folder Key your computer login and click the Set Change button:Once you've done this, the value keyed in will be used throughout the documentto personalize it for your computer.
XAMPP Apache/Php with XAMPP MariaDBThis is the easiest combination to use. We'll assume you'vealready done the XAMPP Installation.Start up the XAMPP Control Panel as administrator and thenstart up both the MySQL and Apache services.Verify that the following URL is working:On Windows, this redirects to the so-called 'dashboard' site.
Establish the '/default' URLI want to map a dedicated URL to the directory which holdsyour Php projects. For definiteness, I will assume thatthis is yourNetBeansProjects folder. Also, fordefiniteness, I am going to use this as the dedicated URL:I will also assume the standard NetBeansProjects installation directory:Edit the following file (through Notepad++). Scroll to the endand make this addition:
Edit the Php init file: php.iniEdit the following file (through Notepad++). Search for timezone. Reset from the initial value (Europe/Berlin):
Php Command-line programThe Php command-line program isIf you want to make this usable simply as php,then add the folder c:xamppphp into the PATH. From the Control Panel, select
Php/MySQL Test Programs
Php Information Test ProgramGo into the NetBeansProjects directory and create this file:
Php PDO/MySQL test programIf necessary, prepare the standard MySQL setup with the test database accessedby the guest user with empty password. Test it first:Create and run the following program in the web server:
XAMPP Apache/Php with Native MySQLThis assumes you have installed XAMPP as inXAMPP on Windowsand have installed MySQL as in MySQL on Windows.Start the XAMPP control panel, but only start up Apache.Simply do all the steps in the previous 2 sections. Everything should work.
Native Apache/Php with Native MySQLThis assumes you have installed MySQL as in MySQL on Windows.Here we are not going to use XAMPP at all.Let's assume thatyou have the 'Windows Essentials' in place as described in NetBeans/JDK on Windows.In particular, you wantNotepad++ for editing and 7zip for extracting. You'll also definitely need to see file extensions.
Apache/Php SitesThe Php home site for Windows isThe Php choice suitable for use within Apache is the thread-safe version.According to the suggestions on the Php site, you should use Apache binaries found at the 'Apache Lounge':
Download SoftwareThe most significant choice for which package to download is basedon whether your machine is 32-bit or 64-bit. For simplicity, I'llassume it is 64-bit. If your computer is 32-bit, you'll have to makethe appropriate adjustments.The next choice is whether to download the most recent version or anolder version. I'll assume the most recent one (as of January 2017),compiled by VC14. These are the downloads:You also may need to install Microsoft's Visual C++ Redistributable for Visual Studio 2015 package installed on your computer. I would suggest waiting to see if 'Apache service' installation failsbefore fixing the problem(you should get the error about a missing DLL).The Apache Lounge Download site provides a link just abovethe Apache 2.4 binaries section. It says:
Running a command shell as administratorFor many purposes we need to run the command shell in this way:
- Click the Start button
- Type 'cmd' into the search field. Don't hit return.
- Wait for an entry with the name icon 'cmd.exe' to appear in the Programs list. Right-click on this entry and select 'Run as administrator'. Say yes when Windows starts throwing a fit.
Install Apache and Apache ServiceRight-click on the http archiveOpen the archive with 7zip. Then simply drag Apache24 into the C: folder and close the archive. Bring up an administrative command shell according to the previous section.From the command shell access the Apache bin directory:You may want to leave this command shell open throughoutthe development for ease of access.To install the Apache service type this command:If it is OK,you should see feedback something like:You may be queried to open a firewall entry for the Apache. Go ahead and 'Allow access'.
Start and control Apache serviceAfter installation, start the Apache service (from the administrative command shell) by doing:We can completely control the Apache service with the following commands(with obvious effects):After starting the service, test it out:You should see the congratulatory 'It Works!' message.Note that you can test configuration changes by:
Edit the Apache config file and make a '/default' URLEdit the fileRight-click on it and select 'Edit with Notepad++'. Go to the end of the file, add a few blank lines and this:
Restart Apache and TestFrom our administrative command shell, type:If there are no errors, test with this link:You should see the contents of the NetBeansProjects directory listed.
Install PhpFrom the c: folder, create the subfolder Then right-click on the Php archiveOpen with 7zip. This time click the Extract buttonand choose the newly-create folderFirst, copy this file into C:WindowsSystem32:Then access the already-opened Apache configuration file in Notepad++.Go to the end and add this:
Restart Apache and TestFrom our administrative command shell, type:If there are no errors, go into the NetBeansProjects directory and create this file see the Test Programs section above.
Create the Php configuration fileWhen Apache restarts the Php module willreload its own configuration taken from the file: If this initfile is not found, default Php configurations settings are used.There are two suggested files which can be serve as a basis:We will use the former because our interest is development. Make sure that you are viewing files extensions!Select and copy Paste the copy back into C:php and rename it:
Create a Php session folderIn the default Php configuration, session support assumes the existence of a folder which does not exist on Windows.Within the C:php folder, create a new subfolder by the name
Edit the Php configuration fileThe php.ini file is rather large, and so it is often easiest to use a search utility in the editor to locate the relevant configuration setting. Right-click on and select Edit with Notepad++.Look for and modify these settings:
- Default Timezone.Search for the 'date.timezone' and make the setting (suitable for the Middle Atlantic region):Make sure you remove the initial ';' comment character.
- Specify the session folder.We created the target folder in the previous section:Search for and modify this setting (forward or backward slashes are both OK):
- Set the extension directory.Php extensions are DLL files which provide extended functionality to Php.Look for 'extension_dir' and change the default setting to this:
- Add the PDO database extensions.Look for the 'Windows Extensions' section and within it, look for and uncommentthese lines by removing the initial semicolons:It's easiest to search for 'php_pdo'
- Error display settings (this is probably OK).In a production environment, error display should always be turned off so as to avoid the inadvertent revealing of server error information. Error display is extremely convenient for debugging in a development environment.Search for display_errors and verify that it is on:
- Error reporting level (this is probably OK).You'll also want the full error_reporting setting. Search for and verify this setting: