private void loadServerData() { serverData = new firedumpdbDataSet.mysql_serversDataTable(); mysql_serversAdapter = new firedumpdbDataSetTableAdapters.mysql_serversTableAdapter(); mysql_serversAdapter.Fill(serverData); cmbServers.DataSource = serverData; cmbServers.DisplayMember = "name"; cmbServers.ValueMember = "id"; if (cmbServers.Items.Count > 0) { cmbServers.SelectedIndex = 0; } }
private void loadComboBoxServers() { serverData = new firedumpdbDataSet.mysql_serversDataTable(); mysql_serversAdapter = new firedumpdbDataSetTableAdapters.mysql_serversTableAdapter(); mysql_serversAdapter.Fill(serverData); cmbServers.DataSource = serverData; cmbServers.DisplayMember = "name"; cmbServers.ValueMember = "id"; if (cmbServers.Items.Count > 0) { cmbServers.SelectedIndex = 0; //backgroundWorker1.RunWorkerAsync(); fillDatabaseCmb(null, null); } }
internal void Start() { List <string> tables = utils.StringUtils.extractTableListFromString(schedulesRow.tables); string database = schedulesRow.database; firedumpdbDataSetTableAdapters.mysql_serversTableAdapter serveradapter = new firedumpdbDataSetTableAdapters.mysql_serversTableAdapter(); firedumpdbDataSet.mysql_serversDataTable servertable = new firedumpdbDataSet.mysql_serversDataTable(); serveradapter.FillById(servertable, schedulesRow.server_id); if (servertable?.Count > 0) { //File.AppendAllText(@"servicelog.txt", "COUNT:"+servertable.Count+","); server = servertable[0]; } else { //File.AppendAllText(@"servicelog.txt", "COUNT:" + "EMPTY" + ","); return; } DumpCredentialsConfig dumpConfig = new DumpCredentialsConfig(); dumpConfig.database = database; dumpConfig.username = server.username; dumpConfig.password = server.password; dumpConfig.host = server.host; dumpConfig.port = (int)server.port; if (tables.Count > 0) { dumpConfig.excludeTables = tables.ToArray(); } mysqldumpAdapter = new MySqlDumpAdapter(); mysqldumpAdapter.Cancelled += OnCancelled; mysqldumpAdapter.Completed += OnCompleted; mysqldumpAdapter.CompressProgress += oncompressprogress; mysqldumpAdapter.CompressStart += oncompstart; mysqldumpAdapter.Error += onerror; mysqldumpAdapter.InitDumpTables += oninitdumptables; mysqldumpAdapter.Progress += onprogress; mysqldumpAdapter.TableRowCount += ontablerowcount; mysqldumpAdapter.TableStartDump += ontablestartdump; //File.AppendAllText(@"servicelog.txt", "STARTDUMP"); mysqldumpAdapter.startDump(dumpConfig); }