{"id":9616,"date":"2022-11-17T14:01:05","date_gmt":"2022-11-17T14:01:05","guid":{"rendered":"https:\/\/stevepedwards.today\/DebianAdmin\/?p=9616"},"modified":"2025-06-08T22:59:01","modified_gmt":"2025-06-08T21:59:01","slug":"9616-2","status":"publish","type":"post","link":"https:\/\/stevepedwards.today\/DebianAdmin\/9616-2\/","title":{"rendered":"WordPress CLI Commands and some MYSQL Repair Commands"},"content":{"rendered":"
<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n

CREATE database NEO ;<\/p>\n

USE NEO;<\/p>\n

DROP database NEO ;<\/p>\n

source \/var\/www\/NEOBabyHPWorking.sql ;<\/p>\n

GRANT ALL PRIVILEGES ON NEO.* TO 'stevee'@'localhost';<\/p>\n

ALTER USER 'stevee'@'localhost' IDENTIFIED BY 'pw';<\/p>\n

WP-CLI:
\ncd \/opt<\/span>
\ncurl -O https:\/\/raw.githubusercontent.com\/wp-cli\/builds\/gh-pages\/phar\/wp-cli.phar<\/span>
\nstevee@localhost:\/opt$ sudo curl -O https:\/\/raw.githubusercontent.com\/wp-cli\/builds\/gh-pages\/phar\/wp-cli.phar<\/span>
\n[sudo] password for stevee:
\n% Total % Received % Xferd Average Speed Time Time Time Current
\nDload Upload Total Spent Left Speed
\n100 6571k 100 6571k 0 0 558k 0 0:00:11 0:00:11 --:--:-- 572k
\nstevee@localhost:\/opt$ php wp-cli.phar --info<\/span>
\nOS: Linux 5.15.0-53-generic #59-Ubuntu SMP Mon Oct 17 18:53:30 UTC 2022 x86_64
\nShell: \/bin\/bash
\nPHP binary: \/usr\/bin\/php8.0
\nPHP version: 8.0.25
\nphp.ini used: \/etc\/php\/8.0\/cli\/php.ini
\nMySQL binary: \/usr\/bin\/mysql
\nMySQL version: mysql Ver 8.0.31-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))
\nSQL modes:
\nWP-CLI root dir: phar:\/\/wp-cli.phar\/vendor\/wp-cli\/wp-cli
\nWP-CLI vendor dir: phar:\/\/wp-cli.phar\/vendor
\nWP_CLI phar path: \/opt
\nWP-CLI packages dir:
\nWP-CLI cache dir: \/home\/stevee\/.wp-cli\/cache
\nWP-CLI global config:
\nWP-CLI project config:
\nWP-CLI version: 2.7.1<\/p>\n

sudo chmod +x wp-cli.phar<\/span><\/p>\n

sudo mv wp-cli.phar \/usr\/local\/bin\/wp<\/span><\/p>\n

cd \/usr\/share\/wordpress\/<\/span><\/p>\n

wp core version<\/span>
\n5.8.3<\/p>\n

wp core version --allow-root<\/span><\/p>\n

----------------------------------------------------------------------<\/p>\n

Below is a listing of all currently available WP-CLI commands with links to documentation on usage and subcommands.<\/p>\n

Looking to learn more about the internal API of WP-CLI or to contribute to its development? Check out the WP-CLI team\u2019s handbook.<\/p>\n

Command Description
\nwp admin<\/span>
\nOpen \/wp-admin\/ in a browser.<\/p>\n

wp cache<\/span>
\nAdds, removes, fetches, and flushes the WP Object Cache object.<\/p>\n

wp cap<\/span>
\nAdds, removes, and lists capabilities of a user role.<\/p>\n

wp cli<\/span>
\nReviews current WP-CLI info, checks for updates, or views defined aliases.<\/p>\n

wp comment<\/span>
\nCreates, updates, deletes, and moderates comments.<\/p>\n

wp config<\/span>
\nGenerates and reads the wp-config.php file.<\/p>\n

wp core<\/span>
\nDownloads, installs, updates, and manages a WordPress installation.<\/p>\n

wp cron<\/span>
\nTests, runs, and deletes WP-Cron events; manages WP-Cron schedules.<\/p>\n

wp db<\/span>
\nPerforms basic database operations using credentials stored in wp-config.php.
\nwp db check --dbuser=stevee --dbpass=xxx<\/span>
\nwp db clean --dbuser=stevee --dbpass=xxx(drops tables!)<\/span>
\nwp db repair --dbuser=stevee --dbpass=xxx<\/span>
\nwp db export \/var\/www\/ESFile --dbuser=xxx--dbpass=poop<\/span><\/p>\n

ElectronicsStuff.wp_xubg_commentmeta
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_comments
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_links
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_options
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_postmeta
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_posts
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_term_relationships
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_term_taxonomy
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_termmeta
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_terms
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_usermeta
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_users
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wpnt_commentmeta OK
\nElectronicsStuff.wpnt_comments OK
\nElectronicsStuff.wpnt_links OK
\nElectronicsStuff.wpnt_options OK
\nElectronicsStuff.wpnt_postmeta OK
\nElectronicsStuff.wpnt_posts OK
\nElectronicsStuff.wpnt_term_relationships OK
\nElectronicsStuff.wpnt_term_taxonomy OK
\nElectronicsStuff.wpnt_termmeta OK
\nElectronicsStuff.wpnt_terms OK
\nElectronicsStuff.wpnt_usermeta OK
\nElectronicsStuff.wpnt_users OK
\nElectronicsStuff.wpnt_wprss_logs OK
\nSuccess: Database repaired.<\/p>\n

(didnt fix pics issue though!)<\/span><\/p>\n

wp dist-archive<\/span>
\nCreate a distribution archive based on a project\u2019s .distignore file.<\/p>\n

wp embed<\/span>
\nInspects oEmbed providers, clears embed cache, and more.<\/p>\n

wp eval<\/span>
\nExecutes arbitrary PHP code.<\/p>\n

wp eval-file<\/span>
\nLoads and executes a PHP file.<\/p>\n

wp export<\/span>
\nExports WordPress content to a WXR file.<\/p>\n

wp help<\/span>
\nGets help on WP-CLI, or on a specific command.<\/p>\n

wp i18n<\/span>
\nProvides internationalization tools for WordPress projects.<\/p>\n

wp import<\/span>
\nImports content from a given WXR file.<\/p>\n

wp language<\/span>
\nInstalls, activates, and manages language packs.<\/p>\n

wp maintenance-mode<\/span>
\nActivates, deactivates or checks the status of the maintenance mode of a site.<\/p>\n

