file sql.gz give error 1064 when import in phpmyadmin

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
imototep
Registered User
Posts: 1
Joined: Mon Nov 14, 2016 9:45 pm

file sql.gz give error 1064 when import in phpmyadmin

Post by imototep »

I tried to import a .sql.gz file that I exported before another server in phpmyadmin in this new phpmyadmin, the phpmyadmin version is the same, the sql is being imported the same way it was exported (GZIP), but the 1064 error and does not conclude

I was opening the .gz file in the text editor, it includes the delimiter - additional to see if it goes, but the result is the same

In the text editor, the .gzip file is not completely visible to the SQL text, after the thousand line is compressed, small sample text
q@WG°LSÔµ
Ä]­0Scˆc»†8¼ëaˆ#üp¢–GwuyqdW—ïX¤^ù¡†Çumqd×…±Ä±]mXcˆãº†8¦ëaˆã93†£É`óóe’e/œ8º·àHÙ\
OìÛx¶2jò6o‚ŸgÛü¼Œ£ÕñEšÍ±ëU¦>Ç…ò‡ †æ!
I need to import this database in phpmyadmin and I can not, I exported another one to see if I could import, no, does phpmyadmin have any configuration that prevents importing the gzip file itself?

seems to me the characters is in the 1052 and not in utf-8 , what can i do please
User avatar
AmigoJack
Registered User
Posts: 5799
Joined: Tue Jun 15, 2010 11:33 am
Location: グリーン ヒル ゾーン
Contact:

Re: file sql.gz give error 1064 when import in phpmyadmin

Post by AmigoJack »

  • The worst thing about censorship is ███████████
  • "The problem is probably not my English but you do not want to understand correctly. ... We will not come anybody anyway, nevertheless, it's best to shit this." Affin, 2018-11-20
  • "But this shit is not here for you. You can follow with your. Maybe the question, instead, was for you, who know, so you shoved us how you are." axe70, 2020-10-10
Locked

Return to “[3.0.x] Support Forum”