i am lab admin, i using deep freeze sw to protect all pc (40 units)
now problem is after install xampp....it cannot save the database....
how to change save location like to personal pendrive or NAS (network attach storage)???
Nobbie wrote:In my opinion, it's a bad design to transfer the data to a NAS. Instead, use the network functionality of the MySQL server (!), so set up a central MySQL server and configure the clients to access this MySQL server instead of localhost. It makes sense that way around.
Nobbie wrote:Use the "Datadir" option from MySQL/MariaDB config file my.ini (not sure in which folder, somewhere in mysql, search with explorer if you dont find it). Keep in mind that Windows System Services cannot access user specific drive letters. You may have difficulties with NAS and Pendrives therefore.
In my opinion, it's a bad design to transfer the data to a NAS. Instead, use the network functionality of the MySQL server (!), so set up a central MySQL server and configure the clients to access this MySQL server instead of localhost. It makes sense that way around.
Nobbie wrote:of course, professional webhosters applys databases for thousands of users. With the the help of phpmyadmin you can create as many users as you need, each of them with its own database (if needed). You may also share databases between users, everything is possible.
Nobbie wrote:Use the "Datadir" option from MySQL/MariaDB config file my.ini (not sure in which folder, somewhere in mysql, search with explorer if you dont find it). Keep in mind that Windows System Services cannot access user specific drive letters. You may have difficulties with NAS and Pendrives therefore.
In my opinion, it's a bad design to transfer the data to a NAS. Instead, use the network functionality of the MySQL server (!), so set up a central MySQL server and configure the clients to access this MySQL server instead of localhost. It makes sense that way around.
cboys00 wrote:if to set up MySQL server,
after install xampp, can i set up MySQL server or need to install others sw???
robbynaish wrote:How can i move it and change D drive in F drive?
Nobbie wrote:cboys00 wrote:if to set up MySQL server,
after install xampp, can i set up MySQL server or need to install others sw???
On the client PCs you dont need any SQL software. Of course Xampp installs MySQL (i dont know if one can choose at installation time, whether to install certain parts or not), but that does not matter anyway. You dont need to start the clients MySQL (its not needed). Even if you start it, it wont have any effect to your central server.
The only thing you have keep in mind, when running PHP scripts which access MySQL, you MUST NOT use "localhost" for the connect, instead use the LAN IP (or servername) of the MySQL Server. And also apply the username (which you created on the Server) and password instead of "root".
Finally - why do you put Apache on each client PC? You also could put that on the same server as MySQL, you could also create userspaces on the server where you put the userfiles and then you have a clean server/client architecture. There is no need to put a server environment like Xampp on client machines, thats kind of odd.
Users browsing this forum: No registered users and 132 guests