Some mysql sql basic command I must remember

I use phpmyadmin in daily environment, do I still know  sql command?

My sql file too large, it’s hard to import using phpmyadmin, please help me

Some question around mysql from my student, my false make them spoil using phpmyadmin all day long 🙂

Here’s my answers :

1. Command to create database

create database databasename

2. Delete database

drop database databasename

3. Import database

mysql -uusername -ppassword databasename < databasename.sql

4. Export database

mysqldump -uusername -ppassword databasename > databasename.sql

5. Pick database and choose one to manage

use databasename

6. List all table in database

show tables

 Illustration in mysql command line :

Continue reading

php5 3 years old and php4 7 years old

php 5.2.3 release!

from php.net

"The PHP development team would like to announce the immediate availability of PHP 5.2.3. This release continues to improve the security and the stability of the 5.X branch as well as addressing two regressions introduced by the previous 5.2 releases. These regressions relate to the timeout handling over non-blocking SSL connections and the lack of HTTP_RAW_POST_DATA in certain conditions. All users are encouraged to upgrade to this release."

I’ll do upgrade for my box but my hosting service still use 5.1.2 ( from phpinfo() ).

While php4 already  reach 7 years of deployment make this version still in my favourite ( I install php4 as apache module and php5 as cgi)

for windows user xampp or wamp provide the latest version of php for complete. Switch to php4 and php5 very easy as switch menu available.

with slow migration php4 to php5 then php6 become more difficult to adopt since it force user to make secure programming with superglobals and register_globals Off.

Life is option so with the php version 🙂

Oh no, fedora 7 is out too, no ‘core’ , just plain fedora in the name.

time for wget 😉

in Blog | 194 Words

Install Local FTP server in Windows XP

At previous post about install wordpress in localhost, I got new question :

What about FTP server, is it possible to install local FTP server to make simulation like upload to real server?

The answer is : Yes

Just install FTP server in computer and point it’s shared folder, for example :

C:\appserv\www

Here’s the steps :

1. Download latest version from here

filezilla.PNG

2. Download FTP client, for example coreftp from here

3. Install FTP server and FTP client

4. Add any password you want, like 123456

5. Add user and password for accessing folder in FTP server, I use : alamster and password : 123456

6. Add shared folder, this folder is destination folder like ‘public_html’ or www in real production server

7. Try login to FTP server with defined user and password at previous step.
For more detail illustration , see this video

in Blog | 132 Words

Free Blog on Your Own Domain with Free Email Hosting Part 3

In part 1 I wrote about how to set dns at domain registrar and register for account in mydomain.com

In part 2 I wrote about pointing blogspot with my domain.

In this part, I’ll describe step taken to make rasyid.info has it’s own email hosted in google apps.

The only requirement to follow this step is have an account in google.

Refer to this post about google account.

Lets begin 🙂

1. Signup for google apps

Continue reading