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
Downloads
Project Information
- Maintenance status: Seeking co-maintainer(s)
- Development status: Under active development
- Module categories: Administration, Import/Export
- Last modified: December 10, 2010