wp media<\/span>
\nImports files as attachments, regenerates thumbnails, or lists registered image sizes.<\/p>\n

wp menu<\/span>
\nLists, creates, assigns, and deletes the active theme\u2019s navigation menus.<\/p>\n

wp network<\/span>
\nPerform network-wide operations.<\/p>\n

wp option<\/span>
\nRetrieves and sets site options, including plugin and WordPress settings.<\/p>\n

wp package<\/span>
\nLists, installs, and removes WP-CLI packages.<\/p>\n

wp plugin<\/span>
\nManages plugins, including installs, activations, and updates.<\/p>\n

wp post<\/span>
\nManages posts, content, and meta.<\/p>\n

wp post-type<\/span>
\nRetrieves details on the site\u2019s registered post types.<\/p>\n

wp profile<\/span>
\nwp rewrite<\/span>
\nLists or flushes the site\u2019s rewrite rules, updates the permalink structure.<\/p>\n

wp role<\/span>
\nManages user roles, including creating new roles and resetting to defaults.<\/p>\n

wp scaffold<\/span>
\nGenerates code for post types, taxonomies, plugins, child themes, etc.<\/p>\n

wp search-replace<\/span>
\nSearches\/replaces strings in the database.<\/p>\n

wp server<\/span>
\nLaunches PHP\u2019s built-in web server for a specific WordPress installation.<\/p>\n

wp shell<\/span>
\nOpens an interactive PHP console for running and testing PHP code.<\/p>\n

wp sidebar<\/span>
\nLists registered sidebars.<\/p>\n

wp site<\/span>
\nCreates, deletes, empties, moderates, and lists one or more sites on a multisite installation.<\/p>\n

wp super-admin<\/span>
\nLists, adds, or removes super admin users on a multisite installation.<\/p>\n

wp taxonomy<\/span>
\nRetrieves information about registered taxonomies.<\/p>\n

wp term<\/span>
\nManages taxonomy terms and term meta, with create, delete, and list commands.<\/p>\n

wp theme<\/span>
\nManages themes, including installs, activations, and updates.<\/p>\n

wp transient<\/span>
\nAdds, gets, and deletes entries in the WordPress Transient Cache.<\/p>\n

wp user<\/span>
\nManages users, along with their roles, capabilities, and meta.<\/p>\n

wp widget<\/span>
\nManages widgets, including adding and moving them within sidebars.
\n-----------------------------------------------------------------------<\/p>\n

wp media regenerate<\/span>
\nwp media regenerate --yes<\/span><\/p>\n

Warning: Can't find \"052412_1712_SilverSynth11.png\" (ID 264).
\nWarning: Can't find \"052412_1712_SilverSynth10.jpg\" (ID 263).
\nWarning: Can't find \"052412_1712_SilverSynth9.png\" (ID 262).
\nWarning: Can't find \"052412_1712_SilverSynth8.png\" (ID 261).
\nWarning: Can't find \"052412_1712_SilverSynth7.jpg\" (ID 260).
\nWarning: Can't find \"052412_1712_SilverSynth6.png\" (ID 259).
\nWarning: Can't find \"052412_1712_SilverSynth5.jpg\" (ID 258).
\nWarning: Can't find \"052412_1712_SilverSynth4.png\" (ID 257).
\nWarning: Can't find \"052412_1712_SilverSynth3.jpg\" (ID 256).
\nWarning: Can't find \"052412_1712_SilverSynth2.jpg\" (ID 255).
\nWarning: Can't find \"052412_1712_SilverSynth1.png\" (ID 254).
\nWarning: Can't find \"052412_1708_SilverSynth21.png\" (ID 251).
\nWarning: Can't find \"052412_1708_SilverSynth20.png\" (ID 250).
\nWarning: Can't find \"052412_1708_SilverSynth19.png\" (ID 249).
\nWarning: Can't find \"052412_1708_SilverSynth18.png\" (ID 248).
\nWarning: Can't find \"052412_1708_SilverSynth17.jpg\" (ID 247).
\nWarning: Can't find \"052412_1708_SilverSynth16.png\" (ID 246).
\nWarning: Can't find \"052412_1708_SilverSynth15.png\" (ID 245).
\nWarning: Can't find \"052412_1708_SilverSynth14.png\" (ID 244).
\nWarning: Can't find \"052412_1708_SilverSynth13.png\" (ID 243).
\nWarning: Can't find \"052412_1708_SilverSynth12.png\" (ID 242).
\nWarning: Can't find \"052412_1708_SilverSynth11.png\" (ID 241).
\nWarning: Can't find \"052412_1708_SilverSynth10.jpg\" (ID 240).
\nWarning: Can't find \"052412_1708_SilverSynth9.png\" (ID 239).
\nWarning: Can't find \"052412_1708_SilverSynth8.png\" (ID 238).
\nWarning: Can't find \"052412_1708_SilverSynth7.jpg\" (ID 237).
\nWarning: Can't find \"052412_1708_SilverSynth6.png\" (ID 236).
\nWarning: Can't find \"052412_1708_SilverSynth5.jpg\" (ID 235).
\nWarning: Can't find \"052412_1708_SilverSynth4.png\" (ID 234).
\nWarning: Can't find \"052412_1708_SilverSynth3.jpg\" (ID 233).
\nWarning: Can't find \"052412_1708_SilverSynth2.jpg\" (ID 232).
\nWarning: Can't find \"052412_1708_SilverSynth1.png\" (ID 231).
\nWarning: Can't find \"052412_1703_SilverSynth1.png\" (ID 229).
\nWarning: Can't find \"052412_1702_SilverSynth5.jpg\" (ID 228).
\nWarning: Can't find \"052412_1702_SilverSynth3.jpg\" (ID 226).
\nWarning: Can't find \"052412_1702_SilverSynth2.jpg\" (ID 225).
\nWarning: Can't find \"052412_1702_SilverSynth1.png\" (ID 224).
\nWarning: Can't find \"HipHopV3\" (ID 191).
\nWarning: Can't find \"DanceCPanel.jpg\" (ID 189).
\nWarning: Can't find \"SteveCopperMinorSquare.jpg\" (ID 172).
\nWarning: Can't find \"SteveCopperMaj.jpg\" (ID 168).
\nWarning: Can't find \"SteveCopperMaj.jpg\" (ID 163).
\nWarning: Can't find \"SteveCopperMaj.jpg\" (ID 161).
\nWarning: Can't find \"MMDX11.jpg\" (ID 28).
\nWarning: Can't find \"MyEye.jpg\" (ID 15).<\/p>\n

This will be because these files are not in the ES folder, as these DB tables should not be in ES or the wp_ ones.
\nOnce wp_ changed to wp_xubg :<\/p>\n

stevee@localhost:\/usr\/share\/wordpress$ wp media regenerate --yes<\/span>
\nFound 158 images to regenerate.
\nWarning: Can't find \"10_4Z.png\" (ID 9752).
\nWarning: Can't find \"DiodesAdd.png\" (ID 9748).
\nWarning: Can't find \"15VZ.png\" (ID 9741).
\nWarning: Can't find \"13Vout.png\" (ID 9735).
\nWarning: Can't find \"2200Ohm.png\" (ID 9730).
\nWarning: Can't find \"noload.png\" (ID 9726).
\nWarning: Can't find \"charger3.png\" (ID 9724).
\nWarning: Can't find \"charger2.png\" (ID 9722).
\nWarning: Can't find \"spicecharger.png\" (ID 9719).
\nWarning: Can't find \"Pins.jpg\" (ID 9709).
\nWarning: Can't find \"UnrectAC,jpg\" (ID 9708).
\nWarning: Can't find \"UnrectDC\" (ID 9707).
\nWarning: Can't find \"DC.jpg\" (ID 9706).
\nWarning: Can't find \"Chassis.jpg\" (ID 9698).
\nWarning: Can't find \"3rdOrder.jpg\" (ID 9676).
\nWarning: Can't find \"2ndorder.jpg\" (ID 9672).
\nWarning: Can't find \"IMG_20210118_200757196.jpg\" (ID 9671).
\nWarning: Can't find \"THD.jpg\" (ID 9668).
\nWarning: Can't find \"MCLgen.jpg\" (ID 9664).
\nWarning: Can't find \"X840OP2.jpg\" (ID 9660).
\nWarning: Can't find \"1kHzGen.jpg\" (ID 9659).
\nWarning: Can't find \"X840OP.jpg\" (ID 9657).
\nWarning: Can't find \"sine2,png\" (ID 9639).
\nWarning: Can't find \"sine.png\" (ID 9635).
\nWarning: Can't find \"14051Bpins.png\" (ID 9619).
\nWarning: Can't find \"4051pins.png\" (ID 9618).
\nWarning: Can't find \"14vpower.png\" (ID 9617).
\nWarning: Can't find \"IMG_20210109_170041015\" (ID 9612).
\nWarning: Can't find \"IMG_20210109_170036030\" (ID 9611).
\nWarning: Can't find \"840pecs.png\" (ID 9607).
\nWarning: Can't find \"svi3102pins.png\" (ID 9603).
\nWarning: Can't find \"delay.png\" (ID 9588).
\nWarning: Can't find \"su600knob.png\" (ID 9580).
\nWarning: Can't find \"specs.png\" (ID 9578).
\nWarning: Can't find \"switches.png\" (ID 9572).
\nWarning: Can't find \"RemoteCaps.png\" (ID 9569).
\nWarning: Can't find \"svi.png\" (ID 9568).
\nWarning: Can't find \"svi3102inputs.png\" (ID 9566).
\nWarning: Can't find \"specs.png\" (ID 9558).
\nWarning: Can't find \"front.png\" (ID 9554).
\nWarning: Can't find \"trans.png\" (ID 9550).
\nWarning: Can't find \"pin10.png\" (ID 9547).
\nWarning: Can't find \"SonyEX50.png\" (ID 9540).
\nWarning: Can't find \"FenderTone.png\" (ID 9528).
\nWarning: Can't find \"MarshalTone\" (ID 9529).
\nWarning: Can't find \"IMG_20200901_181120444\" (ID 9518).
\nWarning: Can't find \"Calx.png\" (ID 9517).
\nWarning: Can't find \"Calx.png\" (ID 9510).
\nWarning: Can't find \"cct.png\" (ID 9495).
\nWarning: Can't find \"ua741.pdf\" (ID 9491).
\nWarning: Can't find \"tl022.pdf\" (ID 9490).
\nWarning: Can't find \"MN3101.pdf\" (ID 9489).
\nWarning: Can't find \"Chorus.jpg\" (ID 9488).
\nWarning: Can't find \"MC14007UB-D.pdf\" (ID 9485).
\nWarning: Can't find \"LM13600.pdf\" (ID 9484).
\nWarning: Can't find \"lm1458.pdf\" (ID 9483).
\nWarning: Can't find \"DODFilter.jpg\" (ID 9480).
\nWarning: Can't find \"PreheatDrive\" (ID 9473).
\nWarning: Can't find \"IMG_20200819_171206514_BURST000_COVER_TOP\" (ID 9470).
\nWarning: Can't find \"specs\" (ID 9471).
\nWarning: Can't find \"IMG_20200819_171132482_HDR\" (ID 9469).
\nWarning: Can't find \"IMG_20200819_171118831_BURST000_COVER_TOP\" (ID 9468).
\nWarning: Can't find \"808spec.png\" (ID 9461).
\nWarning: Can't find \"IMG_20200814_213938761\" (ID 9460).
\nWarning: Can't find \"IMG_20200814_213115465\" (ID 9459).
\nWarning: Can't find \"IMG_20200814_213103039\" (ID 9458).
\nWarning: Can't find \"IMG_20200813_224328992\" (ID 9443).
\nWarning: Can't find \"Specs\" (ID 9440).
\nWarning: Can't find \"Specs840\" (ID 9439).
\nWarning: Can't find \"IMG_20200814_092423229\" (ID 9435).
\nWarning: Can't find \"IMG_20200814_091816282\" (ID 9434).
\nWarning: Can't find \"IMG_20200814_091801335\" (ID 9433).
\nWarning: Can't find \"IMG_20200813_221651336\" (ID 9423).
\nWarning: Can't find \"IMG_20200813_221639003_HDR\" (ID 9422).
\nWarning: Can't find \"BW.png\" (ID 9418).
\nWarning: Can't find \"3880.pdf\" (ID 9362).
\nWarning: Can't find \"IMG_20200728_134000895\" (ID 9356).
\nWarning: Can't find \"IMG_20200728_134008065\" (ID 9355).
\nWarning: Can't find \"IMG_20200728_134025788\" (ID 9354).
\nWarning: Can't find \"IMG_20200728_134735831\" (ID 9353).
\nWarning: Can't find \"IMG_20200728_133850848\" (ID 9352).
\nWarning: Can't find \"IMG_20200804_113028610\" (ID 9349).
\nWarning: Can't find \"IMG_20200804_200801544\" (ID 9341).
\nWarning: Can't find \"IMG_20200804_200837538\" (ID 9340).
\nWarning: Can't find \"IMG_20200726_143139085\" (ID 9322).
\nWarning: Can't find \"IMG_20200726_142248167\" (ID 9321).
\nWarning: Can't find \"IMG_20200726_104427960\" (ID 9320).
\nWarning: Can't find \"IMG_20200626_215627585\" (ID 9313).
\nWarning: Can't find \"IMG_20200626_215602304\" (ID 9312).
\nWarning: Can't find \"wienosc.png\" (ID 9308).
\nWarning: Can't find \"IMG_20200626_203754102\" (ID 9307).
\nWarning: Can't find \"741test.jpg\" (ID 9279).
\nWarning: Can't find \"Short.png\" (ID 9257).
\nWarning: Can't find \"IMG_20200524_160307468\" (ID 9184).
\nWarning: Can't find \"IMG_20200524_153612168\" (ID 9183).
\nWarning: Can't find \"IMG_20200517_184001425\" (ID 9115).
\nWarning: Can't find \"IMG_20200510_120039421\" (ID 9083).
\nWarning: Can't find \"hfe_technics_su-x840_service.pdf\" (ID 9074).
\nWarning: Can't find \"stktest.png\" (ID 8991).
\nWarning: Can't find \"stk.png\" (ID 8988).
\nWarning: Can't find \"limiter.png\" (ID 8982).
\nWarning: Can't find \"stepcct.png\" (ID 8975).
\nWarning: Can't find \"steps.png\" (ID 8973).
\nWarning: Can't find \"stnlid.png\" (ID 8963).
\nWarning: Can't find \"bits.png\" (ID 8962).
\nWarning: Can't find \"16mhz.png\" (ID 8948).
\nWarning: Can't find \"colpittsosc.png\" (ID 8944).
\nWarning: Can't find \"ramposc.png\" (ID 8940).
\nWarning: Can't find \"sawgen.png\" (ID 8936).
\nWarning: Can't find \"vcolm358.png\" (ID 8930).
\nWarning: Can't find \"lm2904vco.png\" (ID 8927).
\nWarning: Can't find \"capcharge.png\" (ID 8921).
\nWarning: Can't find \"capaddition.png\" (ID 8920).
\nWarning: Can't find \"FR100k.png\" (ID 8912).
\nWarning: Can't find \"741maxspecs.png\" (ID 8909).
\nWarning: Can't find \"741gain5.png\" (ID 8907).
\nWarning: Can't find \"tl082cctsame.png\" (ID 8902).
\nWarning: Can't find \"tlo82cn op amp.png\" (ID 8901).
\nWarning: Can't find \"5gaincct.png\" (ID 8899).
\nWarning: Can't find \"5gcct.png\" (ID 8898).
\nWarning: Can't find \"5gain.png\" (ID 8896).
\nWarning: Can't find \"railsplitter.png\" (ID 8894).
\nWarning: Can't find \"railsplitter.png\" (ID 8893).
\nWarning: Can't find \"led.png\" (ID 8890).
\nWarning: Can't find \"ledrect.png\" (ID 8886).
\nWarning: Can't find \"led rect.png\" (ID 8882).
\nWarning: Can't find \"astab5vtimer.png\" (ID 8878).
\nWarning: Can't find \"astablepdf.png\" (ID 8877).
\nWarning: Can't find \"555int.png\" (ID 8875).
\nWarning: Can't find \"555-Astable-Circuit-Diagram.gif\" (ID 8873).
\nWarning: Can't find \"lm2904vco.png\" (ID 8870).
\nWarning: Can't find \"lm738.png\" (ID 8867).
\nWarning: Can't find \"741pin.png\" (ID 8864).
\nWarning: Can't find \"Kentinger.png\" (ID 8848).
\nWarning: Can't find \"ltpcap.png\" (ID 8755).
\nWarning: Can't find \"ltp.png\" (ID 8751).
\nWarning: Can't find \"Splitclipps.png\" (ID 8746).
\nWarning: Can't find \"splitter.png\" (ID 8745).
\nWarning: Can't find \"trigsq.png\" (ID 8744).
\nWarning: Can't find \"trig5v.png\" (ID 8743).
\nWarning: Can't find \"trig.png\" (ID 8742).
\nWarning: Can't find \"shmitt.png\" (ID 8741).
\nWarning: Can't find \"comemit\" (ID 8740).
\nWarning: Can't find \"300px-16MHZ_Crystal\" (ID 8739).
\nWarning: Can't find \"51-C5nPEF1L\" (ID 8738).
\nWarning: Can't find \"astable\" (ID 8737).
\nWarning: Can't find \"IRcons\" (ID 8680).
\nWarning: Can't find \"simpleosc\" (ID 8671).
\nWarning: Can't find \"Xtal\" (ID 8631).
\nWarning: Can't find \"12cpins\" (ID 8603).
\nWarning: Can't find \"12cbus\" (ID 8598).
\nWarning: Can't find \"aerial\" (ID 8492).
\nWarning: Can't find \"XR2206Gen\" (ID 8482).
\nWarning: Can't find \"Lysig\" (ID 8479).
\nWarning: Can't find \"DECGPSOUT\" (ID 8472).
\nWarning: Can't find \"FG100Gen\" (ID 8066).
\nWarning: Can't find \"XR2206Gen\" (ID 8064).
\nWarning: Can't find \"Lysig\" (ID 8062).
\nError: No images regenerated (158 failed).<\/p>\n

