Complete mySQL Database Backup!!!
-
Hello, Do any body have idea of getting complete database backup of mySQL database except this? SELECT * INTO OUTFILE Path FROM Table I want just there should be only one backup file of All tables and how to restore that. I am using: mySQL 4.1 and VB 6.0. Thanks
-
Hello, Do any body have idea of getting complete database backup of mySQL database except this? SELECT * INTO OUTFILE Path FROM Table I want just there should be only one backup file of All tables and how to restore that. I am using: mySQL 4.1 and VB 6.0. Thanks
use MYSQLDUMP a built in function for backup all database in mysql. more information: http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
-
use MYSQLDUMP a built in function for backup all database in mysql. more information: http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
thanks for ur response!!! can u please tell me how it can be used in VB 6.0. I have treid but its giving error?
-
thanks for ur response!!! can u please tell me how it can be used in VB 6.0. I have treid but its giving error?
Hi:) you must use it with SHELL commands i don't know what is this command in VB exactly.but you can search in MSDN for shell. shell commands are Command Prompt console for executing commands. i searched for you and i found these: http://experts.about.com/q/Visual-Basic-1048/using-Windows-Shell-VB6.htm
-
Hello, Do any body have idea of getting complete database backup of mySQL database except this? SELECT * INTO OUTFILE Path FROM Table I want just there should be only one backup file of All tables and how to restore that. I am using: mySQL 4.1 and VB 6.0. Thanks
Why dont you try using MySQL Administrator utility? Its a a free utility available on www.mysql.com. It can perform backups and restores from a graphical interface, and also schedule backups. "MySQL Administrator is a program for performing administrative operations, such as configuring, monitoring and starting and stopping a MySQL server, managing users and connections, performing backups, and a number of other administrative tasks." Thanks and Regards, Aby
-
Why dont you try using MySQL Administrator utility? Its a a free utility available on www.mysql.com. It can perform backups and restores from a graphical interface, and also schedule backups. "MySQL Administrator is a program for performing administrative operations, such as configuring, monitoring and starting and stopping a MySQL server, managing users and connections, performing backups, and a number of other administrative tasks." Thanks and Regards, Aby
Thanks for your suggestion, actually as i mentioned i am using VB 6.0 as front end and mySQL 4.1 as back end. i want there should be an option for taking the backup of complete database from VB form: user just tell the path where he wants to take backup of database. any suggestions? Thanks and Regards, Javed