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 there is some more data that is missing.

In the meantime, I re-exported the database, in gzip format, and this took only 2 seconds, which make me think that the zipfile may not even have something in it. On my pc, it does not want to open the gzip file, it tells me it may be corrupt.

However, I then tried to import the gzip to the server, and got the "not enough" memory error in phpmyadmin:

<b>Fatal error</b>: Allowed memory size of 16777216 bytes exhausted (tried to allocate 10201461 bytes) in <b>/usr/share/phpmyadmin/export.php</b> on line <b>81</b><br />

What does all this mean?

Thank you so much for your support and patience with me, and your proposal to view the data. If all else fails, I don't have a problem if you view the data.

Function has alocated only 10201461 bytes where as you can see you want 16777216 bytes. Try to create split version of whole DB. Like you have 10.000 records you put 5.000 in one file and other in next one. I can remember how I did it last time

I think (and I am not sure) the problem is with an extra quote ' in the query. It might have encountered a value like,for example, O'neil. This would terminate the query abruptly as in the following example.
insert into table (name,address) values ('O'neil','some address'); Anyway, maybe this can help..
http://www.webdevelopment2.com/impor...n-get-bigdump/

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 denied for user '******'@'localhost' (using password: YES)

Edit the database settings in /home/****/public_html/dump/bigdump.php or contact your database provider

Now, the settings is the same as the database name, user and password.

What am I doing wrong?

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, as the import keeps on timing out.

Is there some geek out there that will help me export import this database I will pay for it if it is not too much you charge.

Umm.. I just checked bigdump and it worked for me.. Well, I didn't check with over 50mb of data though.

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.

Are you sure you have changed these configuration ?

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

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, when exported, also via phpmyadmin, and without any error warnings only exported a part of the database.

The new problem, was, how to get this database exported, completely, without SSH access, and also, I am a bit scared as a novice to use this line commands.

After many attempts to download this huge database, in phpmyadmin, it just never did download completely, and any zip format in phpmyadmin did not work either.

I then contacted the owner of the server where this database is currently hosted, and asked them to export it for me and make it available for me to download with FTP.

This was done by the server owner, and this is where I am now, busy to get this huge database via FTP to my local hard drive. The total size of the zipped file is almost 160 megs, so I can just imagine that if uncompressed, it should be like almost be a Gig?

My next step wil be, to import this database onto the new server. I would like to keep this thread open, untill I installed it.

I felt it necessary to wrap this threat with this update, as it is a shame that mostly, unresolved threats just hang in the air, and poor monkeys like myself, waste a lot of time reading them, without getting to the solution.

What I learned so far:

phpmyadmin cannot handle large files, which is very sorry, because otherwise, it is a great tool to use.