Mngr at 17:30, 22 February 2026

2026-02-22T17:30:36Z

Mngr at 15:23, 22 February 2026

2026-02-22T15:23:39Z

← Older revision		Revision as of 15:23, 22 February 2026
Line 19:		Line 19:
	* Any files that must be preserved have been downloaded locally		* Any files that must be preserved have been downloaded locally

	Stop the wiki:		Stop the wiki: add this line on top of LocalSettings.php

	<pre>		<pre>

Mngr at 15:22, 22 February 2026

2026-02-22T15:22:35Z

@@ Line 18: / Line 18: @@
 * MediaWiki is NOT in active use by other users
 * Any files that must be preserved have been downloaded locally
 ---

Mngr: Created page with "= 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 a..."

2026-02-22T15:12:11Z

Created page with "= 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 a..."

New page

= 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''

ICT:System RESET - FIles and Asset Namespace - Revision history

Mngr at 17:30, 22 February 2026

Mngr at 15:23, 22 February 2026

Mngr at 15:22, 22 February 2026