I assume the SQL script you are running is a MySQL database dump.
You need to convert the MySQL syntax in that script to comply with PostgreSQL syntax.
Things you need to check:
- Remove the dreaded backticks around any name
- Remove the engine=.... options
- Make sure you only have valid data (Postgres does not accept 0000-00-00 or 2013-02-31 as a date)
- convert the "KEY (x,y)" parts inside a table definition into a proper "CREATE INDEX ..." statement
- make sure the dump is taken in the proper encoding so that the data inside the dump can successfully be inserted into Postgres
- remove the "DEFAULT CHARSET=..." options
- remove the LOCK TABLES and UNLOCK TABLES statements
There are probably many more things to change.
I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
Tips on how to ask better questions: