I have a web app built using Laravel and MySQL. It's currently running on my www.domain.com
I would like to know how to "duplicate" the web app to a subdomain with a separated database?
The web app has login and signup features. There's also email notification sent to clients if they sign up, make changes, etc.
The reason I'm doing this is because I have two types of clients, local and overseas clients. Therefore I have to separate them since they use different currencies and languages. So, when my team login to the subdomain, they'll know they have to speak in our local language, but when they login to the www.domain.com, they'll know they have to speak English.
Thanks very much, will appreciate any help
UPDATE The database has been successfully copied to a new database, however the sign up and login pages of the subdomain are linked to the main domain.
You could look up https://hyn.readme.io which does pretty much exactly what you want. It lets you setup new tenants which are assigned a subdomain and creates a separate database while at the same time sharing your actual application between them all.
If needed you can add tenant-specific overrides of the default apps views and whatnot by adding them to the tenants own folders.
According to your comment earlier, you are getting error in phpMyAdmin when trying to upload database. Why not just copy the database in phpMyAdmin? Go to database you want click on Operations then under Copy Database type name of new database and select copy structure and data. That should solve your issue.