Database won't restore propertly Emergency!

[DuckBre]

How are you trying to restore the backup? PHPMYADMIN?

i'm trying with backup wizard>restore option which worked fine for me last time i managed to f*** up site

do the newly restored db details match the one in wp-config.php ?

yes i created user, gave priviledges all same as in config file and it doesn't give database error, however when i open site i see page for creating new wordpress site :/