# MySQL schema not synchronized **URL:** \ **Category:** Ask for Help\ **Created:** [September 25, 2024, 9:20am UTC](https://community.glideapps.com/t/mysql-schema-not-synchronized/76610 "2024-09-25T09:20:32Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Julian\_Manrique](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/julian_manrique/32/80039_2.png) [@Julian\_Manrique](https://community.glideapps.com/u/Julian_Manrique)\ **Post date:** [September 25, 2024, 9:20am UTC](https://community.glideapps.com/t/mysql-schema-not-synchronized/76610/1 "2024-09-25T09:20:32Z")
Right now I’m using MySQL as one of the main data sources for my glide app. I want to delete some columns that are not useful to me anymore. However, when I delete them I get errors in Glide saying that the data cannot be loaded because X column cannot be found. Note that I’m not using custom queries to load this data, so I wasn’t expecting this problem since I thought Glide would basically perform “SELECT \* FROM TABLE” statements. But apparently it doesn’t. In order for my app to work again, I had to add the columns back, or create new columns with those exact same names. In the [docs](https://www.glideapps.com/docs/mysql), it says there should be a “Sync Table Schema” button at the top right corner, however, I can’t find it anywhere. What can I do? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/5/25e2c59058a4aa040356334dad43576b78f79501.jpeg) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 25, 2024, 11:49pm UTC](https://community.glideapps.com/t/mysql-schema-not-synchronized/76610/2 "2024-09-25T23:49:39Z")
Is your sync “read & write” or “read only”? I wonder if it makes a difference. Otherwise @DarrenHumphries might be able to comment more here. ---
**Author:** ![DarrenHumphries](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darrenhumphries/32/91715_2.png) [@DarrenHumphries](https://community.glideapps.com/u/DarrenHumphries)\ **Post date:** [September 26, 2024, 12:47am UTC](https://community.glideapps.com/t/mysql-schema-not-synchronized/76610/3 "2024-09-26T00:47:26Z")
To reload your table you’ll see that there is a reload symbol just to the right of the table name at the top middle. Try that and see. ---
**Author:** ![Julian\_Manrique](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/julian_manrique/32/80039_2.png) [@Julian\_Manrique](https://community.glideapps.com/u/Julian_Manrique)\ **Post date:** [September 26, 2024, 8:42am UTC](https://community.glideapps.com/t/mysql-schema-not-synchronized/76610/4 "2024-09-26T08:42:35Z")
@DarrenHumphries I had tried that before, but it gives me the same error: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/5/45b945678eb8e41716c82b2dde67081de219fd76.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/1/01a1a48c54181c1dc4b357eb2de5efeb5223c665.jpeg) It looks like it refreshes records, but not the schema? It works if I add a column with the exact name back: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/a/cab2e4de63c176bba54faeb92ae8658c40cf16e2.png) ---
**Author:** ![Julian\_Manrique](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/julian_manrique/32/80039_2.png) [@Julian\_Manrique](https://community.glideapps.com/u/Julian_Manrique)\ **Post date:** [September 26, 2024, 8:45am UTC](https://community.glideapps.com/t/mysql-schema-not-synchronized/76610/5 "2024-09-26T08:45:48Z")
Should be read & write, since I’m pulling the entire table, instead of doing a custom query and am able to add new rows from in-app forms. ---
**Author:** ![DarrenHumphries](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darrenhumphries/32/91715_2.png) [@DarrenHumphries](https://community.glideapps.com/u/DarrenHumphries)\ **Post date:** [September 26, 2024, 1:38pm UTC](https://community.glideapps.com/t/mysql-schema-not-synchronized/76610/6 "2024-09-26T13:38:35Z")
This looks like something you should let support know about. I’m using Postgres and when I add a column in SQL and hit the reload the column shows up. If I then delete the column in SQL and hit reload it just disappears. Could be there is a problem with this if you are using MySQL. Worth reporting.