Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 12 of 12
  1. #1
    Regular Coder Kevin_M_Schafer's Avatar
    Join Date
    Apr 2011
    Location
    Fairfax, Minnesota, U.S.A.
    Posts
    482
    Thanks
    97
    Thanked 17 Times in 17 Posts

    What program should I use to upload my database?

    I'm new to MySQL.

    I'm ready to upload my database to my host server. The table exists, I just need to upload the content into it from a Microsoft Access document.

    The table is already made because I used a 30-day trial software program, and that trial just ran out about a week ago. I tried to purchase the full version today, but the process got hung up on the security code question for my debit card. If they don't want my money, I don't need their software.

    I can also obtain a MySQL Dump or CVS File versions of my database.

    Can someone recommend which application to use, and which version of my database to use (MS Access, MySQL Dump, or CSV File).

    Is there anything similar to Filezilla that can do this?

    Any help will be appreciated.

    --Kevin

    .
    Last edited by Kevin_M_Schafer; 01-01-2012 at 12:01 AM. Reason: text
    My keyboard is an IBM from 1993 and I like it that way. | Who is Dan Well? Everyone always says I know Dan Well.Building a web page is like building a birdhouse. Put it up there and watch 'em come. | Maintaining the aspect ratio of an image is more important than having a cold orange pop.

  • #2
    Regular Coder Kevin_M_Schafer's Avatar
    Join Date
    Apr 2011
    Location
    Fairfax, Minnesota, U.S.A.
    Posts
    482
    Thanks
    97
    Thanked 17 Times in 17 Posts
    I was able to find a program that allowed me to upload my database.
    My keyboard is an IBM from 1993 and I like it that way. | Who is Dan Well? Everyone always says I know Dan Well.Building a web page is like building a birdhouse. Put it up there and watch 'em come. | Maintaining the aspect ratio of an image is more important than having a cold orange pop.

  • #3
    Senior Coder
    Join Date
    Jan 2011
    Location
    Missouri
    Posts
    4,691
    Thanks
    25
    Thanked 657 Times in 656 Posts
    Kevin what's the name of the program?

  • #4
    Regular Coder Kevin_M_Schafer's Avatar
    Join Date
    Apr 2011
    Location
    Fairfax, Minnesota, U.S.A.
    Posts
    482
    Thanks
    97
    Thanked 17 Times in 17 Posts
    Hi sunfighter,

    Thank you for replying. I appreciate it. After I tried to purchase dbForge Studio for MySQL, which I really liked, I found DreamCoder for MySQL Enterprise Freeware 6.0 Build(6.0.2.0).

    I have 155,000 lines to my database (MS Access), and it took almost five hours to upload. I think I realized after I took this route that I could have just uploaded my database using cpanel. It would have still taken a long time, but I probably wouldn't have had to use a stand alone program. I didn't know that at the time, but I found a youtube tutorial and that's where I figured it out.

    I have a member login database, but the company I purchased it from uploaded it for me. This past month or so is my first attempt at uploading a database by myself.

    I now have a problem with using my web page search. When in cpanel, I can search for any word in the database (English dictionary) and it produces results. Many words have several definitions, and they all appear. The only thing is, I think I need to configure this somehow, because my webpage search hardly produces any results at all. It did in the testing stage, but that was with only 45 lines or so in the database.

    I use Firefox, Opera, and Chrome to view my page. I have IE issues that need to be ironed out a little farther down the road.

    http://www.theeagleextra.com/wordic/wordic.php

    If you have any idea what I should do to tweak my cpanel to make my search work properly, I would appreciate it. I can type in "barn" and I get results, but the word "ten" produces nothing.

    Happy New Year everyone!

    Thanks again.


    --Kevin

    -
    Last edited by Kevin_M_Schafer; 01-01-2012 at 06:13 PM. Reason: text
    My keyboard is an IBM from 1993 and I like it that way. | Who is Dan Well? Everyone always says I know Dan Well.Building a web page is like building a birdhouse. Put it up there and watch 'em come. | Maintaining the aspect ratio of an image is more important than having a cold orange pop.

  • #5
    Supreme Master coder! _Aerospace_Eng_'s Avatar
    Join Date
    Dec 2004
    Location
    In a place far, far away...
    Posts
    19,291
    Thanks
    2
    Thanked 1,043 Times in 1,019 Posts
    This has nothing to do with cpanel. It is all going to come down to what query you are running when you do the search. It will most likely involve you posting your php for wordic.php (processing part that is, either the non-ajax one or the ajax one).
    ||||If you are getting paid to do a job, don't ask for help on it!||||

  • #6
    Regular Coder Kevin_M_Schafer's Avatar
    Join Date
    Apr 2011
    Location
    Fairfax, Minnesota, U.S.A.
    Posts
    482
    Thanks
    97
    Thanked 17 Times in 17 Posts
    Hello Aerospace Eng,

    Thanks for the post. I apologize for not replying right away but I was out buying softener salt and groceries.

    Attached please find the wordic.txt file (you must rename to wordic.php) and search.txt (you must rename to search.php).

    The style sheet should come along for the ride, as I've used a full url address to call it.

    If you need my username and password and database name and such, just send me a PM and I can send it to you.

    Is it okay that I attached the code? I thought it would be better than creating such a long code window.

    Thank you for taking the time to help. I'm learning fast, just not fast enough for what I'm taking on as a project.


    --Kevin

    .
    Attached Files Attached Files
    My keyboard is an IBM from 1993 and I like it that way. | Who is Dan Well? Everyone always says I know Dan Well.Building a web page is like building a birdhouse. Put it up there and watch 'em come. | Maintaining the aspect ratio of an image is more important than having a cold orange pop.

  • #7
    Supreme Master coder! _Aerospace_Eng_'s Avatar
    Join Date
    Dec 2004
    Location
    In a place far, far away...
    Posts
    19,291
    Thanks
    2
    Thanked 1,043 Times in 1,019 Posts
    Do you have the word ten in your database or any other word with ten in it? Have you tried running this query using phpmyadmin from your control panel?
    PHP Code:
    select from wordic where Word like '%ten%' 
    Do you get any results?
    ||||If you are getting paid to do a job, don't ask for help on it!||||

  • #8
    Regular Coder Kevin_M_Schafer's Avatar
    Join Date
    Apr 2011
    Location
    Fairfax, Minnesota, U.S.A.
    Posts
    482
    Thanks
    97
    Thanked 17 Times in 17 Posts
    Yes, I used phpmyadmin for search. Any word you can think of in the English language has been uploaded -- with their definitions. The search from phpmyadmin works perfectly, but the web page search doesn't.

    Here's a screen shot for the search of "ten." There are three results -- with definitions.



    .
    Last edited by Kevin_M_Schafer; 01-01-2012 at 09:22 PM. Reason: text
    My keyboard is an IBM from 1993 and I like it that way. | Who is Dan Well? Everyone always says I know Dan Well.Building a web page is like building a birdhouse. Put it up there and watch 'em come. | Maintaining the aspect ratio of an image is more important than having a cold orange pop.

  • #9
    Regular Coder Kevin_M_Schafer's Avatar
    Join Date
    Apr 2011
    Location
    Fairfax, Minnesota, U.S.A.
    Posts
    482
    Thanks
    97
    Thanked 17 Times in 17 Posts
    Here's a screen shot of the structure.



    .
    My keyboard is an IBM from 1993 and I like it that way. | Who is Dan Well? Everyone always says I know Dan Well.Building a web page is like building a birdhouse. Put it up there and watch 'em come. | Maintaining the aspect ratio of an image is more important than having a cold orange pop.

  • #10
    Supreme Master coder! _Aerospace_Eng_'s Avatar
    Join Date
    Dec 2004
    Location
    In a place far, far away...
    Posts
    19,291
    Thanks
    2
    Thanked 1,043 Times in 1,019 Posts
    But there is a difference between
    select * from wordic where Word like '%$term%' and select * from wordic where Word like '$term'

    Have you tried the first one?
    ||||If you are getting paid to do a job, don't ask for help on it!||||

  • Users who have thanked _Aerospace_Eng_ for this post:

    Kevin_M_Schafer (01-01-2012)

  • #11
    Regular Coder Kevin_M_Schafer's Avatar
    Join Date
    Apr 2011
    Location
    Fairfax, Minnesota, U.S.A.
    Posts
    482
    Thanks
    97
    Thanked 17 Times in 17 Posts
    Okay, no, I haven't tried the first one. I'll do that now.


    --Kevin

    .
    My keyboard is an IBM from 1993 and I like it that way. | Who is Dan Well? Everyone always says I know Dan Well.Building a web page is like building a birdhouse. Put it up there and watch 'em come. | Maintaining the aspect ratio of an image is more important than having a cold orange pop.

  • #12
    Regular Coder Kevin_M_Schafer's Avatar
    Join Date
    Apr 2011
    Location
    Fairfax, Minnesota, U.S.A.
    Posts
    482
    Thanks
    97
    Thanked 17 Times in 17 Posts
    Aerospace Eng,

    That did it! You're great.

    Here's what I did, I took out the two percent signs (one on each side of $term):
    Code:
    $sql = mysql_query ("select * from wordic where Word like '$term'");
    I can search for any word imaginable -- until it doesn't produce any results. Then I go to PHPMyAdmin and search there, and then find out the web page search is correct -- the word "storm" isn't even in the database. Neither is "envision" or "bobcat."

    With 155,500 entries-- and more to go -- I guess Wordic is definitely a work in progress. Who knew there were so many words? I remember still selling typewriters in 1995, and a big promo sticker on the front of one of the boxes said "With built-in 75,000 word spell-check!"

    I have my work cut out for me.

    Thanks a ton. I really appreciate your time.


    --Kevin

    .
    My keyboard is an IBM from 1993 and I like it that way. | Who is Dan Well? Everyone always says I know Dan Well.Building a web page is like building a birdhouse. Put it up there and watch 'em come. | Maintaining the aspect ratio of an image is more important than having a cold orange pop.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •