WebLab

SELECT table_schema AS "Base de Datos", ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Tamaño (MB)" FROM information_schema.TABLES WHERE table_schema = DATABASE();

SELECT table_name AS "Tabla", ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Tamaño (MB)" FROM information_schema.TABLES WHERE table_schema = DATABASE() ORDER BY (data_length + index_length) DESC LIMIT 10;

OPTIMIZE TABLE `wp_options`;

REPAIR TABLE `wp_posts`;

ALTER TABLE `wp_users` ENGINE=InnoDB;

SELECT * FROM wp_options WHERE option_name IN ('siteurl', 'home');

UPDATE wp_options SET option_value = 'https://nuevo-dominio.com' WHERE option_name IN ('siteurl', 'home');

UPDATE wp_posts SET post_content = REPLACE(post_content, 'http://viejo.com', 'https://nuevo.com'), guid = REPLACE(guid, 'http://viejo.com', 'https://nuevo.com');

UPDATE wp_users SET user_pass = MD5('NuevaContraseñaSegura123!') WHERE user_login = 'admin';

SELECT u.ID, u.user_login, u.user_email FROM wp_users u INNER JOIN wp_usermeta m ON u.ID = m.user_id WHERE m.meta_key = 'wp_capabilities' AND m.meta_value LIKE '%administrator%';

DELETE a,b,c FROM wp_posts a LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id) LEFT JOIN wp_postmeta c ON (a.ID = c.post_id) WHERE a.post_type = 'revision';

DELETE FROM wp_options WHERE option_name LIKE '_transient_%' OR option_name LIKE '_site_transient_%';