1
Zap_English
Big problem with SQL

My webhost went out of business because of sanctions. The backup of my 20+ year old site they gave me doesn't have an SQL file. It has a 55 Mb Binary-sql file

Can that be chenged to SQL and used to install the database on the new server or am I F&^%ed ?

2
Mamba
Re: Big problem with SQL
  • 2022/4/29 20:09

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


Sorry to hear about it!

I never did anything with the binary log files (I assume that we're talking about the binary log files).

Maybe this will help?

https://stackoverflow.com/questions/42374958/recover-lost-mysql-data

or this:

https://stackoverflow.com/questions/48554131/restore-mysql-database-using-binary-log-file-log-bin-on-windows

From this article: https://ottomatik.io/mysql-binary-logs-backup/, it seems like you my need an old mysqldump file as a starting point, and then you could apply the binary logs to restore it to the latest version.

Did you talk to them about getting you the MySQL files? If they still have access to the server, then they should be able to get you that?
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs

3
Zap_English
Re: Big problem with SQL

They're not log files

They're called xxx_binary-sql (with not file extension)

On further searching it sems they are only 32 bit check files and don't contain any sql details

So that's 20+ years of work down the toilet

4
Mamba
Re: Big problem with SQL
  • 2022/4/30 9:27

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


Again, I'm so sorry to hear it.

But I can't believe that they could not provide you with the database backup. If they got you all the other files, then obviously they still have access to the server, right?

I would ask them to explain to you what these files are, and how do you suppose to use them? Maybe they could convert these files to a mysql format?

Another way to get back your content, even if it would be very time consuming, is to use http://www.archive.org and then copy individual pages from Publisher there, e.g. your recipes.

Maybe you could even create a script that would go through all the Publisher posts by "id" number, and extract them from http://www.archive.org? Just thinking here loud...

Check your PM...
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs

Login

Who's Online

261 user(s) are online (116 user(s) are browsing Support Forums)


Members: 0


Guests: 261


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits