Announcement

#1 2023-10-20 22:17:27

pebel
Member
2020-08-24
9

Msql

Problem
my hard disk where the msql data is is defective
how can I restore the MSQ tables ?
I have seen that in the folder "install/db" 100-database.php data are kamm one there somehow the MSQL file again restore

Offline

 

#2 2023-10-21 00:06:09

BigIsland270972
Member
Norway
2022-03-15
374

Re: Msql

Find the mysql database folder and backup.


Piwigo 14.0 | https://fotoarkiv.no | https://foto.arki.vet | http://Bergen.gallery  | http://Ålesund.gallery | http://geiranger.gallery | http://fjord.photos | http://foto.oslo.no
Apache | PHP 8.1 | MariaDB

Offline

 

#3 2023-10-21 11:42:40

pebel
Member
2020-08-24
9

Re: Msql

Where can I find it ? because the system disk where msql was is defective

Offline

 

#4 2023-10-21 14:22:25

erAck
Only trying to help
2015-09-06
2043

Re: Msql

We don't know where you backup-ed your database to, if at all. If you don't know either, you probably didn't. So you can't restore.

If your database is broken beyond repair, the easiest is to just install fresh from scratch. Create a new MySQL database with credentials, remove the local/config/database.inc.php file and then point your browser to install.php

If you're using physical albums, you then could sync again. For virtual albums the files exist under upload/ but there's no association whatsoever to images in albums nor tags, so those somehow would have to be reimported, don't know if there's a plugin or script that would help with that.

Good luck.


Running Piwigo at https://erack.net/gallery/

Offline

 

#5 2023-10-21 22:25:11

pebel
Member
2020-08-24
9

Re: Msql

Thanks
So it does not work the msql tables are all empty

created a new database
deleted local/config/database.inc.php
http://xxxx.xx/P0/install.php

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact