Re: remote database backup,

Hi,

Mckoi does provide a built-in function for backing up the database on 
the server but not server to client.  If you wish to copy all the data 
from the server to the client, one way to achieve this is to use the 
standard JDBC API and read the data from the individual tables and write 
it out to a file in a format of your choosing.  Restoring the data would 
require reading the files on the client and inserting the data to the 
database.

Toby.


Vinodh Srinivasasainagendra wrote:
> The following question is with regards to database backup and restores using
> Mckoi. My DB is currently running on a remote server say
> jdbc:mckoi://xxx.xxx.xxx.xxx/DB_NAME/
> 
> My client needs to connect to the server, backup the database onto the
> client's machine. If required it needs to restored back to the server in
> case of mishap. Could any one guide on this? Code Snippets will be great.
> 
> Thanks


---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]