Thứ Năm, 2 tháng 6, 2011

phpmyadmin error



Maximum execution time of 300 seconds exceeded:


go to /var/www/html/phpMyAdmin-version/config.inc.php

There's a var called $cfg['ExecTimeLimit'] which was set to 300 and overided php.ini.


Hope this will be useful to someone else.


I've set it to 3600 but be careful with this


Mysql Error 1153


Change setting on my.cnf and restart mysql:
set-variable = max_allowed_packet=32M
/etc/init.d/mysql restart

Using split and cat in linux


Cutting:
split -b sizetocut filename prefixfilename_


e.g:


split -b 20480k demo.zip demo_


make : demo_aa , demo_ab ..


joining file:


cat file1 file2 ... > newfile
or
cat prefixfilename_* > newfile
e.g:
cat  demo_*  > demo.zip


Apache error!

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request
fixed:
1. Removed .htaccess(if you're using localhost)
2. edit .htacess

Linux : tar command


create :
-Compress file or directory
tar -cvf file.tar file1 file2 file3

tar -cvf dir.tar dir1 dir2

tar -cvjf files.tar.bz2 file4 file5 file6

tar -cvjf files.tar.bz2 dir1 dir2

-Extract file tar & tar.bz2
tar -xvf file.tar

tar -xjvf files.tar.bz2

View Mediawiki Version

www.yourdomain.com/wiki/index.php?title=Special:Version
e.g:
localhost/mediawiki/index.php?title=Special:Version

Mediawiki error


1267:
Illegal mix of collations (latin1_bin,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '=' (localhost)

Solved:
go to LocalSettings.php and set:
$wgDBmysql5 =false;