Here is an update!

To summarize:

The original problem was, a sytax error when trying to upload a database in phpmyadmin.

This error was due to the fact that the databse was not complete,...

jip, defnitly, I changed it, to the same details as created for this database. the server I left at "localhost"

I am sure bigdump will do the trick, but what am I doing wrong in its settings, as it does not want to connect to the database at all.

I do not know how to do the split. What I am doing now, is to export/import the tabels one by one. I am now with the table containing the forum posts, and it looks like this table is the large one,...

I have downloaded and installed bigdump now, and changed the settings to connect to database as specified, but even bigdump cannot connect to the database.

Database connection failed due to Access...

I think you hit the nail dead center here. The data was downloaded via export function of phpmyadmin, and it seems now that the download stream may have been interupted or dipped or something, and...

Geewizzzzzz, thanks for reminding me the basics here.

Line 89499 happens to be the very last line of the file.

The line just above it starts with:

[quote="sonia c":1niozzjk]

And then this...

I now tried the MySQL Query browser, but it is not giving me the option to search on my local pc c drive for loading the dumpfile. It only allows to connect to a server to browse the file.

The...

Is there a shortcut to find line 89499? When I look at the file on my local pc, it is not displaying anything in "line order" or "line number"

I'm sorry for my total stupidity, thats why my...

Thanks peter_budo, I just edited my original post including the error message.

I am helping a website owner to transfer a site to new servers. All site files have been uploaded onto the new server, only thing left is the database.

In phpmyadmin, when I try to export the...