View source for ICT:System RESET - FIles and Asset Namespace

= System Reset – Files and Asset Namespace =

This document defines the **standard, repeatable procedure** to fully clean the system during
Asset v2.x development.

It is intended for **development and testing environments only**.
All data (Assets and files) is assumed to be disposable.

This procedure MAY be executed multiple times during development.

---

== 1. Preconditions ==
Before starting:

* You have shell access to the MediaWiki server
* You have phpMyAdmin access to the MariaDB/Cargo database
* MediaWiki is NOT in active use by other users
* Any files that must be preserved have been downloaded locally

---

== 2. Safeguard Files to Keep (if any) ==
If a small number of files must be preserved (e.g. Main Page images):

# Open each File page
# Download the original file locally
# Verify the local copy opens correctly

After this step, all files on the server may be deleted.

---

== 3. Delete ALL Files (Filesystem Level) ==
On the MediaWiki server, remove all stored files.

<syntaxhighlight lang="bash">
rm -rf /var/www/mediawiki/images/*
</syntaxhighlight>

Notes:
* Do NOT delete the <code>images/</code> directory itself
* This removes all uploaded files, thumbnails, archives, and temp files

---

== 4. Clean File Metadata (Database Level) ==
Using phpMyAdmin on the MariaDB server, execute the following SQL commands
on the MediaWiki database:

<syntaxhighlight lang="sql">
TRUNCATE TABLE image;
TRUNCATE TABLE oldimage;
TRUNCATE TABLE filearchive;
</syntaxhighlight>

Result:
* Special:FileList becomes empty
* File history is forgotten
* Re-uploading previously used filenames is allowed

---

== 5. Run MediaWiki File Cleanup Script ==
On the MediaWiki server, run:

<syntaxhighlight lang="bash">
php maintenance/cleanupImages.php
</syntaxhighlight>

Purpose:
* Removes residual inconsistencies
* Ensures MediaWiki state matches filesystem and database

---

== 6. Delete ALL Asset Pages (Namespace Cleanup) ==

=== 6.1 Determine Asset Namespace ID ===
In phpMyAdmin, run:

<syntaxhighlight lang="sql">
SELECT ns_id, ns_name FROM mw_namespace;
</syntaxhighlight>

Note the numeric <code>ns_id</code> corresponding to <code>Asset</code>.
(Example: 300 – actual value may differ.)

---

=== 6.2 Generate List of Asset Pages ===
On the MediaWiki server:

<syntaxhighlight lang="bash">
php maintenance/getAllPages.php --namespace=3014 > /tmp/asset_pages.txt
</syntaxhighlight>

Replace <code>NS_ID</code> with the Asset namespace ID.

---

=== 6.3 Delete Asset Pages in Bulk ===
Run:

<syntaxhighlight lang="bash">
php maintenance/deleteBatch.php /tmp/asset_pages.txt
</syntaxhighlight>

Result:
* All pages in the Asset namespace are deleted
* Revisions and logs are handled correctly
* No UI interaction required

---

== 7. Clean Cargo Asset Data ==
Using phpMyAdmin on the Cargo database, execute:

<syntaxhighlight lang="sql">
TRUNCATE TABLE Assets;
</syntaxhighlight>

Result:
* No Asset data remains
* Dashboards return empty
* Sequence numbers reset cleanly

---

== 8. Optional Hygiene Step ==
After large deletions, optionally run:

<syntaxhighlight lang="bash">
php maintenance/refreshLinks.php
</syntaxhighlight>

This is not mandatory but recommended after repeated resets.

---

== 9. Verification Checklist ==
After completing all steps:

* Special:FileList → empty
* Special:AllPages (File namespace) → empty
* Special:AllPages (Asset namespace) → empty
* Asset dashboards → empty
* Uploading a previously used filename → allowed

If all checks pass, the system is in a **clean zero state**.

---

== 10. Usage Policy ==
This reset procedure is:
* APPROVED for development and testing
* FORBIDDEN on production systems
* EXPECTED to be executed repeatedly during Asset v2.x stabilization

---

''End of document''