mysql database backup using vb.net code only

[dibakarmishra]

I want to backup my database from vb.net 2010 and i am able to do this using mysqldump through vb.net 2010, but i want to backup my mysql database without useing mysqldump only by vb.net code. please help me ???

[joshl_1995]

Hello,
Can I first just ask why if using MySqlDump works why would you want to do it in just plain VB.NET?

Ok now did you just want the data from the database? (Example below)

+---------+---------+
|ColumnOne|ColumnTwo|
+---------+---------+
|Row1Cell1|Row1Cell2|
+---------+---------+
|Row2Cell1|Row2Cell2|
+---------+---------+

or did you like want a backup script like the example below?

CREATE TABLE IF NOT EXISTS `Testing` (
  `ColumnOne` varchar(255) NOT NULL,
  `ColumnTwo` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `Testing` VALUES ('Row1Cell1', 'Row1Cell2'), ('Row2Cell1', 'Row2Cell2');

[dibakarmishra]

i want to backup full database just useing vb.net code

[joshl_1995]

Ok, I've found this that does just that. Hope this helps.