Ver el código de «Mant MySQL Wiki»

__toc__{{cen1|Mantenimiento a BDs MySQL de las Wiki Locales manejadas con XAMPP}}{{cen2|Proyecto '''ED''' - Escritorio Digital}}
----
== CONSULTAS ==
=== Tamaños BD - MySQL o MariaDB ===
<pre>
SELECT 
    table_schema AS "Base de Datos",
    ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Tamaño (MB)"
FROM information_schema.tables
GROUP BY table_schema
ORDER BY 
    CASE 
        WHEN table_schema LIKE '%wiki%' THEN 0
        WHEN table_schema LIKE '%fsf%' THEN 0
        WHEN table_schema LIKE '%ed%' THEN 0
        WHEN table_schema LIKE '%w11%' THEN 0
        WHEN table_schema LIKE '%rye%' THEN 0
        WHEN table_schema LIKE '%era%' THEN 0
        WHEN table_schema LIKE '%05era%' THEN 0
        ELSE 1
    END,
    table_schema ASC;
</pre>
: {{Ext|https://i.postimg.cc/xTBYcLwW/Tamano-BDs-My-SQL-o-Maria-DB-para-las-Wikis-locales-de-XAMPP-20260317.jpg|Ejemplo resultado.}}
https://i.postimg.cc/gjHW57Sq/BDs-My-SQL-Maria-DB-Wikis-Proy-ED-20260317b.jpg
<!--https://i.postimg.cc/sxYjzxXZ/BDs-My-SQL-Maria-DB-Wikis-Proy-ED-20260317.jpg-->
----
[[CATEGORY:ED]]
[[CATEGORY:ZIV]]
[[CATEGORY:WIKIFSF]]
[[CATEGORY:WIKI]]
[[CATEGORY:MYSQL]]
[[CATEGORY:TOOLS]]
[[CATEGORY:WEB]]