GitHub - matthewblock/capublic_mysql

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 1 Commit
README.txt		README.txt
bill_analysis_tbl.sql		bill_analysis_tbl.sql
bill_detail_vote_tbl.sql		bill_detail_vote_tbl.sql
bill_history_tbl.sql		bill_history_tbl.sql
bill_motion_tbl.sql		bill_motion_tbl.sql
bill_summary_vote_tbl.sql		bill_summary_vote_tbl.sql
bill_tbl.sql		bill_tbl.sql
bill_version_authors_tbl.sql		bill_version_authors_tbl.sql
bill_version_tbl.sql		bill_version_tbl.sql
capublic.sql		capublic.sql
cleanup.bat		cleanup.bat
cleanup.sh		cleanup.sh
codes_tbl.sql		codes_tbl.sql
committee_agenda_tbl.sql		committee_agenda_tbl.sql
committee_hearing_tbl.sql		committee_hearing_tbl.sql
create_capublic.bat		create_capublic.bat
create_capublic.sh		create_capublic.sh
daily_file_tbl.sql		daily_file_tbl.sql
deleteSession.bat		deleteSession.bat
deleteSession.sh		deleteSession.sh
deleteSession.sql		deleteSession.sql
law_section_tbl.sql		law_section_tbl.sql
law_toc_sections_tbl.sql		law_toc_sections_tbl.sql
law_toc_tbl.sql		law_toc_tbl.sql
legislator_tbl.sql		legislator_tbl.sql
loadData.bat		loadData.bat
loadData.sh		loadData.sh
location_code_tbl.sql		location_code_tbl.sql
my.cnf		my.cnf
tables_lc.lst		tables_lc.lst
tables_uc.lst		tables_uc.lst
truncateAll.bat		truncateAll.bat
truncateAll.sh		truncateAll.sh
truncateAll.sql		truncateAll.sql
veto_message_tbl.sql		veto_message_tbl.sql

Repository files navigation

Command for entering mysql server:
mysql -u root -p

Then enter password Dcapublic

Make sure the following is true:

my.cnf is being read from /usr/local/mysql/etc/my.cnf

Make sure to set secure_file_priv = '' and check if it's null in Mysql

Then make sure every .lob file is owned by mysql and is in /usr/local/mysql/lob

sudo chown mysql:mysql *.lob

Make sure that directory is also owned by mysql

Soft links weren't working because the soft link couldn't be owned by mysql? Weird

Also make sure that the path the bill_version_tbl.sql is pointing to is /usr/local/mysql/lob