Monat: März 2021

Export all Databases and Tables

mysqldump -u root -p --all-databases > alldb.sql

// Sometimes problems with tablespaces then use
mysqldump -u root -p --all-databases > alldb.sql

SINGLE Database

mysqldump -u root -p db1 db2 dbx > alldb.sql

mysqldump -u root -p db1 db2 dbx > db.sql

#some hoster have sometimes problems with tablespaces
mysqldump -h hostnameOrIp -u root -p --no-tablespaces db1 db2 dbx > alldb.sql

INNODB Database Export

mysqldump.exe -u root -v --single-transaction --single-transaction --skip-lock-tables database_name_to_export > filename.sql

-v show all exporting line
–single_transaction flag will start a transaction before running. Rather than lock the entire database, this will let mysqldump read the database in the current state at the time of the transaction, making for a consistent data dump.

Import Databases

All Databases

mysql> sudo mysql -u root -p db_name < export.sql

Single Database

mysql> CREATE DATABASE db_name;
mysql> sudo mysql -u root -p db_name <  export.sql