changed to wpnt_<\/p>\n

stevee@localhost:\/usr\/share\/wordpress$ wp media regenerate --yes
\nFound 29 images to regenerate.
\nWarning: Can't find \"gpsceramic\" (ID 8437).
\nWarning: Can't find \"aerial\" (ID 8427).
\nWarning: Can't find \"nanopins\" (ID 8350).
\nWarning: Can't find \"2rigs\" (ID 8339).
\nWarning: Can't find \"newnanolcd\" (ID 8332).
\nWarning: Can't find \"Vantage Pro2\" (ID 8323).
\nWarning: Can't find \"bmpcalc\" (ID 8320).
\nWarning: Can't find \"AltMe\" (ID 8313).
\nWarning: Can't find \"DHT11_BMP180SERIAL\" (ID 8308).
\nWarning: Can't find \"DHT11_BMP180SERIAL\" (ID 8307).
\nWarning: Can't find \"DHT11\u2013Temperature-Sensor-Pinout\" (ID 8300).
\nWarning: Can't find \"DHT11tempshum\" (ID 8298).
\nWarning: Can't find \"BMP180ser\" (ID 8292).
\nWarning: Can't find \"DHT11 temp\" (ID 8290).
\nWarning: Can't find \"BMP180 Datasheet V2.5\" (ID 8284).
\nWarning: Can't find \"DHT11tempshum\" (ID 8280).
\nWarning: Can't find \"DHT11-Datasheet\" (ID 8275).
\nWarning: Can't find \"timesatslatlong\" (ID 8248).
\nWarning: Can't find \"LCDSatclock\" (ID 8243).
\nWarning: Can't find \"gpsinlcd\" (ID 8237).
\nWarning: Can't find \"gpsinlcd\" (ID 8236).
\nWarning: Can't find \"satellite-constellations\" (ID 8232).
\nWarning: Can't find \"myloc\" (ID 8223).
\nWarning: Can't find \"gpslocdata\" (ID 8220).
\nWarning: Can't find \"arduino-to-gps-diagram-gps-tutorial\" (ID 8217).
\nWarning: Can't find \"arduino-as-serial-to-usb-to-gps-diagram-gps-tutorial\" (ID 8215).
\nWarning: Can't find \"LCDpins\" (ID 8213).
\nWarning: Can't find \"Uno pins\" (ID 8209).
\nWarning: Can't find \"Stn\" (ID 8206).
\nError: No images regenerated (29 failed).<\/p>\n

