Error importing database

How are you attempting to perform the import?

I just tried on a local install and it works well.

Using phpMyAdmin:
– create the new database
– select it from the left pane
– click the SQL tab (right pane)
– copy and past the text file into the SQL entry area and then click Go

Note:
– you should be using a plain text editor such as Notepad or Notepad++ (Win) or TextEdit (Mac)

Alternatively, if you still have access to the original db location, try exporting it as a file; this is how I have always done it and without failure ??

documentation:
https://codex.www.ads-software.com/Backing_Up_Your_Database
https://codex.www.ads-software.com/Restoring_Your_Database_From_Backup
https://codex.www.ads-software.com/WordPress_Backups

here’s how i’ve been doing it..

Using phpMyAdmin:
– create the new database
– select it from the left pane
– click the Import tab
– upload file
– change format to csv
– hit go

I only have access to this text file, the original site is now gone unfortunately.