Is it possible through the use of a batch file, I'm trying this code:
mysqldump --host=localhost --user=root --password=nitoryolai -R hospital >E:wampetcdb-backuphosp.sql
Then vb.net will execute the batch file through s.d.p.s("b.bat")But it doesn't work, it only creates an empty .sql file.
I am visual studio 2005(VB.NET) and MYSQL 5.0 as Database. I want to Backup my Database. I am using the following but the result is in 0 KB.Process.Start("C:Program FilesMySQLMySQL Server 5.0
inmysqldump.exe", "--user=root --password=root --host=3306 --databases MySQL hospitality -r ""C:BackUpDataBase.sql""")
I'm creating a program with database and it almost done. The only one thing that left is the backup and restore of database. I don't know how to do this.
View 9 RepliesI,m taking mysql database backup through code behind,by using process.start method.It's taking backup but the problem is that after execution of process.start method,it's showing one command prompt for 2-3 seconds and executing.I dont want to show that command prompt.
View 1 RepliesAnyone here knows a batch file to create a duplicate database!
View 6 RepliesHow can i backup my mssql database using the save file dialog?
View 5 RepliesI am using MySQL 5.0 as back end with VB.NET as front end(Windows Applicaions). I want to take back up my database. I found one command through net as below.
mysql> mysqldump -u root -p root accounts > accounts.sql
My database name is "accounts". When i am trying to run the above command in mysql> prompt, it gives error. Where i have to run the above command?
Anyone knows how to backup mysql db?I got this code by searching, but nothing happens here
Process.Start("C:xampp/mysql/bin/mysqldump.exe", "-u root -p --database=goodhand > -r ""C:ack.sql""")
im trying to make a auto mysql backup for my vb program. this code is working but i want to hide the console window so the user will never notice that something happened.
Process.Start("C:/wamp/bin/mysql/mysql5.5.16/bin/mysqldump.exe", "-uroot coop usertrails --skip-add-drop-table -r ""C:ackup.sql")
how to load a .bak file of database backup in sql server 2005 using vb.net 2008 windows application?
View 5 RepliesHow connect Vb.Net to MYSQL..? How to add info to database user informations using mysql database. How to call login infos using mysql.
View 8 RepliesHow to store Mp3 Files in Database and display it into a listbox? So that I can load the files and display it into a listbox if I start my MP3 Player.
View 3 Repliesbefore re-inventing the wheel, i want to ask you how i can do this best: I have a VB.Net application that uses a database connection to MS SQL Server 2005 (express version). There are users that input data with the application into the database lets say once to 2x an hour to once a minute. I want to do backups like this: Once a day or once a week (in the evening) a full backup, and whenever the program/user is idle for lets say 10 Minutes, i want to do an incremental backup (so that it does not take so long until he can work on after the backup).
There are no big security issues, just copying the backup data files to a network share / a different computer or server would be fine. i guess the average db size may be 300MB, but the daily increments about 1MB.
[Code]...
I developed an application in VB.Net 2010 Express by which my users can updated the data in their offices and send XML files (total 4 xml files) for that particular date - its working fine I am getting 100's of files on daily basis to my FTP servers in a common folder.
Now i want to make an application that read those XML file at a scheduled intervals and import that to MySQL database tables. Also it should keep a log of files that has been imported in order to avoid duplicate importing of files.
I want to upload a text file to a table I have in my database. I have never done this kind of a thing so I don't have any clue. The column is in longblob.
View 10 RepliesHow to Connect an MySQL to VB8 Form to access File from database I used several codes but connection is not establishing have to connect VB form button by click it connect to database in C# code so Help me to connect for database in C# source code
View 1 Replieswith MySQL + vb.net 2008 exp to create back up of MySQL database script file through vb.net
View 2 Repliesi have a program in vb.net and my program will upload any type of file to my database, e.g common ext. to upload (.doc.xls) Im using mysql as database?
View 1 RepliesI have determined thanks to the last q & a that there is something wrong with my "save to db" code as well as my "retrieve to picture" code. Even If I manually save the pic in the db it stil wont retreive. This is code i patched together from 3 or 4 examples around the net.
Dim filename As String = txtName.Text + ".jpg"
Dim FileSize As UInt32
Dim ImageStream As System.IO.MemoryStream[code]......
I am trying to make a login system mysql try to connect to a mysql database.
Here is my code:
Imports MySql.Data.MySqlClient
Public Class LoginForm1
Dim MySqlConnection As MySqlConnection
Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
MySqlConnection = New MySqlConnection()
[code]....
create automatic backup of database in vb 6.0.Im using ms Microsoft SQL Server 2005 express edition..
View 1 RepliesI am using vb.net and sql server 2000 for developing windows applications. I want to know how to take the backup of database for after each and every transactions. is it possible? if possible,
View 6 RepliesHow to upload text file and microsoft office file to mysql database using open file dialog.
View 1 RepliesFirst off I am programming a hotel booking system for my college computing project. This consists of a bunch of windows forms coded in Visual Basic, and an Access database stored locally. The application gets information for the forms about customers, bookings etc... from the database.I would just like a way of making a complete copy of the database (.mdb) file and placing it into a user selected destination.
View 2 Repliesi want to sql database backup through the vb.net code.
View 2 RepliesI want to backup and restore the database by using vb.net.I have a problem here..This dialogue box appear.
"
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open backup device 'C:Documents and SettingsSMy Documentssales.Bak'. Operating system error 5(Access is denied.).
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.
"
I am writing a database application with Access 2007 and VB.net 2008.Is there a way in VB.net to backup and restore the database?
View 3 Replies"How to backup database SQL SERVER from VB NET?"
View 9 RepliesMy application has an access2007 db as its database. I am trying to create a backup/restore utility in my application that allows the user to take the backup or restore the database file "StudentsData.accdb" which is in the application folder. I tried the filecopy method but it gives me an error saying that the "file is not accessible, as it is being used by a process." I believe it is my application process that is using the file.
How do I stop my application accessing the database? I have database connections which i have written in code and all of them close with their respective forms.
i have a problem with using vb.net application, i want to take backup of my database from my vb.net application so that user clicks the button and backup can be copied in a drive .
View 1 Replies