Restored MAMP folder - Can I get my database back?

[tokkelosh]

Firstly, I have to admit that I am not very familiar with DB applications.

Here's my problem (any suggestions would be very much appreciated):

I had a virtual store running on my Mac. All was hunky-dory with 600+ items in the store and almost ready to upload to my host. I made a daily copy of my entire MAMP folder (XAMPP equivalent) which includes the Zencart installation. I stupidly installed WordPress into the htdocs folder - things went wrong and I ended up with an unrecoverable mess.

Copying the entire back-up MAMP folder into the same location gets me sort of back to where I was as far as the layout and customized themes goes, but the DB with all my categories and items are missing. Is there any way of importing/linking the old DB into the 'new' store ? I've tried the Importing from phpMyAdmin but cannot seem to get anywhere. Attached is a snapshot of the files in the DB folder.

Is there something simple I'm missing or have I lost everything ?

[DrByte]

If you open your browser to "localhost/MAMP" can you access phpMyAdmin and access your data?

Your MAMP controls might be on "localhost:8888/MAMP" depending on how you've set it up.

[tokkelosh]

Thanks for your help DrByte.

I can access phpMyAdmin. I reinstalled zencart using the same settings as the original install (db name - zencart and the same password) and now have a zencart (95) db.

Would I be correct in assuming that the file ibdata1 (10MB) is where the original data is stored ? If so, is there any way of importing it ?

Mmmh, is there an 'Idiot' Smilie for me to use ?

[DrByte]

I have no idea what "ibdata1" is.
If you originally had your data in a database named "zencart", then that's where your data would have been. If you've created a new database named "zencart" and/or run a new install using that database name, then you've likley overwritten the contents of that database and would need to restore from backup again.

Rather than doing a "folder" backup to backup database content, you should use phpMyAdmin to do a proper database "export" so that you can move your data around between servers if necessary, etc. Related FAQ: https://www.zen-cart.com/tutorials/i...hp?article=103

[tokkelosh]

The only file that appears in the zencart db folder is 'db.opt' which is only 4k in size. Looks like I have two choices:

1) Learn SQL
2) Start drinking

It's all gone isn't it ?

[DrByte]

It would seem that if your MySQL folder, which at one point contained database table files for your offline Zen Cart data, is empty, that ... well ... that data is not on your computer anymore.

Whether it's available in your backups is the remaining question.


You might find more specific support for restoring your MySQL data using raw operating system files by looking on the MySQL website and/or the MAMP support community.

[tokkelosh]

The backup folder is also empty - I have no idea why the contents weren't copied from the original. Permissions perhaps ?

I've accepted my mistake and have started from scratch. Unfortunately I've had to learn the hard way.

Thanks for the input and help.