Developers October 2024

developers@phpmyadmin.net

3 participants
2 discussions

Re: Problem with database
by William Desportes 25 Oct '24

25 Oct '24

Hello, It is not very clear about the "which is currently closed?" part. Can you explain a bit more ? > is it possible to see the database as text like on the website You can export a database as text, yes. -- William Deportes Le 2024/10/25 11:47, Izabela Kiżewska a écrit : > Hello, > I'm writing with a question- is it possible to see the database as > text like on the website, which is currently closed? Along with > photos? > > Regards > Izabela Kiżewska > Management Assistant > tel. 781 005 053 > > Studio CITY architekci > > 00-610 Warszawa, ul. Lekarska 8 > tel. 22 382 52 24 > > > 71-342 Szczecin, ul. Wincentego Pola 2/1 > tel. 91 882 82 80

1 0

phpMyAdmin as a web service
by team＠focuslab.it 22 Oct '24

22 Oct '24

Hello developers, and congratulations for the excellent work being done here ... I don't know anyone has ever had this need, but I'll try to pose the question: is it possible to call the phpmyadmin table export functionality via a php script, through the curl command, to export MySql db tables without having to use the phpmyadmin interface? I did some tests but, although php doesn't give me any errors, the exported .sql file is always empty (and no phpmyadmin errors are caught). I'm calling curl on the page, https://localhost/phpmyadmin/libraries/classes/export.php to which I pass (via curl options) authentication credentials, the name of the db and the table to export; (I have doubts about how to pass the token, if requested by script, but I would expect at least some authentication errors from phpmyadmin, and instead no errors...) I know that normally for this purpose I can use other main methods, like 1) export directly from a php script or 2) use mysqldump, but with the first method (php script) I don't get a precise and complete export like the one done by phpmyadmin (and this then causes me problems restoring the data), and for the second (mysqldump) the provider that manages the server prevents me, for security reasons, use exec() from php code; and also I can't just use a cron procedure to use mysqldump, as I would like to be able to export the db tables on demand. So I'm looking for alternative ways to export the MySql db in the optimal way as phpmyadmin does, and so I thought about using phpmyadmin as a web service, but I don't know if the idea is viable; thanks in advance to anyone with any advice; Giovanni

2 2

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

Developers October 2024