you can use the mysqldump.exe utility, it should work like this: mysqldump -hserver -uroot -pmypassword databasename
J
JoseMenendez
@JoseMenendez
Posts
-
How to take Mysql server backup to local machine? -
serverUse ProcessStartInfo, and set UseShellExecute to
trueThen you can run the process as you where using the console. -
A doubt about framework 2.0, please help me....(I've been through this with someone) First: Does the laptop have a Serial Port?
-
javascript bugs bug me.I really think that they should come up with something universal, like an Uniscript or something. It would really increase the happiness among us. :wtf:
-
DataGridViewJust set the
AutoSizeColumnsMode = AllCellsExceptHeader -
backup of mysqlThe only way I know to make this possible is by doing the following: Re-Install MySQL, when configuring for the first time, uncheck the checkbox that says "Change default security settings" And MySQL won't prompt for the password again.
-
backup of mysqlthen you'll have to type mysqldump -uroot -p mydatabase and it will prompt for a password. Just hit enter.
-
Ever seen this bad boy?Don't now exactly why it happens, but most likely to be transactional. With this kind of errors, always a re-installation of MySQL will fix the problem.
-
Insert Images to MySQL via SQL Statement?From query browser: - make a select * from your table - Press the "Edit" Button on the bottom of the view - The BLOB field of the last row will show a little "open" icon. - Select the file and fill the other fields - Press "Apply Changes" (which is next to the "Edit" button") That's it? From .NET code: - Use a prepared statement.
-
backup of mysqlI strongly suggest to use mysqldump. You can automate it with including just the mysqldump.exe program is quite tiny and you may call it from your program.