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")
Is it possible to make a little backup program that can backup from one folder to another, is this much work? With a calender also that can be picked up so you can chose when the backup starts.
Im thinking about f.example 10 lines where you can chose where to backup from (different folderes) And one line where the backup shall be saved. All this with browse folder off course. And with a button backup now and a button backup from the date. A very little program with an easy use.
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 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?
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 RepliesAnyone 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""")
Or anybody can tell me : HoW can create storeprocedure which contains this code.I created a store procedure but it cant be saved.If i create a storeprocedure which contains this code then problem will resolved.
[Code]...
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,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 Repliesi was wondering if you can make a program run at start up auto
View 9 RepliesI'm trying to make an Auto Login program, which requires me to do a few clicks. I've tried many of the methods found here on MSDN, but they don't seem to work. The code I'm using to simulate the left click is:
Private Sub leftclick()
Call mouse_event(MOUSEEVENTF_LEFTDOWN, 0, 0, 0, 0)
Call mouse_event(MOUSEEVENTF_LEFTUP, 0, 0, 0, 0)
[Code].....
When I use this code, it always comes up with the following error:
"A call to PInvoke function 'DyKnow Login!DyKnow_Login.Form1::mouse_event' has unbalanced the stack. This is likely because the managed PInvoke signature does not match the unmanaged target signature. Check that the calling convention and parameters of the PInvoke signature match the target unmanaged signature."
make an autoclicker program I want to add to the source code where to click and every time i run the program and press the butoon it auto clicks
View 3 RepliesI am trying to make a very simple program that connects to a MySQL database using VB.NET. My program only has one form and one label. I setup my MySQL database to have a table and one field (a VARCHAR)called "Tab1". I manually inserted the value "CLOSED" into the Tab1 field using PHPMyAdmin. I want my program to change the value of the field to OPEN/CLOSED and I also want the label text on my form to change too when it's clicked.
[Code]...
I'm trying to make an auto updater. It kind of works, but I've got some problems.I need to make the download threaded or something so you can use the program while downloading. I've tried the background worker and now the Application.DoEvents(), but I didn't get it to work.
The second problem is that the program crashes after having downloaded in a while. It may be because it isn't threaded, but I don't know.Anyways, here's my
vb
Imports System.IO
Imports System.Net[code]....
I have a form containes some controls (buttons) how i can make the program auto-scan these controls one by one automatically and whenever the mouse on a button the button select for a time and I can press the enter key to click this button otherwise the mouse will go to the next button and so on.
View 3 RepliesI'm trying to make a program that takes my old records from Access and moves them to MySQL. Its supposed to take records from 3 different tables in Access to 3 different tables in MySQL. The first table is "Orders" and it sorts the ones to pull to the dataset, taxDS, by "Where Status = 'Waiting Payment' OR 'Cancelled'". Then the second table pulls its info(this is where i'm having trouble) by the "Control_Number" in the "Orders" table, so basically if the control number isnt already in the dataset its not going to pull the data into the new table "FNF Taxes".
Imports System.Data.OleDb
Imports MySql.Data.MySqlClient
Public Class Backup
[code]....
So now after my 3rd edit and no answers, I'm finally at the point where I'm only stuck on my For..Next statement not working, How can i get this statement to run for each 24,000 controlnumbers?
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]....
(VS.Net 2005/VB.Net)Why is it that VS.Net does not create LOCAL backup files of edits? Is there a way to make it do that?I accidentally overwrote a day's worth of changes by attempting to do a manual mergeoutside of VS.Net.Is there a way to make VS.Net create backup files of your changes each time you save?Delphi does it using an extension of .~pa for your source files and .~fm for your form files.This way, if your system crashes, which VS.Net is certainly going to do, you wouldn't lose the changes you made since your last save point.I know, I know, I shouldn't have been doing the merge outside of VS.Net but I had my reasons and now I[m paying the price.I just wished VS.Net was a little better IDE than it is because, frankly it sux. I am forever waitingfor something and not very productive using it. Hey, I'm getting good at watching paint dry because that is what developing in this tool seems like.
View 3 RepliesYes how would i make a program that auto clicks "new thread" and types in what are u put in textbox2 and then clicks sumbmit..Why I want to no:+ iM just trying to make a a program that makes it easyer to post.About the program Im trying to make: +im gonna have a webbroswer in my program and then i want then below there wil be a the thread auto click ...so day if i go to www.urlhere.com and go to there forum page i would jsut type everything in my auto clicker and i press button1 it will do everything for me like post the thread
View 2 RepliesAll functions done, but the main function, the autorun and auto hide didnt work like i wish. for this keylogger, im using checkbox to make it autorun when windows startup and another checkbox to autohide. i already placed the codes but nothing happen. when i tick those checkboxes n restart my pc, nothing happen. is it because im using checkbox?
View 3 RepliesI'd like to know how to restore my database in visual basic. the code i used for backing up is[code]...
View 2 RepliesHow to backup ms access database in vb.net?We're gonna make a system for a certain company but our teacher doesn't teach us at all
View 1 RepliesI'm using VB.net to write a MYSQL application and one feature I need to add is the ability to add a column for each week that my employees worked. For example I want the first column to be called "W1" and the next one to be "W2" and so on, right up to "W52". How would I add a column to my table and have it's name add 1 to its current value? If there wasn't any letters in the name it would be easy but I need it to have the "W" in the title as well to avoid confusion. to add the column I have this:
Alter Table Manager ADD W1 MediumINT;
I just need the part that adds an INTEGER to a VARCHAR datatype if possible... Maybe there should be some sort of data type conversion involved? Just to explain further, the black bar at the very top are the date stamps for each week, I would like to have this included in the datagridview if possible but it is not required. Under each week column the employees will be entering the percents they worked (example: 20%, or 0.20 is one day of work) I know this is an odd way of doing things but its mandatory... and i was wondering if it were possible to automate the creation of these columns rather than me having to manually enter them.
i have i problem when making some program to backup database sql server 2000. i have task to develop program with requirement like this:
1. this program must backup database from sql server 2000 (success).
2. this program must compress the backup to the smaller size (Not success,because the backup file is more than 3,9 Gb. i am using SharpZip Wrapper and not succes because the size exceeded.)
3.Copy the backup file or compress to another computer (Succes but take a long time because the size of file is more than 3,9 Gb. That's why I want compress the file.)
any one can give me solution for compress large file with size more than 3,9 Gb. This file will continue to grow in size,so i need compress it so i can copy more quickly?
or any one can reference some freeware can do the task?
How to take backup of database from sql server2005 using vb.net with the help of code
View 1 RepliesI'm been searching for a while for a way to create a vb 2010 program that automatically checks and compare the files you have at a specific location in your hard drive and backup/update them securely though a vpn when a button is clicked.
View 1 RepliesI developed a program using Vb.Net that is data based enabled, it has a field for serial number etc. its working fine but the serial number failed to update when a record is deleted, its always keeps tracks of its formal numbering, even when the program is restarted, unless reinstalled.How do i also backup the data stored in such program.
View 6 RepliesI have my desktop app, bound to an access database. I want now to improve a button so the user can make a backup of the *.mdb file.So i used this
If FolderBrowserDialog1.ShowDialog = Windows.Forms.DialogResult.OK Then
If FolderBrowserDialog1.SelectedPath <> "" Then
FileCopy("BDGRACIA.mdb", FolderBrowserDialog1.SelectedPath & "/BDgracia.mdb")
End If
End If
It works fine when i try the app from within Visual Studio. But when i install it it won�t find the database because it was installed elsewhere.Is there a way to control where the DB is installed and follow that route? Does this depend on the OS the app is installed? Or did I face the problem wrong and i should do something completely different with my button?
create an auto incremented student no.in mysql using vb.net lyk 2006-141791
View 2 RepliesHow can i make my app execute some code at specified day/time (Day/minutes/secconds)?I need to make a scheduled app that will backup(copy) some files at specified time/date.
View 4 Replies
