Uploading DB Schema

wizcom · Post by **wizcom** » Wed Apr 24, 2024 4:05 am

We had a server with a phpmaker project on it running go to server heaven. OK, restore backup. Nope because the backup was only backing up WordPress stuff (yes I know, shoulda verified it). Therefore there is no database. BUT, I have a local copy in phpmaker that is perfect (yes missing data, but better than nothing). I've tried synching - wipes out my local with the newly create empty db on the new server. Tried autosycnching - same. Is there a way to do what I'm trying to do - take the local schema and put it on the server in that form?

Thank you in advance

Howard

arbei · Post by **arbei** » Wed Apr 24, 2024 9:33 am

If you meant you tried to use the old scripts, make sure the connection info is the same as the old project. You better check the connection info in the old code. If your project was generated from recent versions, you may find the connection info in src/config.*.php. If you had Database_Connecting server event, you may find it in src/userfn.php.

wizcom · Post by **wizcom** » Thu Apr 25, 2024 7:57 am

Not quite. I am not using the old scripts. It's just that the database on the server was never backed up so there is no database on the new server. But, in PHPMaker (locally) I have the complete, correct database. I need to export it from PHPMaker to anything local. Then I can Upload it. The problem is that I cannot find any option to export the database in PHPMaker.

arbei · Post by **arbei** » Fri Apr 26, 2024 9:10 am

No, although the project contains basic information about the database schema (such as table/field names and data types), it cannot re-create the database.