Menggunakan openserdbctl: Difference between revisions
From OnnoCenterWiki
Jump to navigationJump to search
Onnowpurbo (talk | contribs) No edit summary |
Onnowpurbo (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
Sebaiknya restart MySQL | |||
# /etc/init.d/mysql restart | |||
Pastikan file /etc/openser/openserctlrc sudah di edit dengan benar | Pastikan file /etc/openser/openserctlrc sudah di edit dengan benar | ||
Latest revision as of 02:04, 21 May 2008
Sebaiknya restart MySQL
# /etc/init.d/mysql restart
Pastikan file /etc/openser/openserctlrc sudah di edit dengan benar
# vi /etc/openser/openserctlrc
Pastikan ada
DBENGINE=MYSQL
Atau database lainnya.
Untuk menggunakan openserdbctl dapat menggunakan perintah berikut
# openserdbctl create <db name or db_path, optional> .....(creates a new database) # openserdbctl drop <db name or db_path, optional> .......(!entirely deletes tables!) # openserdbctl reinit <db name or db_path, optional> .....(!entirely deletes and than re-creates tables!) # openserdbctl backup <file> .................................(dumps current database to file) # openserdbctl restore <file> ................................(restores tables from a file) # openserdbctl copy <new_db> .................................(creates a new db from an existing one) # openserdbctl migrate <old_db> <new_db> .....................(migrates DB from 1.2 to 1.3, not implemented yet!) # openserdbctl presence ......................................(adds the presence related tables) # openserdbctl extra .........................................(adds the extra tables) # openserdbctl serweb ........................................(adds the SERWEB specific tables)
