DB Export, Edit MYSQL Row as Text and Import

Categories

Administration
Import/Export

Component ID

993300

Component name

DB Export, Edit MYSQL Row as Text and Import

Component type

module

Maintenance status

Seeking co-maintainer(s)

Development status

Under active development

Component security advisory coverage

not-covered

Component created

Component changed

Component body

A good name for this script is:
Poorman's PhpMyAdmin ;)

Intro

This is a tiny php command line script that :
- exports a mysql row into a text file via php's var_export. We have 1. mysql row that becomes 2. a PHP array , that becomes 3. string dump of the array (some array elements are unserialized prior to the string export)

- allows for editing via a text editor

- can import back to the database the edited string dump

Currently we support only the editing of context's module mysql table rows - the "context" table.

Install 

cvs -z6 -d:pserver:anonymous:anonymous@cvs.drupal.org:/cvs/drupal-contrib checkout -d db_export_edit_mysql_row_as_text_and_import-HEAD contributions/modules/db_export_edit_mysql_row_as_text_and_import/

How to use:
- download either into sites/all/modules and symlink in the drupal root OR download the script directly in the root.
- invoke via:
- list:
php db_export_edit_mysql_row_as_text_and_import.php list
- export: (using list's output)
php db_export_edit_mysql_row_as_text_and_import.php export io_programme_blocks
-edit /tmp/sdads text file
- import into DB via:
php db_export_edit_mysql_row_as_text_and_import.php import /tmp/tmp.p2spiBra3u

Component url

https://www.drupal.org/project/db_export_edit_mysql_row_as_text_and_import