export database with date and password setting

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

export database with date and password setting

Postby Ptah » 12. April 2015 18:28

I have Windows 7 64 bit, xampp 5.6.3 browser used is Comodo IceDragon. I have three questions to ask and I hope this is in the right category.

1. When exporting the database the template is set as: @Database@ which gives me the following: filename.sql or filename.csv. I would like to have the file exported like this filenameYearMonthDay.sql. I have phpmyadmin installed separately on my other computer, not using xamp at all and I am able to do the following command _DB_-%Y%m%d to get for example: dbbook-20150412.sql. How can I set it in xamp phpmyadmin.

2. Although the database created will not be ever on the internet, it is just a personal file, I would like to set a password on it. I tried through phpmyadmin under users, it was accepted but when I went back into phpmyadmin it did not prompt me with a password. I tried your shell program and it did change but I got an error message from MYSQL saying access was denied when I tried getting back into phpmyadmin. As I could not logon on to phpmyadmin, I uninstalled everything and reinstalled it from scratch. I have read your FAQ document and I have tried those methods but I am not getting a prompt to enter password. I would to enclosed a user account picture to show you the users that are existing but I cannot attache it (dont know how) nor can I post it on the web - do not have server. I log on with http:/127.0.0.1 - I do not know what the others are as I am the only one who uses this computer and logon as administrator.[attachment=]Capture.png[/attachment]

3. I do not see a logout option when I am in phpmyadmin. I just use the X box that my browser has is there a method to close. Also the icon in the notification area when I click on it to "Quit" it gives the following error message "Error: Cannot create File: C:\xampp\xampp-control.ini. Access Denied". Other than that the program works - Apache and MYSQL run, and I can get into phpmyadmin.
Ptah
 
Posts: 8
Joined: 03. April 2015 16:19
Operating System: win 7 64 bit

Re: export database with date and password setting

Postby Nobbie » 12. April 2015 19:36

Ptah wrote:Iand I hope this is in the right category.


Definately NOT.

Ptah wrote:How can I set it in xamp phpmyadmin.


Whatever you did - PhyMyadmin is PhpMyadmin, it is not "Xampp" or any other thing. Whatever you did, you may do it in each PhpMyadmin installation. Xampp only delivers a pre-installed PhpMyadmin Installation, but it is still only PhpMyadmin.

None of your questions affects Xampp, Xampp is only an abbreveation for a software collection, there is no "Xampp" software. And most difficult: I have no clue, what is meant by "Comodo IceDragon". Couldnt you ask in a Comodo IceDragon Board?? What if you install it on a webserver, which is not configured by Xampp? Same questions, but what is the Xampp Part of it?? I cannot see it.
Nobbie
 
Posts: 13170
Joined: 09. March 2008 13:04

Re: export database with date and password setting

Postby Altrea » 13. April 2015 17:05

Ptah wrote:I have phpmyadmin installed separately on my other computer, not using xamp at all and I am able to do the following command _DB_-%Y%m%d to get for example: dbbook-20150412.sql. How can I set it in xamp phpmyadmin.

the same way

Ptah wrote:I tried through phpmyadmin under users, it was accepted but when I went back into phpmyadmin it did not prompt me with a password.
[...]
I tried your shell program and it did change but I got an error message from MYSQL saying access was denied when I tried getting back into phpmyadmin.

sure, because you don't adjust the phpmyadmin config that you want to use the password form instead of config based authentification.

Ptah wrote:I would to enclosed a user account picture to show you the users that are existing but I cannot attache it (dont know how)

This board does not provide any functionallity to attach any files.

Ptah wrote:nor can I post it on the web - do not have server.

On the net there are many one click image hoster. simply search for them.

Ptah wrote:I do not see a logout option when I am in phpmyadmin.

This is the default behavior for config based authentification. phpmyadmin only uses one single user in this mode.
Change the auth_type setting to the correct value and you will be able to use a login form as well as logout your user.

Ptah wrote:when I click on it to "Quit" it gives the following error message "Error: Cannot create File: C:\xampp\xampp-control.ini. Access Denied".

run the control panel with enhanced administrator rights (rightclick -> run as administrator).
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: export database with date and password setting

Postby Ptah » 08. May 2015 00:31

Just so that I understand your responses. If I set to save the database with this command _DB_-%Y%m%d will it work. Because I tried it and it did not. It only gave me the name of the database and the extension like: Books.sql which is not what I want. I would prefer: Books20150407.sql. Is there something that I have to change in phpmyadmin.

To change : auth_type value, where do I change in phpmyadmin or on the xampp control panel. What value do I change it to. :!: I appreciate your response. Thank you.
Ptah
 
Posts: 8
Joined: 03. April 2015 16:19
Operating System: win 7 64 bit

Re: export database with date and password setting

Postby Altrea » 08. May 2015 16:18

phpMyAdmin => choose the database => Export tab => Export method Custom - display all possible options => File name template @DATABASE@-%Y%m%d%H%I%S => works (tested with XAMPP 5.6.3)

PtahJust wrote:To change : auth_type value, where do I change in phpmyadmin or on the xampp control panel.

In the file \xampp\phpMyAdmin\config.inc.php

PtahJust wrote:What value do I change it to.

Depends. try "cookie" or "http" instead of "config"
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


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 126 guests