Backup and Restore Xampp settings

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

Backup and Restore Xampp settings

Postby DFlow » 22. May 2016 08:36

Hello all, I have just started using Mysql and Xampp, and I configured my xampp with security passwords and users on my phpmyadmin, and i have an installer for my app that also installs xampp, but i don't know how to restore the previous xampp configs, any help on these? BTW i used the portable editions but they lack certain features and have bugs... i exported the 5.6.14 database and imported it in portable edition and i always give me an error, but other 5.6.14 on other machine works fine, and wondering how to backup and restore xampp settings...............
DFlow
 
Posts: 5
Joined: 22. May 2016 08:28
XAMPP version: 5.6.21
Operating System: Windows 10 Pro

Re: Backup and Restore Xampp settings

Postby Altrea » 22. May 2016 09:52

Hi DFlow,

There are no "global" XAMPP settings you could export or import. There are Apache configs, MySQL configs, PHP configs, etc.
Please be more specific what you exactly want to backup and restore.

You are talking about MySQL users, so maybe you want to export and import mysql users and privileges?
There are multiple ways to dump this information:
http://stackoverflow.com/a/9410698
http://dba.stackexchange.com/a/95933
http://www.uptimemadeeasy.com/linux/mys ... er-server/

Simply google for "export mysql user privileges". I am sure you will even find other solutions for this.

DFlow wrote:BTW i used the portable editions but they lack certain features and have bugs.

Which features are you missing? And which bugs did you find?

DFlow wrote:and imported it in portable edition and i always give me an error,

Which error? We need the full error message.

best wishes,
Altrea
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: Backup and Restore Xampp settings

Postby DFlow » 22. May 2016 10:28

Thank you for your quick response. After installing i am looking at [img]C:\Users\Dash-Ulziit\Desktop\Untitled.png[/img] and no option to secure my phpmyadmin.......... and anyone can access it............ i want to secure the phpmyadmin with a password and export that user and privileges. But when i try to add password to existing localhost, it gives me this [img]C:\Users\Dash-Ulziit\Desktop\Untitled2.png[/img], and cannot login at all.............. what am i doing wrong here? and can you please teach me how to add a picture?? hehehehee
DFlow
 
Posts: 5
Joined: 22. May 2016 08:28
XAMPP version: 5.6.21
Operating System: Windows 10 Pro

Re: Backup and Restore Xampp settings

Postby Nobbie » 22. May 2016 10:46

DFlow wrote:Thank you for your quick response. After installing i am looking at [img]C:\Users\Dash-Ulziit\Desktop\Untitled.png[/img]


You cannot show local pictures in the internet!

DFlow wrote:and no option to secure my phpmyadmin


PhMyAdmin is only a GUI frontend for MySQL, you cannot "secure" phpmyadmin, you only can secure MySQL. But it is safe anyway.

DFlow wrote:.......... and anyone can access it............


I dont think so. I also have a couple of Xampp installations and use them "out of the box". Please access my MySQL Database, you may destroy everything you find. Tell me, when you are ready.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: Backup and Restore Xampp settings

Postby DFlow » 22. May 2016 10:54

Ok, then how can i show images? and in previous versions, i could give passwords in the "hostname"page and when i access the "hostname"/phpmyadmin, it would ask username and password, but now, when i type "hostname"/phpmyadmin from any machine, i would access it freely, i want that feature from the previous versions............
DFlow
 
Posts: 5
Joined: 22. May 2016 08:28
XAMPP version: 5.6.21
Operating System: Windows 10 Pro

Re: Backup and Restore Xampp settings

Postby Altrea » 22. May 2016 10:57

In current XAMPP versions phpMyAdmin is only requestable from the computer XAMPP is installed on.
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: Backup and Restore Xampp settings

Postby DFlow » 22. May 2016 11:12

Ok so, that is very nice, and if i lock out the root users, no one can access the phpmyadmin from local computer or remote and databases can only be access via codes, right? then That would make it very much reliable, But if i extract the user files, and copy it after i install new instance, will it still work? but i cannot find mysql.db, mysql.tables_priv and mysql.columns_priv anywhere in the xampp folder...........
DFlow
 
Posts: 5
Joined: 22. May 2016 08:28
XAMPP version: 5.6.21
Operating System: Windows 10 Pro

Re: Backup and Restore Xampp settings

Postby DFlow » 23. May 2016 11:19

Ok, Can you please give my full instruction on how to backup the users files and restore them, if possible, i like a way to just copy and paste user files after installation.............
DFlow
 
Posts: 5
Joined: 22. May 2016 08:28
XAMPP version: 5.6.21
Operating System: Windows 10 Pro


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 83 guests