sudo mysql ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '1234';
mysql -u root -p (luego pide la contraseña)
DROP DATABASE phgdb_20180207; CREATE DATABASE phgdb_20180207; GRANT ALL PRIVILEGES ON phgdb_20180207.* TO 'apsl'@'localhost'; FLUSH PRIVILEGES;
delete from south_migrationhistory where app_name in ('constance', 'captcha');
DROP TABLE IF EXISTS phgdb_20180305
.landings_chic_contactmodule
;
DROP TABLE IF EXISTS phgdb_20180305
.landings_chic_imagetextmodule
;
DROP TABLE IF EXISTS phgdb_20180305
.landings_chic_menumodule
;
DROP TABLE IF EXISTS phgdb_20180305
.landings_chic_modalmodule
;
DROP TABLE IF EXISTS phgdb_20180305
.landings_chic_slideritem
;
DROP TABLE IF EXISTS phgdb_20180305
.landings_chic_slidermodule
;
DROP TABLE IF EXISTS phgdb_20180305
.landings_chic_twocolumnsimagetextlistitem
;
DROP TABLE IF EXISTS phgdb_20180305
.landings_chic_twocolumnsimagetextmodule
;
DROP TABLE IF EXISTS phgdb_20180305
.landings_chic_videomodule
;
DROP TABLE IF EXISTS phgdb_20180305
.landings_chic_modulebaselanding
;
DROP TABLE IF EXISTS phgdb_20180305
.landings_chic_modulebase
;
DROP TABLE IF EXISTS phgdb_20180305
.landings_chic_landing
;
commit;
Export data de MySQL workbench, seleccionar todas las tablas, etc
Server > Data Export
Para BBDD grandes, ver imagen en db_dumps con la selección que ha funcionado. Seleccionando demasiadas cosas, no llega ni a empezar.