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 ???

Recommended Answers

All 3 Replies

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');

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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.