Re: Export from Access
I recently exported a large Access database to MySQL using MyODBC. It took me a while to figure out that MyODBC was the thing to try, but once I did tried it, it only took me a few minutes to do the export. I highly recommend that approach (MyODBC). -Eric Original Message From: Josh Trutwin [EMAIL PROTECTED] To: mysql@lists.mysql.com Date: Tue, May-17-2005 10:19 AM Subject: Re: Export from Access On Tue, 17 May 2005 17:17:31 +0100 S.D.Price [EMAIL PROTECTED] wrote: Hi, can anyone explain how I would export a database created in Access to MySQL using PHPMyAdmin - I can't seem to import the data as csv or txt. Acess should allow exporting to CSV. Otherwise you can skip phpMyAdmin and just use ODBC - check out MyODBC on mysql.com. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: text retrieval functions
Alaios [EMAIL PROTECTED] added: Thx for your interest.. The type of my question is for learning what to choose. I would use what u suggest me.. The only information i can provide u is that i am running linux.. If u can suggest me the version of mysql and the appropriate function and after i will continue searching... I am searching if i can implement some functionality of an information retrieval system using mysql...Do u have any resources available? Alaios, MySQL is well suited for that sort of thing, but you'll have some homework to do. You need a programming language to build your information retrieval system in, and you would likely use that same language to access the data in your database. Potential languages are many and include C++, PHP, Perl, Python, etc., etc. I presume you intend to serve (as in server) your information to many people. If you would do this via a browser/the web (intranet or Internet) you might prefer a language like PHP over others, the point being you would want to decide this at the beginning of your project - how you will provide the data to people not sitting at your PC. MySQL has tons of capabilities and applications - its not just for the web - but web applications are an easy thing to gain some knowledge of. Suggestions: - Google terms like web MySQL tutorial or PHP MySQL tutorial and do some reading to get oriented - Buy a book like MySQL (Paul DuBois) or PHP and MySQL Web Development (Luke Wellington, Laura Thomson). If the price of a new edition is cost prohibitive, try picking up a used (good' or new) condition book via Amazon.com - an easy way to get information on subjects you are not sure you are ready to invest in. - Read the online MySQL documentation, and or download it to your PC - Download MySQL (any version, but the latest stable version makes sense) and start playing with it. good luck - have fun exploring. Eric P.S. I'm not really PHP-positive-biased -- it's not my favorite language -- but I know there is an awful lot of tutorial material on the web re: PHP/MySQL... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Full Text Search - Limits?
Thomas Spahni [EMAIL PROTECTED] wrote: the column type will limit the number of characters per row. A column of type TEXT will hold up to 65,535 characters but with LONGTEXT you can put up to 4,294,967,295 charcters into one row. I have an application with Texts of up to 200 pages in one column. Full-Text Search is handling this very well. Thanks... Really?! If I can follow-up with another question, does experience suggest Full-Text Search handles a large number of such documents efficiently? For example, I am expecting to have (up to) one million documents in my database. I was considering breaking each document into paragraphs for search efficiency, but if Full-Text Search can search return results quickly on a large number of long (e.g. 10,000+ character) documents, my database has just become much simpler. Eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Full Text Search - Limits?
I've looked in the documentation but didn't see any indication of the limits of Full-Text Search in terms of how many characters/words it can process per row. For example, if I have a column with 4,000 character strings in it, can I use it effectively in Full-Text Searching? What if the column holds gigabytes of text in each row? My mind is probably stuck in an indexing paradigm, but I'd like to know where the limits (of Full Text search) are, if any. Can anyone advise? [Thanks!] Eric Pederson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DESCRRIBE ALL TABLES
[EMAIL PROTECTED] wrote: snip! some command like describe all tables so that i can see structure of all tables in database. I use a script to do this, if it's a help you are welcome to it: http://paradigmb.com/describe_MySQL.htm It produces a html page showing the database structure (all columns for all tales in the database) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
why: mysqldump and mysqlimport?
I am wondering: I can see the MySQL data files for my various databases. What technically prevents me from simply copying those files and using copies - to move my database to another file structure or server - to back-up my current db Yes, I did put my finger in the electrical socket as a kid. But only several times. TIA Eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql by itself?
OK, I need to ask a stupid question. I normally run MySQL on Apache. I have a second machine [a laptop] which I can't get Apache to run on [the ports are restricted/closed]. Is there a way to run MySQL without a server like Apache underneath it? I see MySQL coined a database server; have I overlooked that it really is a server by itself? EP asking for a friend, I'm much smarter than this -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql by itself? [err: 10061]
EP wrote: OK, I need to ask a stupid question. Obviously, MySQL can run on its own, not quite sure what you really mean by this though. Amazing that it wasn't obvious to me, but I originally installed MySQL after installing Apache, based on home brew instructions that implied a dependency; then I always had Apache running when I used MySQL and was convinced of the flatness of the earth. My problem on my 2nd machine _was_ : Error 2003: Can't connect to MySQL server on 'localhost' (10061) Long story short, now realizing the MYSQL error message had nothing to do with my Apache error messages, I looked and found the MySQL config. error -- fixed it, setting the port to 3306 in the ini file. It's up! Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: web hosting question (slightly off topic)
is it just me, or do hosts underestimate how much data we might want to put in a MySQL database? For instance, 250MB, the largest plan from that host would not come close to holding all my data. I guess what I'm really curious about: do others construct large (GB) databases in MySQL? Is there some reason not to I should know? Eric [yes, I'm trying to pare the memory size of my tables down, but a byte is a byte] snip i really love 'em. how often do you hear that about an ISP? /snip Usually everytime someone is looking for an ISP and an owner/person-with-something-to-gain happens to sniff out the opportunity. -J -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 8:33 AM To: [EMAIL PROTECTED] Subject: RE: web hosting quesiong (slightly off topic) www.soniccommerce.com They're awesome, all linux, and expect you to grow over time so they make upgrading your plan simple. i really love 'em. how often do you hear that about an ISP? -dan -Original Message- From: Chris W [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 8:10 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: web hosting quesiong (slightly off topic) I was wondering if anyone could recommend a good web hosting company for an Apache - php - MySQL project. I don't need much bandwidth or disk space to start out, but may need more if the site gets big. I would also like to have ssh access to the server, preferably a linux server. Chris W -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Python API ...
Paul DuBois wrote: By the way, you may want to visit http://www.kitebird.com/mysql-cookbook and grab a copy of the recipes distribution. In net style led me to: http://www.onlamp.com/pub/a/onlamp/excerpt/mysqlckbk/index2.html?page=1 Much appreciated strategy advice. Is the Python API mentioned: seq1=cursor1.insert_id() MySQLdb? Or another specific Python-MySQL API? [Should it be applicable to any Python Database API Specification v2.0 API ?] That approach will really help, thanks. Eric Pederson P.S. In absence of this kind of technique I was struggling with the idea of multiple SELECT FROM's within a single INSERT (is that even possible?) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Python API ...
. In absence of this kind of technique I was struggling with the idea of multiple SELECT FROM's within a single INSERT (is that even possible?) I'm not sure what you mean here. Will something like this work (with a correction of syntax which is unknown to me)? INSERT INTO webpages(author_key, subject_key, title, description) SELECT MAX(author_key) from authors, SELECT MAX(subject_key), title, description, from subjects; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SQL syntax? [Select within Insert]
Struggling to get an INSERT to work, can anyone help? Here's my scenario: Students[table] Student_ID [primary key, auto-increment] Student_name Student_sex Extra_Credit[table] EC_ID [primary key, auto-increment] Student_ID Points First: INSERT INTO Students (Student_name, Student_sex) VALUES('Josh Baxter, M); [suceeds] Then: INSERT INTO Extra_Credit (Student_ID, Points) SELECT MAX(Student_ID) from Students, (1) ...VALUE ('25'); or (2) ... '25' as Points; Either one fails... Any hints on syntax to achieve the insert (pulling the Student_ID in from the just modified record in the Students table)? TIA! Eric Pederson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
password mysql with kylix
Dear all, I got problem, I want to build application with Kylix + MySql. These problem is when this password to connection mysql Null that application running OK, but if i fill password then message error on Kylix Error mapping failed', if I click again then message Unable to execute query. I was Update new patch Driver to connection mysql(libsqlmy23.so.1) Adhi.. - 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
Password mysql running in kylix
Dear all, I got problem, I want to build application with Kylix + MySql. These problem is when this password to connection mysql Null that application running OK, but if i fill password then message error on Kylix Error mapping failed', if I click again then message Unable to execute query. I was Update new patch Driver to connection mysql(libsqlmy23.so.1) thanks for your help.. regards, Adhi Eka P - 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