Home arrow Forum

Remository Forum

 


pctech

Karma: 0  
How to Empty jos_downloads_blob? - 2006/12/15 09:14 Hi. First Thanks for this good component.
Good Work Programmers!!!!!

i am using now since 3.2 remository as Downloadcorner.

Iam now installed 3.4 and iam so far lucky with it.
BUT: Because i was not sure where to store the files, i didnt first chanched it to filesystem. So i dit upload a lot of files. Now i dit change all to the filesystem. It works so far with the funktion from Backend. I did also change Force children to inherit on Yes the Containers.

Now my trouble i got:
My Database is by jos_downloads_blob 7.5 GIGA
iam now unable to backup and restore. So i not able to move on a other server.
How to empty jos_downloads_blob Database table on a secure way?


Please help and answere.
Niemand urteilt schärfer als der Ungebildete.
Er kennt weder Gründe noch Gegengründe
und glaubt sich immer im Recht.
(Ludwig Feuerbach)
  | | Sorry, you do not currently have permission to write here.
pctech

Karma: 0  
Re:How to Empty jos_downloads_blob? - 2006/12/15 19:52 Hi again. So i did it.
For security:
First i was backup jos_download_blob seperatly. cost me about 6 hours to download it.....

Second i was with phpMyAdmin on the Database and just empty the table jos_download_blob seperatly.

So i was close my eyes and reload my page.
www.pcte.ch


And: it works everthing fine. OK i dit have about 17000 Tablerows to Empty.
Now i just looking for to modified css of the hole komponent, because it is really bad that all the rss buttons are thats big and not a alt tags is on it.

Post edited by: pctech, at: 2006/12/15 14:53
Niemand urteilt schärfer als der Ungebildete.
Er kennt weder Gründe noch Gegengründe
und glaubt sich immer im Recht.
(Ludwig Feuerbach)
  | | Sorry, you do not currently have permission to write here.
pctech

Karma: 0  
Re:How to Empty jos_downloads_blob? - 2006/12/16 16:05 So i prouf now everything and i lost about 23 Files from 250. So it is les then 10%.

So Programmers, please work on this feature again, please.

Post edited by: pctech, at: 2006/12/16 13:55
Niemand urteilt schärfer als der Ungebildete.
Er kennt weder Gründe noch Gegengründe
und glaubt sich immer im Recht.
(Ludwig Feuerbach)
  | | Sorry, you do not currently have permission to write here.
pctech

Karma: 0  
Re:How to Empty jos_downloads_blob? - 2006/12/16 19:10 So i was now manually clean out of the Database table witch php my admin.
I Backup the tables with insert and drop,jos_downloadfiles and jos_downloads_containers first.
Then i deinstall the remository 3.40
and delet the Database Tables with jos_downloads in beginning.
and i install the remository 3.41
I Check in the Remossitory Admin interface the global setting for store in Filepath. I also
modified the filepath and everything i need.

Then I Import the jos_downloads_containers first back to the Database
Then i Clean out of Table jos_downloads_files in edit evry row mode:
Set the filepath in your directory
Check if is local is 1
Set isblob on 0 (zero)
Set chunkcount on 0 (zero)

Do that with every row (Proof it)
Now it works and i had nothing really to do.
Mayby some SQL Programmers in here can make a script for to do that and include that in the Interface.

Hey Admin is it posible to make a the Backend interface also for Publishers. Or a link to it?
Niemand urteilt schärfer als der Ungebildete.
Er kennt weder Gründe noch Gegengründe
und glaubt sich immer im Recht.
(Ludwig Feuerbach)
  | | Sorry, you do not currently have permission to write here.
pcbest

Karma: 0  
Re:How to Empty jos_downloads_blob? - 2013/11/07 17:09 This is an old post, but I have an easier way to do this. I am using Joomla 2.5 and Remository 3.55. I removed all of the files through the backend of Joomla, but my database was still 8MB. I only had 5 documents, all PDF's. I logged into the SQL with phpmyadmin and browsed the tables. I clicked on downloads_blob and the details were displayed on the right. BELOW that information was a section titled: Information and below it the "space usage" showed over 7MB. The table was empty but still taking up space. I clicked on the link "optimize" below the usage and "space usage" went to 0 MB. Then the size of my SQL was less than a MB. Apparently the chunk remains in the downloads_blob even after deletion unless you optimize.
  | | Sorry, you do not currently have permission to write here.

Save FM Radio

Login

Subscribe to Premium Support

Get priority support for Remository and Glossary, sign up now for a Premium Support monthly subscription:

Your Remository user name

Or purchase a year's support:

Your Remository user name

Who is Online

Remository welcomes guests and visitors

Real Time Web Analytics