[Zayzo]

Hi guys, I was just wondering how I can parse dbs in a fast way.

Thanks.

[meow]

Table/column indexing, using the correct table/column types, and just having a good CPU.

[Zayzo]

Yeah but I mean like, instead of having to import export everything on phpmyadmin just having a program that would be able to do it. Which would be nice for bigger dbs.

[Zayzo]

I'm unsure as to what you're trying to accomplish, if you want to grep users credentials use AstroGrep.

Making big clumsy dbs smaller by only having username:hashalt:email:ip

instead of 0,`, `,etc

[meow]

I'm unsure as to what you're trying to accomplish, if you want to grep users credentials use AstroGrep.

You're an idiot.

Making big clumsy dbs smaller by only having username:hashalt:email:ip

instead of 0,`, `,etc

If this is what you wanted to do your question should've been something like "how to sort databases", not how to parse them.
You can accomplish that with awk, cut, and sed.