restore from backup

This backup was made at a different host, and i am moving away from them to another host.

I have imported through phpmyadmin and when i try acess this site, its redirecting to the OLD SITE, i assume this is because the admin CP still has the OLD url configured in the DB.

How and where do i change this to point to my new site?

`SQL query:

# WordPress MySQL database backup
#
# Generated: Monday 27. October 2008 09:41 UTC
# Hostname: myhost.com
# Database: mydb
# ——————————————————–
# ——————————————————–
# Table: wp_comments
# ——————————————————–
#
# Delete any existing table wp_comments
#
DROP TABLE IF EXISTS wp_comments ;

MySQL said: Documentation
#1046 – No database selected

I tried to take another backup and restore on top of the old one i imported already, as it was few days older.
How to fix this one?