timezone@chaos.socia..
posted 15 Apr 2024 15:31 +0000
this is an irregular reminder that doing a database backup means dumping the db into a file, not just making a copy of the db server's data directory
timezone@chaos.socia..
posted 15 Apr 2024 15:31 +0000
this is an irregular reminder that doing a database backup means dumping the db into a file, not just making a copy of the db server's data directory
benjojo
replied 15 Apr 2024 20:55 +0000
in reply to: https://chaos.social/users/timezone/statuses/112275954530961018
@timezone Bonus tip, when your tables get big enough, it's well worth the effort to dump each table into it's own .sql file. So you can easily recover each table individually if you blow up just one table, or restore more than one table at once