Database & File Manager Access with InMotion Central

File Manager and Database Access - InMotion Central Tools

If you’re an advanced user, you’ll sometimes want to make adjustments to your WordPress site that aren’t possible within the default WordPress dashboard.

InMotion Central’s file manager and database access make it easy to make changes to raw files and database tables by only offering the tools you need to complete advanced tasks. You get a cleaner interface that’s easier to navigate.

Continue reading to learn more about the file manager and database access within InMotion Central.

Of note, you must have a Cloud WordPress Premium subscription to access these tools.

File Manager

  1. Log into InMotion Central and select a project.
  2. Select Tools> File Manager.
  3. Now click Launch App.
  4. The File Manager will open in a new tab, displaying your website root directory.
  5. At the top-right you’ll have three options:

    – Search for files and subdirectories in the current directory

    – Upload files to the current directory using your system window manager, drag-and-drop, or the public URL

    Upload file from PC or URL

    – Create a new file or folder

    Create a new file
  6. Files and folders are listed and can be organized by alphabetical order, file size, date last modified, numeric file permissions, and owner.
  7. To the right of each file and directory, in the Actions column, are options to:

    – Delete the file or directory
    – Rename the file or directory
    – Copy the file or directory to another location
    – View the public file or directory URL in the browser
    – Download the file

    File Manager actions
  8. At the bottom, you’ll see system memory and disk space stats along with buttons to manage multiple files at once including archive creation with zip or tar.

    Memory and disk space stats

Edit a File with InMotion Central

  1. Select a file name to view the raw text or edit the file.

    View file contents and metadata
  2. There are two options for editing files – Edit and AdvancedEditor.

    Edit opens a basic text editor with no additional features, sufficient for quick changes.

    Basic text file editor


    AdvancedEditor is equipped with features fit for in-depth coding:

    – Full screen mode
    – Search and replace
    – Word wrap
    – Programming language syntax highlighting
    – Bright and dark color themes

    Advanced text editor

Database Access 

  1. You can access the database from InMotion Central by selecting Tools>Database. Users already in the File Manager can simply select Database in the upper-right corner.



  2. Cloud WordPress Premium will display all tables in your WordPress database.

    WordPress Database manager
  3. From the top of the page you can:

    – Alter the database character set

    Alter database character set

    – View and export a schema showing all tables and their columns

    WordPress database schema

    – Create a database user with remote database access

    Create a database user

  4. On the left of Cloud WordPress Premium you’ll see the name of your database (username_wp#), tables within the database, and additional functions:

    – “SQL command” allows you to execute MySQL commands

    SQL Commands terminal emulator

    – Import SQL files from your local machine or already uploaded to the web server

    Import database from PC or server

    – Export database tables in SQL, CSV, or TSV formats

    Export database with preferred settings


    – Create a new table

    Create a database table

  5. In the main section, select a table name (e.g. “wp_commentmeta”) to view structure info including indexes, foreign keys, and triggers.

    wp_commentmeta table details
  6. Click Select data on the top of the page, or select on the left of the page (beside the individual table), to run basic SQL commands with the graphical interface.

    SQL commands available from the GUI
  7. Alter table is where you’ll modify a column:

    – Name
    – Data type
    – Length
    – Data type options
    – Allow “NULL”
    – Allow “AUTO_INCREMENT” (AI)
    – Order
    – Add and remove columns

    Alter table column settings

Check and Repair Database

If your WordPress site shuts down and displays “Error Establishing a Database Connection,” this is an indicator of database corruption. Fortunately, most cases can be resolved easily with a “check and repair database” function. Keep in mind that resolving the public-facing error doesn’t fix the underlying problem causing db corruption.

The fastest method, especially if you see this error often, is to configure WordPress to complete this process automatically with one extra code block in the wp-config.php file:

define (‘WP_ALLOW_REPAIR’, ‘true’);

While we recommend editing wp-config.php for this, you can repair the database manually in the database manager.

  1. Return to the main page to view all WordPress database tables.
  2. Select the top-left checkbox to select all tables.
    Select all tables to check and repair
  3. Select Check at the bottom. The page should refresh and state “OK” beside every table to indicate no errors.
  4. Select all tables again and select Repair
  5. If the page refreshes to show “The storage engine for the table doesn’t support repair,” you’ll need to change the storage engine from InnoDB to MyISAM for each table to repair tables. Note which tables had the error and show “InnoDB” in the table list.

    Export a backup before making further changes.

  6. Select SQL command on the left.
  7. If only one or a few tables need to be changed, you can use the code block below. Remember to update “table_name” to the table name.
    ALTER TABLE table_name1 ENGINE=MyISAM; ALTER TABLE table_name2 ENGINE=MyISAM;

    If all tables had the error, you can copy the selection below which includes all default WordPress tables:
    ALTER TABLE wp_commentmeta ENGINE=MyISAM; ALTER TABLE wp_comments ENGINE=MyISAM; ALTER TABLE wp_links ENGINE=MyISAM; ALTER TABLE wp_options ENGINE=MyISAM; ALTER TABLE wp_postmeta ENGINE=MyISAM; ALTER TABLE wp_posts ENGINE=MyISAM; ALTER TABLE wp_termmeta ENGINE=MyISAM; ALTER TABLE wp_terms ENGINE=MyISAM; ALTER TABLE wp_term_relationships ENGINE=MyISAM; ALTER TABLE wp_term_taxonomy ENGINE=MyISAM; ALTER TABLE wp_usermeta ENGINE=MyISAM; ALTER TABLE wp_users ENGINE=MyISAM;
  8. Execute the SQL command.
  9. Return to step 4.

We hope this helps. Let us know if you have any questions about InMotion Central tools.

JB
John-Paul Briones Content Writer II

John-Paul is an Electronics Engineer that spent most of his career in IT. He has been a Technical Writer for InMotion since 2013.

More Articles by John-Paul

Comments

It looks like this article doesn't have any comments yet - you can be the first. If you have any comments or questions, start the conversation!

Was this article helpful? Let us know!