Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Special Interests > Visual Media > Web Design and Development

Reply
 
Thread Tools Search this Thread Display Modes
Old Apr 23, 2013, 11:57 PM   #1
cool11
macrumors 65816
 
Join Date: Sep 2006
Phpmyadmin & mamp problem

I have made an installation of MAMP web server in my mac.
The problem is that I cannot import any compressed database, in filename.sql.zip format, using MAMP's phpmyadmin.

It does not display any error, but it doesn't import it too.
Where the problem lies?
cool11 is offline   0 Reply With Quote
Old Apr 24, 2013, 01:51 AM   #2
wedgeantilles
macrumors newbie
 
Join Date: Apr 2013
Try unzipping the .sql file and importing that.
wedgeantilles is offline   0 Reply With Quote
Old Apr 24, 2013, 03:18 AM   #3
cool11
Thread Starter
macrumors 65816
 
Join Date: Sep 2006
Quote:
Originally Posted by wedgeantilles View Post
Try unzipping the .sql file and importing that.
This is not the point.
I can do it this way. But I want to bypass it.
My installation has a 32mb limit size liti of importing databases. Everyone with a Mamp installation should know it.
My database is 30mb large right now. Compressed is about 6mb!
So, if I can import it as compressed database, then I can manage my database for ages!
If I had to import it uncompressed, in a few months I could not do it anymore.

So, I need to make importing with compressed file.
cool11 is offline   0 Reply With Quote
Old Apr 24, 2013, 08:31 AM   #4
SrWebDeveloper
macrumors 68000
 
SrWebDeveloper's Avatar
 
Join Date: Dec 2007
Location: Alexandria, VA, USA
 
Quote:
Originally Posted by cool11 View Post
I have made an installation of MAMP web server in my mac.
The problem is that I cannot import any compressed database, in filename.sql.zip format, using MAMP's phpmyadmin.

It does not display any error, but it doesn't import it too.
Where the problem lies?
Go to http://www.phpmyadmin.net/home_page/downloads.php and download the latest, install as you'd install any new site in MAMP into its own docroot, do not attempt to replace the MAMP one with the new one. Configure it with the MAMP database username and password, customize as you see fit, bookmark it for easy access later, done.

Version 3.5.8 is pretty cool.
__________________
Jim Goldbloom
Sr. Web Developer, owner GoldTechPro, LLC
http://www.GoldTechPro.com
SrWebDeveloper is offline   0 Reply With Quote
Old Apr 24, 2013, 03:08 PM   #5
wedgeantilles
macrumors newbie
 
Join Date: Apr 2013
Okay, so have you tried editing your php.ini file to increase max_upload_size? You should be able to set this higher and the upload should work.

If you still experience problems, you may also want to look at the max_packet_size and increase this as well.
wedgeantilles is offline   0 Reply With Quote
Old Apr 24, 2013, 04:33 PM   #6
SrWebDeveloper
macrumors 68000
 
SrWebDeveloper's Avatar
 
Join Date: Dec 2007
Location: Alexandria, VA, USA
 
Quote:
Originally Posted by wedgeantilles View Post
Okay, so have you tried editing your php.ini file to increase max_upload_size? You should be able to set this higher and the upload should work. If you still experience problems, you may also want to look at the max_packet_size and increase this as well.
Just pointing out there is nothing wrong with making those changes to support larger upload file size, but trust me that I can't stand waiting for the damned upload followed by processing time to import large DB content via phpMyAdmin. Also, some databases contain binary data or user or map/geo-location information and can be huge so even compressed they might be 60MB for an initial import or merging of multiple DB's, etc. Also, it's convenient to export and zip up so it saves space on your Mac for backup during a project. I know we all have tons of gigs and broadband, but that doesn't remove the benefits of compression. So don't increase those settings TOO much and open up security vulnerabilities as well. Find the balance and use the proper software and you'll have less stress. Been there, done that!

(This response was intended mostly for the OP)
__________________
Jim Goldbloom
Sr. Web Developer, owner GoldTechPro, LLC
http://www.GoldTechPro.com
SrWebDeveloper is offline   0 Reply With Quote

Reply
MacRumors Forums > Special Interests > Visual Media > Web Design and Development

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Cannot access phpMyAdmin website with regular browsers, but with Tor lingtalfi OS X 0 Apr 23, 2014 12:29 AM
Webhost small business recommendation please? - cpanel,php,mysql,phpmyadmin whitedragon101 Web Design and Development 8 Jan 24, 2014 06:07 AM
MAMP/LAMP/etc...help? fig Web Design and Development 11 Mar 15, 2013 10:06 AM
MAMP Pro image problem on Mountain Lion andymac2210 Web Design and Development 0 Jul 26, 2012 05:21 AM
Mamp Pro phpMyAdmin Error firedept Web Design and Development 0 Jun 24, 2012 10:16 PM

Forum Jump

All times are GMT -5. The time now is 04:46 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC