Hello and welcome to our community! Is this your first visit?
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Aug 2010
    Thanked 2 Times in 2 Posts

    $cfg['UploadDir'] string explanation?

    Maybe this is a simple question. I have three tables that are over the mysqladmin import size limit.

    Documentation refers me to use this: $cfg['UploadDir'] string

    Forgive my ignorance, but I have no idea what I'm supposed to do with that information? Use it how? How/where do I upload these .sql files. I'm using Network Solutions Hosting, and I don't see any access to the folder containing MySQLadmin... I just have htdocs, cgibin and backup.

  2. #2
    Senior Coder CFMaBiSmAd's Avatar
    Join Date
    Oct 2006
    Denver, Colorado USA
    Thanked 511 Times in 499 Posts
    A) You are using phpmyadmin.

    B) The only way you would be able to directly upload a too-large file into a folder and import it using the host's supplied phpmyadmin is if your web host has configured the phpmyadmin $cfg['UploadDir'] setting to point to a per-user folder.

    C) If your web host won't increase the upload_max_filesize and post_max_size settings where phpmyadmin is running and he hasn't or won't do item B), then your easiest solution would be break up the .sql files into multiple parts and upload/import each part separately.

    D) You could always install phpmyadmin within your htdocs folder and use it to import your files. It would run under your php settings (where you should be able to set the upload_max_filesize and post_max_size settings) and your database connection credentials. In this case the $cfg['UploadDir'] setting could be set to a folder within your account and you could ftp the large file (or perhaps that's where it is already at) onto the server and import it.

    E) Have you asked your web host to help with this. Perhaps he would import your too-large file for you using a different tool than phpmyadmin.

    F) What sort of actual problem or error are you having?
    Finding out HOW to do something is called research, i.e. keep searching until you find the answer. After you attempt to do something and cannot solve a problem with it yourself, would be when you ask others for help.


Posting Permissions

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