Publishing MySQL Database to Production Server

[nexgen]

I publish my wappler app via ftp. Does it also sync the mysql database structure?

It looks like it’s not syncing the mysql database structure.

[Sorry_Duh]

To get the structure you want to right click the word changes when the target is on production and select apply latest changes.

[nexgen]

I have set the database host as “localhost” since after publish the mysql database will be on the same host as where the app files will be.

For changes I’m getting the error below.

[George]

You have to edit the two database connections in two places in Wappler. One in the database manager for Wappler to remotely connect to your database ( use full remote server ip/host there) and one in server connect globals for what runs on your server there you can use localhost.

See also:

What is the difference between DB Connection in DB Manager and DB Connection in Target Database section?

The Database Connection in server connect points to exact the same database as the connection in the database manager. The only different is that the one in server connect is used - server side, so on your server, while the one in the database manager is a direct remote connection. But they do point to the same thing. Both use the same name - just can have different settings depending on the access rights. Each target has its own database settings. Still under the same database name - but you…

[nexgen]

@George

and one in server connect globals for what runs on your server there you can use localhost.

When I change anything like server address, port etc… in any target it gets changed in both targets. How to fix that?

[George]

No you have to change it per target.

[nexgen]

I changed it per target. Please see what I have done wrong:

[brad]

After changing the host/details, close the file. Then change targets and reopen it.

[nexgen]

Thank you. It worked this way.