I re-installed my board on the same server without making any changes but when i try import my backups, i tried 3 different ones i get the following message.
Error
SQL query:
[...]
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 '?LI?I?,HLI)J-.?SKRs2?R??????#1?$3?"??????????n???Þ›?H????Z???9??yi?' at line 1
Could someone please help?
I'm using phpmyadmin and i'm the server owner.
What's the extension of the file you're importing?
It's ( longnamehere.sql.gz ) the same as it was when i downloaded it from the site using admin panel backup
It's a compressed archive. You need to decompress it and import the .sql file. If the backup is on the server, and you're using a linux distro, you can use the gunzip
command.
I'm not able to unzip it, i get "Is not archive" (I'm trying to do it from windows).
(2016-03-27, 11:03 PM)Nathan Malcolm Wrote: [ -> ]You should be able to use 7-Zip.
http://www.7-zip.org/
I tried it, i also tried
http://gnuwin32.sourceforge.net/packages/gzip.htm
I can't make it work
Looking at the file i think it's broken?
-- MyBB Database Backup
-- Generated: 18th March 2016 at 15:23
-- -------------------------------------
CREATE TABLE `mybb_adminlog` (
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`ipaddress` varbinary(16) NOT NULL DEFAULT '',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`module` varchar(50) NOT NULL DEFAULT '',
`action` varchar(50) NOT NULL DEFAULT '',
`data` text NOT NULL,
KEY `module` (`module`,`action`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
]«®iÍ ößWZ ‹ %ÉÁ
‚0Çñ{O1¼LÁ •ÌS!ŒÒ: n¶5Ø4Ú<Hô½JÏؤÓÿûùýó¢ÌŽÊ‹jôض
Zvª¿!Ÿ rest of the file looks like this
^ that looks like corrupt database !