Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.This project is not covered by Drupal’s security advisory policy.
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
Project information
Seeking co-maintainer(s)
Maintainers are looking for help reviewing issues.- Module categories: Administration Tools, Import and Export
- Created by rsvelko on , updated
This project is not covered by the security advisory policy.
Use at your own risk! It may have publicly disclosed vulnerabilities.
