My Blogger

1.php Nama fail: php.ini perkara2 yang perlu diubah: max_execution_time = 30 kpd 300 memory_limit = 128M  cth 1028M upload_max_filesize = 2M kpd filesize anda, cht 500M 2. mysql nama fail: my.ini perkara2 yang perlu diubah: max_allowed_packet = 1M kpd 100M atau yang sesuai. 3. Export database(semua/ part by part) 4. Ubah link eg jika alamat web www.yourweb.edu.my tukar kepada localhost. Guna notepad++ (download daripada filehippo.com). find and replace sahaja. 5. Format Database innodb format tak boleh copy folder database MyISAM format boleh copy dan pindahkan ke dalam folder database Lokasi fail

1. Copy and paste this script. Save to ConvertToUTF8.php.  2. Change database info to appropriate, dbuser to database user, dbpass to database password and dbname to database name. &lt? php // Database info $dbhost = "localhost"; $dbuser = "root"; $dbpass = ""; $dbname = "smachdb"; //————— header("Content-type: text/plain"); $dbconn = mysql_connect($dbhost, $dbuser, $dbpass) or die( mysql_error() ); $db = mysql_select_db($dbname) or die( mysql_error() ); $sql = "SHOW TABLES"; $result = mysql_query($sql) or die( mysql_error() ); while ( $row = mysql_fetch_row($result) ) { $table = mysql_real_escape_string($row[0]); $sql = "ALTER TABLE $table DEFAULT CHARACTER SET utf8 COLLATE utf8_bin"; mysql_query($sql) or die( mysql_error() ); print "$table changed to UTF-8.\n"; } mysql_close($dbconn); ?> cikguphablog

1. database 2. Moodledata 3. program moodle

Ada 2 masalah besar apabila upgrade database, iaitu tidak dapat logon dan perubahan format database (utf-8 bin). 1. Skrip ini digunakan untuk menukar password. Password yang ditukar adalah sama dengan nama pengguna (username). 2. Skrip ini hendaklah disimpan dengan nama tukarpass.php. 3. Simpan dalam folder program moodle. 4. Anda perlu ubah 3 perkara iaitu nama database, username dan password. Sila rujuk fail config.php sekiranya anda tidak faham. 5. Inilah skripnya. <?php // please increase max execution time to 300, example max_execution_time = 300 //mysql_connect("localhost","db_user","db_password"); mysql_connect("localhost","root","root"); //mysql_select_db("db_name"); $dbname=mysql_select_db("lmssmach"); // convert database to format utf8_bin // ALTER DATABASE `database-name` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin echo "------------convert database to format utf8-bin ----...