be sure to clear the log AND load the systab after you finish the restore...
1) db_execute clear log 2) load_systab -u <dbauser>,<dbapassword> -ud <dbapassword> -----Original Message----- From: K Cardal [mailto:[EMAIL PROTECTED] Sent: Thursday, July 14, 2005 5:31 PM To: maxdb@lists.mysql.com Subject: Cannot Connect To DB after recovery I recently loaded a database backup to a new server for testing purposes etc... I cannot access the database via SQLStudio I tried the following but no success: -created an instance for recovery -created an instance then using recovery -created an instance added users (via dbmgui)then did a recovery the error i recieve when trying to access the db via SQL Studio is: ------------------------ SQL Studio DBLayer ------------------------ ODBC-error: [MySQL MaxDB][SQLOD32 DLL][MaxDB] invalid authorization specification;-4008 POS(1)Unknown user name/password combination return-code: SQL_ERROR (-4008) ------------------------ now the unknow username issue is puzzling as users were created and still no access. I also tried using the control/control dbadmin/admin dba/dba dbm/dbm no luck Anyone have a clue to what has happened or what is happening? Thank you, K __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
