Step 1 – Backing up using phpMyAdmin
1. Login to phpMyAdmin.

2. Select the database you wish to use.

3. On the navigation bar on the top, select “Export” (besides SQL, Structure, Search, Query… etc.)

4. You should now be presented with a nifty little page which shows all the tables in the database, SQL Options and Save Types. *

5. To backup the whole database, click “Select All” under the list of tables in the page.

6. To backup a selected few, just hold down CTRL on your keyboard and select the tables you wish to backup (release the key when all selecting is done).

7. SQL Options can be left as default, but I suggest ticking the “Add DROP TABLE” option as if you are restoring a backup on a database that already exists and has the table in it – you will get a lot of errors! This way, by ticking the “Add DROP TABLE” option you will avoid the errors. For more information on the options just click the little “?” icon after SQL Options.

8. If you want to save the backup as a file (recommended) then tick “Save as file” – Leave file name as is or edit for your needs. Select “gzipped” as compression. Now click “Go”. If asked, choose “Save to disk” and save it wherever on your computer (it may take sometime depending on the size).

9. If you want to show the whole backup SQL on your browser window, don’t tick “Save as file” – once you have selected the tables you wish to backup (explained in step 5/6) click “Go”. The page will now change and should show the SQL information (it may take sometime depending on the size). Copy and paste it to a text file or do whatever you want with it!

Note: Yes, the tables of the database will be shown to the far left in a frame, but they will also be displayed in a different form on this new page to the right in phpMyAdmin.

Congratulations! You have successfully backed up your database / selected tables!
Read the rest of this entry »

Check out the links below, I am quite surprised to see that Malaysian datacenters provide safe heaven for torrent web sites.
April 2009 – Malaysia

Jaring IDC hosting many popular web sites such as Lowyat.net and political based web i.e Harakah Daily, Tranungkite and Malaysiakini. Recent denial of service attack targeted these political based web sites hosted in Jaring IDC such as Tranungkite.net. The attack crippled the network and caused interruption to many web sites including our server – Copper which is hosted in Jaring IDC.

Riz
DataKL Support.

Google menghantar ‘crawlers’ yang dipanggil Googlebot yang meneliti setiap laman web yang berada di internet. Googlebot adalah jutaan process ‘bot’ yang aktif yang sentiasa meneliti laman web terbaru untuk di katalogkan kedalam database index carian google. Bot-bot ini juga mengikuti pautan-pautan yang berada dalam laman web dan membuat perbandingan samaada kandungan telah pun di perbaharui atau tidak. Proses yang berulang ini dinamakan ‘indexing’. Laman yang sering di index semula laman web berita online yang kandungannya selalui di perbaharui berbanding laman statik contohnya laman web korporat.

Pautan-pautan ini juga membantu kedudukan ‘ranking’ laman web anda yang dipanggil ‘PageRank’. PageRank adalah salah satu daripada 200 faktor atau kriteria yang digunakan Google untuk memastikan hasil carian adalah tepat dan relevan. Jika anda mahukan kedudukan atau ‘ranking’ lebih baik, pastikan kandungan laman web anda di perbaharui dengan maklumat terbaru