Re: mysql 4.0.11-gamma: TRUNCATE table bug
Hi, Now my problem is, a user with no privilege is able to run SQL command TRUNCATE table to empty any table! Thanks for the bug report. The bug has been entered into our bug database as bug #138: http://bugs.mysql.com/bug.php?id=138 This will be fixed in the next release, 4.0.12. Rgds, Indrek -- MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Support Guy /_/ /_/\_, /___/\___\_\___/ Uuemõisa, Haapsalu, Estonia ___/ www.mysql.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
Re: FAQ hosting site [FAQTS.COM]
Hi, Can I strongly suggest there be a link from the MySQL documentation page to: http://www.faqts.com/knowledge_base/index.phtml/fid/52 It is the MySQL section of FAQTS.com which, IMHO, is the best online FAQ site. Thanks for the pointer - I've added link to this to our documentation page (http://www.mysql.com/documentation/index.html) now. Rgds, Indrek -- MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Uuemõisa, Haapsalu, Estonia ___/ www.mysql.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
Re: Query
Hi, I would like to know the maximum number of rows and columns which can be inserted into a table in MYSQL. The maximum number of columns in a table is currently 3398. The maximum number of rows is not limited - the only limit is your hard disk space. By the way, you can see this and much more information about the limits of MySQL and other databases at our Crash-Me pages at: http://www.mysql.com/information/crash-me.php Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/?ref=mtfr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Uuemõisa, Haapsalu, Estonia ___/ www.mysql.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
Re: MySQLGUI
Hi, I've granted a user ALL PRIVILEGES on a particular database and when they log in using MySQLGUI they can see all the databases on the server. Even though they can't do anything with them, I would prefer if they didn't see them at all. Any ideas? Check out: http://www.mysql.com/doc/P/r/Privileges_options.html You need to run the server with the --safe-show-database option. Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.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
Re: Why I will stay with Microsoft SQL Server
Hi, Regarding this situation, is it possible to setup a replication on the same table between two servers, two way? as in i modify server a and server b replicates the table change i then modify server b and server a replicates the table change If you're talking about 2 different tables, e.g.: i modify table a on server a and server b replicates the change i then modify table b on server b and server a replicates the change then it's a piece of cake. Two-way replication of the same table however has some gotchas, mainly the indices - since there is a (in most cases we're talking about milliseconds, but still) tiny lag between the servers catch up to date again, there is a possibility of inserting conflicting entries on both sides at the same time and replication really can't decide which one to keep. Especially when you use auto_increment ID fields. If you're serious about replication and advanced MySQL use, you should consider participating in a MySQL training. The next one in Germany is 11-15.02 at Hamburg so you yet have time :-) Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.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
Re: Why I will stay with Microsoft SQL Server
Hi, we have 3 Tables where new orders are stored (and costumerdates etc...) - and 12 tavles where products are in - but how could I connect them ? IN MySQL's replication FAQ and Manual its only talking about whole servers you can look at the MySQL documentation regarding replication, at http://www.mysql.com/doc/R/e/Replication.html in http://www.mysql.com/doc/R/e/Replication_Options.html (Replication options) there are options like replicate-do-table and replicate-wild-do-table and others, that let you replicate selected tables. Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.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
Re: mySQL newbie?
Hi, Is their another gui I could use to populate a mySQL database? my personal opinion - the best MySQL GUI by far I've seen is the EMS MyManager: http://ems-hitech.com/mymanager/ Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.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
Re: MySQL home page redirects to obsolete link (sunsite.dk)
Hi, I wanted to download the MySQLGUI 1.7.5 source code, but I couldn't. The erroneous link was: http://mirrors.sunsite.dk/mysql/Downloads/mysqlgui/mysqlgui-1.7.5.tar.gz mirrors.sunsite.dk is for sale now and only displays nasty commercials when accessed. hm, from where I'm at, the sunsite.dk looks just down. from my host, mirrors.sunsite.dk resolves to 130.225.51.30 - is it different from your side? anyways, the SunSITE.dk guys had a DDOS attack against them this morning (european time, late yesterday night US time). they're currently working on straightening this out, so our downloads should be operational again real soon. Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.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
Re: creating tables using a number THIS IS A BUG
Hi, SO this does seem like a bug .. hope MySql guys see this. I have looked but can't find anything about how to contact in case of bugs .. mail to [EMAIL PROTECTED] :-) Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.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
Re: GEMINI Table Type
Hi, does MYSQL.COM has a table type same as GEMINI ( GEMINI does not complies with GPL according to what I read) that support the ACID PROPERTIES ( TRANSACTIONS ) (MyIsam, Inodb ?) ... yes. MySQL contains support for BDB and InnoDB tables, that are transaction-safe. if you are downloading a binary distribution, you should download the MySQL-Max binary, that has BDB/InnoDB compiled in (the default MySQL does not). Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.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
Re: Permissions Problems
Hi, Can anyone explain why this is happening? root@www:/# mysql -u dgadmin -h www.4cdg.com -p cdgcatalog Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) remove the space between -p and the password. Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.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
Re: Copy of databse on my PC....
Hi, I have a databse on the server. It os called ads. I want to make copy of it on my PC. I have Win32, Apache with PHP and MySQL. And I also have phpMyAdmin on that server. I'm writing this: mysqldump -A ads /home/myaccount/www/backup.sql But it says that i'm making a mistake. -A stands for all databases. probably there are some databases on the server that you don't have access to and that is causing the error message. a better commandline would be: mysqldump --opt -uUSERNAME -p ads /path/backup.sql Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.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
Re: MySQL - Table damaged Help!
Hi, mysql select * from logezboo; ERROR 1016: Can't open file: 'logezboo.MYD'. (errno: 145) shut down your mysql, change to your MySQL data directory (as root or the user MySQL runs as) and run: myisamchk -r */*.MYI and then restart MySQL after that and you should be back and running. Rgds, Tfr --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==-- - 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: why does it not work
Hi, - DAY) '$tdate' and city.id=special.cityid order by RAND() limit 1; ERROR 1064: You have an error in your SQL syntax near 'RAND() limit 1' at line 3 select version(); +---+ | version() | +---+ | 3.22.32 | +---+ What could be the problem order by rand() didn't work back in 3.22. if i remember correctly (if this doesn't work, you can try to search the list archives), the workaround was: SELECT col1,col2,RAND() as r FROM table ORDER BY r LIMIT 1; Rgds, Tfr --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==-- - 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: Inserting images into BLOB Fields
Hi, How can I insert an image file into a blob field? I search the MySQL Documents but nothing came up specificaly on inserting images from files. INSERT INTO sig VALUES ( 1, 'Paul', 'Davolio', LOAD_FILE('d:/signatures/paul.txt') ); Rgds, Tfr --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==-- - 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: Fulltext and phrases
Hi, I have just done this: select * from indexed_table where match(indexed_col) against ('visual basic') This returns rows with either visual or basic. I read phrase searching was allowed in mySQL v4.0? Can someone please advise. you're right, phrase and AND searches will be in MySQL v4.0. but you'll have to wait a bit more for the 4.0 to come out. :-) Rgds, Tfr --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==-- - 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: I have a question
Hi, I can not access to an access file via ODBC It gives me Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data., SQL state S1000 in SQLConnect in c:\inetpub\wwwroot\php\ietest.php on line 7 this is in no way associated to MySQL. as the error message says, you're trying to connect to a Microsoft Access data source, what is already exclusively opened by another user - your probably have the database open in MS Access - it opens it for exclusive use by default. Rgds, Tfr --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==-- - 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 denied error
Hi, i am trying to import or export using MYSQL driver. that time it gives following error; Access Denied For User '[EMAIL PROTECTED]' (Using password:YES) did you give all the privileges manually through editing the grant tables, or by the GRANT command (the right command should be something like GRANT all ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password'? if you did it manually, did you run 'mysqladmin reload' afterwards? Rgds, Tfr --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==-- - 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: mysql
Hi, Does anyone know the correct syntax to connect to a mysql database with DBI? I tried the syntax mentioned in the Perl DBI O'Reilly book, but I got errors. i'm pretty sure the syntax given in the O'Reilly book was right. and it would really make it easier to help solve your problems, if you would post the errors you were getting, here. Rgds, Tfr --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==-- - 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: if then (SQL statement) else (SQL statement 2)
Hi, Hi, I'm trying to use an if then alike statement in MySQL, myabe anyone can tell me the correct syntax if got a variable named naam. when the content of this variables is empty the following SQL statement should be executed: select * from beheerder; when naam is not empty: select * from beheerder wherer naam like '%naam%' Can this be done with SQL language? that looks like something that should be done in your front-end level (Perl, PHP, whatever). but actually, if you run select * from beheerder wherer naam like '%naam%' and naam (what you probably pass from a script) is empty, the query will produce the same results as select * from beheerder, since %% will match everything. Rgds, Tfr --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==-- - 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: Query for Accessing MySQL in C/C++
Hi, I have to manipulate (or access) MySQL Database through pure C or C++, but I am not getting the exact libraries for it. Also, I don't know how to do it. Please anybody would tell me if it is possible or not. And if it is possible, then let me know how to do it and what to do for it. in any way you need mysql client libraries on the machine you're compiling and running your C/C++ programs. if you're writeing pure C programs, just look at the MySQL C API (http://www.mysql.com/doc/C/C/C.html) and you should be going. if you're into C++, you might want to look at MySQL++, the C++ class for MySQL (at http://www.mysql.com/downloads/api-mysql++.html). Rgds, Tfr --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==-- - 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: Problem
Hi, I have some tables in the ISAM format in the database. The tables have the data, but whenever I do a select * from table_name, it returns an empty set for most of the tables. Whenever I do a count(*) query I get the total no of records. try running isamchk (c:\mysql\bin\isamchk *.ISM) in the database directory. Rgds, Tfr --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==-- - 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: database recovery (errcode 13)?
Hi, The server where the db was located got hacked and I had to reinstall the whole thing. The old HD is preserved as was and the server got a new HD. I moved the old db to the new disk and when I try to access it, I get the following error: mysql use thedb; Can't read dir of './thedb/' (Errcode: 13) Database changed mysql show tables; ERROR 12: Can't read dir of './thedb/' (Errcode: 13) mysql Error code 13 stands for permission denied. make sure the whole MySQL data directory is owned by the same user you run the mysql daemon as. i'm not completely sure about the RPM install, but it should run it as user mysql - in that case, run chown -R mysql /mysql/data/dir as root. Rgds, Tfr --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==-- - 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: [Help] best way to synch mysql with an Oracle DB
Hi, I have a project which need to synch our mysql db with external Oracle DB. It requires that anytime DB admin modifies their Oracle DB, the change should be synched remotely with our DB in mysql. To make thing easy, we could use the same table structure on both end. just a quick idea that popped into my mind (i'm not completely sure about Oracle's possibilities on this, but it might be worth to give a look at): in Oracle, you can set up triggers for tables. you can try to make a trigger that on table update writes the corresponding SQL clause to update the remote table in a file. then, write a little crontab script that checks for the files created by Oracle trigger, and copies them over to the remote MySQL server (via scp for example). on the MySQL server machine, create another crontab script that checks for the existence of these files, and if they exist, runs mysql -uuser -ppassword dbname sqlfilename to import the changes. just my .02 :) Rgds, Tfr --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==-- - 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: Problem
Hi, Tried doing isamchk on the .ISM files and got that following error The Exception Integer division by zero (0xc094) occured in the application at the location 0x0040224a. getting such errors usually means you've got hardware (bad memory?) or some serious software installation problems on your machine. Rgds, Tfr --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==-- - 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: Migrate Lotus Domino .nsf == MySQL 3.23.27
Hi, we have to migrate a database from Lotus Domino (.nsf format) to MySQL. Is there anybody out there having had experience on this kind of job? Let we know, we are a bit .. desperate ... the easiest way is to try to make SQL dumps from your current database (Domino) and then work around the porting issues if needed. Rgds, Tfr --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==-- - 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: Need help with 23.36
Hi, mysql use lumina; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'absences' Didn't find any fields in table 'admins' Didn't find any fields in table 'classes' Didn't find any fields in table 'marks' Didn't find any fields in table 'students' Didn't find any fields in table 'teachers' Didn't find any fields in table 'users' Didn't find any fields in table 'vars' Database changed mysql select * from users; ERROR 1017: Can't find file: './lum/users.frm' (errno: 13) errno 13 stands for Permission denied - check your mysql data directory permissions. Rgds, Tfr --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==-- - 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: duplicating rows
Hi, Table 1 is called: active_users Table 2 is called: deleted_users When "joe_smith" wishes to be deleted, I want to remove his entry from the active_users table, and place it into the delete_users table, with exactly the same information. INSERT INTO deleted_users SELECT * FROM active_users WHERE user='joe_smith'; DELETE FROM active_users WHERE user='joe_smith'; Rgds, Tfr --== [EMAIL PROTECTED] == MySQL development team == Tallinn / Estonia ==-- - 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