[support] Uploading and getting online

Cary Gordon listuser at chillco.com
Sat Jul 26 16:43:18 UTC 2008


The "PhPMyAdmin upload declares a max size of 51KB" sounds like a big
problem. It also sounds like a misconfiguration on the server. Someone
should check the phpmyadmin config.inc.php file for a possible
misconfiguration. You might also be running up against limits in the
/etc/php.ini file, but 51 kb would be a pretty severe upload limit.

Even with normal limits of 2-8 mb you would have to split your script
into 2-5 scripts to stay below the limit. Of course, you could try
splitting it into 180 pieces for stay under 50Km, but that would be
insane.

The best way to do what you need is from the command line.

* In phpmyadmin, drop and create (or empty) the database. Do not add any tables.
* FTP the file to your home directory
* run "mysql -u user -p dbname < dbname.sql" (you will be prompted for
the password.
* if you do not have privileges to run mysql form the command line,
have your admin do it.

If you are on a cPanel host, use the cPanel MySQL cp to do this.

-- 
Cary Gordon
The Cherry Hill Company
http://chillco.com


More information about the support mailing list