LiveCode Forums.

Hello

So I understand that SQLite is a localized within the application in writing. How do I switch to MySQL, as the application will need to connect to a server? How do I set this stuff up, I have no idear how to. Currently, I have a server rack running Ubuntu Linux distro 16.04. How do I switch from SQLite to MySQL?

I believe this is the article your looking for https://support.rackspace.com/how-to/in ... on-ubuntu/

I believe this is the article your looking for https://support.rackspace.com/how-to/in ... on-ubuntu/

Is it? Can't find a section on how to port a DB from SQLite to MySQL.

I am sorry, perhaps I wasn't clear enough in my answer. The link was in reference to your original post questions

lupacexi wrote: ↑

Thu Mar 15, 2018 7:39 pm

How do I switch to MySQL, as the application will need to connect to a server? How do I set this stuff up, I have no idear how to. Currently, I have a server rack running Ubuntu Linux distro 16.04...

The article tells you how to setup mysql on your distro, and the link at the bottom tells you how to configure it when finished.

As to how you would move a complete local sqlite db to a completely remote server sql db, I would think you'd have to read the sqlite db into either memory or the program, reading it into a simple table control would be the easiest to make sure it is formatted correctly, and then save it out as mysql. You would have to form the connections to both dbs to do that, connect to the sqlite first, read it in, connect to the mysql, write it out.

In Lc, if the db doesn't exist, it will be created at the location your saving out to, so that part of it isn't too much of a problem on the mysql side.

For specific instructions on working with different dbs (creating/updating/etc) you can go to this page and scroll down to 'Databases', Max's entries are usually a bit more complete than the standard dictionary, and the different databases Lc can work with are listed.