# How to backup Layout Based Form? (LBF)

**URL:** <https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125>\
**Category:** Management and Administration\
**Created:** [March 21, 2025, 2:34pm UTC](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125 "2025-03-21T14:34:31Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![George\_Messiha](https://community.open-emr.org/user_avatar/community.open-emr.org/george_messiha/32/21517_2.png) [@George\_Messiha](https://community.open-emr.org/u/George_Messiha)\
**Post date:** [March 21, 2025, 2:34pm UTC](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125/1 "2025-03-21T14:34:31Z")

</div>

Are LBF forms in the Database or on the OpenEMR web site?

I would like to backup the LBF form I created.

---

<div class="post-metadata">

**Author:** ![moussa](https://community.open-emr.org/letter_avatar_proxy/v4/letter/m/90ced4/32.png) [@moussa](https://community.open-emr.org/u/moussa)\
**Post date:** [March 21, 2025, 2:42pm UTC](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125/2 "2025-03-21T14:42:53Z")

</div>

> [@George\_Messiha](#):
>
> Are LBF forms in the Database

Yes

 ![image](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/3X/4/e/4e77810afe67da56f313cffbb1e3f9bcfdd2c27e.png)

---

<div class="post-metadata">

**Author:** ![George\_Messiha](https://community.open-emr.org/user_avatar/community.open-emr.org/george_messiha/32/21517_2.png) [@George\_Messiha](https://community.open-emr.org/u/George_Messiha)\
**Post date:** [March 21, 2025, 3:12pm UTC](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125/3 "2025-03-21T15:12:13Z")

</div>

Perfect what about Manage List? I don’t see my custom list in lists or list options

I want to create in Dev a custom list and and a custom form and be able to export it and deploy it on another environment.

---

<div class="post-metadata">

**Author:** ![adunsulag](https://community.open-emr.org/user_avatar/community.open-emr.org/adunsulag/32/12606_2.png) [@adunsulag](https://community.open-emr.org/u/adunsulag)\
**Post date:** [March 21, 2025, 3:13pm UTC](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125/4 "2025-03-21T15:13:18Z")

</div>

There is a option in Admin → Features → Configuration Export/Import you can turn on that adds more features to the Admin → System → Backup page.

 ![image](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/3X/8/e/8ec103dd78c7d73037a0c70955b048cdf4007640.png)

You should be able to download your layouts as well as any lists you’ve created. I know I’ve done exports just to track changes in LBF forms. I haven’t played with the import process, but presumably you should be able to do an import of an LBF form. Bear in mind you’ll want to import each custom list first before doing the LBF form import as I imagine otherwise things would break.

---

<div class="post-metadata">

**Author:** ![adunsulag](https://community.open-emr.org/user_avatar/community.open-emr.org/adunsulag/32/12606_2.png) [@adunsulag](https://community.open-emr.org/u/adunsulag)\
**Post date:** [March 21, 2025, 3:13pm UTC](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125/5 "2025-03-21T15:13:51Z")

</div>

![image](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/3X/7/8/78bce07c798a2ff7cc22b52685b569dbf6759b8b.png)  
Here’s a screenshot on one of the demo’s of what the Export Configuration screen looks like.

---

<div class="post-metadata">

**Author:** ![George\_Messiha](https://community.open-emr.org/user_avatar/community.open-emr.org/george_messiha/32/21517_2.png) [@George\_Messiha](https://community.open-emr.org/u/George_Messiha)\
**Post date:** [March 21, 2025, 3:17pm UTC](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125/6 "2025-03-21T15:17:11Z")

</div>

Unfortunately, i am running in Docker and the Export doesn’t work for me I get “There was an error on the backup” Doing the config backup or the standard backup.

Version 7.0.2(2)

---

<div class="post-metadata">

**Author:** ![adunsulag](https://community.open-emr.org/user_avatar/community.open-emr.org/adunsulag/32/12606_2.png) [@adunsulag](https://community.open-emr.org/u/adunsulag)\
**Post date:** [March 21, 2025, 3:18pm UTC](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125/7 "2025-03-21T15:18:25Z")

</div>

That’s interesting, there must be something unique to your setup. The demo servers are all running on docker.

For example: [https://demo.openemr.io/openemr/](https://demo.openemr.io/openemr/)

Username admin/pass and you can verify the export is working fine for the LBF form & lists.

---

<div class="post-metadata">

**Author:** ![George\_Messiha](https://community.open-emr.org/user_avatar/community.open-emr.org/george_messiha/32/21517_2.png) [@George\_Messiha](https://community.open-emr.org/u/George_Messiha)\
**Post date:** [March 21, 2025, 3:21pm UTC](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125/8 "2025-03-21T15:21:06Z")

</div>

Running Docker on Windows.

I used these commands to create the containers:

docker pull openemr/openemr:latest  
#docker pull phpmyadmin/phpmyadr:latest  
docker pull phpmyadmin:latest  
docker pull mysql:latest

docker network create mynet  
docker run --detach --name mysql --env “MYSQL\_ROOT\_PASSWORD=root” --net mynet mysql --character-set-server=utf8  
docker run --detach -p 81:80 --name phpmyadmin --env “PMA\_HOST=mysql” --net mynet phpmyadmin/phpmyadmin  
docker run --detach -p 80:80 --name openemr --env “MYSQL\_HOST=mysql” --env “MYSQL\_ROOT\_PASS=root” --net mynet openemr/openemr

---

<div class="post-metadata">

**Author:** ![adunsulag](https://community.open-emr.org/user_avatar/community.open-emr.org/adunsulag/32/12606_2.png) [@adunsulag](https://community.open-emr.org/u/adunsulag)\
**Post date:** [March 21, 2025, 3:28pm UTC](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125/9 "2025-03-21T15:28:50Z")

</div>

Check your apache error logs (where php errors are stored) on the docker image when you do the backup. Perhaps there’s something unique to the windows environment, shouldn’t be though since its a docker container.

How are you handling the writeable sites directory on the docker image? That’d be the other thing I’d look at. I believe the export writes out to /tmp/ but if it is writing to the sites directory and that’s locked down you may run into problems.

---

<div class="post-metadata">

**Author:** ![George\_Messiha](https://community.open-emr.org/user_avatar/community.open-emr.org/george_messiha/32/21517_2.png) [@George\_Messiha](https://community.open-emr.org/u/George_Messiha)\
**Post date:** [March 21, 2025, 3:36pm UTC](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125/10 "2025-03-21T15:36:53Z")

</div>

Looking at the log file in /var/log/apache2/

Undefined array key “data\_type” in /var/www/localhost/htdocs/openemr/interface/main/finder/dynamic\_finder.php on line 411

---

<div class="post-metadata">

**Author:** ![adunsulag](https://community.open-emr.org/user_avatar/community.open-emr.org/adunsulag/32/12606_2.png) [@adunsulag](https://community.open-emr.org/u/adunsulag)\
**Post date:** [March 21, 2025, 3:38pm UTC](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125/11 "2025-03-21T15:38:56Z")

</div>

That’s the only thing you see after running the export and getting an error? That dynamic\_finder.php is in a different code section, there should be other logs showing the error.

---

<div class="post-metadata">

**Author:** ![adunsulag](https://community.open-emr.org/user_avatar/community.open-emr.org/adunsulag/32/12606_2.png) [@adunsulag](https://community.open-emr.org/u/adunsulag)\
**Post date:** [March 21, 2025, 3:39pm UTC](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125/12 "2025-03-21T15:39:51Z")

</div>

The name of the page for the backup is: /interface/main/backup.php so that should be showing in your logs if there is a php error being triggered.

---

<div class="post-metadata">

**Author:** ![George\_Messiha](https://community.open-emr.org/user_avatar/community.open-emr.org/george_messiha/32/21517_2.png) [@George\_Messiha](https://community.open-emr.org/u/George_Messiha)\
**Post date:** [March 21, 2025, 3:40pm UTC](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125/13 "2025-03-21T15:40:24Z")

</div>

[Fri Mar 21 15:18:12.674434 2025] [php:notice] [pid 105:tid 105] [client 172.19.0.1:50478] [2025-03-21T15:18:12.674129+00:00] OpenEMR.ERROR: Not all selected assets were included in header {“selectedAssets”:[“”],“foundAssets”:[“jquery”,“bootstrap”,“utility”,“main-theme”,“compact-theme”,“textformat”,“dialog”]} , referer: [http://localhost/interface/main/tabs/main.php?token\_main=VG294k1PcjJagERZ0D3H5Sz564RIi3LFN8ZidrV5](http://localhost/interface/main/tabs/main.php?token_main=VG294k1PcjJagERZ0D3H5Sz564RIi3LFN8ZidrV5)  
mysqldump: Got error: 1045: “Plugin caching\_sha2\_password could not be loaded: Error loading shared library /usr/lib/mariadb/plugin/caching\_sha2\_password.so: No such file or directory” when trying to connect

---

<div class="post-metadata">

**Author:** ![adunsulag](https://community.open-emr.org/user_avatar/community.open-emr.org/adunsulag/32/12606_2.png) [@adunsulag](https://community.open-emr.org/u/adunsulag)\
**Post date:** [March 21, 2025, 3:49pm UTC](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125/14 "2025-03-21T15:49:30Z")

</div>

Haven’t seen that error before. You mentioned you’re running a mysql image above, yet its looking for a mariadb plugin. Not sure if you’re error is on the php server side, or if its on the mysql side of things.

@brady.miller or @jesdynf any thoughts on this?

The only other thing I would of trying is to use one of the image files from the development docker-composes. For example our easy-dev uses openemr/openemr-flex for the image and uses mariadb:11.4 for the database and see if you run into the same error. However you’d want to do a manual db dump and also copy your openemr sites directory (that has all the encryption keys) before you do something like that if you have work you want to save.

---

<div class="post-metadata">

**Author:** ![sjpadgett](https://community.open-emr.org/user_avatar/community.open-emr.org/sjpadgett/32/21623_2.png) [@sjpadgett](https://community.open-emr.org/u/sjpadgett)\
**Post date:** [March 21, 2025, 4:00pm UTC](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125/15 "2025-03-21T16:00:02Z")

</div>

Just to be sure I’ll fire up my windows docker and test.

Update:  
Test okay for me using easy dev.  
11.4.4-MariaDB-ubu2404 - [mariadb.org](http://mariadb.org) binary distribution

---

<div class="post-metadata">

**Author:** ![George\_Messiha](https://community.open-emr.org/user_avatar/community.open-emr.org/george_messiha/32/21517_2.png) [@George\_Messiha](https://community.open-emr.org/u/George_Messiha)\
**Post date:** [March 21, 2025, 5:58pm UTC](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125/16 "2025-03-21T17:58:53Z")

</div>

Yea not sure how to change it to use mysql instead for that function.

---

<div class="post-metadata">

**Author:** ![sjpadgett](https://community.open-emr.org/user_avatar/community.open-emr.org/sjpadgett/32/21623_2.png) [@sjpadgett](https://community.open-emr.org/u/sjpadgett)\
**Post date:** [March 21, 2025, 6:56pm UTC](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125/17 "2025-03-21T18:56:35Z")

</div>

Problem is MariaDB doesn’t support by default caching\_sha2\_password plugin. You must be using a mysql config to migrate your database. Check my.ini if authentication plugin caching\_sha2\_password is used.  
You can update the user’s authentication method to mysql\_native\_password using an ALTER USER command.

---

<div class="post-metadata">

**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\
**Post date:** [March 21, 2025, 7:05pm UTC](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125/18 "2025-03-21T19:05:45Z")

</div>

Looks like [mysql 8 doesn’t either](https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded).

---

<div class="post-metadata">

**Author:** ![George\_Messiha](https://community.open-emr.org/user_avatar/community.open-emr.org/george_messiha/32/21517_2.png) [@George\_Messiha](https://community.open-emr.org/u/George_Messiha)\
**Post date:** [March 21, 2025, 7:28pm UTC](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125/19 "2025-03-21T19:28:30Z")

</div>

How? To update native password? Nothing else has issues just the backup and export function

---

<div class="post-metadata">

**Author:** ![sjpadgett](https://community.open-emr.org/user_avatar/community.open-emr.org/sjpadgett/32/21623_2.png) [@sjpadgett](https://community.open-emr.org/u/sjpadgett)\
**Post date:** [March 21, 2025, 7:51pm UTC](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125/20 "2025-03-21T19:51:31Z")

</div>

Sounds like to me that somehow your MariaDB install is corrupted or your client and server binaries are different. An install from the MariaDB repo’s should provide the correct/working native server and client utilities.  
Where do the engine config’s come from?

[Next page](https://community.open-emr.org/t/how-to-backup-layout-based-form-lbf/25125.md?page=2)
