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?
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="Barend":3v' at line 1