Database

Hi
I am new to Scriptcase and would like to set up a shopping cart. From the online Shopping cart example in Scriptcase which runs fine in my windows development server,how would I transfer the database tables or database to a Mysql database to get the application to work on a different server once deployed.

Thanks for any help
Peter

Re: Database

Create an export script from your database. Then, on your remote server, import and run that script. If you’re using a virtual host PHPAdmin is probably installed and will let you do that.

Excellent tools to help you are available here:

http://wb.mysql.com/

They are essentially free for you to use.

Re: Database

Many thanks GuiGuy
I will try this. Just one more question, Would you know in which directory the Sqlite database and table files are stored for the online shop example in scriptcase
thanks again
Peter

Re: Database

Not sure. I haven’t used sqlite. But on a Linux box I’d expect it in /var/lib/sqlite or something similar.

I had a quick look in the documentation, but as with most opensource and some “pro” software you’ll need to study for a Diploma in Obfuscation. Sorry, it’s a pet peeve; the appalling documentation that accompanies most software these days. What i’m saying is my head started to spin so I gave up.