Jump to the post that solved this thread.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 4 Years, 1 Month, 4 Weeks ago [How To?] Import database backup
#1
Solved: 4 Years, 1 Month, 4 Weeks ago
Hi everyone,

Recently my hosting decided to quit out of nowhere, without a warning.
So all I had was a sql backup, more specific, sql.gz back ups.
Now I can not import this file towards my database, because I get the following error:
#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 '?' at line 1

Anyway how to fix this? The adminlog column does get imported though.

Kind regards.
Reply
#2
Solved: 4 Years, 1 Month, 4 Weeks ago
Dit you try to restore the database tables from phpMyAdmin?
Regards, Ad Bakker (NL)
Reply
#3
Solved: 4 Years, 1 Month, 4 Weeks ago
(07-05-2015, 05:33 PM)Ad Bakker Wrote: Dit you try to restore the database tables from phpMyAdmin?

My apologies for the late reply.
I've tried doing so, which resulted in it not working either.
It's compressed and I can't open it with Sublime text either.
Reply
#4
Solved: 4 Years, 1 Month, 4 Weeks ago
(07-21-2015, 09:51 AM)ElCocaine Wrote: It's compressed and I can't open it with Sublime text either.

Can't you uncompress it then?

How large is the file?
Regards, Ad Bakker (NL)
Reply
#5
Solved: 4 Years, 1 Month, 4 Weeks ago
(07-21-2015, 09:57 AM)Ad Bakker Wrote:
(07-21-2015, 09:51 AM)ElCocaine Wrote: It's compressed and I can't open it with Sublime text either.

Can't you uncompress it then?

How large is the file?

8.01mb.
I sadly can not uncompress it, winrar says it's corrupt, so does gzip.
Reply
#6
Solved: 4 Years, 1 Month, 4 Weeks ago
I fear then this is the end. I do not know of software that can repair corrupted .gz files.
A lot of data to loose. You cannot get in contact with the old host?

A lesson perhaps, go for a trusted host. Prices are not that high!
Regards, Ad Bakker (NL)
Reply
#7
Solved: 4 Years, 1 Month, 4 Weeks ago
(07-21-2015, 10:04 AM)Ad Bakker Wrote: I fear then this is the end. I do not know of software that can repair corrupted .gz files.
A lot of data to loose. You cannot get in contact with the old host?

A lesson perhaps, go for a trusted host. Prices are not that high!

I can't, they claimed to be hacked and then went offline.
They don't reply on skype nor twitter.

Thanks anyways.
Reply
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)