8/17/2023 0 Comments Export xampp database![]() Now, copy the contents of, (not the entire folder), your mysql database folder that contains the. At this point you’ll want to turn off the MySQL service. For example, if your previous database was called ‘wordpress,’ in phpMyAdmin, (under the ‘Create new database’ text field), you would enter ‘wordpress.’ This will create a folder named wordpress in /Applications/MAMP/db/mysql if you’re using MAMP, or C:\xampp\mysql if you’re using XAMPP. Then create an empty database using phpMyAdmin with the same name as your original database, (the one you’re trying to restore). The first thing you’ll want to do is install a fresh copy of either MAMP, (Mac only), or XAMPP. I chose to avoid using MAMP on my machine because of everything I have invested into that application, but that doesn’t mean you have to. Either one of these solutions will work, as they essentially provide the same services. ![]() Rather than fooling with this at all I opted to use XAMPP on a Windows XP SP2 machine. I use MAMP on a regular basis and as such have quite a few MySQL databases associated with that installation. I made the decision early on to solve this problem locally, (I find that working directly from a web server usually just gets me into trouble). My guess is that this is irrelevant, though.ĪLSO NOTE This article assumes you are comfortable with software solutions such as MAMP and/or XAMPP, as well as phpMyAdmin. ![]() NOTE The MySQL database I was tasked with restoring was associated with a WordPress installation. ![]() Thus, I thought I’d share my experience in hopes of helping others that may run into this. The solution turned out to be rather simple, but that didn’t stop me from racking my brain for a few hours. Last week I was presented with a problem that involved restoring a MySQL database for a client using only the /data folder from an original MySQL installation. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |