This forum is no longer open and is for reading/searching only.

Please use our new MachForm Community Forum instead.

MachForm Community Forums » MachForm 2

Export DB, modify it in Excel & Reimport in MySQL

Started 13 years ago by msfbiz | 3 posts |


  1. msfbiz
    Member

    I have a large number of edits to do on many entries of one form.

    Can I export the MySQL DB as a csv file, make all the changes in Excel, and the re-import it back?

    If so, will the edited entries be automatically overwritten (as they should) in the MySQL DB, or do I need to first delete the entries in the DB before re-importing?

    Posted 13 years ago #

  2. yuniar

    You can do so, but don't use the export feature provided through MachForm admin panel.
    Instead, use phpMyAdmin to do the export/import.

    The old entries need to be deleted first before re-importing. Make sure to delete only the entries, not the table itself.

    MachForm Founder

    Posted 13 years ago #

  3. msfbiz
    Member

    That makes sense. Thanks!

    Posted 13 years ago #

RSS feed for this topic

Reply