Restore WordPress database on a new server

[this post will be properly edited]

I was creating the new database and WordPress would tell me to install the site.

Solution: dropped the database and created it from ‘mysql’ prompt.

user$ mysql -u root -p’yourpassword’ -h localhost
mysql> create database your_database_name;
mysql> exit
user$ mysql -u root -p’yourpassword’ -h localhost your_database_name