stevee@localhost:\/usr\/share\/wordpress$ wp media regenerate<\/span>
\nPHP Warning: Undefined array key \"HTTP_HOST\" in phar:\/\/\/usr\/local\/bin\/wp\/vendor\/wp-cli\/wp-cli\/php\/WP_CLI\/Runner.php(1296) : eval()'d code on line 10<\/span>
\nNeither <b>\/etc\/wordpress\/config-.php<\/b> nor <b>\/etc\/wordpress\/config-.php<\/b> could be found. <br\/> Ensure one of them exists, is readable by the webserver and contains the right<\/span> password\/username.stevee@localhost:\/usr\/share\/wordpress$<\/p>\n

stevee@localhost:\/usr\/share\/wordpress$ ls -la<\/span>
\ntotal 224
\ndrwxr-xr-x 5 root root 4096 Sep 4 10:02 .
\ndrwxr-xr-x 374 root root 12288 Nov 16 19:50 ..
\nlrwxrwxrwx 1 root root 23 Jan 11 2022 .htaccess -> \/etc\/wordpress\/htaccess
\n-rw-r--r-- 1 root root 405 Feb 6 2020 index.php
\n-rw-r--r-- 1 root root 7389 Jan 11 2022 readme.html
\n-rw-r--r-- 1 root root 7565 Jan 11 2022 wp-activate.php
\ndrwxr-xr-x 9 root root 4096 Sep 4 10:02 wp-admin
\n-rw-r--r-- 1 root root 351 Feb 6 2020 wp-blog-header.php
\n-rw-r--r-- 1 root root 2328 Feb 17 2021 wp-comments-post.php
\n-rw-r--r-- 1 root root 2543 Jan 7 2022 wp-config.php
\n-rw-r--r-- 1 root root 3004 May 21 2021 wp-config-sample.php
\ndrwxr-xr-x 5 root root 4096 Sep 4 10:02 wp-content
\n-rw-r--r-- 1 root root 3939 Jul 30 2020 wp-cron.php
\ndrwxr-xr-x 25 root root 20480 Sep 4 10:02 wp-includes
\n-rw-r--r-- 1 root root 2496 Feb 6 2020 wp-links-opml.php
\n-rw-r--r-- 1 root root 3900 May 15 2021 wp-load.php
\n-rw-r--r-- 1 root root 45463 Apr 6 2021 wp-login.php
\n-rw-r--r-- 1 root root 8509 Apr 14 2020 wp-mail.php
\n-rw-r--r-- 1 root root 22297 Jun 2 2021 wp-settings.php
\n-rw-r--r-- 1 root root 31693 May 7 2021 wp-signup.php
\n-rw-r--r-- 1 root root 4747 Oct 8 2020 wp-trackback.php
\n-rw-r--r-- 1 root root 3236 Jun 8 2020 xmlrpc.php<\/p>\n

 <\/p>\n

mysql -u stevee -p<\/span><\/p>\n

show databases ;<\/span><\/p>\n

use ElectronicsStuff ;<\/span><\/p>\n

Find DB collation:
\nSELECT @@character_set_database, @@collation_database;<\/span><\/p>\n

and for Engine:
\nSHOW TABLE STATUS\\G<\/span><\/p>\n

Diff Engines are not a prob in same DB.<\/p>\n

GRANT ALL PRIVILEGES ON ElectronicsStuff TO stevee@localhost IDENTIFIED BY xxx;<\/span><\/p>\n

SHOW GRANTS FOR 'stevee'@'localhost';<\/span><\/p>\n

systemctl restart mysql.service<\/span><\/p>\n

mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'PASSWORD';<\/span>
\nmysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;<\/span>
\nmysql> FLUSH PRIVILEGES;<\/span><\/p>\n

ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';<\/span><\/p>\n

mysql> show tables ;<\/span>
\n+----------------------------+
\n| Tables_in_ElectronicsStuff |
\n+----------------------------+
\n| wp_Counterize |
\n| wp_Counterize_Countries |
\n| wp_Counterize_Keywords |
\n| wp_Counterize_Outlinks |
\n| wp_Counterize_Pages |
\n| wp_Counterize_Referers |
\n| wp_Counterize_UserAgents |
\n| wp_commentmeta |
\n| wp_comments |
\n| wp_edd_customermeta |
\n| wp_edd_customers |
\n| wp_links |
\n| wp_options |
\n| wp_postmeta |
\n| wp_posts |
\n| wp_term_relationships |
\n| wp_term_taxonomy |
\n| wp_termmeta |
\n| wp_terms |
\n| wp_usermeta |
\n| wp_users |
\n| wp_xubg_commentmeta |
\n| wp_xubg_comments |
\n| wp_xubg_links |
\n| wp_xubg_options |
\n| wp_xubg_postmeta |
\n| wp_xubg_posts |
\n| wp_xubg_term_relationships |
\n| wp_xubg_term_taxonomy |
\n| wp_xubg_termmeta |
\n| wp_xubg_terms |
\n| wp_xubg_usermeta |
\n| wp_xubg_users |
\n| wpnt_commentmeta |
\n| wpnt_comments |
\n| wpnt_links |
\n| wpnt_options |
\n| wpnt_postmeta |
\n| wpnt_posts |
\n| wpnt_term_relationships |
\n| wpnt_term_taxonomy |
\n| wpnt_termmeta |
\n| wpnt_terms |
\n| wpnt_usermeta |
\n| wpnt_users |
\n| wpnt_wprss_logs |
\n+----------------------------+<\/p>\n

