Hi,

I'm new to MaxDB and am trying to get to grips with saving and restoring data. I'm running an installation obtained from maxdb-all-win-32bit-i386-7_5_00_26.zip, whilst following instructions gleaned from maxdb-chmdoc-75.chm; both of which have been obtained from the mysql website. These are running under a Micro$oft windoze 2000 professional OS.

To gain understanding of the principles involved and find my way around the command structures I'm entering commands in the cli from a DOS prompt. Currently I've been able to create a simple table, add data to it and query this to check the results.

Now I'm down to saving and restoring instance data, and this is where the trouble starts.

Firstly, I've tried to save the database instance. Here's a copy of the typed commands and responses from MaxDB. From what I've read in the documentation everything's behaving as expected.

*** COMMANDS 1 START ***
<pre>
dbmcli>sql_execute select * from aName
OK
END
'Alphabet'
'Battleship'
'Camera'

---
dbmcli>medium_put dbcopy c:\backup\050729.bak file data 0 0 yes
OK

---
dbmcli>db_state
OK
State
ONLINE

---
dbmcli>db_admin
OK

---
dbmcli>param_versions
OK
c:\mysqldata\data\config\APK
c:\mysqldata\data\config\APK.01

---
dbmcli>util_connect dbm,dbm
OK

---
dbmcli>backup_start dbcopy data
OK
Returncode              0
Date                    20050729
Time                    00173951
Server                  cpc4-basf1-5-1-cust156.nott.cable.ntl.com
Database                APK
Kernel Version          Kernel    7.5.0    Build 026-123-094-430
Pages Transferred       232
Pages Left              0
Volumes                 1
Medianame               dbcopy
Location                c:\backup\050729.bak
Errortext
Label                   DAT_000000001
Is Consistent           true
First LOG Page          1056
Last LOG Page
DB Stamp 1 Date         20050729
DB Stamp 1 Time         00172644
DB Stamp 2 Date
DB Stamp 2 Time
Page Count              216
Devices Used            1
Database ID cpc4-basf1-5-1-cust156.nott.cable.ntl.com:APK_20050729_173951
Max Used Data Page      0

---
dbmcli>
</pre>
*** COMMANDS 1 END ***

This should I think indicate that I've made a copy of the database instance correctly - the return code is zero. I now shut down the instance and exit the cli.

*** COMMANDS 2 START ***
<pre>
dbmcli>db_stop
OK

---
dbmcli>db_offline
OK

---
dbmcli>quit

---

C:\Documents and Settings\Administrator>
</pre>

*** COMMANDS 2 END ***

Restarting the database instance should I think restore both the structure and content of the instance, but it doesn't...

*** COMMANDS 3 START ***
<pre>
C:\Documents and Settings\Administrator>dbmcli -d apk -u dbm,dbm
dbmcli on apk>db_online
OK

---
dbmcli on apk>db_restart
OK

---
dbmcli on apk>sql_connect fred,fpass
OK

---
dbmcli on apk>sql_execute select * from aName
ERR
-24988,ERR_SQL: sql error
-4004,Unknown table name:ANAME

---
dbmcli on apk>
</pre>
*** COMMANDS 3 END ***

I've also tried to restore the data into a different instance.

*** COMMANDS 4 START ***
<pre>
C:\Documents and Settings\Administrator>dbmcli
dbmcli>db_create apk1 dbm,dbm
OK

---
dbmcli>param_startsession
OK

---
dbmcli>param_copy apk
OK

---
dbmcli>param_checkall
OK

---
dbmcli>param_commitsession
OK

---
dbmcli>param_addvolume 1 log log_001 f 2000
OK

---
dbmcli>param_addvolume 1 data dat_001 f 10000
OK

---
dbmcli>medium_put dbrest c:\backup\050729.bak file data 0 0 no
OK

---
dbmcli>db_admin
OK

---
dbmcli>db_activate admin,secret
OK

---
dbmcli>db_online
OK

---
dbmcli>sql_connect admin,secret
OK

---
dbmcli>sql_execute create user fred password fpass resource not exclusive
OK

---
dbmcli>sql_release
OK

---
dbmcli>db_admin
OK

---
dbmcli>util_connect dbm,dbm
OK

---
dbmcli>db_activate recover dbrest data
OK
Returncode              0
Date                    20050729
Time                    00183656
Server                  cpc4-basf1-5-1-cust156.nott.cable.ntl.com
Database                APK
Kernel Version          Kernel    7.5.0    Build 026-123-094-430
Pages Transferred       232
Pages Left              0
Volumes                 1
Medianame               dbrest
Location                c:\backup\050729.bak
Errortext
Label                   DAT_000000001
Is Consistent           true
First LOG Page          1056
Last LOG Page
DB Stamp 1 Date         20050729
DB Stamp 1 Time         00172644
DB Stamp 2 Date
DB Stamp 2 Time
Page Count              216
Devices Used            1
Database ID cpc4-basf1-5-1-cust156.nott.cable.ntl.com:APK_20050729_1
73951
Max Used Data Page      0

---
dbmcli>sql_connect fred,fpass
ERR
-24988,ERR_SQL: sql error
-4008,Unknown user name/password combination

---
dbmcli>db_online
OK

---
dbmcli>sql_connect fred,fpass
OK

---
dbmcli>sql_execute select * from aName
ERR
-24988,ERR_SQL: sql error
-4004,Unknown table name:ANAME

---
dbmcli>
</pre>

*** COMMANDS 4 END ***

I *think* that I should have restored the data here; I just don't seem to be able to get at it. I think this is the same problem as my attempt to restore the instance I've shut down and restarted (commands 3).

There's probably way too much garbage from the cli interactions here but I daren't prune it at the moment since I don't know what's important for debugging just yet.

If at all possible I'd prefer an answer to my problem within the cli framework so I can try and understand what's happening.

Thanks for wading through all of this and I hope you can help,

And Kemp.



--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to