question for research (OT)
Hi! I saw Czech people posting here. Im doing research for a local computer magazine and I'm looking for online fees in Czech Republic. The article deals with chances for international companies after Czech EU accedence. Nothing to find in Google database. Could you please feed me some data or point me to (english/german language) websites? I'm looking for providers, costs per minute, flat rates, leased lines, technical differences (modem, isdn, xdsl, powerline, cable) etc. Plz answer to my private mail address. Thanx in advance and sorry for any inconvenience by this post. Your help is highly appreciated! sql query STIBS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to port MS Access to MySQL ??
Yep, ODBC works great. Make a connection from Access to MySQL and mirror the access db into MySQL. STIBS myodbc works fairly OK for me. On Fri, 2002-11-08 at 14:17, tmb wrote: Is there a tool for doing a quick port from MS Access to MySQL? Or must you manually create all the tables sql statements in MySQL and then export the MS Access data to a comma delimited file... then import it into MySQL? Thanks for any help - tmb __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: perl dbi and mysql question
No clue of dbi/dbd but the query SHOW DATABASES does what it tells. STIBS - Original Message - From: Shon Stephens [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 08, 2002 3:44 PM Subject: perl dbi and mysql question i am using perl dbi with dbd::mysql. i know that using the dbi function, $dbh-tables (), will list all the tables in a database. is there a function that will show all the databases on a server? thanks, shon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access replacement...
I had my own little investigation in this topic and found the following: A programming environment; A report builder Kugar is a good choice for building reports and as a programming environment ala VB. I is programmable via Python. It's not Open Source but relatively cheap: http://www.thekompany.com A more BASICalike Environment would be gambas but Benoit (the developer) has no database component up yet. http://gambas.sourceforge.net He's busy with acting school atm. To the rest: Guys, anyone up for writing something? I have no clue of C A database maintenance utility; MyCC from mysql.com isn't a bad choice and it is cross platform A database query tool; can't help you here, I ike SQL in ASCII mode STIBS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access replacement...
ooopps! ähm sorry... yes, Rekall, not Kugar! STIBS - Original Message - From: Daniel Kasak [EMAIL PROTECTED] To: Brad [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 3:47 AM Subject: Re: Access replacement... Brad wrote: I am thinking of a move from a Windows network to Red Hat Linux at my work. I am happy with OpenOffice for spreadsheets, word processing etc but the main problem is replacing MSAccess. MySQL provides a replacement for the database component but that still leaves: A programming environment; A database maintenance utility; A database query tool; A report builder Some of our users have had MSAccess training and are quite proficient in producing simple but usable applications involving: The creation of a database and tables; Forms to populate the database; Queries and reports to display the data. All this in a graphical interface without needing to know SQL or doing any serious programming. They would need to be able to continue doing this in the new Linux environment - is there a suitable Forms utility? We also have some serious applications written in MSAccess by outside professional programmers. This was partly done to allow the simpler changes (eg reports and screen layouts) to be made by the advanced users in order to reduce costs and delays. I would assume that a Forms utility would not provide enough features to be used here. Does this mean that development has to be done in the opensource equivalent of VB which may shut out the advanced users from making changes? Regards, Brad We can both search together then :) I bought Kylix 1 and was extremely disappointed with it. Don't bother with that one... I considered using VB under wine but that isn't really a 'pure' solution that I can be proud of. I'm now looking into using Python. I installed boa-constructer (a Python IDE) last night. It looks interesting, but I don't think it's really geared towards database type stuff. I am also considering buying Rekall by TheKompany: http://www.thekompany.com/products/rekall/ It combines Python and database aware stuff, but the currently only support very old MySQL client libraries and I haven't been able to get a demo version working on my box, so I'm not really sure. TheKompany have some interesting stuff though... Anyone got anything to add to this? -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: First time MySQL user needs help using/understanding mysqlimport
With a similar case I had my problems because the exported database records from Sage KHK, a german biz management software, had and other special chars in it that made it not possible to run a proper import from a CSV file and manual cleaning with 35.000 records was out of question ;o) I did the following: exported an Access db from KHK, Opened it in M$ Access, made an ODBC connection to MySQL and exported the tables to the MySQL db. Some lines SQL and I got rid of duplicates, etc. Does Filemaker has the feature to connect to an ODBC source and if yes to export tables there? I have no clue with Mac's. STIBS At 17:28 -0400 10/19/02, Paul Melia wrote: Hello, I am newbie to MySQL and I having some problems transferring my existing data to MySQL. Could someone tell me what I am doing wrong? I started by exporting certain fields from Filemaker 5.5 to a comma-separated .txt file. I then opened the file in BBedit, deleted duplicates and made other adjustments (like sorting the output properly) and then saved the file (with unix line breaks). I then opened a Terminal on a my Mac running OS 10.2.1 and issued the following command: mysqlimport -v omomain /Users/paul/Desktop/omostuff/csv_files/aproducer.txt This is what I got in return: Connecting to localhost Selecting database omomain Loading data from SERVER file: /Users/paul/Desktop/omostuff/csv_files/aproducer.txt into aproducer mysqlimport: Error: Can't get stat of '/Users/paul/Desktop/omostuff/csv_files/aproducer.txt' (Errcode: 13), when using table: aproducer I have tried other permutations that I have found at listsearch.com and at mysql.com and but I keep encountering the Error: Can't get stat of '/Users/paul/Desktop/omostuff/csv_files/aproducer.txt' (Errcode: 13), when using table: aproducer % perror 13 Error code 13: Permission denied This means the server can't read the file. Most likely the permissions you have on it don't allow other users to read it, and the server probably runs as a different user than you. You can either make the file world readable, or use the --local option to have the client send the file to the server over the connection. I'm assuming the server is on the same machine; if it's not, only the --local approach will work. The table exists, the database exists, and the spelling is correct so I am stumped. All files, servers and the Terminal are on the same machine. (nothing is remote) The version of MySQL I am running is: 3.23.46 Any help is greatly appreciated! Thanks, Paul Melia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- - PLEASE NO HTML EMAILS! THANX ALOT SAYS MY KMAIL CLIENT. - Best Regards/ Freundliche Grüße Michael Stibane (STIBS) [EMAIL PROTECTED] Training, Linux, Admin, Programming, Web http://www.stibs.cc Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - Dresden - London http://www.escapade.org +++ GMX - Mail, Messaging more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: content design / database design help
Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Let me add a bit to this Relations will make sense for items like 'project notes' which would work something like. table 'notes' project_id | create_date | note | author my tabledesign would be note_id(primary) | project_id(foreign) | create_date | note | author in order to have a primary that not only one note for each project is possible. table 'project_contacts' project_id | name | company | address | phone | description same here, add a contact_id :o) ... Though I'd go with the first advise. There is a good solution I often use for construction companies: http://www.phprojekt.com. Veryvery complete! :o) -- - PLEASE NO HTML EMAILS! THANX ALOT SAYS MY KMAIL CLIENT. - Best Regards/ Freundliche Grüße Michael Stibane (STIBS) [EMAIL PROTECTED] Training, Linux, Admin, Programming, Web http://www.stibs.cc Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - Dresden - London http://www.escapade.org +++ GMX - Mail, Messaging more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen! -- - PLEASE NO HTML EMAILS! THANX ALOT SAYS MY KMAIL CLIENT. - Best Regards/ Freundliche Grüße Michael Stibane (STIBS) [EMAIL PROTECTED] Training, Linux, Admin, Programming, Web http://www.stibs.cc Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - Dresden - London http://www.escapade.org +++ GMX - Mail, Messaging more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php