stevee@localhost:\/var\/www\/ElectronicsStuff$ mysqlcheck -c ElectronicsStuff -u stevee -p<\/span>
\nEnter password:
\nElectronicsStuff.wp_Counterize OK
\nElectronicsStuff.wp_Counterize_Countries OK
\nElectronicsStuff.wp_Counterize_Keywords OK
\nElectronicsStuff.wp_Counterize_Outlinks OK
\nElectronicsStuff.wp_Counterize_Pages OK
\nElectronicsStuff.wp_Counterize_Referers OK
\nElectronicsStuff.wp_Counterize_UserAgents OK
\nElectronicsStuff.wp_commentmeta OK
\nElectronicsStuff.wp_comments OK
\nElectronicsStuff.wp_edd_customermeta OK
\nElectronicsStuff.wp_edd_customers OK
\nElectronicsStuff.wp_links OK
\nElectronicsStuff.wp_options OK
\nElectronicsStuff.wp_postmeta OK
\nElectronicsStuff.wp_posts OK
\nElectronicsStuff.wp_term_relationships OK
\nElectronicsStuff.wp_term_taxonomy OK
\nElectronicsStuff.wp_termmeta OK
\nElectronicsStuff.wp_terms OK
\nElectronicsStuff.wp_usermeta OK
\nElectronicsStuff.wp_users OK
\nElectronicsStuff.wp_xubg_commentmeta OK
\nElectronicsStuff.wp_xubg_comments OK
\nElectronicsStuff.wp_xubg_links OK
\nElectronicsStuff.wp_xubg_options OK
\nElectronicsStuff.wp_xubg_postmeta OK
\nElectronicsStuff.wp_xubg_posts OK
\nElectronicsStuff.wp_xubg_term_relationships OK
\nElectronicsStuff.wp_xubg_term_taxonomy OK
\nElectronicsStuff.wp_xubg_termmeta OK
\nElectronicsStuff.wp_xubg_terms OK
\nElectronicsStuff.wp_xubg_usermeta OK
\nElectronicsStuff.wp_xubg_users OK
\nElectronicsStuff.wpnt_commentmeta OK
\nElectronicsStuff.wpnt_comments OK
\nElectronicsStuff.wpnt_links OK
\nElectronicsStuff.wpnt_options OK
\nElectronicsStuff.wpnt_postmeta OK
\nElectronicsStuff.wpnt_posts OK
\nElectronicsStuff.wpnt_term_relationships OK
\nElectronicsStuff.wpnt_term_taxonomy OK
\nElectronicsStuff.wpnt_termmeta OK
\nElectronicsStuff.wpnt_terms OK
\nElectronicsStuff.wpnt_usermeta OK
\nElectronicsStuff.wpnt_users OK
\nElectronicsStuff.wpnt_wprss_logs OK<\/p>\n

stevee@localhost:\/var\/www\/ElectronicsStuff$ mysqlcheck -c -u stevee -p --all-databases<\/span>
\nEnter password:
\nDebianAdmin.wp_xubg_commentmeta OK
\nDebianAdmin.wp_xubg_comments OK
\nDebianAdmin.wp_xubg_ewwwio_images OK
\nDebianAdmin.wp_xubg_ewwwio_queue OK
\nDebianAdmin.wp_xubg_links OK
\nDebianAdmin.wp_xubg_options OK
\nDebianAdmin.wp_xubg_postmeta OK
\nDebianAdmin.wp_xubg_posts OK
\nDebianAdmin.wp_xubg_pvc_daily OK
\nDebianAdmin.wp_xubg_pvc_total OK
\nDebianAdmin.wp_xubg_snippets OK
\nDebianAdmin.wp_xubg_term_relationships OK
\nDebianAdmin.wp_xubg_term_taxonomy OK
\nDebianAdmin.wp_xubg_termmeta OK
\nDebianAdmin.wp_xubg_terms OK
\nDebianAdmin.wp_xubg_usermeta OK
\nDebianAdmin.wp_xubg_users OK
\nElectronicsStuff.wp_Counterize OK
\nElectronicsStuff.wp_Counterize_Countries OK
\nElectronicsStuff.wp_Counterize_Keywords OK
\nElectronicsStuff.wp_Counterize_Outlinks OK
\nElectronicsStuff.wp_Counterize_Pages OK
\nElectronicsStuff.wp_Counterize_Referers OK
\nElectronicsStuff.wp_Counterize_UserAgents OK
\nElectronicsStuff.wp_commentmeta OK
\nElectronicsStuff.wp_comments OK
\nElectronicsStuff.wp_edd_customermeta OK
\nElectronicsStuff.wp_edd_customers OK
\nElectronicsStuff.wp_links OK
\nElectronicsStuff.wp_options OK
\nElectronicsStuff.wp_postmeta OK
\nElectronicsStuff.wp_posts OK
\nElectronicsStuff.wp_term_relationships OK
\nElectronicsStuff.wp_term_taxonomy OK
\nElectronicsStuff.wp_termmeta OK
\nElectronicsStuff.wp_terms OK
\nElectronicsStuff.wp_usermeta OK
\nElectronicsStuff.wp_users OK
\nElectronicsStuff.wp_xubg_commentmeta OK
\nElectronicsStuff.wp_xubg_comments OK
\nElectronicsStuff.wp_xubg_links OK
\nElectronicsStuff.wp_xubg_options OK
\nElectronicsStuff.wp_xubg_postmeta OK
\nElectronicsStuff.wp_xubg_posts OK
\nElectronicsStuff.wp_xubg_term_relationships OK
\nElectronicsStuff.wp_xubg_term_taxonomy OK
\nElectronicsStuff.wp_xubg_termmeta OK
\nElectronicsStuff.wp_xubg_terms OK
\nElectronicsStuff.wp_xubg_usermeta OK
\nElectronicsStuff.wp_xubg_users OK
\nElectronicsStuff.wpnt_commentmeta OK
\nElectronicsStuff.wpnt_comments OK
\nElectronicsStuff.wpnt_links OK
\nElectronicsStuff.wpnt_options OK
\nElectronicsStuff.wpnt_postmeta OK
\nElectronicsStuff.wpnt_posts OK
\nElectronicsStuff.wpnt_term_relationships OK
\nElectronicsStuff.wpnt_term_taxonomy OK
\nElectronicsStuff.wpnt_termmeta OK
\nElectronicsStuff.wpnt_terms OK
\nElectronicsStuff.wpnt_usermeta OK
\nElectronicsStuff.wpnt_users OK
\nElectronicsStuff.wpnt_wprss_logs OK
\nmyphpsite.text OK
\nmysql.columns_priv OK
\nmysql.component OK
\nmysql.db OK
\nmysql.default_roles OK
\nmysql.engine_cost OK
\nmysql.func OK
\nmysql.general_log OK
\nmysql.global_grants OK
\nmysql.gtid_executed OK
\nmysql.help_category OK
\nmysql.help_keyword OK
\nmysql.help_relation OK
\nmysql.help_topic OK
\nmysql.innodb_index_stats OK
\nmysql.innodb_table_stats OK
\nmysql.password_history OK
\nmysql.plugin OK
\nmysql.procs_priv OK
\nmysql.proxies_priv OK
\nmysql.replication_asynchronous_connection_failover OK
\nmysql.replication_asynchronous_connection_failover_managed OK
\nmysql.replication_group_configuration_version OK
\nmysql.replication_group_member_actions OK
\nmysql.role_edges OK
\nmysql.server_cost OK
\nmysql.servers OK
\nmysql.slave_master_info OK
\nmysql.slave_relay_log_info OK
\nmysql.slave_worker_info OK
\nmysql.slow_log OK
\nmysql.tables_priv OK
\nmysql.time_zone OK
\nmysql.time_zone_leap_second OK
\nmysql.time_zone_name OK
\nmysql.time_zone_transition OK
\nmysql.time_zone_transition_type OK
\nmysql.user OK
\nphpmyadmin.pma__bookmark OK
\nphpmyadmin.pma__central_columns OK
\nphpmyadmin.pma__column_info OK
\nphpmyadmin.pma__designer_settings OK
\nphpmyadmin.pma__export_templates OK
\nphpmyadmin.pma__favorite OK
\nphpmyadmin.pma__history OK
\nphpmyadmin.pma__navigationhiding OK
\nphpmyadmin.pma__pdf_pages OK
\nphpmyadmin.pma__recent OK
\nphpmyadmin.pma__relation OK
\nphpmyadmin.pma__savedsearches OK
\nphpmyadmin.pma__table_coords OK
\nphpmyadmin.pma__table_info OK
\nphpmyadmin.pma__table_uiprefs OK
\nphpmyadmin.pma__tracking OK
\nphpmyadmin.pma__userconfig OK
\nphpmyadmin.pma__usergroups OK
\nphpmyadmin.pma__users OK
\nsys.sys_config OK
\ntext.sometext<\/p>\n

