MySQL Snippets

MySQL_Snippets.md

Windows: Export all MySQL db into single .sql files

mysql.exe -u root -p -s -N -e "SHOW DATABASES" | for /F "usebackq" %D in (`findstr /V "information_schema performance_schema"`) do mysqldump %D -u root -p > D:\Backup\MySQL\%D.sql

Windows: Import MySQL .sql file into db

First create empty database, then import the dump file into the newly created db.

mysql.exe -u root -p -e "create database database_name";
mysql.exe -u root -p database_name < database_name.sql

Windows: Load large csv into MySql

From phpmyadmin -> Query SQL Insert the following code:

LOAD DATA LOCAL INFILE 'C:\\xampp\\mysql\\data\\segnoprogetto_calligaris_sofas\\Tab_Prezzi_Divani.csv' 
INTO TABLE `Tab_Prezzi_Divani` CHARACTER SET 'utf8' 
FIELDS TERMINATED BY ';' 
ENCLOSED BY '' 
LINES TERMINATED BY '\r\n' 
IGNORE 1 LINES;

Windows: Load large txt into MySql

From phpmyadmin -> Query SQL Insert the following code:

LOAD DATA INFILE 'D:\\Sites\\triplette-rhyme\\_sources\\660000_parole_italiane.txt' INTO TABLE `dictionary_ita`