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
6. List all table in database
Illustration in mysql command line :
php 5.2.3 release!
"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 😉
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 :
Here’s the steps :
1. Download latest version from here
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 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
At previous post, I describe about how to set dns at domain registrar and register for account in mydomain.com.
Today I’ll continue pointing blogspot with my domain.
The only requirement for this step is account in blogger.
With assumption I already signup at blogger.
I continue to create new blog.
1. Login to blogger to start