stevee@localhost:\/var\/www\/ElectronicsStuff$ mysqlcheck -a ElectronicsStuff -u stevee -p<\/span>
\nEnter password:
\nElectronicsStuff.wp_Counterize Table is already up to date
\nElectronicsStuff.wp_Counterize_Countries Table is already up to date
\nElectronicsStuff.wp_Counterize_Keywords Table is already up to date
\nElectronicsStuff.wp_Counterize_Outlinks Table is already up to date
\nElectronicsStuff.wp_Counterize_Pages Table is already up to date
\nElectronicsStuff.wp_Counterize_Referers Table is already up to date
\nElectronicsStuff.wp_Counterize_UserAgents Table is already up to date
\nElectronicsStuff.wp_commentmeta Table is already up to date
\nElectronicsStuff.wp_comments Table is already up to date
\nElectronicsStuff.wp_edd_customermeta Table is already up to date
\nElectronicsStuff.wp_edd_customers Table is already up to date
\nElectronicsStuff.wp_links Table is already up to date
\nElectronicsStuff.wp_options Table is already up to date
\nElectronicsStuff.wp_postmeta Table is already up to date
\nElectronicsStuff.wp_posts Table is already up to date
\nElectronicsStuff.wp_term_relationships Table is already up to date
\nElectronicsStuff.wp_term_taxonomy Table is already up to date
\nElectronicsStuff.wp_termmeta Table is already up to date
\nElectronicsStuff.wp_terms Table is already up to date
\nElectronicsStuff.wp_usermeta Table is already up to date
\nElectronicsStuff.wp_users Table is already up to date
\nElectronicsStuff.wp_xubg_commentmeta OK
\nElectronicsStuff.wp_xubg_comments OK
\nElectronicsStuff.wp_xubg_links OK
\nElectronicsStuff.wp_xubg_options OK
\nElectronicsStuff.wp_xubg_postmeta OK
\nElectronicsStuff.wp_xubg_posts OK
\nElectronicsStuff.wp_xubg_term_relationships OK
\nElectronicsStuff.wp_xubg_term_taxonomy OK
\nElectronicsStuff.wp_xubg_termmeta OK
\nElectronicsStuff.wp_xubg_terms OK
\nElectronicsStuff.wp_xubg_usermeta OK
\nElectronicsStuff.wp_xubg_users OK
\nElectronicsStuff.wpnt_commentmeta Table is already up to date
\nElectronicsStuff.wpnt_comments Table is already up to date
\nElectronicsStuff.wpnt_links Table is already up to date
\nElectronicsStuff.wpnt_options Table is already up to date
\nElectronicsStuff.wpnt_postmeta Table is already up to date
\nElectronicsStuff.wpnt_posts Table is already up to date
\nElectronicsStuff.wpnt_term_relationships Table is already up to date
\nElectronicsStuff.wpnt_term_taxonomy Table is already up to date
\nElectronicsStuff.wpnt_termmeta Table is already up to date
\nElectronicsStuff.wpnt_terms Table is already up to date
\nElectronicsStuff.wpnt_usermeta Table is already up to date
\nElectronicsStuff.wpnt_users Table is already up to date
\nElectronicsStuff.wpnt_wprss_logs Table is already up to date<\/p>\n

OPTIMISE - shows FAULT:
\nstevee@localhost:\/var\/www\/ElectronicsStuff$ mysqlcheck -o ElectronicsStuff -u stevee -p<\/span>
\nEnter password:
\nElectronicsStuff.wp_Counterize OK
\nElectronicsStuff.wp_Counterize_Countries OK
\nElectronicsStuff.wp_Counterize_Keywords OK
\nElectronicsStuff.wp_Counterize_Outlinks OK
\nElectronicsStuff.wp_Counterize_Pages OK
\nElectronicsStuff.wp_Counterize_Referers OK
\nElectronicsStuff.wp_Counterize_UserAgents OK
\nElectronicsStuff.wp_commentmeta OK
\nElectronicsStuff.wp_comments OK
\nElectronicsStuff.wp_edd_customermeta OK
\nElectronicsStuff.wp_edd_customers OK
\nElectronicsStuff.wp_links OK
\nElectronicsStuff.wp_options OK
\nElectronicsStuff.wp_postmeta OK
\nElectronicsStuff.wp_posts OK
\nElectronicsStuff.wp_term_relationships OK
\nElectronicsStuff.wp_term_taxonomy OK
\nElectronicsStuff.wp_termmeta OK
\nElectronicsStuff.wp_terms OK
\nElectronicsStuff.wp_usermeta OK
\nElectronicsStuff.wp_users OK
\nElectronicsStuff.wp_xubg_commentmeta
\nnote : Table does not support optimize, doing recreate + analyze instead
\nstatus : OK
\nElectronicsStuff.wp_xubg_comments
\nnote : Table does not support optimize, doing recreate + analyze instead
\nerror : Invalid default value for 'comment_date'
\nstatus : Operation failed
\nElectronicsStuff.wp_xubg_links
\nnote : Table does not support optimize, doing recreate + analyze instead
\nerror : Invalid default value for 'link_updated'
\nstatus : Operation failed
\nElectronicsStuff.wp_xubg_options
\nnote : Table does not support optimize, doing recreate + analyze instead
\nstatus : OK
\nElectronicsStuff.wp_xubg_postmeta
\nnote : Table does not support optimize, doing recreate + analyze instead
\nstatus : OK
\nElectronicsStuff.wp_xubg_posts
\nnote : Table does not support optimize, doing recreate + analyze instead
\nerror : Invalid default value for 'post_date'
\nstatus : Operation failed
\nElectronicsStuff.wp_xubg_term_relationships
\nnote : Table does not support optimize, doing recreate + analyze instead
\nstatus : OK<\/p>\n

