|
| |
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
 |
MySQL with Frontpage - 9/20/2002 7:05:08
Hi,
I need a database that can store huge number of records. I learned that MySql can store data more than Access.
Is it possible to use MySql with frontpage the same Access is used. I mean can I put a MySql database in the web folder, then from Frontpage generate ASP pages with the same ease I use with access?
I don' t want to use MySql code, I just want the database used by Frontpage.
Best regards
Hisham
< Message edited by hhammash -- 9/19/2002 7:17:33 AM >
|
|
|
|
Long Island Lune
Posts: 2340
Joined: 6/8/2002
From: New York
Status: offline
|
RE: MySQL with Frontpage - 9/20/2002 13:28:24
Hisham,
I had the same problem. I went from Access to SQL Server 2000. MySQL is supposed to be great but I know little about it. Access to SQL Server 2000 is probably a better choice. The only problem is the price. BIG$$$.
SQL Server can handle huge databases, heavy site activity and heavy transaction processing. I' m in the midst of converting my biggest site from Access to SQL Server because it is getting hits and transactions far beyond what the owner thought it would ever get. 9,000 hits a day and 2000 transactions. Access can only handle so much. Plus Microsoft says that once a database gets larger than 10,000 records, you should jump to the MSDE or SQL Server.
LLL
_____________________________
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: MySQL with Frontpage - 9/20/2002 13:59:09
Hi LLL,
Thanks a lot.
I have SQL server 2000.
What do I have to do? Just create the database with the tables I need and that' s it?
I think frontpage connection should change right?
Any input will be appreciated.
Thanks
Hisham
| |
|
|
|
mack2313
Posts: 60
Joined: 9/11/2002
Status: offline
|
RE: MySQL with Frontpage - 9/20/2002 14:06:03
Yes if you want to change to sql then bring in the individual tables that are in access and create a database connection for each and when you want to use the data connection it will be in the drop down menu. I think it is easier then access but heck you know what they say about opinions...
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: MySQL with Frontpage - 9/20/2002 17:53:01
Hi,
Thanks mack.
I think I will need to move to SQL.
Which is better SQL 2000 or MySQL, in terms of storage and transactions handling?
Regards
Hisham
| |
|
|
|
Long Island Lune
Posts: 2340
Joined: 6/8/2002
From: New York
Status: offline
|
RE: MySQL with Frontpage - 9/20/2002 20:42:16
Hisham,
GO FOR IT... I' m only one step ahead of you. Transition has been relatively painless. I hope to never go back to Access again.
LLL
_____________________________
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: MySQL with Frontpage - 9/21/2002 8:17:57
Hi LLL,
What do I have to do?
1- Install SQL 2000 server
2- Create the database with the tables
3- Import the database to Frontpage
Are the above steps correct?
I have never used SQL before.
Regards
Hisham
| |
|
|
|
Long Island Lune
Posts: 2340
Joined: 6/8/2002
From: New York
Status: offline
|
RE: MySQL with Frontpage - 9/21/2002 11:56:36
Hisham,
Yes, that' s the basic routine. But I imported each table one at a time. I think that is the safer method. Just like mack2313 mentioned too. It' s the better way. If you import the entire database at once, things could be changed on import. Know what is happening to each table as they come in. Keep your eye on any autonumber fields too.
LLL
_____________________________
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: MySQL with Frontpage - 9/21/2002 12:47:19
Hi LLL,
So it is not like Access, a database with tables. You can import only the table to Frontpage.
What do you mean by keep and eye on the autonumber?
Regards
Hisham
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: MySQL with Frontpage - 9/21/2002 13:46:43
Hi,
Thanks friend.
Hisham
| |
|
|
|
s2bn1
Posts: 192
Joined: 2/2/2002
From: Dubai United Arab Emirates
Status: offline
|
RE: RE: MySQL with Frontpage - 9/23/2002 11:28:24
Hisham
Why you want to import all the tables to the web folder if you are going for sql.I think like access there is no need to import the tables to web folder.In the sql create the database.Using ODBC connection create the connection, (same as in access ,difference is here you are using sql driver instead of access driver) then go to FP and do as it is in access.
Good luck
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: MySQL with Frontpage - 9/24/2002 5:24:39
Thanks s2bn1,
Thank you for your nice reply.
In this case I have to create the database on the web server, right?
SQL2000 server has to be installed on the web server.
An Access DB can handle 2GB of data
What about SQL database? What is the capacity?
Regards
Hisham
| |
|
|
|
s2bn1
Posts: 192
Joined: 2/2/2002
From: Dubai United Arab Emirates
Status: offline
|
RE: RE: MySQL with Frontpage - 9/25/2002 11:16:56
Hisham
Sorry, for the delay.
It is not compulsory that the SQL server should be in your web server.It should be in any of your computers in the network.When you make the ODBC connection give the path ie all.
About the capacity I am not sure.But I am sure about one thing, SQL is more faster,reliable and can handle more datas than access.And also it makes less problems for the web.
Good luck
| |
|
|
|
Long Island Lune
Posts: 2340
Joined: 6/8/2002
From: New York
Status: offline
|
RE: MySQL with Frontpage - 9/25/2002 11:31:47
Hisham,
Yes, the database you create in SQL Server has to be uploaded to your host site. The same as Access. Unless your using it somewhere else (locally). Create the database like you normally do. Link it to FP. Then upload it.
_____________________________
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: MySQL with Frontpage - 9/25/2002 16:28:48
Hi LLL,
Thanks a lot.
LLL, do you remember in which post your taught me how to upload a picture to a folder and add the link to the database?
Best regards
Hisham
< Message edited by hhammash -- 9/24/2002 5:00:59 PM >
| |
|
|
|
Long Island Lune
Posts: 2340
Joined: 6/8/2002
From: New York
Status: offline
|
RE: MySQL with Frontpage - 9/25/2002 17:07:24
Hisham,
Yes my friend - here you go:
http://www.frontpagewebmaster.com/tm.asp?m=91145&p=2&tmode=1
The post title was: Text Database with DRW
Good Luck.
LLL
_____________________________
| |
|
|
|
hhammash
Posts: 1064
Joined: 8/19/2002
Status: offline
|
RE: MySQL with Frontpage - 9/25/2002 17:51:34
Hi,
Thank you LLL for you quick response.
I forgot to subscribe to the post which is very important to me. This is why I asked.
Thanks again friend
Regards
Hisham
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
I just happened to be in the forum when you posted the question. I visit here about 3 times a day. Anyway, I hope you try the script. This script has been in use a long time on my busiest site and literally 1000' s of photos have been uploaded (all graphic types: .bmp, .gif. .jpeg/jpg, .art) with NO problems to report. If a question comes up send me a post. 