...
Step 4: Reindex the contents of the database using the Lucene Reindex admin tool.
Notes: If you run out of space due to the ibdata1 file becoming too large, you can do this:
| Code Block |
|---|
supervisorctl stop mapping-service
--Delete mappingservicedb database (rather than just dropping the tables)
drop schema mappingservicedb;
--stop MySQL
service mysql stop
--Delete those three files
rm /var/lib/mysql/ibdata1
rm /var/lib/mysql/ib_logfile0
rm /var/lib/mysql/ib_logfile1
--Start MySQL
service mysql start
--Recreate table
CREATE DATABASE mappingservicedb
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE utf8_general_ci;
GRANT ALL ON mappingservicedb.* TO 'otf';
--Checking df to ensure storage usage did in fact go down a good idea
--And then load the dump file as normal. |
References/Links
- n/a