back up old website database

[delia]

php 5.1.6, mysql 5.0.95, zc 1.3.9h

I tried using an old version of the backup mysql mod which did not export all the data. Then I used the most recent version and got nothing exported.

I tried a php script to export the database which only gave me a error message with no details so mysql, not a php error.

The host took over a month to get the ftp access set up correctly and there is no database access (and it is on another server as well). We have to move/upgrade this site as things are going screwy there and the site is essentially unusuable at this point due to some other ssl screwiness (probably old server stuff and not a new ssl cert)

Anyone have suggestions about how to grab this old database?

[balihr]

Adminer: https://www.adminer.org/

[delia]

I’ll check it out, thanks.

[delia]

I love it - small and easy! And it worked! Thanks again.

[carlwhat]

Adminer: https://www.adminer.org/

dude! i'm an adminer fan.

in fact, i have it integrated on all my sites once one is logged in onto the admin so there is no need to enter your DB credentials....

i was planning on a simple plugin for use (one still needs to download adminer from their site as the ZC plugins do not allow binary), but i was running into some headers already sent errors that i did have time to track down... perhaps i will now be inspired....

best.

[delia]

It’s not allowed in some hosting. Way too easy access for a bad actor.

[carlwhat]

only if you are not up-to-date:

"As discussed on our blog over two years ago, hackers are interested in Adminer versions below 4.6.3, which contain a security hole that allowing them to read files on servers using the LOAD DATA LOCAL INFILE statement...".

[delia]

no, there are hosts that automatically quarantine and delete it. This is more likely to be the case when phpmyadmin is already provided. It's a great alternative when you don't have access to phpmyadmin in cpanel but I do agree the use of it should be restricted, no matter the version.

[balihr]

Yeah, I love Adminer because it's super simple and gets the job done. But, I also keep a standalone copy of pmpMyAdmin on standby for cases where host automatically deletes Adminer. So, I just upload the entire pma folder, modify the config.inc.php if necessary and then access pma directly from browser and login with credentials from configure.php - works every time, that never failed me. The only difference is that Adminer is easier and faster to upload, as well as remove after I'm done.