So I was trying to upload a backup to a new web address as a testing grounds for my forum. Whenever I did this, I got this insanely large and completely confusing #1064 error messages.
Also, please be extremely newbie friendly. I don't understand all kinds of code so a detailed description of what to do would be helpful. Thanks!

Quote: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----
eNrt2Hk01Pv/B3CyxGecspRB26cTd2bKMIOJdDqZYWQZY1+jZsYMMxpDzBR187VGWa6bpShFtjCE
kKSFSiiyR6tKllSSK5WW76C63zrfe799z/mdn+8f7znmmPP+vOf9fr5fn/fM5zMPsp2dtZ0hbIyH
jXVgCplqCBP09ERPAqyjjyPoQPYOoqOrIMjeSXRI3ZxpCAfu5PrTAwJZAVpcDkPLn+0P4/E4vD6s
g8PpY/E6WB08jDcwFP3p6bnBXJbvBlgdsgq2t6WIhtbCaxH0IUd7O9jaXhMmbiFTHTRhJ7JoCmcO
D7YnmhLtzEW9cFoEXX3IxopoCOto4fFaepCNmc1MP01r+5lRRI36MIXDEwRBFCJ1iyHM4mEFfC+s
ATQ7DRYLWwWTSLAJnU9n0ANZMInuuUPgD4nat7B4rAA6nyVaB86Az4YtBNxgUXI8AabzYdx6Qz2D
mV7Yn3lAkLEdmehAhh2IJAoZpvkGMxjb6UxfDo/r502D0RAM0wQcJg3m8PhoPA4DC3iBHG8eiwlT
rR1gqiOFApuQTYmOFAcYhUNpznTn+NOZzABWYCAN3kUPYHB49IBgNH495t+8Y+4NTNFSuBwe67+Z
xNePKeCyZmfwZNMD0ATcX49P9+Rz/Hg/11eUhU6D+awg/rcuM+2WZNc/50R/faX5dWjMtz6ztULP
/sNAGJhM3WJOJW+yCja3J1p9m8vYjGhnT3bYJDrbBhvXwLP7Cg5g8QUBM2um82CWrz8/WNQSKODy
4UAWH0ZztFha8B5WgB8c4Lc7EKMFQatiZcRmHxITfyB2Qbav/kCMOzcWUywOWlOaWm7eaLJ2bjND
t1DM28wbNc0o5hgLrJZ0ub2ipV2gzoRd2M17H5I7lsuvwZ9T1928+JedAj/+xrQjmQXyg8NKz9SE
mVm8UyXZx/8I6dSBWWwGl81m8Ghe0MCSww6DOc9SmTmDecoS59LOSb0jaxiZnkzJchTkpYSJnmWC
4po8AlKM5SiMzBCl+zOmxgE8VI9TMd1treDeQYpqUD44MtCWBS/ljjqUFsi+Nz500Dx6Lse26xJB
+NP92tSxC2PrimoM9HKE6ZvwE7hjkXq0yaDVxM1hz7NX8kjN5wMWeUCn9VyifEw3jJyIORPd/sm6
PXqg+n4l2WpBM9sk+tZ0FI1T75J+zTX80Qdhd/P2FNtF9uavZOpufxD/hcvf2LrCu3brL3Rf/433
dRa2lq53Ke6mXV53YDRp/7vHiLQ+1/tnv19BExEKN1rSML4vX+XeKVp/jk18kbJWJM7MV2O4t/ZZ
XZyprpZ6DXXhMMMj63ensc/T21KRI2XqrttWxqTXlDwi0bWj143fUSAvqwgaIs3Mb7TjbviyxN4I
K0KMbWvdLenoT58Hiq2p5/elKF8NLFhWfX9qoiq6QSF33PBepPIdimLqoDT0BwUXH4pYlVv2mHvt
eGO9iW6zD6owQ1K18o6b4wWTKOlIj+0lJzRDfvHmb7zO8Lr4wymYWYCK6VQGwz87PCzJlFDiVi1f
D1c6Jmbrdi/WVWutThw2XJEZK4j6xJ58MH1RU7vD2Ly89p7SJkJLGgLKeHb6atEWeYHNlQwE3syz
TeqsHRFlK9A2nVR64DZ8/nPTjhPLz55fi40ZstP3PyqqfuZOE04tdNtSzhOlMfRmttKVekcOh7A1
Dp2R2iuGULqC3rihvck81FYIOXVj2mi5lydH3jc9R/TrO26u/i77/9cuZzKhAfWhoVxW3qjyQHKe
9+BSCSmj2eTJ4lbS+OI4YaFusZwwtvimkJEcsM5SMemgZ7JQ1FScFFpf+Sy9x13soT2bUjEP4elM
Bk/u58LHFTOSDykGfkte7eTRmY4Q07v5fn3ZPCUX/7nkmqLkr+1uIF7rTlgc/DH/npJLD8/OR34u
00t2YCA3FTngPZiy5NsSrhntTxaHFv5LfDkr0bbpb34Sq/sawfghfYXM8SOX5yf9IsUblljtxls3
12F6sI0YK9EL6YNhchgJtUUMN1VXR283VRfkVlXVrdfQdSnXkYdnz8xSFJKlHPp8XYJteWuFTgV1
wWM3gdUOLTGlCxITTfOyDgb7u7OQn5rMHMxFSkgl6SpOdNiHxZmskyh6NhcS1ym8c3ReQvrI/Gux
qVhM001LbWlotqTe6oO5+QtUDzhJO3XPfZm8jnfUnp+cXjTJny1mMfFRwPyE5HEXDCQr5yuP5CGf
HlZeIhFsdIWYk/L719sRKfllbsitaW7X0O8OD+UqX0O73i7c4RYoLkYdxhwump/EHPG5xOExDHgh
e31MhU55oejzUyp6LmAYjzLWGUsUqeRmdi2JKu06Vt51SEVj9MuW7VNYWfrDBb0OCsctjx7bdO2V
TlR4nrSO9YqZGwuZrMQec/YZSHV4dlcdXTOXbE/Gykzk6NL3W/LHpkMulfsc9IxtLixu549NI5BJ
HdmqNo21ityWrptRpR0b/OuQG9Ziiag1H94qhXgkt39OOiOTMRVt354pr1Tb8HHo44JEvdXqluV6
+19R77TQ4k+sSF7iI+6v1hl98u49W9J5eDTc3XZBZUShn5uby3GDZufttg4qheXfx084P3dLeGIu
X3VOFNSgrD3SlWVMXNv7zAFXIPs0ugpzTm7u8MWExf2x76A8g31D/qmn0UUf3LNPCq3ZQRUv4mPF
G7YJ0LRFkrEqFHcZbPy4ZnXKpriOJ5mRo979uxE+H7a0kvgtCYdrSeKzFTGofzE18cb40JHEfb/2
vqw1WDNZ2Nls1XB0Ce2jf02WdeZolw3pKKtD0z6TWXV1x/oTCzwJZy2WPdxmQEFuxpCulNX+9WmQ
ksj/7jQ09u2X4ye1KChcoC5ui52EPmZ3Tu27tN2VcK2MzOruYV9cfCVq3LXQ/LfGsYyBfb03onby
Iiv7jxUzDlmEtqafH0E9r7Eo/oQaleA/WEUlR/xK8Y8R3dhKwRySWaqpudwjIe5uO/usC7ruKUTT
y1tsnn3PjrRRe7TW3W62+hYqouo36m9HNEmKl/9V6mFRamfT/2bznBROeEYcLC9oCxqrQSCzOyJG
bC/XKmoyfB6TXEaWV/efWZ6cmpmtEPJW9lJr8/DnJteY1ukrmNO2obIJ/lPBl8TU++QPzQ6v/oAY
hHpReLbBepEFRJAw8BBtoJ2D6KwXOr6H005K+iAc71dUlM7k2nkEe/EZ41DJ96vA3iSK9pC8VNuF
fBleYSaNG6vhcc5/dYzUVg/Z9YTsRTkF6ti5BTwWzIwSipyAqEVF7/w+4W4IanqZ3HOtik4PYh/D
jgdMnb3XNy5zeIe+XuTQHB6YnCIkZosfZOWq3ZcOFpbpXLIbNK46eroqNhmaGehlfO3jiZD2/rBb
wUte+Zuyl/eO9zm1dP8+/I4Y4UDbGmM008mGwkBV9069u7gqu7/YLe9UXVef1KOupZ2fXbuaUFE5
A16XOwZHoCcPkJiZ3qj6h3/zk0nqHy8yv/xkEqw90mXycbVVrvlChdNPxGuPOOPqnu4dG1/KShnb
YZc8mcD/rWqTbF9W+8cUk19NmpQSdq9+mimc1IqyV4t/fWcyoIt4tY/u9ym/H7+BVxVdO1cfBan0
tjfTwXuNaiRdckup++KcoDO4nuhDwzPRJLeWosqDvVRLvaAWPWPpLJLTqZSdk1D3tVXaat5Jq3qm
9ijMx/06ncHkiX9/ASjApGkYrW1vbiw07Gy+XNPb3LbWtGluKNMmUZN8o67U6w83JuxiQ+da566z
N0+tsS6flxVwObL/JyuYKkqByv/meykiFcE8bhgkT1pdnJT4sx/vP68NvcEaNdX2ush6i6HLUtsH
TlVIZsS9emL9VmBr+tn6AXm4dvOx12pRR/pVpk5MIYzYJDMLjBVcm7Rrk8sT74UaUW5ix3z7jMus
BlXovolVxDyVsDtER30sVtN6OatIO2FlYMK8VN+Hy5T9z6px4ItqfKlVvPMPtNFkPQMD12dg4M4p
WltOWHyRsiJJJadSkc/dRsD946Sq7IGSTvEaF2d2Tvd0SIi2djN3e1btqV1mizxu28yeh3OK78M/
VA0Joa0h2XH361Rux7nJu4dZFrhqN2SiblS+38xZlvlkz95Gi4G9vYgLL6eDz0c8kXnCVCUfiCiL
CE27EC6pq8i90k/ZS89AuyaiUBNd8pRnHHdre2ppZ3OBWPF60ubErdu3JVJDAuKG7/3oAjP5l39x
AWKSNKHEzUyGnthj0die5kP7FKmrqOiRL8EvK2nTdrswdfHP+PG+e09SZLEtUlItsIsS4bGp6ui5
yv44Q62owczmUuKnyF1UlY+bOUonZ6Mvedv724c3EyHi/oqete5XzeXo99HvujzOPVZ+zX2fIIFJ
S4qGz3QpUny0Cy44yMtVhq+tbl/GeSnTk78qL0nbWS8mtfpvQMamP4f8n0Am/WlTGcxxWh6jdrdq
kERHTa8bTxcn6/q9ao0KCu2pktKHyySOFiIjjoWfgN7c/9y07MSxXdM6TQeG7Ha/rHp46+5Ktahk
Xk/72tI2r+RSnL5NJiq8QMr9LRy/1NvyjYny1XRbpw30p1cbT3X3FD5XX6sHP38f8DHojQTy0Tjz
7yyGmKT81WJS/sJi9G4keRI7hAbyP20xX6N/sRhbsxGvFcU9Kg1Ui9YXVj4cnPbHNgt1UW6xqhgo
WxhQ33wgzFaIder76jDjzxG+6Yp539ecEG8J1RvJ7Z86zhjOw6L5FW/Zzlo16Jjw4hLJjUAlgUoC
lQQqCVQSqCRQSaCSQCWBSgKVBCoJVBKoJFBJoJJAJYFKApUEKglUEqgkUEmgkkAlgUoClQQqCVQS
qCRQSaCSQCWBSgKVBCoJVBKoJFBJoJJAJYFKApUEKglUEqgkUEmgkkAlgUoClQQqCVQSqCRQSaCS
QCWBSgKVBCoJVBKoJFBJoJJAJYFKApUEKglUEqgkUEmgkkAlgUoClQQqCVQSqCRQSaCSQCWBSgKV
BCoJVBKoJFBJoJJAJYFKApUEKglUEqgkUEmgkkAlgUoClQQqCVQSqCRQSaCSQCWBSgKVBCoJVBKo
JFBJoJJAJYFKApUEKglUEqgkUEmgkkAlgUr+r6nkPwHZQBfD
----END CUT----
----BEGIN RAW----
ERROR: C1 C2 LEN: 544 545 27052
STR:

