Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

Uploading Mysql files to a server

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

    Uploading Mysql files to a server

    OS win xp
    I have created a MySQL connection and have MySQL data tables working.

    I am wondering how I will upload the MySQL database to a remote server.
    I think I have located the tables in (localhost)
    C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data\mytables
    I am not sure if these are the tables.
    They have a .FRM extension

    I am using a windows 2003 on the remote server.
    Can any one say where I upload these files to, on the remote server if they are indeed the tables?
    Many thanks
    John

    #2
    Re: Uploading Mysql files to a server

    I presume you did everything in development with a named connection string.

    In that case, you can put your database files wherever you want on your server. When you publish your files from development to server, adjust your published named connection string to point to the correct location.
    -Steve
    sigpic

    Comment


      #3
      Re: Uploading Mysql files to a server

      Thanks for the info Steve, am I guessing right that the MySQL tables have a .FRM file extension.

      I tried to create a MySQL connection on my developer machine to allow easy access to the tables
      D:\_MyData Port 3306 but could not.

      As I have a my server here I want to load the data files by copying on to the server and cant see how this can be carried out. I can copy the files from my A5Webroot OK but cant see how to Link to the MySQL data tables.

      Comment


        #4
        Re: Uploading Mysql files to a server

        Steve,

        I have been trying to figure this out too. I've just spent some time searching the wiki help site (looking for "sql publish" and other keywords) with no luck. So I came here and was glad to find this topic being dealt with.

        When you say, "adjust your published named connection string to point to the correct location."...

        ...is this an option on the Publish dialogue process? There are many options in this dialogue/genie but if there is documentation that explains how it all works I'd like to get my hands on it (e.g. when to precede a path with 'c:/...' and should it be '/' or '\' etc.). :-)

        Thanks,
        Vaughn

        Comment


          #5
          Re: Uploading Mysql files to a server

          I bought a product named NaviCat for MySQL. In that product I create a connection to my local db, and the remote server's db. Then to transfer either direction, I bring up the 'data synch' utility, highlight which tables I want to sync, and which direction, and it does it.
          Steve Wood
          See my profile on IADN

          Comment


            #6
            Re: Uploading Mysql files to a server

            Thats interesting Steve, I also have purchased Navicat which seems to have many answers although I havent yet cracked remote publishing. I wonder whether this would be a suitable subject for this weeks "Steve Woods Webinar"

            Comment


              #7
              Re: Uploading Mysql files to a server

              John,

              Yes Steve is correct and Navicat is the way to go.
              You could also do a backup and a restore feature too.
              Nicholas Wieland
              LedgerSuite.com Corp
              [email protected]
              http://www.ledgersuite.com

              Comment


                #8
                Re: Uploading Mysql files to a server

                Thank you Nicholas for your thoughts,

                The Data Transfer looks excellent but I cannot think what to place in the Target connection box.

                I imagine the IP address goes in but what about the user, password and db file locations needed. Any ideas?

                I am attaching a pic of the Data Transfer box

                Comment


                  #9
                  Re: Uploading Mysql files to a server

                  You could also click on file and save it upload and then do the opposite on the server to bring in but that is the same as backup/restore.

                  I need to investigate how those settings work too. Maybe Pat B can chime in here or someone else that is using Navicat.......
                  Nicholas Wieland
                  LedgerSuite.com Corp
                  [email protected]
                  http://www.ledgersuite.com

                  Comment


                    #10
                    Re: Uploading Mysql files to a server

                    John,

                    For the Target, you install NaviCat also on your server and create a connection to that mysql server, just like your local one. After some permissions work, that remote server can be included on your local NaviCat as a 'remote' database. Then you can sync between them.
                    As important as data sync is the structure sync, in fact you need to run this first to ensure your remote server tables have the same structure before sync'ing the data.

                    Its a good topic for Friday discussion, but I am too behind on projects to work something up specific. And I never record the Friday sessions because they are purposely kept in loose format.

                    Watch for an IADN video coming up here soon where one of our members did show how to use NaviCat in the course of their presentation.
                    Steve Wood
                    See my profile on IADN

                    Comment


                      #11
                      Re: Uploading Mysql files to a server

                      Many thanks Steve for the excellent explanation you give for Data Transfer in Navicat. I am obvious getting something wrong as I get the error
                      I get an error message Invalid connection type.

                      On my server (windows2003) I installed Navicat and Created a connection
                      XXX_DellServer.
                      I created a database xxxtest.
                      On my Developer Machine I created a Data Transfer

                      Source connection to use an existing table set.

                      I set a Target Connection
                      http://xx.yyy.137.53/XXX_DellServer with a DataBase xxxtest

                      I get an error message Invalid connection type.

                      I notice your remark
                      After some permissions work,
                      and wonder if you could give any clues on this.


                      Will look out for the video from IADN http://forum.alphadevnet.com/
                      Regards
                      John

                      Comment


                        #12
                        Re: Uploading Mysql files to a server

                        John,i'm not sure if you understand MySql correctly, or maybe its me lol...but..its a database server,so you can have multiple databases in one server..so you cant just copy files or tables..you just have to transfer the data itself. I just use dbf tables first,design all the tables and then export...very easy.

                        Comment


                          #13
                          Re: Uploading Mysql files to a server

                          Thanks Jukka
                          I expect I do not understand MySQL very well, but learning.

                          The problem I have with dbf tables is that they are all created in in the control panel and then published locally to say A5Webroot_V10 into the correct folder. There they can be uploaded to the server.

                          However if updating has already been carried out on the server ie the domain, it seems uploading from A5Webroot_V10/myfolder/ will also over write the server domain updating.
                          I hope thats clear enough to understand.
                          There must be a way around this but at the moment I dont see it.
                          Cheers
                          John

                          Comment


                            #14
                            Re: Uploading Mysql files to a server

                            You can export a dbf file and the contents of it to MySql...thats what i do. First creating it as a dbf, and then export. And if you need to restructure your remote MySql table,you can use tools like MySql workbench,which is free btw. Or you can import it as dbf..restructure and export again.

                            Comment


                              #15
                              Re: Uploading Mysql files to a server

                              Once you get familiar with NaviCat and the data or structure synch, you won't want to us DBF for anything. You'd have to write an xbasic script for each table to sync the structure, and not overwrite your data. After awhile, you cannot use the DBF to do any back and forth conversion because your sql database will have stored procedures, triggers, etc. that do not translate to the DBF world.

                              In early stages, after I make changes to my local sql database, I run the structure sync, then data sync with the remote database. Later, when my application is live and I cannot overwrite the online data, I use only the structure sync to update the remote database to the current structure but NOT overwrite the data.

                              John - yes, read the instructions on how to set permissions on the remote server for your navicat connection. You can set it to allow anyone who knows the username and password, or from a specific IP address.
                              Steve Wood
                              See my profile on IADN

                              Comment

                              Working...
                              X