Jump to content


Corporate Sponsors


Latest News: (loading..)

- - - - -

site transfer


3 replies to this topic

#1 brimasta

  • Community Member
  • 8 posts
  • Real Name:brian

Posted 28 July 2011, 11:10

I am currently having our site hosted free by 000webhost but unfortunately the free hosting does not support ssl certificates and therefore i have had to upgrade my subscription, yet again, unfortunately i cannot transfer my free domain over to the premium hosting site even though the premium site owns and runs the free site. so they registered me a free domain and here is the problem, i am really struggling to upload the database and i keep getting the following error.......


"localhost
Error
There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNoBFATr+0VSUk9SOiBDMSBDMiBMRU46IDMgNCA1NTYKU1RSOiADCgpTVk46ICRJZCQKTXlTUUw6
IDUuMC45Mi1jb21tdW5pdHkKVVNSIE9TLCBBR0VOVCwgVkVSOiBXaW4gTU9aSUxMQSA1LjAKUE1B
OiAzLjMuMTAuMgpQSFAgVkVSLE9TOiA1LjIuOSBMaW51eApMQU5HOiBlbi11dGYtOApTUUw6IApQ
SwMEFAAAAAgAEUr2Jmd0O69/gcQkKAIANU4OABMAAABhMjY2Mzg5Nl9teXNxbDguc3Fs5L3tduJI
0jD4f65C5zkzj6veU3ahlITA8/S8gzG26cI2Criqq/bdQwsQRm1AjCTscv/cW9m/+2dvYfdO9ko2
IyZxdW90OyUkIexMhLvm3Z3To3YDGYqMjIzvjCZsdDsmZ3Q71laz1fVzY7Lwllr/l452vl6s/nJ8
rD26Qej5S42d6PqJCZ/Momh1+vHj09PTCR+zeHZgzMnSjfiX8P2VH0an2twfO/MZ/xMmZ3Q7unSX
buBEAGfgLdxT7ef1XGPsg8Yquq45kVapn+pVrXEKP+67AX9p/OJTzTrRTywbvuledbXPm485SvZf
/tJvCgDh4fXteeun/7i5HTbuBrfDz43OXWt4ezP81urd/sff/yZxdW90O3A7dyZxdW90O2fkhByD
3xxWrRq1enW4eA7/Na/9Br+Anxzv+b/4FQNnNHe1MArW42gduNrUD7QIP/vNmUwCNwyHI99/oPc1
e63GoKUKGmedVu577d1ftOxHQ2/ym+Yto3e6/l67uR1oN3edjobTbd9wSNetm8EHGDReh5G/4IQq
HIE/cZdR8CZsdDu8d5cTN/hNG8+c4B3/SfO20wF85nytljp8zZdtJmd0Oxx7RYPH/mLlLJ9/0x6d
AAEY7CUI562Lxl1nC8rUC8Jo6SxcWTgFmMyd0iD4erluNBTk3gCqmqqA1qN1MCpJlBXfN2N/kpqQ
XlFdHS+SXppCejiRND13zGLsr/HfhWwbjzmqHKWG/OEvXanfd3vt60bvq/ap9VV7t7VL3sNP4Kvf
vMn3Yebb7N54l90r7//yXmvdXLZvWj9dP7f7jWsteW/zqtHjouYnmn1MjJ+2iZHdjz/pTNtIHy5T
veW9NuFS6GW50L7pt3oDrX0zuM2LBZRs/XfVDxr/5+joA1FdOxoFnrMEWTrj0+EfH4WR++guQ/hT
10aBM+FvnGiRGwTOGH/QmfPtu3heuuMZ/v6ZMa3qzuFvP3xy+ZZ4hr9X/tMzQGEgsCvv/y6BnPlB
MzPIXTtRNHOfANwVZwo3gL8uOPG0Op+HduMmZ3Q7addOEGnducAK/t+60k1NH/yKf0+8Jd9Y94jp
tTeZ+9GMz1cKLV3/oMH/U4gF3vgBZ/m7OzqD8lk=
----END CUT----
----BEGIN RAW----

ERROR: C1 C2 LEN: 3 4 556
STR: 

