leetsombrero

<p>Jot allows non-technical WordPress administrators to modify MySQL<br />
tables with a lightweight, user-friendly interface.  This plugin currently supports MySQL only.</p>
<h3>Features</h3>
<ul>
<li>Create menus directly in the WordPress administration page to view and interact with tables</li>
<li>Quickly add and edit single entries to the data table</li>
<li>Associate table entries with images, which are uploaded and managed using the Jot interface</li>
<li>Rearrange table entries or split entries into multiple tables</li>
</ul>
<h3>Usage</h3>
<h4>Creating a menu</h4>
<ul>
<li>To create a menu, navigate to the “Settings”>”Jot Settings”</li>
<li>Ensure “Create New” is selected under “Menu Selection”</li>
<li>Fill in your database information and click Update</li>
<li>Choose the table that you want to create a menu for</li>
<li>Fill in the remaining form and click “Add New”</li>
</ul>
<h4>Modifying a menu</h4>
<ul>
<li>To edit a menu, navigate to the “Settings”>”Jot Settings”</li>
<li>Choose a menu to edit under “Menu Selection”</li>
<li>Modify the settings to your liking and click “Save Changes” at the bottom of the page</li>
</ul>
<h4>Deleting a menu</h4>
<ul>
<li>To delete a menu, navigate to the “Settings”>”Jot Settings”</li>
<li>Choose a menu to edit under “Menu Selection”</li>
<li>Click “Delete Menu” at the bottom of the page</li>
</ul>
<h4>Regarding image association</h4>
<ul>
<li>Tables you wish to associate with images must have a dedicated image source column (ex. <code>imgsrc</code>)
<ul>
<li>The image source column will contain the image FILENAME</li>
<li>The image directory will be defined during setup</li>
</ul>
</li>
<li>To use your own default image (used when no association is made),<br />
   simply add a “blank-profile-picture.jpg” to your image directory</li>
</ul>


Jot Data Manager

Jot allows non-technical WordPress administrators to modify MySQL

yihui

<p>This plugin can convert your WordPress database (both tables and columns) to UTF-8 character set. It will be especially useful when you move your database from one server to another where the default CHARSET is not UTF-8.</p>


Convert WP Database to UTF-8

Converts the WordPress database (both tables and columns) to UTF-8 character set.

Jot Data Manager vs Convert WP Database to UTF-8