User Tools
tech_public:webdev (text)
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| tech_public:webdev [2025/02/27 16:56] – [Local Apache HTTPS SSL] jasonwch | tech_public:webdev [2025/02/27 17:50] (current) – [Flarum migration] jasonwch | ||
|---|---|---|---|
| Line 61: | Line 61: | ||
| - b. mysql -u mysql_user -p DATABASE < backup.sql | - b. mysql -u mysql_user -p DATABASE < backup.sql | ||
| - Copy over your flarum-root/ | - Copy over your flarum-root/ | ||
| + | |||
| + | ---- | ||
| + | |||
| + | **<fs x-large> | ||
| + | |||
| + | < | ||
| + | USE YourFlarumDataBaseName; | ||
| + | ALTER TABLE posts DROP INDEX content; | ||
| + | CREATE FULLTEXT INDEX content ON `posts` (`content`) WITH PARSER ngram; | ||
| + | </ | ||
| + | |||
| + | < | ||
| + | USE YourFlarumDataBaseName; | ||
| + | ALTER TABLE discussions DROP INDEX title; | ||
| + | CREATE FULLTEXT INDEX title ON `discussions` (`title`) WITH PARSER ngram; | ||
| + | </ | ||
tech_public/webdev.1740646577.txt.gz · Last modified: by jasonwch (text)
Top ↑