Hi all, I wish to restore an sql file in a mysql database though VB. One way of doing it is writing the Create Database command and the mysql restore command 'mysql -options < sql_file' in a batch file and executing it.
Is there any other better way of doing it? Btw, I try to make an ADO connection and call the command "\. sql_file" using Execute/Open method of Connection Object. But that doesn't seem to work. Thanks, Nawal Lodha.