Title: Export Schedule
Last modified: November 16, 2022

---

# Export Schedule

 *  Resolved [jfdesignco2](https://wordpress.org/support/users/jfdesignco2/)
 * (@jfdesignco2)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/export-schedule/)
 * Is there a way to export the schedule to a new install? We redesigned my client’s
   site and need to export their current schedule to the new site.

Viewing 1 replies (of 1 total)

 *  Plugin Author [plainware](https://wordpress.org/support/users/plainware/)
 * (@plainware)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/export-schedule/#post-16241315)
 * Hello,
    I’m sorry for not replying sooner. Our plugin keeps its data in WordPress
   database tables so you can either move the whole WordPress database to the new
   site, or just export then import only ShiftController related data.
 * wp_options: records where “option_name” starts with “sh4_”
    wp_posts: records
   where “post_type” starts with “sh4_” wp_postmeta: records where post_id in the
   results of the previous step
 * Speaking in SQL, you’ll need to export the full results of the following queries,
   then load them into the new database keeping the records ids:
 *     ```
       SELECT * FROM "wp_options" WHERE "option_name" LIKE "sh4_%"
       SELECT * FROM "wp_posts" WHERE "post_type" LIKE "sh4_%"
       SELECT * FROM "wp_postmeta" WHERE "post_id" IN(SELECT ID FROM "wp_posts" WHERE "post_type" LIKE "sh4_%")
       ```
   

Viewing 1 replies (of 1 total)

The topic ‘Export Schedule’ is closed to new replies.

 * ![](https://ps.w.org/shiftcontroller/assets/icon-128x128.png?rev=1851172)
 * [ShiftController Employee Shift Scheduling](https://wordpress.org/plugins/shiftcontroller/)
 * [Support Threads](https://wordpress.org/support/plugin/shiftcontroller/)
 * [Active Topics](https://wordpress.org/support/plugin/shiftcontroller/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/shiftcontroller/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/shiftcontroller/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [plainware](https://wordpress.org/support/users/plainware/)
 * Last activity: [3 years, 6 months ago](https://wordpress.org/support/topic/export-schedule/#post-16241315)
 * Status: resolved