Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MaxDB - Everything about MaxDB, formerly known as SAP DB
MySQL++ - Programming with the C++ API to MySQL
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• mysql openssl Question
• mysql:it 's a db not a dbms how it 's possible?!
• Does the binary log enabling affect the MySQL performances?
• Strange behavior, Table Level Permission
• FULLTEXT query format question
• Preventing Duplicate Entries
• Comparing and writing out BLOBS
• Executing MySQL Commands From Within C Program
• Can 't access mysql after kernel upgrade
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Downgrade Mysql from 4 to 3 23
• MySQL Cluster Software
• mysql test 4 1 fails with the gis test
• ERROR 2002: Can 't connect to local MySQL server through socket
• Getting Identity after INSERT
• Update one field with more fields from another table
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• mysql have same function mthod as Oracle decode()
 
doing a restore on SuSe

doing a restore on SuSe

2007-01-04       - By Heinrich, Tilo

 Back
Reply:     1     2     3  

Hello Frank,

Depending on the state of the database something along the following
lines should work:

dbmcli -d <db_name> -u <dbm_user>,<dbm_password>
>db_admin
>db_util_connect
>recover_start <your_backup_medium>
>db_online
>exit

If you would like to recreate/erase the log volume, you would use a
"db_activate recover <your_backup_medium>" instead of "recover_start
...".

If the database does not exist, you have to create it first.

Best regards,
Tilo Heinrich
SAP Labs Berlin

-- --Original Message-- --
From: Frank
Sent: Donnerstag, 4. Januar 2007 12:26
To: Heinrich, Tilo
Subject: RE: doing a restore on SuSe

Tilo, it's an online complete db backup with no data checkpoint

-- --Original Message-- --
From: Heinrich, Tilo
Sent: 04 January 2007 11:44 AM
To: maxdb@(protected)
Cc: Frank
Subject: RE: doing a restore on SuSe

Hello Frank,

I'm probably asking too late, but what kind of backup do you have?

Best regards,
Tilo Heinrich
SAP Labs Berlin

-- --Original Message-- --
From: Frank
Sent: Donnerstag, 14. Dezember 2006 10:51
To: maxdb@(protected)
Subject: doing a restore on SuSe

can anyone assist me with the best way to do a restore of a complete
backup?


OS: SuSe and MaxDB 7.4

any help would be appreciated




--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=mysql@(protected)