Noob Question - .sql file related

[44]

I've researched but can't seem to find a simple, easy tool or method for viewing an sql db in table format.

I downloaded some off RF a while back n never bothered. Lol

Just wanna see or just extract combo related data if possible.

[589]

It's been a minute since I've done this but you can convert your sql to csv and copy the columns that way (to extract things like usernames/passwords/emails/salts/etc...). I use regex to do this instead and simply extract the information that way. The steps I use are difficult to explain though. I'm using a filesplitter, notepad++, regular expressions, a macro recorder... Tools for this already exist but I don't like downloading random shit I can't confirm is safe.

[44]

It's been a minute since I've done this but you can convert your sql to csv and copy the columns that way (to extract things like usernames/passwords/emails/salts/etc...). I use regex to do this instead and simply extract the information that way. The steps I use are difficult to explain though. I'm using a filesplitter, notepad++, regular expressions, a macro recorder... Tools for this already exist but I don't like downloading random shit I can't confirm is safe.

Thanks for the reply. Man, that sounds confusing. lmao. I know this kinda stuff isn't just dead easy, but still thought it'd be easier than that.

[589]

Tools for this already exist, try searching the forums. You could write your own tool. That's always an option.

Show ContentSpoiler:

Parse the SQL file and make a multi-dimensional array with these values like so:

Code:

[
    [
        ['label', 'value'],
        ['label', 'value'],
        ['label', 'value'] 
    ],
    [
        ['label', 'value'],
        ['label', 'value'],
        ['label', 'value'] 
    ]
]

Now you can fetch each item with little effort.

If you're too lazy for that no fear. I'm working on a tool for this right now. The GUI is taking more time than the actual script running in the background.

[44]

Tools for this already exist, try searching the forums. You could write your own tool. That's always an option.

Show ContentSpoiler:

Parse the SQL file and make a multi-dimensional array with these values like so:

Code:

[
    [
        ['label', 'value'],
        ['label', 'value'],
        ['label', 'value'] 
    ],
    [
        ['label', 'value'],
        ['label', 'value'],
        ['label', 'value'] 
    ]
]

Now you can fetch each item with little effort.

If you're too lazy for that no fear. I'm working on a tool for this right now. The GUI is taking more time than the actual script running in the background.

I'm far from too lazy. I'm just a bit on the slow side as far as learning stuff. Even if it's simple.