Announcement

Collapse
No announcement yet.

Database

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    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.
    The GuiGuy
    ... from Down Under

    Comment


    • #3
      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

      Comment


      • #4
        Re: Database

        [quote author=marfam link=topic=4032.msg9406#msg9406 date=1299587327]
        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
        [/quote]

        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.


        The GuiGuy
        ... from Down Under

        Comment

        Working...
        X