Backup MySQL

Some time PHPMyadmin is not enough to restore mysql-backup. you have to many option adn configuration to restore file

- Max upload limit (modify in php.ini)
- Maximum post limit (modify in php.ini)
- Time execution limit
- and so on


This article describe howto restore the bigger file thank common setting permited.

1. Use PHP bigdump

• Download from here http://www.ozerov.de/bigdump.php
• Extact to your web directory
• Open the bigdump.php, dan modify some setting like database name, user name and password
  
• Browse using Firefox or your favorite browser (ie http://localhost/bigump.php
  
• Upload the file
• Then start to restore

note:
Your dump file probably contains a statement like this: SET character_set_client = @saved_cs_client; Bigdump is not able to restore settings saved at the beginning of the import process. However you can skip this error message by adding a comment setting $comment[]='SET character_set_client = @saved_cs_client;'; to the BigDump configuration.


2. Back up your MySQL Database with Compress

If your mysql database is very big, you might want to compress the output of mysqldump. Just use the mysql backup command below and pipe the output to gzip, then you will get the output as gzip file.

$ mysqldump -u [uname] -p[pass] [dbname] | gzip -9 > [backupfile.sql.gz]

If you want to extract the .gz file, use the command below:

$ gunzip [backupfile.sql.gz]

3. Restoring your MySQL Database

Above we backup the Tutorials database into tut_backup.sql file. To re-create the Tutorials database you should follow two steps:

• Create an appropriately named database on the target machine
• Load the file using the mysql command:

$ mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]

Have a look how you can restore your tut_backup.sql file to the Tutorials database.

$ mysql -u root -p Tutorials < tut_backup.sql

To restore compressed backup files you can do the following:

gunzip < [backupfile.sql.gz] | mysql -u [uname] -p[pass] [dbname]

If you need to restore a database that already exists, you'll need to use mysqlimport command. The syntax for mysqlimport is as follows:

mysqlimport -u [uname] -p[pass] [dbname] [backupfile.sql]

--


taken from : http://www.ozerov.de/bigdump.php and http://www.webcheatsheet.com/SQL/mysql_backup_restore.php

Dikirim dari suwidi.or.id dengan dukungan dev-NET(system)

New Release of Medical Module of OpenERP

Kabar Gembira pagi ini,

Realase terbaru dengan feature yang lebih lengkap dari modeul Medial dari OpenERP. kebetulan memang lagi ngoprek OpenERP. Selamat dan semoga lebih bermanfaat bagi kegiatan kemuanusiaan.

Download disini http://medical.sourceforge.net/

Widi

berikut petikan dari Luis

"I just uploaded Medical 0.0.49 with some important changes in the functionality, reporting and navigation. I have also included Panagiotis Kontaxis localization for Greece. "

v 0.0.49
------------------------------------------------------------------------
r90 | meanmicio | 2010-05-30 19:06:39 -0300 (dom 30 de may de 2010) | 21 lines
 
- Create Patient Vaccinations report
 - Add observations field to the patient vaccinations tree view
- Fix string in Medical directions
- Put a label in the allergy information box
- Fixed field in Patient allergies
- Change Allergies widget from many2many to one2many list
  - Create the patient allergy object, holding the type of allergy and severity of the allergic reaction, and pointing to the patient disease object for the other information
- Add is_allergy field in the patient disease object, to be used with domains in other references, such as the list of allergies in the patient.
  - Move perinatal information from the main module view to the medical_gyneco module
- Add Pathology indication in the Medication tree view
- Show Patient ID in the Patient form . This is the internal id of the center, not the partner identifier.
  - Change identifier to patient_id in patient tree view
- Add heal date of a disease
- Change diagnosis age to integer
- Add a field to determine that a disease is at an active state
- Sort list of patient diseases by its activity status.
  - Link medication to patient diseases instead of general pathology.
- Added missing "course_completed" field on the medication form
- Highlight in the form the allergies that generate severe reactions on the patient
  

--
Dikirim dari suwidi.or.id dengan dukungan dev-NET(system)

Ubuntu 10.04 LTS Firefox selalu start dengan mode Offline

Pengen ngicipin Ubuntu 10.04 LTS, saya paling demen kalo LTS kerena suportnya paling lama dan update bisa diandalkan.
Seminggu sudah waktu abis untuk upgrade program dan database karena imbas Ubuntu LTS ini mulai dari PHP, APACHE OPENERP, semua seba baru apalagi beberapa program saya install dari source code.

Suka-tidak harus suka dengan ngoprek, dan kadang malah menyita waktu. Ok lah kalo begitu sekarang saya mau cerita dengan tips kecil tentang firefox yang selau offline ini. Mungkin ini hal kecil tapi kadang membuat mood kacau apalagi program2 yang saya develope adalah kebanyakan web base. buka firefox langsung ada

"Offline mode    
Firefox is currently in offline mode and can't browse the Web.
    *   Uncheck "Work Offline" in the File menu, then try again."


bayangkan saya harus mengulang 10 tabulasi lagi bener2 bikin "bete"

Ok sakaran pada solusi

1. Buka alamat berikut "about:config" di addess firfox (mozilla) selanjutnya
   