SVN: $Id$
MySQL: 5.0.92-community
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 3.3.10.2
PHP VER,OS: 5.2.9 Linux
LANG: en-utf-8
SQL:
PKJ�>���$(5Na2663896_mysql8.sql��v�H�0��B�93���Sv������1���6
�����C Fm@�$�r��[ٿ�goa�N�J6#"%$!�L���ݝӣv�����<>�V���sc��Z���v�^��r|�=�A��K���� �̢hu������ �xv`��ҍ���F���;��>�t�n�Dg�-�S���\c��*��9�V���U�q
?�i��S�:�O,��^u�ϛ�9J�_��o
����y����6���ύ�]kx{3��������"p;w"g���V��zu�x�5��������g4w�0
��h����?�͙L7 �#���5{�Ơ�
g�V�{��_��GCo��-�w��^��h7w����m�pH׭��4^����*�?q�Q�<�w�7�MϜ��I��|�|��:|͗m>{E���b�,����%筋�]g �� �h�,\Y8�̝� �z�n4������֣u0*I��7c���^Q]/�^�Bz8�4=w�b��߅l�9�����/]��w{��F���U{��K��O�߼��a����x��+���^k�\�oZ?]?��k-yo����'�}L�����ݏ?�L�H.S��6�R�e�о�z�}3�͋�l�w�����Q];��Y:�������.C�S�F�3�o�h��Й��x^�����1����o?|r�x��W��3@a �+��.���A33�];Q4s��g
7��.8�:��v�>i�Niݹ�
�ߺ�MM�O�%�X��7��ь�W
-]����S���g�;

----END RAW----

SQL query:

PKJ�>���$(5Na2663896_mysql8.sql��v�H�0��B�93���Sv������1���6 �����C Fm@�$�r��[ٿ�goa�N�J6#"%$!�L���ݝӣv�����<>�V���sc��Z���v�^��r|�=�A��K���� �̢hu������ �xv`��ҍ���F���;��>�t�n�Dg�-�S���\c��*��9�V���U�q ?�i��S�:�O,��^u�ϛ�9J�_��o ����y����6���ύ�]kx{3��������"p;w"g���V��zu�x�5��������g4w�0 ��h����?�͙L7 �#���5{�Ơ� g�V�{��_��GCo��-�w��^��h7w����m�pH׭��4^����*�?q�Q�<�w�7�MϜ��I��|�|��:|͗m>{E���b�,����%筋�]g �� �h�,\Y8�̝� �z�n4������֣u0*I��7c���^Q]/�^�Bz8�4=w�b��߅l�9�����/]��w{��F���U{��K��O�߼��a����x��+���^k�\�oZ?]?��k-yo����'�}L�����ݏ?�L�H.S��6�R�e�о�z�}3�͋�l�w�����Q];��Y:�������.C�S�F�3�o�h��Й��x^�����1����o?|r�x��W��3@a �+��.���A33�];Q4s��g 7��.8�:��v�>i�Niݹ� �ߺ�MM�O�%�X��7��ь�W -]����S���g�;

MySQL said: Documentation
#1064 - 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 'PK' at line 1"

the hosting company cant/wont help, can one of my fellow os commerce compatriots please tell me where i am going wrong?
kind regards, Brian

#2 Jack_mcs

  • Community Member
  • 24,449 posts
  • Real Name:Jack
  • Gender:Male

Posted 28 July 2011, 12:53

It looks like you are trying to upload something that is not valid. What program are you using to do the upload? Where did you get the database file you are trying to upload?

#3 brimasta

  • Community Member
  • 8 posts
  • Real Name:brian

Posted 28 July 2011, 13:11

View PostJack_mcs, on 28 July 2011, 12:53, said:

It looks like you are trying to upload something that is not valid. What program are you using to do the upload? Where did you get the database file you are trying to upload?
Thanks for the reply....
I tried the upload through php my admin and as for the database, it is a downloaded zipped backup of the database for my existing site. I made the database backup through php my admin on the free hosting site. I know I am no web guru or anything but this has got me feeling very thick indeed.

#4 brimasta

  • Community Member
  • 8 posts
  • Real Name:brian

Posted 28 July 2011, 15:16

View Postbrimasta, on 28 July 2011, 13:11, said:

Thanks for the reply....
I tried the upload through php my admin and as for the database, it is a downloaded zipped backup of the database for my existing site. I made the database backup through php my admin on the free hosting site. I know I am no web guru or anything but this has got me feeling very thick indeed.
Would you flippin believe it???!!!
my new hosting site has made the transfer for me now, after about 30 tickets with the helpdesk regarding uploading my old site site, they finaly said " if you give us the details about your account, we will do it for you"
so its all done now, but thank you for helping.