Apache Friends Support Forum

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)???

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: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.

So so true.

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.

how to set??

if set mySQL server, can multiple user (i have 34 user) save difference database name (34 files name)???

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: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.

tq tq tq

how to so set up a central MySQL server and configure the clients to access this MySQL server i

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.

i am using deep freeze sw to protect all pc (40 units), if set up MySQL server.....
the file still save in server, right??

and client PC still protected by deep freeze, correct??

if to set up MySQL server,
after install xampp, can i set up MySQL server or need to install others sw???

Hi guys,

i use this thread because i have similar issue. If i disturb and i need open a new thread , delete my message and i will open a new one-


Xampp working on a drive D
If i move in another PC in drive F, it doesen't work cause it serach file in D:/xampp....

How can i move it and change D drive in F drive?

I tried read what you wrote here, but i coundt fix

Thanks
Ale

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.

robbynaish wrote:How can i move it and change D drive in F drive?

After moving Xampp to F, proceed to the Xampp Folder and run "setup_xampp.bat" once. This should fix the drive letters in your Xampp configuration. Keep in mind that network drive letters are unknown to Windows Services, if you are running Xampp (Apache/MySQL) as a service and F: points to a network drive (or a NAS), it wont find F: (resulting in error).

in mySQL, can use export to transfer file to another location??

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.

how to set my PC as server and client can save their file in my PC???
i am using windows 7