pd = connection.prepareStatement("ALTER TABLE sp_playerdata CHANGE Password Password VARCHAR(255) NOT NULL DEFAULT '';");
            pd.executeUpdate();
            pd.close();
            connection.close();
            importData();
            return true;
        } catch (SQLException e) {
            StaffPlus.get().message.sendConsoleMessage("Connection failed with the database! Are the details correct?",true);
            e.printStackTrace();
            return false;
        }
    }

    public Connection getConnection()throws SQLException{
            return datasource.getConnection();
    }

    public static void kill() {
        datasource.close();
    }

    private void importData(){
        FileConfiguration save = StaffPlus.get().dataFile.getConfiguration();
        if(!StaffPlus.get().getConfig().getBoolean("storage.mysql.migrated"))
        {
            try(Connection connection = getDataSource().getConnection();
                PreparedStatement pd = connection.prepareStatement("INSERT INTO sp_playerdata(GlassColor, Password, Player_UUID, Name)" +
                        "VALUES(?, ?, ?, ?) ON DUPLICATE KEY UPDATE Player_UUID=?;");
                PreparedStatement report = connection.prepareStatement("INSERT INTO sp_reports(Reason, Reporter_UUID, Player_UUID) " +
                        "VALUES(?, ?, ?);");
                PreparedStatement warn = connection.prepareStatement("INSERT INTO sp_warnings(Reason, Warner_UUID, Player_UUID) " +
                        "VALUES(?, ?, ?);");
                PreparedStatement  name =  connection.prepareStatement("INSERT INTO sp_alert_options(Name_Change, Player_UUID) " +
                        "VALUES(?, ?) ON DUPLICATE KEY UPDATE Name_Change=?;");
                PreparedStatement xray= connection.prepareStatement("INSERT INTO sp_alert_options(Xray, Player_UUID) " +
                        "VALUES(?, ?) ON DUPLICATE KEY UPDATE Xray=?;");
                PreparedStatement mention = connection.prepareStatement("INSERT INTO sp_alert_options(Mention, Player_UUID) " +
                        "VALUES(?, ?) ON DUPLICATE KEY UPDATE Mention=?;")){
                for (String key : save.getConfigurationSection("").getKeys(false)) {
                    StaffPlus.get().message.sendConsoleMessage(key +" "+save.getString(key+".name")+" "+
                            save.getInt(key+".glass-color")+ " "+save.getString(key+".password"),false);
                    pd.setInt(1,save.getInt(key+".glass-color"));
                    pd.setString(2,save.getString(key+".password"));
                    pd.setString(3,key);
                    pd.setString(4,save.getString(key+".name"));
                    pd.setString(5,key);
                    StaffPlus.get().message.sendConsoleMessage("Update returned "+pd.executeUpdate(),false);
                    pd.executeUpdate();
                    for(String reportInfo : save.getStringList(key+".reports")){
                        String[] info = reportInfo.split(";");
                        report.setString(1,info[0]);
                        report.setString(2,info[2]);
                        report.setString(3,key);
                        report.executeUpdate();
                    }
                    for(String warnInfo : save.getStringList(key+".warnings")){
                        String[] info = warnInfo.split(";");
                        warn.setString(1,info[0]);
                        warn.setString(2,info[2]);
                        warn.setString(3,key);
                        warn.executeUpdate();
                    }
                    for(String alertOptions : save.getStringList(key+".alert-options")){
                        String[] info = alertOptions.split(";");
                        if(info[0].equalsIgnoreCase("name_change")) {
                            name.setString(1,info[1]);
                            name.setString(2,key);
                            name.setString(3, info[1]);
                            name.executeUpdate();
                        }else if(info[0].equalsIgnoreCase("xray")){
                            xray.setString(1,info[1]);
                            xray.setString(2,key);
                            xray.setString(3, info[1]);
                            xray.executeUpdate();
                        }else if(info[0].equalsIgnoreCase("mention")){
                            mention.setString(1,info[1]);
                            mention.setString(2,key);
                            mention.setString(3, info[1]);
                            mention.executeUpdate();
                        }
                    }
                }
            }catch (SQLException e){
                e.printStackTrace();
            }
            StaffPlus.get().message.sendConsoleMessage("Data has been imported to MySQL from flatfile",false);
            //StaffPlus.get().getConfig().set("storage.mysql.migrated",true);
            StaffPlus.get().saveConfig();
        }
    }