Re: How to convert Acess 2007 ACCDB file to MySQL?

2008-12-29 Thread Dan Nelson
In the last episode (Dec 29), mos said: > Someone has given me an Access 2007 file *.ACCDB and I don't have Access > 2007. Is there a (preferably free) way to convert it to CSV or MySQL? Try the ODBC driver downloadable at "2007 Office System Driver: Data Connectivity Components" http://www.mic

How to convert Acess 2007 ACCDB file to MySQL?

2008-12-29 Thread mos
Someone has given me an Access 2007 file *.ACCDB and I don't have Access 2007. Is there a (preferably free) way to convert it to CSV or MySQL? Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.or

Re: about mysql_ping() function

2008-12-29 Thread Warren Young
raid fifa wrote: Is this a bug of mysql_ping() ? or any other advice? Probably not. I think you'll find that it *does* time out, just after a longer period than you'd prefer. Timeouts of 30, 60 and 120 seconds are common in network code, because it's not possible to reliably determine tha

about mysql_ping() function

2008-12-29 Thread raid fifa
Hi guys, I used mysql_ping() function in my program. But when I unplug the network wire between client and MySQL server, my program has no response as mysql_ping() can not return value and hanged there. Is this a bug of mysql_ping() ? or any other advice? thanks!!! *^_^* _

Re: What files to install for Windows

2008-12-29 Thread Manish Sinha
Octavian Rasnita wrote: Is it legal to build the MySQL installer with a program I make? Thanks. Octavian Legal Issues? I think in such a case you have provide the source code too as per GPL. Wait for experts in this field -- Manish Sinha Personal Blog: http://www.manishsinha.info Tech Blog:

Re: how to design book db

2008-12-29 Thread mos
At 08:17 AM 12/29/2008, you wrote: I am rather fresh to MySQL and am trying to fix and update a website - modifying from just plain html to css, php and MySQL. I'm working on FreeBSD 7.0, MySQL 5.1,30, PHP5.28 & Apache 2.2.11. I need figure out how to set up (design) a database of books which ge

Tips for optimizing stored procedures

2008-12-29 Thread Vikram Vaswani
Hi all I am new to stored procedures and have just started using them. Is there any Web site you could suggest which discusses common optimization tips for MySQL SPs? Vikram -- Operator: "So what do you need? Besides a miracle." Neo: "Guns. Lots of guns." -- The Matrix -- MySQL General M

RE: What files to install for Windows

2008-12-29 Thread Martin Gainty
Jerry is correct you are better off using the pre-packaged installer from the MySQL distro for the most part you are downloading (binaries) from some site creating a MYSQL_HOME environment variable to point to home folder for MySQL unzipping/uncompressing the distro to the MYSQL_HOME folder make

RE: What files to install for Windows

2008-12-29 Thread Jerry Schwartz
I'm late to the game, but many Windows installers run the actual installer for required applications. Have your application's installer run the normal installation package for MySQL. That's all I can give you, my knowledge of installers is too old to be of real use. Regards,   Jerry Schwartz The

how to design book db

2008-12-29 Thread PJ
I am rather fresh to MySQL and am trying to fix and update a website - modifying from just plain html to css, php and MySQL. I'm working on FreeBSD 7.0, MySQL 5.1,30, PHP5.28 & Apache 2.2.11. I need figure out how to set up (design) a database of books which gets rather complicated since I must