<snip> > > > i have written a bat file in which the data databackup has been taken in > sql > > it runs automatically every 1 hour and sends a automatically through email > > now at the other end i have to manually restore the database can any one > give me the codes to restore the database automatically > > in vb or as a bat file > > the databack up say for a database test is > > test.sql >
I am assuming you used mysqldump to create your test.sql mysql [-u user] [-ppassword] new_db_name < test.sql If new_db_name already contains data within test.sql you may need to use something like --add-drop-table when you create test.sql. mysqldump --add-drop-table my_db > test.sql HTH Graham -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]