01-01-2012, 12:00 AM
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.
01-01-2012, 07:18 AM
I was able to find a program that allowed me to upload my database.
01-01-2012, 05:45 PM
Kevin what's the name of the program?
01-01-2012, 06:08 PM
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(220.127.116.11).
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.
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! :)
01-01-2012, 06:52 PM
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).
01-01-2012, 08:34 PM
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.
01-01-2012, 08:43 PM
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?
select * from wordic where Word like '%ten%'
Do you get any results?
01-01-2012, 09:21 PM
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.
01-01-2012, 09:26 PM
Here's a screen shot of the structure.
01-01-2012, 11:06 PM
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?
01-01-2012, 11:15 PM
Okay, no, I haven't tried the first one. I'll do that now.
01-01-2012, 11:43 PM
That did it! You're great. :thumbsup:
Here's what I did, I took out the two percent signs (one on each side of $term):
$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. :)