MySQL

public void createDump() {
        try (var con = getConnection(); //
            var s = con.createStatement(); //
            var rset = s.executeQuery("SHOW TABLES")) {
            final var fileName = database + "_dump_" + DATE_TIME_FORMATTER.format(LocalDateTime.now()) + ".sql";
            var dump = new File("dumps", fileName);
            new File("dumps").mkdir();
            dump.createNewFile();
          
            
if (rset.last()) {
                rset.beforeFirst();
            }
          
            try (var fileWriter = new FileWriter(dump);
                var fws = new FileWriterStdout(fileWriter)) {
                while (rset.next()) {
                    fws.println("CREATE TABLE `" + rset.getString(1) + "`");
                    fws.println("(");
                    try (var desc = con.createStatement();
                        var dset = desc.executeQuery("DESC " + rset.getString(1))) {
                        final var keys = new HashMap<String, List<String>>();
                        var isFirst = true;
                        while (dset.next()) {
                            if (!isFirst) {
                                fws.println(",");
                            }
                            fws.print("\t`" + dset.getString(1) + "`");
                            fws.print(" " + dset.getString(2));
                            if (dset.getString(3).equals("NO")) {
                                fws.print(" NOT NULL");
                            }
                            if (!dset.getString(4).isEmpty()) {
                                if (!keys.containsKey(dset.getString(4))) {
                                    keys.put(dset.getString(4), new ArrayList<String>());
                                }
                                keys.get(dset.getString(4)).add(dset.getString(1));
                            }
                            if (dset.getString(5) != null) {
                                fws.print(" DEFAULT '" + dset.getString(5) + "'");
                            }
                            if (!dset.getString(6).isEmpty()) {
                                fws.print(" " + dset.getString(6));
                            }
                            isFirst = false;
                        }
                        if (keys.containsKey("PRI")) {
                            fws.println(",");
                            fws.print("\tPRIMARY KEY (");
                            isFirst = true;
                            for (String key : keys.get("PRI")) {
                                if (!isFirst) {
                                    fws.print(", ");
                                }
                                fws.print("`" + key + "`");
                                isFirst = false;
                            }
                            fws.print(")");
                        }
                        if (keys.containsKey("MUL")) {
                            fws.println(",");
                            isFirst = true;
                            for (String key : keys.get("MUL")) {
                                if (!isFirst) {
                                    fws.println(", ");
                                }
                                fws.print("\tKEY `key_" + key + "` (`" + key + "`)");
                                isFirst = false;
                            }
                        }
                        fws.println();
                        fws.println(");");
                        fws.flush();
                    }
                  
                    try (var desc = con.createStatement();
                        var dset = desc.executeQuery("SELECT * FROM " + rset.getString(1))) {
                        boolean isFirst = true;
                        int cnt = 0;
                        while (dset.next()) {
                            if ((cnt % 100) == 0) {
                                fws.println("INSERT INTO `" + rset.getString(1) + "` VALUES ");
                            } else {
                                fws.println(",");
                            }
                          
                            fws.print("\t(");
                            boolean isInFirst = true;
                            for (int i = 1; i <= dset.getMetaData().getColumnCount(); i++) {
                                if (!isInFirst) {
                                    fws.print(", ");
                                }
                              
                                if (dset.getString(i) == null) {
                                    fws.print("NULL");
                                } else {
                                    fws.print("'" + dset.getString(i).replace("\'", "\\\'") + "'");
                                }
                                isInFirst = false;
                            }
                            fws.print(")");
                            isFirst = false;
                          
                            if ((cnt % 100) == 99) {
                                fws.println(";");
                            }
                            cnt++;
                        }
                        if (!isFirst && ((cnt % 100) != 0)) {
                            fws.println(";");
                        }
                        fws.println();
                        fws.flush();
                    }
                }
                fws.flush();
            }
        } catch (Exception ex) {
            System.err.println("There has been an error creating a database backup for " + database + "!");
            ex.printStackTrace();
        }
    }