Posted in Work, tagged backup, database, mysql, phpmyadmin, restore on April 29, 2009 | Leave a Comment »
Melalui Query
>> Backup
>mysqldump.exe -u dhani -p blogtastic > blogtastic.sql
>> Restore
>mysqldump.exe -u dhani -p blogtastic < blogtastic.sql
Melalui PHPMYAdmin
>>Backup/Export
>Restore/Import
referensi : http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/
Posted in Work, tagged database, foreign key, index, mysql, phpmyadmin on April 29, 2009 | Leave a Comment »
1. Konversi Tipe database dari MyISAM ke InnoDB
2. Buat index dari field yang akan dijadikan foreign key
3. Kemudian pilih relation view arahkan field yg jadi index ke field tabel yg dijadikan Primary key.
Screenshoot gambar ntar nyusul.
