[oik] plugins.com

WordPress plugins and themes

  • Home
  • About
    • lazy shortcodes
    • smart shortcodes
    • oik base plugin
      • oik – donate
      • oik PayPal buttons
      • oik installation
      • oik Button Shortcode button
      • oik changelog
      • oik FAQ
      • oik plugins on SVN
      • oik plugins on GitHub
  • Plugins
    • oik base plugin
    • FREE oik plugins
    • WordPress plugins
    • Premium oik plugins
    • Bespoke oik plugins
  • Shortcodes
    • Shortcode examples
  • Blocks
    • Block examples
  • APIs
    • ALL action and filter hooks
  • Blog

OIK_innodb::convert_engine() – Convert tables from one engine to another

You appear to be a bot. Output may be restricted

Description

Convert tables from one engine to another

We assume that the WordPress user has the authority to alter tables

Usage

OIK_innodb::convert_engine( $from_engine, $to_engine );

Parameters

$from_engine
( string ) optional default: MyISAM –
$to_engine
( string ) optional default: INNODB –

Returns

void

Source

File name: oik-batch/class-oik-innodb.php
Lines:
1 to 12 of 12
  function convert_engine( $from_engine="MyISAM", $to_engine="INNODB" ) {
    global $wpdb;
    foreach ( $this->results as $result ) {
      if ( $from_engine == $result->engine ) {
        //$query = $wpdb->prepare( "ALTER TABLE %s engine=%s", DB_NAME . "." . $result->table_name, $to_engine );
        $query = sprintf( "ALTER TABLE %s engine=%s", $result->table_name, $to_engine );
        echo $query;
        echo PHP_EOL;
        $rows_affected = $wpdb->query( $query );
      }
    }
  }
 
 View on GitHub

Published: March 14, 2017 | Last updated: March 14, 2017

Information

Function name: OIK_innodb::convert_engine
Class ref: OIK_innodb
Plugin ref: oik-batch
Version: 1.0.0
Sourcefile: class-oik-innodb.php
File ref: class-oik-innodb.php
Deprecated?: No
API Letters: C,E,I,O

Recent plugin updates

oik v4.9.2 Upgrade to oik v4.9.2 for support for PHP 8.1 and PHP 8.2. ...
oik-block v0.3.0 oik-block v0.3.0 no longer displays the Editor selection meta box ...
oik-blocks v1.4.3 Upgrade to oik-blocks v1.4.3 for PHP 8.2 support. ...
cookie-cat v1.4.6 Upgrade to cookie-cat v1.4.6 for PHP 8.1 & PHP 8.2 support. ...
oik-fields v1.54.0 oik-fields v1.54.0 caters for the deprecation of get_page_by_title() in WordPress 6.2. ...

Plugins

  • All Plugins
  • oik base plugin
  • FREE oik plugins
  • WordPress plugins
  • Premium oik plugins

Themes

  • FREE themes
  • Bespoke themes
  • Premium themes

Blocks

  • All Blocks
  • Block examples
  • About Blocks

Shortcodes

  • All Shortcodes
  • Shortcode examples
  • About Shortcodes

Reference

  • About APIs
  • All APIs
  • All Classes
  • All Files
  • All Hooks

Support

  • Contact
  • Cookies policy
  • Get API key
  • Privacy
  • Request support
  • Sitemap
  • Stay informed
  • Terms and Conditions
oik-plugins
Email: herb@bobbingwide.com

Weight shipping plugins

Find out which cart weight shipping plugin you need for your WooCommerce site.
Which cart weight based plugin do I need?

Site:  www.oik-plugins.com
© Copyright oik-plugins 2011-2023. All rights reserved.


Website designed and developed by Herb Miller of Bobbing Wide
Proudly powered by WordPress and oik-plugins
WordPress 6.3.1. PHP: 7.4.33. Memory limit: 768M