2. klik persetujuan
3. Ketik "browser.offline-apps.notify" pada form filter
4. Kemudian rubah nilai dengan "FALSE" caranya dengan diuble klik

Demikian semoga membantu 
     
--
Dikirim dari suwidi.or.id dengan dukungan dev-NET(system)

Upgrade database alumni STMA-SMTI

Berhubung keperluan pendataan makin banyak maka dilakukan perubahan sbb:

1. Dilakukan backup secara berkala pada 2 masin sekaligus (1 kali perhari) arsip harian, mingguan, bulanan dan tahunan
2. Registrasi melibatkan no kontak (telp)
   
3. Upgrade dilakukan pada mesin server terbaru (Ubuntu 10.04 LTS) dangan APACHE Server version: Apache/2.2.14 (Ubuntu) Server built: Apr 13 2010 19:28:27 dan PHP versi PHP 5.3.2-1ubuntu4.2 with Suhosin-Patch (cgi-fcgi) (built: May 13 2010 20:00:36) MySQL Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (i486) using readline 6.1
4. Upgrade CI (php codeigniter) versi 1.72
   

Langkah adalah

1. Install LAMP (mesin ujicoba)

$sudo tasksel install lamp-server

lalu aktifkan rew_write_mod

$sudo a2enmod rewrite

2. Ambil database terbaru dari backup harian
3. buat database smti_alumni
4. Restore database kemudian lakukan perubahan database

ALTER TABLE `lr_users` ADD `no_telp` VARCHAR( 200 ) NULL

5. Copy directory "smti"
6. lakukan perubahan pada file controller/member/member.php untuk handle field 'no_telp'
7. lakukan perubahan pada file view/member/register
8. upgrade directory 'system' dengan menggunakan CI (codeigniter) terbaru


tahap selanjutnya

1. merubah 'view'
2. merubah 'edit' profile'

Permasalahan yang ditemui

Message: Function set_magic_quotes_runtime() is deprecated

solusi: replace semua directory system (dalam CI) dengan system dari CI terbaru (versi 1.72)


Demikian log versi terbaru hari ini smoga bisa menambah catatan sederhana ini, besok dilanjut dengan menu profile dan view

(tambahan: update sudah dilakukan tanggal 26-Mei-2010, lihat komentar dibawah untuk lebih lanjut)
--
Dikirim dari suwidi.or.id dengan dukungan dev-NET(system)

Install LAMP di Ubuntu 10.04 LTS

Setelah ngoprek lama dan tidak dipublikasikan, maka ini article kecil yang saya gunakan untuk triger menulis yang lain yang lebih komplek. Kadangkala lao mau nulis yang besar itu berat banget makanya mulai saja dengan yang mudah. OK langsung tancap

- Ide awal mau install APACHE2, PHP, dan MySQL pada komputer user. beberapa hari lalu ada user yang ngotot mau belajar linux, ok-lah bisa saja install dengan modal 1 keping USB jadul ukuran 1 G. (smoga bisa menulis trik install dari USB)

langkah pertama:
1. Buka console
2. Ketik

sudo tasksel install lamp-server

3. Ikuti petunjuk dan tunggu sampe kelar, selanjutnya migrasi database dan aplikasi

Endian Proxy Error (Content Filter Stopped)

 

Endian Proxy, hmmm

 

Setelah sekian lama tidak ada masalah, akhirnya Proxy kesayangan (Endian Firewall Community) ini memui masalah juga. Bermula dengan status error berikut

 

"

ERROR The requested URL could not be retrieved While trying to retrieve the URL: http://www.google.com/   The following error was encountered: Unable to forward this request at this time. Sorry, you are not currently allowed to request: http://www.google.com/ from this cache until you have authenticated yourself. This request could not be forwarded to the origin server or to any parent caches. The most likely cause for this error is that: The cache administrator does not allow this cache to make direct connections to origin servers, and All configured parent caches are currently unreachable. Your cache administrator is @

 

 

Kemudian hasil pengecekan status

 

"Conten filter STOPPED"

 

 

 

 

Penyelesaian (Solution)

 

"un check / remove antivirus option" see the picture above. Hilangkan opsi antivirus

2. Simpan  (SAVE)

 

Check status.

 

 

 

Demikain masalah bisa selesai, Tapi bagaimanapun juga Proxy sudah jalan tetapi masih meniggalkan masalah kerana antivirus tidak bekerja, tatapi paling tidak bisa dijalankan sambil menunggu penyelesaian bug ini

lihat http://bugs.endian.com/view.php?id=534

 

 

hope this helps

me@suwidi.or.id

Install CI-CMS

Ikuti petunjuk disni

Saat install malah keluar
ci-cms/start/start/start/start/start/start/start/start/start/start/start/start/start/start/start/start/start/start/start/start/index.php

dan halaman menjadi:

The page isn't redirecting properly             

Firefox has detected that the server is redirecting the request for this address in a way that will never complete.       


    *   This problem can sometimes be caused by disabling or refusing to accept
          cookies.


Solusi:

Rubah file .htaccess

Options +FollowSymLinks
RewriteEngine On

RewriteBase /smti/ci-cms/

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php?/$1 [L]


Demikian smoga membantu

Suwidi