Menggunakan openserdbctl
Jump to navigation
Jump to search
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)