upload dengan file SQL yang besar sapa takut :D

cara merubah setingan upload dengan merubah settingan di php ini.


in /etc/php5/apache2/php.ini:
max_execution_time = 60     ; Maximum execution time of each script, in seconds (def. 30)
max_input_time = 90 ; Maximum amount of time each script may spend parsing request data (def. 60)
memory_limit = 128M      ; Maximum amount of memory a script may consume (def. 128mb)
upload_max_filesize = 16M ; Maximum allowed size for uploaded files. (def. 2mb)
post_max_size = 16M ; (def. 8mb)

membuat repository lokal dengan iso di hardisk

buat direktory di media dengan amsumsi
#mkdir /media/repo1
#mkdir /media/repo2
#mkdir /media/repo3
#mkdir /media/repo4
#mkdir /media/repo5
#mkdir /media/repo6
#mkdir /media/repo7
#mkdir /media/repo8

atau

sudo mkdir /media/repo1 /media/repo2 /media/repo3 /media/repo4 /media/repo5 /media/repo6 /media/repo7 /media/repo8

buka gedit kemudian isi file tersebut seperti dibawah ini...

mount -o loop  /media/Freedom/iso/ubuntu-10.04-dvd-i386.iso /media/repo1
mount -o loop  /media/Freedom/iso/ubuntu-10.04-repository-i386-2_contrib.iso /media/repo2
mount -o loop  /media/Freedom/iso/ubuntu-10.04-repository-i386-3_contrib.iso /media/repo3
mount -o loop  /media/Freedom/iso/ubuntu-10.04-repository-i386-4_contrib.iso /media/repo4
mount -o loop  /media/Freedom/iso/ubuntu-10.04-repository-i386-5_contrib.iso /media/repo5
mount -o loop  /media/Freedom/iso/ubuntu-10.04-repository-i386-6_contrib.iso /media/repo6
mount -o loop  /media/Freedom/iso/ubuntu-10.04-repository-i386-7_contrib.iso /media/repo7
mount -o loop  /media/Freedom/iso/ubuntu-10.04-repository-i386-8_contrib.iso /media/repo8

dan kemudian di simpan dengan nama mount.sh
---------------------------------------------------------------------------------------------------------------------------
setelah file mount.sh sudah terbuat
lansung saja exekusi

buka konsole kemdian anda akses file mount.sh tersebut dengan #
#./mount.sh

tunggu hingga selesai,

dan proses mountin file iso telah selesai...
---------------------------------------------------------------------------------------------------------------------------
proses selanjutnya...
menambahkan di /etc/apt/source.list dengan isi seperti dibawah ini

deb file:///media/repo1 lucid main restricted
deb file:///media/repo2 lucid main restricted 
deb file:///media/repo3 lucid multiverse universe
deb file:///media/repo4 lucid universe
deb file:///media/repo5 lucid universe
deb file:///media/repo6 lucid universe
deb file:///media/repo7 lucid universe

semua yang mengarah update ke link luar di remark aja cukup dengan link yang mengarah ke hardisk
---------------------------------------------------------------------------------------------------------

setelah semua itu selesai
buka terminal kemudian apt-get update,...
hingga tampil seperti ini

root@ubuntu:/media/Freedom/iso# apt-get update
Get:1 file: lucid Release.gpg [189B]
Ign file:/media/repo1/ lucid/main Translation-en_US
Ign file:/media/repo1/ lucid/restricted Translation-en_US
Ign file: lucid Release.gpg
Ign file:/media/repo2/ lucid/main Translation-en_US
Ign file:/media/repo2/ lucid/restricted Translation-en_US
Ign file: lucid Release.gpg
Ign file:/media/repo3/ lucid/multiverse Translation-en_US
Ign file:/media/repo3/ lucid/universe Translation-en_US
Ign file: lucid Release.gpg
Ign file:/media/repo4/ lucid/universe Translation-en_US
Ign file: lucid Release.gpg
Ign file:/media/repo5/ lucid/universe Translation-en_US
Ign file: lucid Release.gpg
Ign file:/media/repo6/ lucid/universe Translation-en_US
Ign file: lucid Release.gpg
Ign file:/media/repo7/ lucid/universe Translation-en_US
Get:2 file: lucid Release [3,005B]
Ign file: lucid Release    
Ign file: lucid Release          
Ign file: lucid Release          
Ign file: lucid Release
Ign file: lucid Release
Ign file: lucid Release
Ign file: lucid/main Packages
Ign file: lucid/restricted Packages
Ign file: lucid/multiverse Packages
Ign file: lucid/universe Packages
Ign file: lucid/universe Packages
Ign file: lucid/universe Packages
Ign file: lucid/universe Packages
Ign file: lucid/universe Packages
Ign file: lucid/main Packages
Ign file: lucid/restricted Packages
Ign file: lucid/multiverse Packages
Ign file: lucid/universe Packages
Ign file: lucid/universe Packages
Ign file: lucid/universe Packages
Ign file: lucid/universe Packages
Ign file: lucid/universe Packages
Ign file: lucid/main Packages
Ign file: lucid/restricted Packages
Ign file: lucid/main Packages
Ign file: lucid/restricted Packages
Reading package lists... Done

oke selamat mencoba ^^