how to change save location

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

how to change save location

Postby cboys00 » 16. January 2018 06:21

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)???
cboys00
 
Posts: 23
Joined: 15. January 2018 02:27
XAMPP version: 3.2.2
Operating System: 7

Re: how to change save location

Postby Nobbie » 16. January 2018 11:28

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
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: how to change save location

Postby Altrea » 16. January 2018 11:45

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.
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: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: how to change save location

Postby cboys00 » 17. January 2018 05:59

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)???
cboys00
 
Posts: 23
Joined: 15. January 2018 02:27
XAMPP version: 3.2.2
Operating System: 7

Re: how to change save location

Postby Nobbie » 17. January 2018 11:04

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
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: how to change save location

Postby cboys00 » 18. January 2018 00:27

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
cboys00
 
Posts: 23
Joined: 15. January 2018 02:27
XAMPP version: 3.2.2
Operating System: 7

Re: how to change save location

Postby cboys00 » 18. January 2018 00:33

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??
cboys00
 
Posts: 23
Joined: 15. January 2018 02:27
XAMPP version: 3.2.2
Operating System: 7

Re: how to change save location

Postby cboys00 » 18. January 2018 03:38

if to set up MySQL server,
after install xampp, can i set up MySQL server or need to install others sw???
cboys00
 
Posts: 23
Joined: 15. January 2018 02:27
XAMPP version: 3.2.2
Operating System: 7

Re: how to change save location

Postby robbynaish » 18. January 2018 11:02

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
robbynaish
 
Posts: 11
Joined: 17. January 2018 10:48
XAMPP version: 3.2.2
Operating System: Windows 7

Re: how to change save location

Postby Nobbie » 18. January 2018 11:18

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.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: how to change save location

Postby Nobbie » 18. January 2018 11:22

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).
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: how to change save location

Postby cboys00 » 22. January 2018 02:07

in mySQL, can use export to transfer file to another location??
cboys00
 
Posts: 23
Joined: 15. January 2018 02:27
XAMPP version: 3.2.2
Operating System: 7

Re: how to change save location

Postby cboys00 » 22. January 2018 02:18

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
cboys00
 
Posts: 23
Joined: 15. January 2018 02:27
XAMPP version: 3.2.2
Operating System: 7


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 122 guests