How to export database

[AnnieHoney]

I have a 1.4 gallery that I want to update, but I don't have a cPanel or phpMyAdmin, does anyone how do I can export the database to make a backup before upgrading to 1.5*

[phill104]

You have your work cut out for you but there are ways. What access do you have? Just a basic terminal?

You could use the PHPmyadmin plugin for coppermine - https://coppermine-gallery.com/forum/index.php/topic,58906.0.html

If you have terminal access to your hosting then there are plenty of options but a lot of that depends on what versions of PHP etc you are using. There may be tools already installed such as backup2l, or you may have to go to the directory where the databases are stored and manually copy them. All this your host should be able to advise on better than we can as they know exactly what the setup is.

[AnnieHoney]

I don't have phpMyAdmin or any panel at all.It's a raw dedicated server with an outdate OS and php version. No cPanel or any other. I tried installing but it didn't work.
I do have SSH access

The site is hosted on a friends server, I don't have a way to contact the host and my friend has been too busy to do the proper upgrades. That's why I wanted to move the gallery to my host and upgrade it there

I could login on a ftp interface and copy the database files, but since they're not the same format and an actual SQL dump, I wouldn't be able to upload to my current host where I don't have SSH access

[phill104]

That is why I suggested installing the above plugin as it is a coppermine plugin that gives you PHPmyadmin.

If you cannot do that then you can use the mysqldump command as mentioned above in the format

Code Select Expand

  $ mysqldump -u [uname] -p db_name > db_backup.sql

[AnnieHoney]

thank you! i'll try that