Results 1 to 6 of 6

Thread: Ubuntu Server 12.10, PHP5, Lighttpd & PHPMyAdmin

  1. #1
    Join Date
    Mar 2009
    Location
    Birmingham, UK
    Beans
    42
    Distro
    Xubuntu 12.10 Quantal Quetzal

    Ubuntu Server 12.10, PHP5, Lighttpd & PHPMyAdmin

    Hi,

    I'm urgently trying to set up a dev environment for a Sugar job I'm doing, the problem is I can't get PHPMyAdmin to restore the backup databases I have. It is not displaying any error messages, just linking me to an article on edititing the PHP.ini. I have editied my PHP.ini with 100M upload size and /tmp as the temp directory. I have made these changes @ both locations of /etc/php5/cgi/php.ini and /etc/php5/cli/php.ini.

    I'm stumped, please help.

    Thanks.

    Edit: This is the error message from phpMyAdmin "You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit."
    Last edited by daz1uk; March 1st, 2013 at 06:13 PM. Reason: Added Error Message

  2. #2
    Join Date
    Feb 2007
    Location
    West Hills CA
    Beans
    10,044
    Distro
    Ubuntu 14.04 Trusty Tahr

    Re: Ubuntu Server 12.10, PHP5, Lighttpd & PHPMyAdmin

    How large is your primary database? Perhaps 100MB is not large enough for PHP to handle, try 256MB, then reduce after restoration.
    -------------------------------------
    Oooh Shiny: PopularPages

    Unumquodque potest reparantur. Patientia sit virtus.

  3. #3
    Join Date
    Mar 2009
    Location
    Birmingham, UK
    Beans
    42
    Distro
    Xubuntu 12.10 Quantal Quetzal

    Re: Ubuntu Server 12.10, PHP5, Lighttpd & PHPMyAdmin

    Cheers for the response,

    The file I'm trying to restore is 82MB, yeah I've already set it 256MB in case that was the issue. Any other ideas? Any ideas how to show the actual error in PHPMyAdmin?

  4. #4
    Join Date
    Feb 2007
    Location
    West Hills CA
    Beans
    10,044
    Distro
    Ubuntu 14.04 Trusty Tahr

    Re: Ubuntu Server 12.10, PHP5, Lighttpd & PHPMyAdmin

    I would ssh into the server and look at the log files in /var/log/apache2 or in /var/log/mysql. PHP is simply handling the html and mysql requests so errors will get dumped in /var/log. PHPMyAdmin will let you look at the database and fields, and overall schema, but the errors are probably happening with PHP execution of mysql queries.

    I was under the impression that SugarCRM had an administration page that allowed migration and restoration of sugar databases? Is there a reason that you are not using the tools within SugarCRM?

    A simple google search on sugarcrm database migration gives a lot of hits with procedures. Have you tried any of those?
    -------------------------------------
    Oooh Shiny: PopularPages

    Unumquodque potest reparantur. Patientia sit virtus.

  5. #5
    Join Date
    Mar 2009
    Location
    Birmingham, UK
    Beans
    42
    Distro
    Xubuntu 12.10 Quantal Quetzal

    Re: Ubuntu Server 12.10, PHP5, Lighttpd & PHPMyAdmin

    Thanks for the help, I ended up re-installing Ubuntu Server 12.04, set all the php.ini settings as I needed them and it all worked fine, don't know what the issue was in 12.10 mind.

  6. #6
    Join Date
    Jun 2011
    Location
    Las Vegas
    Beans
    Hidden!
    Distro
    Ubuntu 8.04 Hardy Heron

    Re: Ubuntu Server 12.10, PHP5, Lighttpd & PHPMyAdmin

    While your at this. Consider replacing lighttpd (pretty dead now) with Nginx.

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •