Importing Large MySQL Files into PHPMyAdmin
The default file size for uploading mysql dump files into PHPmyadmin is around 2mb. I needed to upload a 160mb file. How to do it?
1. Increase the maximum execution time for phpmyadmin:
I use xampp, so I just had to find the config.default.php file, which for me was located in xampp/phpMyAdmin/libraries/config.default.php. I then searched for the line $cfg['ExecTimeLimit'], and set this value to 0, for no limit.
2. Set a PhpMyAdmin Upload Directory
Thanks to the following stackoverflow article, I edited the config.inc.php file. I searched for the line $cfg['UploadDir'], and set that to 'upload'.
3. Create the Upload Directory
I then created a folder named 'upload' within the phpmyadmin directory (so for me, this is 'D:/xampp/phpMyAdmin/upload') copy your mysql dump file to this folder.
4. Import the file
For the database you want to import the msql dump file to, go to the 'import' tab. There should now be a dropdown menu with the filename that you copied into that folder. Click on that, and then submit the import. Importing may take quite a while, but should work.
Communicating Website Design to Developers
The best method of communicating website designs and intent to developers.
Flatten a Wordpress Website to HTML and CSS
I recently inherited a whole bunch of wordpress websites for one of my clients -- in fact I think one of the first times it dawned on me that I would have to start working with these sites is when one of them got hacked...
Designers Should Just Learn to Code
Of course all of the time spent learning a new piece of software could just be spent learning how to code...
Adding PDF Files to Shopify Pages
I've had to add pdf files to pages within the shopify platform several times now, and I always seem to forget how to do it...
Related WritingsCommunicating Website Design to Developers Flatten a Wordpress Website to HTML and CSS Designers Should Just Learn to Code Adding PDF Files to Shopify Pages Simplification On-Page SEO Checklist Google Analytics Sucks PHP JSON Returned As Object Instead of Array Data: The End of Web Design as an Art My Backend is Better than Yours Git Ignore a Directory Organizing Files for Web Projects Serving Websites to Other Computers on a Local Network with XAMPP
The Built Environment