lsimeonov / laravel-fulltext-rebuild by ucaka

Rebuilds MySQL FULLTEXT indexes
430
1
1
Package Data
Maintainer Username: ucaka
Maintainer Contact: lsimeonov@despark.com (Ludmil Simeonov)
Package Create Date: 2017-06-15
Package Last Update: 2017-06-15
Language: PHP
License: MIT
Last Refreshed: 2024-04-25 15:12:39
Package Statistics
Total Downloads: 430
Monthly Downloads: 0
Daily Downloads: 0
Total Stars: 1
Total Watchers: 1
Total Forks: 0
Total Open Issues: 0

About

This is a simple library for laravel that helps you rebuild fulltext indexes for MySQL. This is useful when you change innodb_ft_min_token_size property. You can find more info about MySQL fulltext index length here

Always backup your database before doing manipulations to it.

Usage

You must include the library service provider inside config/app.php

$providers = [
    ...
    Ucaka\FullTextRebuild\Providers\FullTextRebuildProvider::class,
]

The only thing that a service provider will do for you is register a command. If you prefer you can skip the provider and directly add the command \Ucaka\FullTextRebuild\Console\Commands\FullTextRebuild inside your app/Console/Kernel.php

After you installed the command just run it

php artisan mysql:fulltext:rebuild

If it's needed you can specify custom database connection with --connection or -c option

php artisan mysql:fulltext:rebuild -c "custom_connection"