On Fri, 2003-10-17 at 20:16, Mike Bailey wrote: > I desperately need everyone's help. > > I normally build database driven websites on NT Servers with an MS Access database, > using perl 5 to read/write the database. > > Now I need to build a website that can handle a database with almost a gigabyte > worth of images to catalog (no it's not porn). > > Ideally I would like to use the same method BUT the only hosts i can find that will > offer that much disk space only use Unix and MySQL. > > I, However, have never used MySQL. I have used sql statements in the perl script to > read/write the MS Access database, but i have never used MySQL. > > I need someone to tell me would I have to buy some software to build a MySQL > database? > Is there a free download that i can use to build the database? > Where would I find it to download/purchase it?
MySQL is GPL'd software. It's free. You can purchase a license if you need a warranty, support or if you want to distribute the software as part of a non-GPL'd package. You can download either a Linux or Windows version from www.mysql.com. > Is there an easy example of what statements I could use from a perl script to add, > delete and read a single entry or a whole range of entries from the database? I assume you're using DBI in your Perl scripts. (I wasn't aware that Access had an SQL server engine. I thought you had to use SQLServer for that.) MySQL and Perl should work essentially the same as Access and Perl. Just use a MySQL driver instead of an Access driver. There will likely be slight variations in the dialects of SQL spoken by the two databases, of course, but it shouldn't be anything too difficult to sort out. There's also a mailing list for Perl and MySQL if you run into problems. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
