Subversion Repositories web.active

mysqldump -u root -p pw_active > ./active.sql


mysqldump -u root -p --all-databases > /backup/mariadb.dump

-–add-drop-table  Tells MariaDB to add a DROP TABLE statement before each CREATE TABLE statement.
-–no-data   Dumps only the database structure, not the contents.
-–lock-all-tables   No new record can be inserted anywhere in the database while the copy is finished. This option is very important to ensure backup integrity.
-–add-drop- database  Tells MariaDB to add a DROP DATABASE statement before each CREATE DATABASE statement.


Debian: pw = Margr!et@70
mysqldump -u marcel --add-drop-table -p pw_active > ./active.sql

Windows: pw = Nitrox32
mysqldump -u root --add-drop-table -p pw_active > ./active.sql




mysql -u root -p inventory < /backup/mariadb.dump

mysql -u marcel -p pw_active < ./active.sql