53 lines
1.3 KiB
Markdown
53 lines
1.3 KiB
Markdown
Importar bbdd
|
|
==============
|
|
clpctl db:import --databaseName=joomla --file=/home/getcloud-cnt-sindikatua/backups/sindikatua-utf8.sql
|
|
|
|
Ejecutar SQL para limpiar
|
|
==========================
|
|
|
|
```
|
|
-- Drop tables with multiple prefixes automatically
|
|
SET SESSION group_concat_max_len = 1000000;
|
|
|
|
SET @tables = (
|
|
SELECT GROUP_CONCAT('`', table_name, '`')
|
|
FROM information_schema.tables
|
|
WHERE table_schema = 'joomla'
|
|
AND (
|
|
table_name LIKE 'd8yd3_%'
|
|
OR table_name LIKE 'bak_%'
|
|
OR table_name LIKE 'gdkw3_%'
|
|
OR table_name LIKE 'qwe9g_%'
|
|
)
|
|
);
|
|
|
|
SET @drop_query = CONCAT('DROP TABLE IF EXISTS ', @tables);
|
|
|
|
PREPARE stmt FROM @drop_query;
|
|
EXECUTE stmt;
|
|
DEALLOCATE PREPARE stmt;
|
|
```
|
|
Ir al wordpress > herramientas > importar desde Joomla y ejecutar
|
|
|
|
==========================
|
|
==========================
|
|
NOTAS MIGRACIÓN
|
|
|
|
LIMPIEZA CATEGORÍAS - ELIMINAR
|
|
Blog (13), News, Review, tutorial, updates
|
|
Joomla! (24)
|
|
tutorial, updates,
|
|
Uncategorised (30)
|
|
Helbideak (8)
|
|
Service (1)
|
|
|
|
MANTENER
|
|
Berriak -> (noticias) (695)
|
|
Albisteak -> (noticias) (419)
|
|
-Lan gatazkak (Conflictos laborales) (87)
|
|
Lan gatazkak (Conflictos laborales) (83)
|
|
Servicios privados -> página
|
|
Servicios públicos -> página
|
|
Industria (2) -> página
|
|
Acerca de CNT (8) -> Acerca
|
|
Zer da CNT? -> Acerca |