SQL Anywhere for Linux - dbbackup in Debian Linux without Tools

Author

dbbackup in Debian Linux without Tools

M. Ahmer Eirabie

2005-04-05, 8:02 pm

Hello,

Need help in running 'dbbackup' in Debian Linux. We are
running 2.05a.0(1) of debian Linux, with no administrative
tools installed like Sybase Central, ISQL, or dbconsole on
the server. We get the message that user cannot
start/shutdown the server, when we run the following command
in a terminal session on the server:
dbbackup -c
" uid=dba;pwd=sql;eng=
ABCdb;dbn=/opt/sybase/SYBSsa9/Mlink/MeasurLink60.db"
/opt/sybase/SYBSsa9/backupd

The response is the same with and without .db extension, and
-s option.

Regards

Ahmer

Reg Domaratzki $iAnywhere Solutions$

2005-04-05, 8:02 pm

DBN is the connection parameter to specify the database name. I suspect you
want to use DBF which is used to specify the database file.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

<M. Ahmer Eirabie> wrote in message
news:416ff5de.2da8.1681692777@sybase.com...
> Hello,
>
> Need help in running 'dbbackup' in Debian Linux. We are
> running 2.05a.0(1) of debian Linux, with no administrative
> tools installed like Sybase Central, ISQL, or dbconsole on
> the server. We get the message that user cannot
> start/shutdown the server, when we run the following command
> in a terminal session on the server:
> dbbackup -c
> " uid=dba;pwd=sql;eng=
ABCdb;dbn=/opt/sybase/SYBSsa9/Mlink/MeasurLink60.db"
> /opt/sybase/SYBSsa9/backupd
>
> The response is the same with and without .db extension, and
> -s option.
>
> Regards
>
> Ahmer

Mohammed Eirabie

2005-04-05, 8:02 pm

The problem is not using DBN or DBF. The problem is that 'dbbackup' is not
working under Debian Linux.

My question is if do not have the administrative tools installed, how can we
backup and restore?

Regards,

M. Ahmer Eirabie
"Reg Domaratzki (iAnywhere Solutions)" < Spam_bad_rdomarat@ia
nywhere.com>
wrote in message news:41700b54$1@foru
ms-2-dub...
> DBN is the connection parameter to specify the database name. I suspect
you
> want to use DBF which is used to specify the database file.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer Version 8
> Please reply only to the newsgroup
>
> iAnywhere Developer Community : http://www.ianywhere.com/developer
> iAnywhere Documentation :
http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> <M. Ahmer Eirabie> wrote in message
> news:416ff5de.2da8.1681692777@sybase.com...
" uid=dba;pwd=sql;eng=
ABCdb;dbn=/opt/sybase/SYBSsa9/Mlink/MeasurLink60.db"[color=darkred]
>
>

Greg Fenton

2005-04-05, 8:02 pm

Mohammed Eirabie wrote:
> The problem is not using DBN or DBF. The problem is that 'dbbackup' is not
> working under Debian Linux.
>

How is it not working? What are the symptoms? If it is the "cannot
start/stop database" that typically has to do with either the way your
database engine is starting up (or was started up if it is already
running) and/or the connection parameters that you are using to the
client application (in this case dbbackup).

> My question is if do not have the administrative tools installed, how can we
> backup and restore?

If the dbbackup command exists in your "$ASANY9/bin" directory, then it
is installed. Now it is matter of making sure that it works.

The error you posted about indicates that the connection parameters are
not finding the specified database and so the client app (well, the ASA
client library) is trying to automatically start the database. However,
for whatever reason, the database can't start. As Reg pointed out, one
possibility is that you used DBN instead of DBF to specify the path of
the .db file.

Are you trying to backup an *already running* database? If so, you
should *not* specify the path to the .db file. You should specify the
ENG and DBN so that the dbbackup utility can connect to the right
database on the already running engine.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links