Importing text file - maximum filesize

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Jean Bidule

    Importing text file - maximum filesize

    Hi,

    I installed phpmyadmin to test my site on my homecomputer. The table i want
    to "upload" in my mysql table is about 5 Mb but in phpMyadmin the maximum
    size is 2048 kb.

    Where can I change the maximum size of text files in PhpMyAdmin ? Somewhere
    in "config.inc.php " ?

    Thank you very much
    Jean



  • Sjoerd

    #2
    Re: Importing text file - maximum filesize

    In your php.ini:



    Comment

    • Jim Michaels

      #3
      Re: Importing text file - maximum filesize

      If you installed PHPMyAdmin only to put in the data, your MySQL database
      came with command-line tools that also do the job. mysql is the client, in
      MySQL's bin directory.
      mysql --user=username --password=somepa ssword [database]
      and at the prompt just type
      source filename

      and it will execute your SQL script.
      help will give you commands (such as exit)

      to backup your database, use mysqldump. for command-line options on
      mysqldump, do mysqldump -?
      should be similar to that of mysql client.


      "Jean Bidule" <bidulele@hotma il.com> wrote in message
      news:43edb6a5$0 $1178$ba620e4c@ news.skynet.be. ..[color=blue]
      > Hi,
      >
      > I installed phpmyadmin to test my site on my homecomputer. The table i
      > want
      > to "upload" in my mysql table is about 5 Mb but in phpMyadmin the maximum
      > size is 2048 kb.
      >
      > Where can I change the maximum size of text files in PhpMyAdmin ?
      > Somewhere
      > in "config.inc.php " ?
      >
      > Thank you very much
      > Jean
      >
      >
      >[/color]


      Comment

      Working...