I made one into a SQL file, which gave me a white page when uploading it. And I did a GZ file, which gave me this.
Can anyone help with this? I really need this resolved.
I still very much need help. Someone has to know what to do.

for phpmyadmin it needs to be sql.gz and if its throwing that error the backup process failed somewhere corrupting the file it gave you. coming from a web hosts prospective the best I can suggest is do a new backup of the database and see if that helps if not contact your hosting provider. is your testing ground local or on a hosting provider?

(07-09-2015, 08:29 AM)Ben Cousins Wrote: [ -> ]Compression doesn't do much anyway. If it's a large site you're better off running "source name.sql" in MySQL anyway

Well yea for me I know alot of hosts keep there limit to around 50 MB if its free hosting you get a bigger upload size if you are paying for a premium plan of some sort or well at least that's how I do it.

(07-08-2015, 07:27 AM)SilentThief Wrote: [ -> ]I made one into a SQL file, which gave me a white page when uploading it. And I did a GZ file, which gave me this.
I still very much need help. Someone has to know what to do.

What settings did you use when making the backup, are you sure you used "structure and data" for your backup?

(07-09-2015, 05:54 AM)rservices Wrote: [ -> ]for phpmyadmin it needs to be sql.gz and if its throwing that error the backup process failed somewhere corrupting the file it gave you. coming from a web hosts prospective the best I can suggest is do a new backup of the database and see if that helps if not contact your hosting provider. is your testing ground local or on a hosting provider?

(07-08-2015, 07:27 AM)SilentThief Wrote: [ -> ]I made one into a SQL file, which gave me a white page when uploading it. And I did a GZ file, which gave me this.
I still very much need help. Someone has to know what to do.

What settings did you use when making the backup, are you sure you used "structure and data" for your backup?

How large is the backup file?

@rservices I am using a hosting provider and is there an option for sql.gz? Also, I have tried numerous times.
@Ad Bakker I tried both GZIP compressed and plain text (tried both), download, and did structure and data. Also, the file size is for the GZ file is 1,497 KB, and the SQL file is 3,262 KB.