I want to use an external folder as a database, and I don't know how

Dapplication's profile image Dapplication posted 4 years ago in General Permalink

Hello, as a newbie, I don't have so much idea about databases and such, but even with that little knowledge, I wanted to make a family photo archive with XAMPP+Piwigo on Windows. I have a 2 TB HDD that is split to two(150 gigs for Windows ans programs, 1.6 TB for the archive) and I downloaded XAMPP to 150 gig part. I actually downloaded it thrice in 1.6 TB disk but everytime it gave me some problems and I had to delete-reinstall everything. Now I want to actually just delete Piwigo-XAMPP part and not the database itself(with photos). So that I'd like to use XAMPP-Piwigo itself in 150 gig part while 1.6 TB will not be touched ever again. I don't even know how to ask this question in computer-programming general language(as you know, like "how to create an external disk to this Linux setup in this built") so that I tried to simplify the thing in my mind.

Best regards, Ibrahim.

Dapplication's profile image Dapplication posted 4 years ago Permalink

And while asking this, I want to ask another question.

I have some clips that was recorded in analog cameras that was converted to digital after, and when it was getting converted, they were not compressed. A SD or HD one and a half hour video is around 25-40 gigs, and just one part of the videos were 400 gigs.

And as you know, PHP has limitations for it and I tried to bypass it, but whatever I try, I couldn't manage to do it. Changed the 2 settings for max sizes to 0 in php.ini, changed the error_log to E_ALL incase it was getting to default because of a minor error(saw it in a forum, didn't work), changed LimitRequestModel to 0 in somewherelse, nope nope nope. Changed the browser in-case it was the problem, nope.

Any suggestions for it too?

I have an idea, I think if I directly copy the video to the database folder without tagging it would make it visible in Piwigo, and I can tag it later in it's site, but just like I said, the database is in the 150 gig part and the videos that I talked about are in external hard drives and I have to copy it directly to database.

Note: 2 TB HDD is split to two parts(150 gigs, 1.6 TB) if I said wrong, not two hard drives.

ansgar's profile image ansgar posted 4 years ago Permalink

Is there any question related to HeidiSQL in your posts?

Dapplication's profile image Dapplication posted 4 years ago Permalink

Is there any question related to HeidiSQL in your posts?

How to do it in HeidiSQL? As I said, I don't know anything about it.

ansgar's profile image ansgar posted 4 years ago Permalink

HeidiSQL is an SQL client. You cannot use a simple folder with it. Not sure how you came to the conclusion you can do that with Heidi?

Dapplication's profile image Dapplication posted 4 years ago Permalink

HeidiSQL is an SQL client. You cannot use a simple folder with it. Not sure how you came to the conclusion you can do that with Heidi?

As a newbie I thought the uploading files were dependant on the database itself. My mistake, sorry for the inconviencence.

ansgar's profile image ansgar posted 4 years ago Permalink

No problem, it's very ok to ask such questions here, I did not just get exactly what you are trying to do. I suppose using Piwigo is a good idea - a browser based gallery software, OpenSource - why not. Probably try and ask in their forum?

ansgar's profile image ansgar posted 4 years ago Permalink

You may also want to try out Resourcespace, a free DAM system, PHP based. We are running Resourcespace on an internal Windows Server with Apache and PHP, which is similar to your XAMP setup.

Dapplication's profile image Dapplication posted 4 years ago Permalink

You may also want to try out Resourcespace, a free DAM system, PHP based. We are running Resourcespace on an internal Windows Server with Apache and PHP, which is similar to your XAMP setup.

Thanks for letting me know resourcespace, I'll try it! And I asked it to Piwigo forum, and yes, it is indeed can be changed via them.

Please login to leave a reply, or register at first.