Database Backups and Restores with mysqldump and SQL Scripts // NodeFlux Docs

Export database snapshots using mysqldump and restore SQL backup scripts to your MariaDB service. ## Steps 1. To export a full database backup via command line: mysqldump -h host -P port -u user -p databasename > backup. NodeFlux documentation for free Minecraft, Node.js and application hosting.

Export database snapshots using mysqldump and restore SQL backup scripts to your MariaDB service. ## Steps 1. To export a full database backup via command line: mysqldump -h host -P port -u user -p databasename > backup.

Export database snapshots using mysqldump and restore SQL backup scripts to your MariaDB service. ## Steps 1. To export a full database backup via command line: mysqldump -h host -P port -u user -p databasename > backup.sql. 2. Compress backup files into .sql.gz archives for long-term storage or transfers. 3. To restore an SQL dump file: mysql -h host -P port -u user -p databasename < backup.sql. 4. When importing large SQL dumps via GUI tools (like DBeaver), set max_allowed_packet options if handling blob data. 5. Verify table counts and row totals match post-import. ## Notes - Regular automated SQL dumps protect critical user account data and game state records. - Include --single-transaction flag in mysqldump commands to prevent locking active database tables during backup execution.