|
SetupGnizrDatabase
Prepare MySQL database for gnizr installation
This page describes the steps to prepare MySQL database for gnizr installation. These steps must be performed before running the gnizr web application. Requirement
Note: We assume that you have properly installed MySQL database. If you need addition help on using MySQL, see http://dev.mysql.com Create database tables and stored procedures
Upgrade database tables and stored proceduresInstructions described in this section are for upgrading gnizr software from an existing installation. If you install gnizr for the first time, follow instructions in "Create database tables and stored procedures". Upgrading to gnizr 2.3.0If you are currently running gnizr 2.2.x or 2.3.0 milestones, do the following:
Related |
Sign in to add a comment
安装好了，但是还不知道怎么具体用哦，哈哈
〉安装好了，但是还不知道怎么具体用哦，哈哈
你可以看看 http://code.google.com/p/gnizr/wiki/GetStarted
如果someone可以翻譯this document, 哪就好了！
Suggested addition to Upgrading... 0. Always backup your database (I didn't have a problem, but having a backup is peace of mind.)
rows=mysql -u $USER -p${PASS} -e "show tables" $DB |wc -l
if $rows -gt 0
upgrade with loadup.sh?" fijust noticed that the wiki removed my backticks...they should be surrounding the entire statement afters rows=
rrezinas, thank you for the suggestion. i will try to merge your code into the install scripts in the next release.
"make sure this account has all the necessary privileges to manage and access the gnizr database schema"
What privs ARE necessary? Creating the account is only a one line command in MySQL, perhaps we could have an example?
It appears that the assertion "MySQL 5.0+" is incorrect. The thread at
http://groups.google.com/group/gnizr-users/browse_thread/thread/0b414ba735b5f760
Shows that an error is thrown at step 3 (./loadupg.sh gnizr_db gnizr gnizrpass) using 5.1.23. I also encountered this error (3 September 2008).
The "REQUIREMENT" above should be altered so that others don't need to encounter the same problems.
how to install sql under winXP