Results 1 to 9 of 9

Thread: sql file to big

  1. #1
    Join Date
    Apr 2013
    Beans
    93

    sql file to big

    the sql file am trying to upload is to big, can anyone point me in the right direction how to upload it. cheers

  2. #2
    Join Date
    Apr 2013
    Beans
    2

    Re: sql file to big

    Where do you want to upload the file?
    If you want import the sql file with phpmyadmin you can split it

  3. #3
    Join Date
    Nov 2008
    Location
    Metro Boston
    Beans
    11,645
    Distro
    Kubuntu 14.04 Trusty Tahr

    Re: sql file to big

    You give us very little information to go on, but if you are using a web-based tool like phpmyadmin, then you are probably hitting the maximum upload size limitation in PHP. If you have control over the server, look in /etc/php5/apache2/php.ini for the upload_max_filesize setting and increase it. You'll need to restart the web server to make the change take effect.
    If you ask for help, please have the courtesy to check for responses and thank the people who helped you.

    Blog · Linode System Administration Guides · Android Apps for Ubuntu Users

  4. #4
    Join Date
    Apr 2013
    Beans
    93

    Re: sql file to big

    aye its for myphpadmin how do you split it?

    i had a look in etc/ but theres no folder called php5 pr myphp etc, anywhere else it could be located?

  5. #5
    Join Date
    Nov 2008
    Location
    Metro Boston
    Beans
    11,645
    Distro
    Kubuntu 14.04 Trusty Tahr

    Re: sql file to big

    Try running "locate php.ini".

    Is this an Ubuntu or Debian server, or a RedHat or CentOS server? They put configuration files in different places. On RH-flavored systems the file is /etc/php.ini. On Ubuntu it resides in /etc/php5/apache2/.

    Remember that this a file that resides on the server, not on the machine you are trying to upload from.
    If you ask for help, please have the courtesy to check for responses and thank the people who helped you.

    Blog · Linode System Administration Guides · Android Apps for Ubuntu Users

  6. #6
    Join Date
    Apr 2013
    Beans
    93

    Re: sql file to big

    its a ubuntu server, there is no php5 folder in etc/


    locate: can not stat () `/var/lib/mlocate/mlocate.db': No such file or directory
    root@:~#

  7. #7
    Join Date
    Nov 2008
    Location
    Metro Boston
    Beans
    11,645
    Distro
    Kubuntu 14.04 Trusty Tahr

    Re: sql file to big

    Apparently it is not building the locate database. Try running "sudo updatedb", wait for it to finish, then try looking for php.ini again.

    Or you could use one of the methods described here.
    If you ask for help, please have the courtesy to check for responses and thank the people who helped you.

    Blog · Linode System Administration Guides · Android Apps for Ubuntu Users

  8. #8
    Join Date
    Apr 2013
    Beans
    93

    Re: sql file to big

    working now mate, thanks


    /etc/php5/apache2/php.ini
    /etc/php5/cli/php.ini
    /usr/share/doc/php5-common/examples/php.ini-development
    /usr/share/php5/php.ini-production
    /usr/share/php5/php.ini-production-dist
    /usr/share/php5/php.ini-production.cli


    edit: one last question where should i edit?


    edit again:

    ; Maximum allowed size for uploaded files.
    ; http://php.net/upload-max-filesize
    upload_max_filesize = 2M

    ??
    Last edited by Joe67; April 9th, 2013 at 08:01 PM.

  9. #9
    Join Date
    Nov 2008
    Location
    Metro Boston
    Beans
    11,645
    Distro
    Kubuntu 14.04 Trusty Tahr

    Re: sql file to big

    That limits the filesize to 2 megabytes. If you know how big the file you are uploading is, just change "2M" to something larger than your file like "20M". Don't forget to restart Apache after making the change with
    Code:
    sudo service apache2 restart
    If you ask for help, please have the courtesy to check for responses and thank the people who helped you.

    Blog · Linode System Administration Guides · Android Apps for Ubuntu Users

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
  •