‘index-mysql’ is not a registered wp command

  • Resolved chrisdperry91

    (@chrisdperry91)


    3 years, 2 months ago

    Hello, I started another support thread regarding my site timing out while trying to key wp_postmeta. I was able to key the other tables and was waiting for wp-cli support to finalize the wp_postmeta table. Glad to see it was added. I’m currently getting this error when trying to run index-mysql command. 

    [email protected] [~]# wp index-mysql status --path=/home/mcpirdmy/public_html
Warning: require_once(/home/mcpirdmy/public_html/wp-content/plugins/index-wp-mysql-for-speed/code/cli.php): failed to open stream: No such file or directory in /home/mcpirdmy/public_html/wp-content/plugins/index-wp-mysql-for-speed/index-wp-mysql-for-speed.php on line 49
Fatal error: require_once(): Failed opening required '/home/mcpirdmy/public_html/wp-content/plugins/index-wp-mysql-for-speed/code/cli.php' (include_path='.:/opt/cpanel/ea-php74/root/usr/share/pear') in /home/mcpirdmy/public_html/wp-content/plugins/index-wp-mysql-for-speed/index-wp-mysql-for-speed.php on line 49
Error: There has been a critical error on this website.Learn more about troubleshooting WordPress. There has been a critical error on this website.

    I’ve tried re-installing the latest version to no avail.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author OllieJones

    (@olliejones)

    Fixed in version 1.2.3. Thanks for the bug report and for your patience!

    Thread Starter chrisdperry91

    (@chrisdperry91)

    With the update I was able to access the command, thanks!

    However I still loose connection to server after about 1000 seconds during ALTER TABLE ADD PRIMARY KEY. My wp_postmeta table is 1.3GB and about 8M rows. I’ve tried indexing the SQL commands one by one via phpmyadmin as well and it will alwayse fail on that step.

    Any ideas or workarounds for such a large table? Maybe a time limit constraint in my SQL settings?

    Thanks for your continued help, I really want to take advantage of this plugin for my massive amount of woocommerce postmeta.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘‘index-mysql’ is not a registered wp command’ is closed to new replies.