REPAIR:<\/p>\n

stevee@localhost:\/var\/www\/ElectronicsStuff$ mysqlcheck -r ElectronicsStuff -u stevee -p<\/span>
\nEnter password:
\nElectronicsStuff.wp_Counterize OK
\nElectronicsStuff.wp_Counterize_Countries OK
\nElectronicsStuff.wp_Counterize_Keywords OK
\nElectronicsStuff.wp_Counterize_Outlinks OK
\nElectronicsStuff.wp_Counterize_Pages OK
\nElectronicsStuff.wp_Counterize_Referers OK
\nElectronicsStuff.wp_Counterize_UserAgents OK
\nElectronicsStuff.wp_commentmeta OK
\nElectronicsStuff.wp_comments OK
\nElectronicsStuff.wp_edd_customermeta OK
\nElectronicsStuff.wp_edd_customers OK
\nElectronicsStuff.wp_links OK
\nElectronicsStuff.wp_options OK
\nElectronicsStuff.wp_postmeta OK
\nElectronicsStuff.wp_posts OK
\nElectronicsStuff.wp_term_relationships OK
\nElectronicsStuff.wp_term_taxonomy OK
\nElectronicsStuff.wp_termmeta OK
\nElectronicsStuff.wp_terms OK
\nElectronicsStuff.wp_usermeta OK
\nElectronicsStuff.wp_users OK
\nElectronicsStuff.wp_xubg_commentmeta
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_comments
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_links
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_options
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_postmeta
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_posts
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_term_relationships
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_term_taxonomy
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_termmeta
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_terms
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_usermeta
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wp_xubg_users
\nnote : The storage engine for the table doesn't support repair
\nElectronicsStuff.wpnt_commentmeta OK
\nElectronicsStuff.wpnt_comments OK
\nElectronicsStuff.wpnt_links OK
\nElectronicsStuff.wpnt_options OK
\nElectronicsStuff.wpnt_postmeta OK
\nElectronicsStuff.wpnt_posts OK
\nElectronicsStuff.wpnt_term_relationships OK
\nElectronicsStuff.wpnt_term_taxonomy OK
\nElectronicsStuff.wpnt_termmeta OK
\nElectronicsStuff.wpnt_terms OK
\nElectronicsStuff.wpnt_usermeta OK
\nElectronicsStuff.wpnt_users OK
\nElectronicsStuff.wpnt_wprss_logs OK<\/p>\n

ALL switches:<\/p>\n

-A, \u2013all-databases Consider all the databases
\n-a, \u2013analyze Analyze tables
\n-1, \u2013all-in-1 Use one query per database with tables listed in a comma separated way
\n\u2013auto-repair Repair the table automatically it if is corrupted
\n-c, \u2013check Check table errors
\n-C, \u2013check-only-changed Check tables that are changed since last check
\n-g, \u2013check-upgrade Check for version dependent changes in the tables
\n-B, \u2013databases Check more than one databases
\n-F, \u2013fast Check tables that are not closed properly
\n\u2013fix-db-names Fix DB names
\n\u2013fix-table-names Fix table names
\n-f, \u2013force Continue even when there is an error
\n-e, \u2013extended Perform extended check on a table. This will take a long time to execute.
\n-m, \u2013medium-check Faster than extended check option, but does most checks
\n-o, \u2013optimize Optimize tables
\n-q, \u2013quick Faster than medium check option
\n-r, \u2013repair Fix the table corruption<\/p>\n

mysql> SELECT @@character_set_database, @@collation_database;<\/span>
\n+--------------------------+----------------------+
\n| @@character_set_database | @@collation_database |
\n+--------------------------+----------------------+
\n| utf8mb4 | utf8mb4_0900_ai_ci<\/p>\n

Missing comma before start of a new alter operation. (near \"DEFAULT CHARSET\" at position 47)<\/p>\n

OK, let\u2019s try this. When displaying the database in phpMyAdmin, you will see a list of tables. One of them is wp_posts. Click on that table, and then click on the \u201cOperations\u201d tab. In the Table Options box, make sure the collation is set to utf8mb4_unicode_520_ci and there is a check in the \u201cChange all column collations\u201d checkbox, then click the \u201cGo\u201d button.<\/p>\n","protected":false},"excerpt":{"rendered":"

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n

CREATE database NEO ; USE NEO; DROP database NEO ; source \/var\/www\/NEOBabyHPWorking.sql ; GRANT ALL PRIVILEGES ON NEO.* TO 'stevee'@'localhost'; ALTER USER 'stevee'@'localhost' IDENTIFIED BY 'pw'; WP-CLI: cd \/opt curl -O https:\/\/raw.githubusercontent.com\/wp-cli\/builds\/gh-pages\/phar\/wp-cli.phar stevee@localhost:\/opt$ sudo curl -O https:\/\/raw.githubusercontent.com\/wp-cli\/builds\/gh-pages\/phar\/wp-cli.phar [sudo] password for stevee: % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload ...\u00a0 WordPress CLI Commands and some MYSQL Repair Commands<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-9616","post","type-post","status-publish","format-standard","hentry","category-post"],"a3_pvc":{"activated":true,"total_views":27,"today_views":0},"_links":{"self":[{"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/posts\/9616","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/comments?post=9616"}],"version-history":[{"count":7,"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/posts\/9616\/revisions"}],"predecessor-version":[{"id":10345,"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/posts\/9616\/revisions\/10345"}],"wp:attachment":[{"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/media?parent=9616"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/categories?post=9616"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stevepedwards.today\/DebianAdmin\/wp-json\/wp\/v2\/tags?post=9616"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}