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()
 
Restored database does not contain backup data!

Restored database does not contain backup data!

2007-01-10       - By Eduard M

 Back
Reply:     1     2     3     4     5     6  

I have the following problem. I am trying to backup database and restore it
on another server (I need to do this to make a standby instance from master
instance). On the standby database I have 1 schema, "MASTER". When I restore
this database, the restored one does not contain any schema "MASTER". When I
look into "Owned users" using SQL Studio, on restored instance, I only see
some mystical user "DBSERVICE". When I look into ALL_TABLES, I don't see
anything other than 4 tables owned by SYS.

Here are the details:
Source instance (to backup): 7.6.00 (build number I'm not sure - how can I
tell? - but it is either 16 or 32), 64-bit version, SUSE (by the way, how
can I check the build number and the full version info?)
Target instance (to restore): 7.6.00.27, 64-bit version, SUSE

I do a full data backup on the source instance to a file using Database
Manager wizard as described in Maxdb documentation.
I create backup instance with the following parameters:

param_startsession
param_init
param_put MAXUSERTASKS 100
param_put DEFAULT_CODE UNICODE
param_put _UNICODE YES
param_checkall
param_commitsession
param_addvolume 1 LOG LOG_001 F 2000
param_addvolume 1 DATA DAT_001 F 10000
db_admin

Then I restore it from the backup file and activate:

medium_put burvis /opt/sdb/backup/BURVIS_COM FILE DATA
recover_start burvis
db_activate dba,dba
load_systab

What is wrong?

Eduard