From: Arne Gehlhaar (gehlhaarisl.org)
Date: Wed Sep 22 2004 - 08:33:23 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This is roughly what I did (using SAB-DB 7.4.03)

1) make a full DATA backup on server1 (DATA1)
2) copy the dump-file to server2
3) create a new database on server2 using the installation wizard in the
    DBMGUI and choose 'restore parameters from a backup medium'
4) when the wizard wants to restore the backup medium (DATA1) press
    cancel
5) do a full DATA backup on server2 onto a new medium (DATA2) in order
    to create an entry point for the backup history (this seems to be a
    bug in the DBMGUI)
6) restore the medium DATA1
7) set the database in online mode.
8) done

Arne

David Pérez Gómez wrote:

> Hello to all.
>
> I want to copy a database from a server to another one (both they have
> SUSE Linux and the same version of MaxDB). I know that it is possible
> to be done through Manager Database.
>
> Could you explain step by step to me how to do it please?
>
> If I do backup of the database of a server, soon I cannot make restore
> from an empty database in another server.
>
> _________________________________________________________________
> Móviles, DVD, cámaras digitales, coleccionismo... Con unas ofertas que
> ni te imaginas. http://www.msn.es/Subastas/
>
>

--
Institut fuer Seeverkehrswirtschaft und Logistik http://www.isl.org/
Arne Gehlhaar mailto:gehlhaarisl.org
Universitaetsallee GW1 Block A tel:+49 421 22096-49
D-28359 Bremen fax:+49 421 22096-55

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]