i am new here, so hopefully i'm doing well...
I had the same issue and i found a solution or workaround for me and maybe it will help you as well.
read everything before you try it out and of course no guarantee...
1. I converted my vm data (~/.bitnami/stackman/machines/xampp/vm/machine.qcow2) from qcow2 to vmdk (as end1an described)
- Code: Select all
qemu-img convert -f qcow2 -O vmdk machine.qcow2 ~/Downloads/machine.vmdk
(for installing qemu - https://www.qemu.org/download/#macos - I used homebrew - https://brew.sh)
2. I changed the machine.vmdk to machine.zip and extracted it (also with keka - https://www.keka.io/en/)
3. i installed xampp 7.4.16 for macOS with the installer (not vm)
4. I copied my projects from the old restored /opt/lampp/htdocs folder to the new one /Applications/XAMPP/xamppfiles/htdocs
5. I copied my projects database folders + phpmyadmin from the old restored /opt/lampp/var/mysql/ folder to the new one /Applications/XAMPP/xamppfiles/var/mysql
6. i copied ibdata1, ib_logfile0, ib_logfile1 from the old restored /opt/lampp/var/mysql/ folder to the new one /Applications/XAMPP/xamppfiles/var/mysql
7. i copied db.myd, db.myi, db.frm and proc.myd, proc.myi, proc.frm from the old restored /opt/lampp/var/mysql/mysql/ folder to the new one /Applications/XAMPP/xamppfiles/var/mysql/mysql/ (I'm not sure if this step is a must, but I did it...)
8. i fixed the file/folder permissions/rights for the files I copied to mysql or mysql/mysql to the same like the others in these folders with the terminal (for changes I used sudo chown -R _mysql [file or folder], sudo chgrp -R _mysql [file or folder], sudo chmod -R 770 [file or folder] and ls -l for listing) - be carful by changing rights
after restarting mysql it worked (before I used a err log file to see why the mysql server didn't start /Applications/XAMPP/xamppfiles/var/mysql/usersname-macbookname.local.err) ... some project Wordpress settings are lost (I don't no why, but nothing important for me) and the link to the localhost is now localhost without port :8080 ...
AT LEAST I've got all my databases, files, folders etc - good luck
some more links I used:
https://stackoverflow.com/questions/29258769/how-to-restore-mysql-database-in-xampp
https://superuser.com/questions/1328965/how-to-restore-mysql-database-using-files-on-data-folder
https://stackoverflow.com/questions/38759870/xampp-mysql-table-doesnt-exist-in-engine-1932/44799226