[sqlite] Difficulty with sqlite3_backup_init

[Nimish Nayak]

Sir

 I wanted to back up my database... I was basically on the look out for the
C APIS which would perform the exact same thing as .backup in cli mode.
 From a link i got redirected to a page.. where i came to know of
sqlite3_backup i tried it but I was not able to get it working ..
 Maybe i am going wrong somewhere.. kindly help me out..

My Code:-

#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <sqlite3.h>

int main(int argc,char *argv[]){

    int rc;
    sqlite3 *sdb,*ddb;
    sqlite3_backup *sql3b;

    rc = sqlite3_open("/home/Desktop/source.db",&sdb);

    if(rc != SQLITE_OK){

        printf("%s\n",sqlite3_errmsg(ddb));
        return 0;

    }

    rc = sqlite3_open("/home/Desktop/dest.db",&ddb);

    if(rc != SQLITE_OK){
        sqlite3_close(sdb);
        printf("%s\n",sqlite3_errmsg(ddb));
        return 0;

    }

    sql3b = sqlite3_backup_init(ddb,"main",sdb,"main");

    if(sql3b == NULL){
        sqlite3_close(sdb);
        sqlite3_close(ddb);
        printf("Error\n%s\n",sqlite3_errmsg(ddb));
        return 0;

    }

    rc = sqlite3_backup_step(sql3b, -1);

    if(rc != SQLITE_DONE){
        printf("%s\n",sqlite3_errmsg(ddb));
        return 0;

    }

    rc = sqlite3_backup_finish(sql3b);

    if(rc!= SQLITE_OK){

        printf("Error\n%s\n",sqlite3_errmsg(ddb));
        return 0;

    }

    sqlite3_close(sdb);
    sqlite3_close(ddb);

    return 1;
}
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users