I have a mySQL database with information of landscapes.
Each landscape has several pictures(jpg) associated to it, stored on a separate mySQL database (not in the filesystem) on a Ms Windows Machine.
Each landscape record also has a date associated. So i can do querys to get pictures by date intervals.
At this moment the pictures database size is bigger than 70 GB. The hard disc drive is only 80 GB.
So im in problems because of disk space.
I need to dump part of the picture database to filesystem folders by quering by date, so i can backup every 3 months to DVD to keep the database size low. So i only have online the last 6 months of pictures.
I wish to give each DVD a correlative number. so when i query the landscape information database and points me to a record that has no pictures on the online image database it tells me the .jpg files are on the DVD #123 on the specified path (example: /dvd_123/id_landscape/ folder).
So the superuser can upload those images to the online image database temporally so the web user can browse them.
i allready have the php script for dumping files from database to filesystem.
Can someone give me advice on what im doing.
Are there scripts that can help me copying the stuff to DVD ?
Is this the best way ?
any advice is apreciated.
Thanks
