-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Alonso Caballero / ReYDeS wrote: > Saludos. > > >>El phpmyadmin presenta el problema de limitación de tamaño de archivos a >>la hora de subir el SQL (copia de seguridad). Para windows Xp existe una >>utilidad que se llama MakeChumks para trocear el archivo .sql y subirlo >>por trozos. ¿Sabeis si existe algo parecido en Debian? >> >>Un saludo. >> > > > Pue asi es, hace una semana tuve el mismo inconveniente con el > servicio hosting de un cliente, se tuvo que solicitar a los > administradores que suban el file .sql de la base de datos, dado que > el limite impuesto por el phpmyadmin es de 2 MB. Ademas de que este > servicio hosting no cuenta con acceso via ssh, con lo cual facilitaria > mucho las cosas, o como minimo tener un terminal via web, o un sh via > web, como tantas herramientas que se utilizan post "comprometer" un > sistema. Es un poco engorros estar dependiendo de que un tercero haga > dicha copia, pero esas son las politicas de hosting. > > Eso si, si alguien sabe algun mecanismo para subir un archivo sql > grande por partes, mediante phpmyadmin sin tener que modificar los > parametros del mismo, se lo agradeceria/riamos. > > Atte:
san google dice: http://cvs.sourceforge.net/viewcvs.py/phpmyadmin/phpMyAdmin/Documentation.html?rev=2.151 $cfg['UploadDir'] string The name of the directory, where SQL files have been uploaded by other means than phpMyAdmin (for example, ftp). Those files are available under a drop-down box when you click the database name, then the SQL tab. Please note that the file names must have the suffix ".sql" (or ".sql.bz2" or ".sql.gz" if support for compressed formats is enabled). This feature is useful when your file is too big to be uploaded via HTTP, or when file uploads are disabled in PHP. Please note that if PHP is running in safe mode, this directory must be owned by the same user as the owner of the phpMyAdmin scripts. See also FAQ 1.16 for alternatives. y FAQ 1.16 [1.16] I cannot upload big dump files (memory, http or timeout problems). The first things to check (or ask your host provider to check) are the values of upload_max_filesize, memory_limit and post_max_size in the php.ini configuration file. All of these three settings limit the maximum size of data that can be submitted and handled by PHP. One user also said that post_max_size and memory_limit need to be larger than upload_max_filesize. There exist several workarounds if your upload is too big or your hosting provider is unwilling to change the settings: * Look at the $cfg['UploadDir'] feature. This allows one to upload a file to the server via scp, ftp, or your favorite file transfer method. PhpMyAdmin is then able to import the files from the temporary directory. More information is available in the Configuration section of this document. * Using a utility (such as BigDump) to split the files before uploading. We cannot support this or any third party applications, but are aware of users having success with it. * If you have shell (command line) access, use MySQL to import the files directly. You can do this by issuing the "source" command from within MySQL: source filename.sql. [ > > -- > Alonso Caballero Quezada aka ReYDeS - [EMAIL PROTECTED] > http://alonsocaballero.informatizate.net - LRU # 307242 > http://www.SWP-scene.org - http://www.NoticiasTrujillo.com > http://www.RareGaZz.net - CCPLL > > - -- Ricardo A.Frydman Consultor en Tecnología Open Source - Administrador de Sistemas jabber: [EMAIL PROTECTED] - http://www.eureka-linux.com.ar SIP # 1-747-667-9534 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) iD8DBQFDOskskw12RhFuGy4RAjGGAJ9orde3jvQQu8chcjSZptpbjPhdqQCglP2g XrEyz8Ehjr1noXMZzOUoUlQ= =GHcj -----END PGP SIGNATURE-----