Support

Akeeba Backup for Joomla!

#35200 Getting only the database script copy from backup which has been taken

Posted in ‘Akeeba Backup for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Akeeba Backup version
n/a

Latest post by nicholas on Wednesday, 12 May 2021 03:34 CDT

Sunday, 09 May 2021 04:42 CDT

anildagia

Please look at the bottom of this page (under Support Policy Summary) for our support policy summary, containing important information regarding our working hours and our support policy. Thank you!

 


EXTREMELY IMPORTANT: Please attach a ZIP file containing your Akeeba Backup log file in order for us to help you with any backup or restoration issue. If the file is over 2Mb, please upload it on your server and post a link to it.

 


Description of my issue: Hello,

 

I have a backup of my site taken by akeeba pro. Now what happened is I was cleaning up my database email list and accidently deleted some that were not meant to be deleted. I also did a lot of other cleaning up. I don't want to do all of that again.

The bakcup file contains the SQL script collection. Is there a method by which I can upload the scripts to a temporary database? If yes, then I could just take the entries that I need and proceed wth adding them into the main database from phpadmin.

In the absence of that I have to install wamp/mamp and then install the full website on a backup server and then get the relevant entries. I am hoping I can avoid all of that.

Please suggest if I can use the sql scripts and simply create a temporary database and upload the data there. If yes, - How can I do that?

Monday, 10 May 2021 02:49 CDT

nicholas

There is a method, but I'm not sure it's easier than restoring the backup on a local web server. It's documented in https://www.akeeba.com/documentation/akeeba-backup-documentation/unorthodox-emergency-restoration.html You need the first four steps.

In my opinion it's far easier restoring the entire site locally and using HeidiSQL (Windows), DBeaver (Windows, Linux, macOS) or Sequel Ace (macOS) to extract the one table you want and restore it on your server with phpMyAdmin. When I screwed up the user properties table on our site a few years ago this is exactly what I did. Much simpler than trying to figure out which files contain the data I need and edit them by hand.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Wednesday, 12 May 2021 00:18 CDT

anildagia

Thank you Nicolas. I guessed as much and yes indeed it was far easier to just restore it on a temporary databsae. Although what I did was a I created a temp database on my main server and resotred it over there in a subdirectory.

 

The issue is I used to have WAMP on my windows laptop and currently I hav a Mac. I tried using MAMP on Mac but fter installation when I launch it, it would not launch for hours. Their guideline says it will take a long time for launch but forever is much longer than long.

Do you have any recommendation any WAMP equivalent for Mac - which has PHP, MySQL, Apache all inbuilt? My Mac is on Big Sur and the software would need to be compatible on Big Sur. Sorry - I know this is not your core expertise - but if you have used something then maybe you know something that works.

Thanks.

 

Othere than this suggestion - we can close this ticket

Wednesday, 12 May 2021 03:34 CDT

nicholas

Well, as it happens, it is part of my core expertise. I am setting up my own dev servers on Windows, Linux and macOS for the past ten years and write blog posts about them. You can't write a backup extension without knowing how web and database servers work at a rather intimate level.

The instructions in https://www.dionysopoulos.me/custom-apache-and-php-server-on-macos-the-definitive-2019-edition.html still apply on macOS Big Sur with the following notes.

PHP 5.6 is no longer available. No big loss there, this PHP version is obsolete for years now.

Remember that when the instructions talk about PHP 7.4 they are actually talking about the default HomeBrew PHP version which is now 8.0.

You will need to install PHP 7.4 manually, with the same instructions as 7.3 replacing @7.3 with 7.4.

The part about SSL certificates is optional but strongly recommended. Some features won't work on plain HTTP sites e.g. WebAuthn in Joomla 4 and Akeeba LoginGuard. Having SSL with valid certificates already set up on your local server is a massive help when testing this kind of features.

You don't need the SSH2 extension. Don't bother with it. I wrote about it because I use it for development of some Akeeba Backup features. 

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!