• Home

Restore lost data in MySQL using InnoDB engine without file ibdata1

If by any chance you moved your MySQL files by copy pasting or you lost you ibdata1 file and your MySQL database is now not working, you may encounter this problem that when you go to phpMyAdmin you are abel to see the database and all the tables, but after you click on the table name you get the following error:

MySQL error - #1932 - Table 'table_name' doesn't exist in engine.

In this case, you can follow these steps to help you restore your database from you .FRM and .IBD files. 

In this example, I'm assuming you are using your localhost and XAMPP installed on a Windows machine. 

Continue reading

XAMPP on the cloud (OneDrive, DropBox, Google Drive, Box, ...)

If you are like me, I don't like to be bound to a single computer at home, rather I like to have all my files with me all the time, just in case!

If you are a developer and use XAMPP on your local computer, how can you have your XAMPP files on different computers so you can use them at anytime? Follow these steps and you can have all your website files and database with you on any of your computers. 

Continue reading