MySQL Program Deployment using XAMPP

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySQL Program Deployment using XAMPP

Postby markjco » 27. July 2011 15:21

Hello guys,

This is my first time posting here and I'm just new to XAMPP. Not quite sure how it is different from installing MySQL separately from their website, but from what I've read, this is faster and includes apache and Php so I went with XAMPP. My dilemma is, if I program a database system (not using the apache web server and Php development), just a plain MySQL database accessed by a C# written program, will I be able to deploy it as a full blown software? Can I run the program on a separate computer that does not have XAMPP installed?

My project is to make a simple inventory program that will run on any windows computer. The data will be saved on that computer, and the user won't have to bother with setting up the MySQL server and things like that to use the program.

Thank you very much for your time.

Regards,
markjco
 
Posts: 3
Joined: 27. July 2011 15:10

Re: MySQL Program Deployment using XAMPP

Postby Altrea » 27. July 2011 15:36

Hi markjco,

markjco wrote:from what I've read, this is faster

That depends. XAMPP comes preconfigurated so that all the single components are normally ready to use and can interact with each other. But it is not configurated to run really fast because the configuration is related on compatibility (with slower computers as well).

markjco wrote:if I program a database system (not using the apache web server and Php development), just a plain MySQL database accessed by a C# written program, will I be able to deploy it as a full blown software?

That depends too. You can run XAMPP portably (on an USB-Stick for example). BUT the component(s) have to be started by hand (no windows services possible) and the configured port(s) have to free.

MySQL is not the smallest DBMS so i don't know if that is a good choice for your needs.

markjco wrote:Can I run the program on a separate computer that does not have XAMPP installed?

Try it out. Copy the MySQL folder to any portable drive, switch it on another computer and try to start the MySQL Server.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MySQL Program Deployment using XAMPP

Postby markjco » 27. July 2011 15:55

Thanks for your reply.

So basically, if I use MySQL in XAMPP for the program I would have to carry the XAMPP software as well?

Will installing MySQL separately from its website differ from accessing it from XAMP in my C# development?

Thanks again.
markjco
 
Posts: 3
Joined: 27. July 2011 15:10

Re: MySQL Program Deployment using XAMPP

Postby Altrea » 27. July 2011 16:19

markjco wrote:So basically, if I use MySQL in XAMPP for the program I would have to carry the XAMPP software as well?

I haven't tried it yet to copy just MySQL on a usb device. XAMPP can run from USB. Thats why i said you should try it out.

markjco wrote:Will installing MySQL separately from its website differ from accessing it from XAMP in my C# development?

Sorry, i think i don't understand your question. Can you explain what you want to know exactly? :D
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MySQL Program Deployment using XAMPP

Postby markjco » 28. July 2011 16:01

I want to know what would be advisable, the difference, between using XAMPP and installing MySQL independently, if I would be developing a database program until production. I am not going to use apache and PHP as of now, just MySQL. :)
markjco
 
Posts: 3
Joined: 27. July 2011 15:10

Re: MySQL Program Deployment using XAMPP

Postby Altrea » 28. July 2011 16:51

I don't think that you can get a portable version of MySQL if you use the default installation file. Thats the big difference.
If you Google MySQL + USB or MySQL + portable most of the ressources will point to the XAMPP project or other portable webserver stacks.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 53 guests