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 DATABASE to my local PC, using zip or gzip to compress, as this is a large database, the file doesn't want to uncompress on my local pc, I get an error message that it may be corrupt?

Then I exported the database without compressing it, and it downloaded without any problems.

As I am realy very novice in this, and only have a basic knowledge how to import this database from my local PC to the new server, using phpmyadmin, the first problem was that phpmyadmin only allows 51 mb to import this way, and this database is about 90 mb. I am very unlitterate in doing command line queries to do this import, so I contacted the support of the new host to help out, and they said I can upload the database via ftp to the server, and they wil install it from there.

I then uploaded the uncompressed .sql text file to a folder, via ftp, using binary mode.

When the host tried to install it, they got an error message in the syntax at a certain line, and asked me to correct it. I have no idea how to, as this database is just what came from the old server, nothing changed to it.

Is there any help or hope for me on this one?

Edit:

The full error message the host got was:

[root@cayenne /home/kletsker/mysqldump]# mysql kletsker_kletskerk < localhost.sql ERROR 1064 (42000) at line 89499: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''[quote=&quot;Barend&quot;:3v' at line 1

If you post the error along side of critical part of sql somebody should be able to help you...

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

That nice, but you see what it says
So can you kindly provide that part of SQL and few lines above and bellow will not hurt anyone as long you not have some sensitive data such as contacts, acoount details etc.

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 avater looks like me.

Ehmm that is good question...
I dont think you will be able to do so in phpMyAdmin (I'm not aware of such option), but I was able to open sql file (that what you get it after dumping isn't it?) with Dreamweaver, Microsoft SQL Server Managment Studio Express (is free) and I believe you should be able to it with MySQL Query Browser (for free part of MySQL tool package). Do not forget change setitng of chosen application to show line numbers

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 database is sitting now on my pc, and I need to find this line number there, I am viewing the file in notepad. If I do a search document, it returns many markers with that words in it, so how wil I know which one is the queried line?

I will pay someone to export/import this database for me, as I feel my knowledge is far too short now.

Right click on the sql file Open With >> Choose Program. Navigate to the location of MySQL Query Browser ( in my case also default location is C:\Program Files\MySQL\MySQL Tools for 5.0\MySQLQueryBrowser.exe ) and the file is open...

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=&quot;sonia c&quot;:1niozzjk]

And then this users forum post follows.

Then the troubled line only looks like this:

[quote=&quot;Barend&quot;:3v

Nothing else.

If I look at this, should the "[" at the start not also close "]" somewhere?

I am learning, thanks for your trouble.

I have distinct feeling that you main not pull all data from original database. What I mean is that you maybe just missing closing bracklet, but in worst scenario reminder of the post or other data entries. It is very difficult to advice on this as I do not know structure of database you trying to export/import. You need to closely examine previous data entries and work out appropriate structure. Also you should compare it with old database if still available what this data entry contained and if there are any data entries after it.
I will make exclusion in this case and if you wish you may send me personal message with some data examples (last 100 lines should do it). It is up to you to decide if you can handle also if you can pass such data on 3rd person