Thread: [sqlmap-users] Read sqlite3
Brought to you by:
inquisb
From: Iago S. <146...@gm...> - 2012-09-22 16:12:41
|
Hello there, Can I read dumped db into sqlite3 file without sqlmap? I apologize for my little knowledge, but I really dunno how to do this. -- Regards, Iago Sousa |
From: Miroslav S. <mir...@gm...> - 2012-09-22 18:35:17
|
Hi Iago. Sorry, but it's not really clear what are you trying to do. You mean that you want to convert dumped content from CSV to sqlite3 DB or something else? Kind regards, Miroslav Stampar On Sat, Sep 22, 2012 at 6:12 PM, Iago Sousa <146...@gm...> wrote: > Hello there, > Can I read dumped db into sqlite3 file without sqlmap? > > I apologize for my little knowledge, but I really dunno how to do this. > > -- > Regards, Iago Sousa > > > ------------------------------------------------------------------------------ > How fast is your code? > 3 out of 4 devs don\\\'t know how their code performs in production. > Find out how slow your code is with AppDynamics Lite. > http://ad.doubleclick.net/clk;262219672;13503038;z? > http://info.appdynamics.com/FreeJavaPerformanceDownload.html > _______________________________________________ > sqlmap-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlmap-users > > -- Miroslav Stampar http://about.me/stamparm |
From: Iago S. <146...@gm...> - 2012-09-22 18:51:12
|
I want to convert sqlite3 into CSV, and the other way around (vice versa), and I'd like to know if can I read the sqlite3 without sqlmap. I can use the line below to read all tables in site stored in sqlite3 file: ./sqlmap.py -d sqlite://output/site/dump/db.sqlite3 --table Can I read in sqlite3 DB without using sqlmap.py? Using the sqlite3 itself. I only want to know, if is not possible, there is no problem here. Sorry for no clear message. On Sat, Sep 22, 2012 at 3:35 PM, Miroslav Stampar < mir...@gm...> wrote: > Hi Iago. > > Sorry, but it's not really clear what are you trying to do. You mean that > you want to convert dumped content from CSV to sqlite3 DB or something else? > > Kind regards, > Miroslav Stampar > > On Sat, Sep 22, 2012 at 6:12 PM, Iago Sousa <146...@gm...> wrote: > >> Hello there, >> Can I read dumped db into sqlite3 file without sqlmap? >> >> I apologize for my little knowledge, but I really dunno how to do this. >> >> -- >> Regards, Iago Sousa >> >> >> ------------------------------------------------------------------------------ >> How fast is your code? >> 3 out of 4 devs don\\\'t know how their code performs in production. >> Find out how slow your code is with AppDynamics Lite. >> http://ad.doubleclick.net/clk;262219672;13503038;z? >> http://info.appdynamics.com/FreeJavaPerformanceDownload.html >> _______________________________________________ >> sqlmap-users mailing list >> sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sqlmap-users >> >> > > > -- > Miroslav Stampar > http://about.me/stamparm > -- Regards, Iago Sousa Programmer and Security Researcher |
From: mitchell <mit...@tu...> - 2012-09-22 19:22:28
|
...or he has used the --replicate switch, and now asks how to view the data? @Iago if this is the case, then you can use # sqlite3 filename.db (where filename.db is the name of the sqlite3 database) to connect to a sqlite3 database. Then, you can use .help for more information. ~m. On Sat, Sep 22, 2012 at 9:35 PM, Miroslav Stampar < mir...@gm...> wrote: > Hi Iago. > > Sorry, but it's not really clear what are you trying to do. You mean that > you want to convert dumped content from CSV to sqlite3 DB or something else? > > Kind regards, > Miroslav Stampar > > On Sat, Sep 22, 2012 at 6:12 PM, Iago Sousa <146...@gm...> wrote: > >> Hello there, >> Can I read dumped db into sqlite3 file without sqlmap? >> >> I apologize for my little knowledge, but I really dunno how to do this. >> >> -- >> Regards, Iago Sousa >> >> >> ------------------------------------------------------------------------------ >> How fast is your code? >> 3 out of 4 devs don\\\'t know how their code performs in production. >> Find out how slow your code is with AppDynamics Lite. >> http://ad.doubleclick.net/clk;262219672;13503038;z? >> http://info.appdynamics.com/FreeJavaPerformanceDownload.html >> _______________________________________________ >> sqlmap-users mailing list >> sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sqlmap-users >> >> > > > -- > Miroslav Stampar > http://about.me/stamparm > > > ------------------------------------------------------------------------------ > How fast is your code? > 3 out of 4 devs don\\\'t know how their code performs in production. > Find out how slow your code is with AppDynamics Lite. > http://ad.doubleclick.net/clk;262219672;13503038;z? > http://info.appdynamics.com/FreeJavaPerformanceDownload.html > _______________________________________________ > sqlmap-users mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlmap-users > > |
From: Iago S. <146...@gm...> - 2012-09-22 18:53:45
|
Yes mitchell, I really wanted that. And I add the question that Miroslav has proposed. On Sat, Sep 22, 2012 at 3:50 PM, mitchell <mit...@tu...> wrote: > ...or he has used the --replicate switch, and now asks how to view the > data? @Iago if this is the case, then you can use > > # sqlite3 filename.db > > (where filename.db is the name of the sqlite3 database) to connect to a > sqlite3 database. > > Then, you can use .help for more information. > > ~m. > > > On Sat, Sep 22, 2012 at 9:35 PM, Miroslav Stampar < > mir...@gm...> wrote: > >> Hi Iago. >> >> Sorry, but it's not really clear what are you trying to do. You mean that >> you want to convert dumped content from CSV to sqlite3 DB or something else? >> >> Kind regards, >> Miroslav Stampar >> >> On Sat, Sep 22, 2012 at 6:12 PM, Iago Sousa <146...@gm...> wrote: >> >>> Hello there, >>> Can I read dumped db into sqlite3 file without sqlmap? >>> >>> I apologize for my little knowledge, but I really dunno how to do this. >>> >>> -- >>> Regards, Iago Sousa >>> >>> >>> ------------------------------------------------------------------------------ >>> How fast is your code? >>> 3 out of 4 devs don\\\'t know how their code performs in production. >>> Find out how slow your code is with AppDynamics Lite. >>> http://ad.doubleclick.net/clk;262219672;13503038;z? >>> http://info.appdynamics.com/FreeJavaPerformanceDownload.html >>> _______________________________________________ >>> sqlmap-users mailing list >>> sql...@li... >>> https://lists.sourceforge.net/lists/listinfo/sqlmap-users >>> >>> >> >> >> -- >> Miroslav Stampar >> http://about.me/stamparm >> >> >> ------------------------------------------------------------------------------ >> How fast is your code? >> 3 out of 4 devs don\\\'t know how their code performs in production. >> Find out how slow your code is with AppDynamics Lite. >> http://ad.doubleclick.net/clk;262219672;13503038;z? >> http://info.appdynamics.com/FreeJavaPerformanceDownload.html >> _______________________________________________ >> sqlmap-users mailing list >> sql...@li... >> https://lists.sourceforge.net/lists/listinfo/sqlmap-users >> >> > -- Regards, Iago Sousa Programmer and Security Researcher |
From: Miroslav S. <mir...@gm...> - 2012-09-22 19:12:56
|
Hi. 1) For browsing sqlite3 database I would recommend "SQLite Database Browser" [1]. On Windows machine you are gonna need to download and install it. On Linux you should be able to find it in default repositories (e.g. apt-get install sqlitebrowser). 2) For converting from CSV to sqlite3 I would recommend you to follow steps given at [2]. In case of any problems I could make you a small python script which would do this for you. Kind regards, Miroslav Stampar [1] http://sourceforge.net/projects/sqlitebrowser/ [2] http://smallbusiness.chron.com/import-csv-sqlite-48112.html On Sat, Sep 22, 2012 at 8:53 PM, Iago Sousa <146...@gm...> wrote: > Yes mitchell, I really wanted that. > > And I add the question that Miroslav has proposed. > > > On Sat, Sep 22, 2012 at 3:50 PM, mitchell <mit...@tu...> wrote: > >> ...or he has used the --replicate switch, and now asks how to view the >> data? @Iago if this is the case, then you can use >> >> # sqlite3 filename.db >> >> (where filename.db is the name of the sqlite3 database) to connect to a >> sqlite3 database. >> >> Then, you can use .help for more information. >> >> ~m. >> >> >> On Sat, Sep 22, 2012 at 9:35 PM, Miroslav Stampar < >> mir...@gm...> wrote: >> >>> Hi Iago. >>> >>> Sorry, but it's not really clear what are you trying to do. You mean >>> that you want to convert dumped content from CSV to sqlite3 DB or something >>> else? >>> >>> Kind regards, >>> Miroslav Stampar >>> >>> On Sat, Sep 22, 2012 at 6:12 PM, Iago Sousa <146...@gm...> wrote: >>> >>>> Hello there, >>>> Can I read dumped db into sqlite3 file without sqlmap? >>>> >>>> I apologize for my little knowledge, but I really dunno how to do this. >>>> >>>> -- >>>> Regards, Iago Sousa >>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> How fast is your code? >>>> 3 out of 4 devs don\\\'t know how their code performs in production. >>>> Find out how slow your code is with AppDynamics Lite. >>>> http://ad.doubleclick.net/clk;262219672;13503038;z? >>>> http://info.appdynamics.com/FreeJavaPerformanceDownload.html >>>> _______________________________________________ >>>> sqlmap-users mailing list >>>> sql...@li... >>>> https://lists.sourceforge.net/lists/listinfo/sqlmap-users >>>> >>>> >>> >>> >>> -- >>> Miroslav Stampar >>> http://about.me/stamparm >>> >>> >>> ------------------------------------------------------------------------------ >>> How fast is your code? >>> 3 out of 4 devs don\\\'t know how their code performs in production. >>> Find out how slow your code is with AppDynamics Lite. >>> http://ad.doubleclick.net/clk;262219672;13503038;z? >>> http://info.appdynamics.com/FreeJavaPerformanceDownload.html >>> _______________________________________________ >>> sqlmap-users mailing list >>> sql...@li... >>> https://lists.sourceforge.net/lists/listinfo/sqlmap-users >>> >>> >> > > > -- > Regards, Iago Sousa > Programmer and Security Researcher > > -- Miroslav Stampar http://about.me/stamparm |