World of *Nix

২.৫ বছর পর অবশেষে নতুন বাসায় উঠলাম। খুব মজা লাগছে নতুন রুমে শুয়ে জানালা দিয়ে আকাশ দেখতে দেখতে কাজ করতে । গত ৬ মাস ধরে একটা সুন্দর বাসা খুজছিলাম, অবশেষে…

**নিজস্ব নিরাপত্বার জন্য নতুন বাসার ঠিকানা গোপন রাখলাম। আপনারা চাইলে পুরোন বাসার ঠিকানা দিতে পারি

Thanks for visiting my blog. This is not a technical post (most of my previous post are technical 😛 ).
Today i am going to share the history of this blog. I started blogging about 2 years ago with wordpress.com. After passing some time i moved my entire blog to blogspot.com. Then i tried lot’s of other host like x10hosting.com, 100webs etc . But every where there is some limit ion. So i move my blog to this paid hosting about 3 months ago.

From the very beginning i tried to share my knowledge with you. To share the knowledge with more and more people, i always try to some more people in. So if you think my blog is really helped you, please don’t forget to tell your friend about my blog.

To get more people in, i added digg support on my everypost (past and future). So if you really like any my post, please give a digg (it’s so simple, just click on the digg icon then follow there instruction). Though it will waste your little time, belive me, it will help lots of other people to get this post :).

If you have any feedback, please write it on comment or send a mail to smibrahim[at]gmail.com

thanks,
lavluda

Today i bought this nokia 5300 🙂 .

alexa তার রেংকিং টা হিসাব করে শুধু মাত্র্ তাদের টুল ব্যবহার কারিদের প্রদত্ত তথ্যের উপর নির্ভর করে। তাই আপনারা যদি সা.ই-কে টপ লিস্টে দেখতে চান, সবাই তাদের টুলবারটি ইনস্টল করে নিন।

টুলবারটি ডাউনলোড করুন এখান থেকে

বি.দ্র: এটি আমার ব্যক্তিগত পোস্ট।

Few minutes ago, one of our mysql database table (it’s really a big table) was crashed.
So to repair this i login that server and excute

repair table tablename

But the repair process failed, and i got this output.

test.t1 | repair | error | 13 when fixing table |
| test.t1 | repair | status | Operation failed |

Then i start searching on google. After passing some time i found the reason. Mysql can’t repair that table as there is a trigger on this table. So i tried to drop the trigger

drop trigger triggername

no luck, mysql can’t drop the trigger, as the table was crashed 🙁

Now i studied more and more. At last i got the solution 🙂

REPAIR TABLE tablename USE_FRM

Now the table repair complete successfully. Thanks to Allah as i got the solution in time:)

গত কাল পোস্টটি ইংরেজীতে লেখার পর, কয়েকজনের অনুরুধে বাংলায় দিচ্ছি।
এখান থেকে পিডিএফ আকারে ডাউনলোড করুন

লিনাক্সে PHP ডেভলাপমেন্টের পরিবেশ তৈরি করার উপর একটি টিউটোরিয়াল লিখলাম। সময়ের অভাবে বাংলায় করা গেল না। এখানে দেখুন ইংরেজীতে দেখুন

Nowadays, lots of php developers are thinking to move their development environment to linux. And I am writing this tutorial for them. As I like Debian GNU/Linux (www.debian.org) best and ubuntu (www.ubutnulinux.org) is now doing great, in this tutorial I am using the commands for debian & ubuntu.

Ok, now starting:

First on all let’s make a list of software a PHP developer need mostly:

1.Apache
2.PHP
3.Mysql
4.PHP IDE

Ok, let’s start with Apache. Debian & ubuntu use APT to manage the packages. You can easily install apache using apt, here is the command

Debian user:

su

Ubuntu user:

sudo su

Rest of the command ar same for both debian & ubuntu.

apt-get install apache2

It will install all the apache2 & all the related packages (software)
If you need to enable mod_rewrite, follow this link
Now install the PHP

Apt-get install php5 libapache2-mod-php5

This will install the php5 and configure your apache2 server for PHP. You don’t need to do anything.
Lets test the server, if it working ok.

touch /var/www/info.php

Chown www-data:www-data info.php

Now edit this info.php with your feviourate editor and add write code to show phpinfo():
and now browse http://localhost/info.php from your browser. Now check if all your requested library are installed.
if you need any more library, you can check if it already available on your debian/ubuntu package list.

apt-cache search php5-

then you will get the list of available php5 library. Now simple use this command to install it.

apt-get install php5-gd

(example, if you want to install php5 GD library)

Remember: after installing every extra packages, you must need to restart apache server

/etc/init.d/apache2 restart

Ok, so you have now apache2 and php5 installed system. Let’s install mysql:

apt-get install mysql-server-5.0 php5-mysql

It will install all the necessary packages to run mysql-server.
Now restart your apache to take effect.
Complete!!!! Server is allmost ready.
Now i am going to derive how you will transfer your old code to this new environment. Belive me it’s too simple, so don’t worry.

First of all copy your source code to /var/www, here is the details procedure:

mkdir /windows

Here we make a folder for C drive of windows to mount.
mount /dev/hda1 /windows
then we mount the C drive to windows folder (here i use hda1 as example, if your hdd is sata then it will be sda1)

cp -r windows/Apache2/htdocs/xyz /var/www

here we copied our xyz site to /var/www (in debian and ubuntu, default apache2 root folder is /var/www)

cd /var/www

chown -R www-data:www-data xyz

Now change the ownership to www-data

Now we need to move the mysql database, there is two way:

1.use phpmyadmin
2.simple copy the database from data folder
I am deriving the 2nd way.

cp -r /windows/Mysql/data/xyz /var/lib/mysql

chown -R mysql:mysql /var/lib/mysql/xyz

You are done.

PHP Ide for linux environment:

1.Zend ( i personaly use this)
2.PHPEd
3.PHPEclipse
4.quanta plus
5.emacs
6.vi
7.PHPedit

***I know this tutorial needs more edit, please make your comments if you got anything wrong, or missed anything. I want it a cool tutorial for php developers.

Read some reviewed, the best and most affordable php hosting solutions on the market.

Few minutes ago i make a unoffical repository of deb packages for debian (though it’s empty).
you have to add this line to your /etc/apt/sources.list
deb http://debian.lavluda.com binary/

if you want to release any deb file unofficaly for debian and need help to host it, send me the .deb file and don’t forget to add signature to your package.

** for testing i added the d4x on my repository, i will remove it.

please test my repository and give your feedback here.