Forum Replies Created

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter lindawoodrow

    (@lindawoodrow)

    Thank you Dion. I’ll let you know the outcome, but in any case I am eternally grateful!

    Thread Starter lindawoodrow

    (@lindawoodrow)

    Hi Dion, thank you for getting involved. If I copy, I get a green notice that it is copied, but wp_usermeta2 does not appear in the list of tables. I also get a notice

    Some erros have been detected on the server. Please look at the bottom of this window

    .
    At the bottom is:

    `Notice in .\libraries\classes\Controllers\Table\OperationsController.php#453
    Undefined offset: 0

    Backtrace

    Routing.php#192: PhpMyAdmin\Controllers\Table\OperationsController->__invoke(
    ,
    array,
    )
    index.php#43: PhpMyAdmin\Routing::callControllerForRoute(
    ,
    string ‘/table/operations’,
    ,
    ,
    )`

    Before I do the last resort, does that shed any light?

    Thread Starter lindawoodrow

    (@lindawoodrow)

    Unfortunately Sumit that hasn’t worked. For the first queries, if I run them in the database for the site, it says

    `errors were found during analysis.

    This type of clause was previously parsed. (near “REPAIR” at position 23)
    SQL query: Copy

    REPAIR TABLE mysql.db REPAIR TABLE mysql.user;

    MySQL said: Documentation

    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘REPAIR TABLE mysql.user’ at line 2`

    For the second ones, it won’t let me run any query at all on the corrupt table, it just gives me the message to try to repair it.

    Thread Starter lindawoodrow

    (@lindawoodrow)

    I don’t know if this is relevant or useful either: One of the forums I looked at suggested

    `8) If ‘Repair’ fails no choice but to ‘DROP TABLE user’ ….
    (9) Recreate ‘user’ table from the distribution backup by copying the following 3 files.

    C:\xampp\mysql\backup\mysql\user.frm
    C:\xampp\mysql\backup\mysql\user.MYD
    C:\xampp\mysql\backup\mysql\user.MYI
    to

    C:\xampp\mysql\data\mysql\`

    My problem is that user.frm is there, but I cannot find user.MYD or user.MYI in that folder.

Viewing 4 replies - 1 through 4 (of 4 total)