I'm not sure if its the backup, or the restore procedure thats broke.
If you want me to look at your tables please export them from phpMyAdmin and mail me them along with the backup file you got. I'll try and make some sense out of them.
It looks like the permissions table isnt setup correctly.
On the export tab set:
Select all tables
in SQL Options section tick: Structure, add auto_increment value, add backticks
check the Data, but leave the 2 data options cleared.
Email to damian(AT)tikiwiki(DOT)org
p.s. Is it 1.7.4 or 1.7.5?