celia
3/20/2018 - 8:17 AM

MySQL db

Conexión de usuarios

sudo mysql ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '1234';

Login

mysql -u root -p (luego pide la contraseña)

Crear base de datos

DROP DATABASE phgdb_20180207; CREATE DATABASE phgdb_20180207; GRANT ALL PRIVILEGES ON phgdb_20180207.* TO 'apsl'@'localhost'; FLUSH PRIVILEGES;

Tras import

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.