Error No. 7
Hello When I use the Alter table structure command to alter any field, it comes up with an error stating that Error number 7 - error in renaming of table table name.myi to sql-208... and so on with (Errorcode 13). Thus I am unable to change the structure of any table. I am using MySQL ver 3.23.55 and on a Windows XP professional system. Any help. Insane - 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 Editing mysql Text field
Hello There is a bug in both MySQL-Front and NaviCat where updating a field before retrieving all the record in the data result hangs up the thread as they use mysql_use_result() feature. Try using some other Front Ends. Insane - Original Message - From: Daniel Negron/KBE [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 13, 2003 8:13 PM Subject: Problem Editing mysql Text field Hi all, I was wondering if anyone could help me with this issue. I have a TEXT field in my database, It contains HTML, when I edit the field through a web browser it updates fine with no problems. But If I manually edit with MySQL-Front or NaviCat and use the BLOB-TEXT editor It freezes up. I have added the following lines to my.ini, this is after following a few leads to my current problem. set-variable=max_allowed_packet=16M set-variable=thread_stack=1M With these variables in place, I still get the same problem. Any suggestions. TIA **DAN** - 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
Top MYSQL Sites
Hello Can somebody tell me what are the top sites ( except ofcourse mysql.com ) for general MySQL News, Tutorials etc. Insane - 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: Migrating Microsoft Access to MySQL
there is a tool called SQLyog at http://www.webyog.com/sqlyog/download.html It has a very good ODBC import tool which will import your Access data to MySQL without any fuss and its FREE!!! Insane - Original Message - From: Edward Kim [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 12, 2003 1:24 AM Subject: Migrating Microsoft Access to MySQL I am with a small business in Southern California that would like to migrate our MS Access databases to MySQL server. Are their any computer service companies who can help me? - 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: Is there a SQL/diff program out there?
Hello The latest version of SQLyog at http://www.webyog.com/sqlyog/download.html contains a very powerful diff tool and it is free. Try it out. Insane - Original Message - From: Daevid Vincent [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 07, 2003 6:58 AM Subject: Is there a SQL/diff program out there? I searched google, but didn't find anything. SYNOPSIS: Wondering if anyone knows of, or has built, or is interested in building a program that will take two .sql schema dumps (one new and one old) and create the ALTER / CREATE TABLE syntax to make the old one look like the new one. It should work in such a way that it doesn't matter if the table's schema are in the same order or not. REASON: We do a lot of development on our dev server and this involves creating new fields in the databases and even new tables. We have to manually go through using a script and update all the 'live' databases then so they jive with our dev environment. It's quite tedious to remember all that's changed and manually make the 'alter table' syntax ourselves. I'm surprised this isn't a more common tool request and it doesn't exist already -- at least none that I can find. There are ten million mySQL graphical clients out there, you'd think one of them would have such a useful feature. Is this something that people would want/use? If so, I'll build it. I just didn't want to spend the time/energy if it existed already somewhere. - 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: converting MS SQL to MySQL
The best way is to import data from MS SQL Server to MySQL. SQLyog at http://www.webyog.com/sqlyog/download.html has a DTS like ODBC Wizard. Try it out and all you data will be imported. Insane - Original Message - From: Hawk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 06, 2003 8:33 PM Subject: converting MS SQL to MySQL Hi, I am new to SQL. I am attempting to create a database that was created in MS SQL to MySQL. The below SQL statements works with MS SQL. I am executing the following: CREATE TABLE 'Accounting'( 'Username' VARCHAR(254) NULL, 'CallerID' VARCHAR(128) NULL, 'Addr' VARCHAR(128) NULL, 'NAS' VARCHAR(128) NULL, 'Port' VARCHAR(128) NULL, 'Start' DATETIME NULL, 'Stop' DATETIME NULL, 'SessionTime' INTEGER DEFAULT 0, 'ExtraTime' INTEGER DEFAULT 0, 'TimeLeft' INTEGER DEFAULT 0, 'KBytesIn' INTEGER DEFAULT 0, 'KBytesOut' INTEGER DEFAULT 0, 'SessionKB' INTEGER DEFAULT 0, 'ExtraKB' INTEGER DEFAULT 0, 'KBytesLeft' INTEGER DEFAULT 0, ) GO CREATE INDEX IX_Username ON Accounting(Username) MySQL will not take this command GO CREATE TABLE 'ActiveUsers'( 'UserID' VARCHAR(254) PRIMARY KEY, 'NAS' VARCHAR(128) NULL, 'Port' VARCHAR(128) NULL, 'Username' VARCHAR(254) NULL, 'CallerID' VARCHAR(128) NULL, 'Address' VARCHAR(128) NULL, 'LoginTime' DATETIME NULL, ) GO CREATE TABLE 'TAC_GRP'( 'TAC_ID' VARCHAR(254) NOT NULL, 'TAC_Attr' VARCHAR(64) NOT NULL, 'TAC_Val' TEXT NULL ) GO CREATE UNIQUE INDEX IX_TAC_ID ON TAC_GRP(TAC_ID, TAC_Attr) MySQL will not take this command GO CREATE TABLE 'TAC_USR'( 'TAC_ID' VARCHAR(254) NOT NULL, 'TAC_Attr' VARCHAR(64) NOT NULL, 'TAC_Val' TEXT NULL ) GO CREATE UNIQUE INDEX IX_TAC_ID ON TAC_USR(TAC_ID, TAC_Attr) MySQL will not take this command GO Thanks in advance. --- [This E-mail scanned for viruses by Friend.ly.net.] - 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
Webyog Releases SQLyog 3.02
SQLyog v3.02 - The definitive Windows Front End for MySQL, has been released. It is a superfast, compact and easy to use Front End for MySQL. A must for MySQL developers. SQLyog is FREE! Some of the new features added in SQLyog 3.02 are - -- ODBC Import. The simplest and the most powerful tool to import data from any ODBC compliant database to MySQL. -- Database Synchronization Tool. Bring your remote databases in Sync with a single mouseclick. -- Connection Manager. -- Manage relationships on InnoDB tables. All other options fully InnoDB compliant. -- Column Reordering. -- Copy databases between two MySQL hosts. -- Insert/Update on the Resultset of a query. -- Fully updated keyword list for syntax highlighting. -- Picklist for Enum/Set values in Insert/Update Dialog. -- Improved datagrid. Allows multiple row deletion. -- Option to add column name while exporting data in CSV. -- Multi selection of tables in export as SQL Scripts dialog. -- Empty a database with a single click. -- Show/Hide edit window. -- Improved error messages. -- Lot of bugfixes and enhancements. You can download the new SQLyog at http://www.webyog.com/sqlyog/download.html. Send your comments, suggestions, feature request through their NEW discussion board at http://www.webyog.com/forums/index.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
SQLyog 3.02 Released
SQLyog v3.02 - The definitive Windows Front End for MySQL, has been released. It is a superfast, compact and easy to use Front End for MySQL. A must for MySQL developers. SQLyog is FREE! Some of the new features added in SQLyog 3.02 are - -- ODBC Import. The simplest and the most powerful tool to import data from any ODBC compliant database to MySQL. -- Database Synchronization Tool. Bring your remote databases in Sync with a single mouseclick. -- Connection Manager. -- Manage relationships on InnoDB tables. All other options fully InnoDB compliant. -- Column Reordering. -- Copy databases between two MySQL hosts. -- Insert/Update on the Resultset of a query. -- Fully updated keyword list for syntax highlighting. -- Picklist for Enum/Set values in Insert/Update Dialog. -- Improved datagrid. Allows multiple row deletion. -- Option to add column name while exporting data in CSV. -- Multi selection of tables in export as SQL Scripts dialog. -- Empty a database with a single click. -- Show/Hide edit window. -- Improved error messages. -- Lot of bugfixes and enhancements. You can download the new SQLyog at http://www.webyog.com/sqlyog/download.html. Send your comments, suggestions, feature request through their NEW discussion board at http://www.webyog.com/forums/index.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: reports
What type of reports you want ? Probably you will have to develop your customized app to get the reports you want. Insane - Original Message - From: geeta varu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 24, 2002 12:25 PM Subject: reports sir, i would like to generate reports using mySQL but unable to get any information related to it could u please help me out or give some name of the sites that will get me to get some solution regards __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.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: Best Windows MySQL client?
Greetings I prefer SQLyog. You can download it at http://www.webyog.com/sqlyog/download.html Its free, compact and has lot of features. Insane - Original Message - From: Jeff Snoxell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 20, 2002 8:54 PM Subject: Best Windows MySQL client? What's the best MySQL client for windows? I've tried 5 or 10 shareware ones that seem ok but all seem a bit chasty (some more than others). Any recommendations? Thanks, Jeff - 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: GUI for the server part of MySQL
Greetings What do you mean server part of MySQL. SQLyog allows you to perform almost all operation which MySQLAdmin does except starting and shutting down a MySQL server, which probably SQLyog will have in one of its future releases. Insane - Original Message - From: Stan Sebastian [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 12:47 PM Subject: GUI for the server part of MySQL Is there any GUI for the server part of MySQL fro Windows. I mean not a client for MySQL, like SQLyog OR MySqlFront. Something better then the MySqlAdmin? -- Sebastian Stan [EMAIL PROTECTED] ### Disclaimer on Exchange This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/doc/ (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Am I Violating Any Rules ?
If I distribute it free or commercial then ? Karam - Original Message - From: Dan Nelson [EMAIL PROTECTED] To: Karam Chand [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, December 12, 2002 1:10 AM Subject: Re: Am I Violating Any Rules ? In the last episode (Dec 11), Karam Chand said: I want to statically link libmysql.dll with my closed source application, which I have not planned to distribute freely or commercial ? If you are not distributing the application, you are safe. -- Dan Nelson [EMAIL PROTECTED] - 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: How is DBTools Software?
Greetings I like SQLyog. http://www.webyog.com/sqlyog/download.html Rgds Insane - Original Message - From: Chris Mason [EMAIL PROTECTED] To: 'MySQL List' [EMAIL PROTECTED] Sent: Sunday, December 08, 2002 4:07 PM Subject: RE: How is DBTools Software? I've found mysql-front to be far superior, in fact, I can't complain about it at all. -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 07, 2002 3:27 PM To: Will Standley Cc: Sandeep Murphy; Crercio O. Silva; MySQL List Subject: Re: How is DBTools Software? Hi, I used it for a while, it's quite good for free software, but it is rough around the edges. Some of the menus are a bit hard to navigate and it crashes once in a while too. I'm currently using EMS Hitech's MySQL Manager. It's one of the best GUI's I've come across. There are a couple of glitches with the program, but nothing severe. The author is really responsive in returning questions and comments. The only drawback - It's not free... http://www.ems-hitech.com/mymanager I'm debating if I should register it (might go back to DB Tools), but that's because I'm building a charity/non-profit site and funds are kind of tight! At 08:15 AM 12/7/2002 -0500, Will Standley wrote: Has anyone used DBTools Software? (http://www.dbtools.com.br/EN/) It is a free utility for managing MySQL other db's. I also discovered Intelligent Converters at www.convert-in.com Both look good. The first is free and does more than convert Access to MySQL. The second converts more stuff... like Excel to MySQL. All comments encouraged. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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 - 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: LOAD DATA command
Greetings... Are you using Windows to connect to the MySQL. Then you can try SQLyog at http://www.webyog.com/sqyog/download.html It will help you a lot in these works and you dont have to write queries also. Rgds Insane - Original Message - From: Padma kuruganti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, December 07, 2002 12:46 AM Subject: LOAD DATA command Hi I just downloaded version 3.23.53 for evaluation. when I try to use LOAD DATA LOCAL INFILE 'some.txt into TABLE sometable I get a message saying 'the used command is not allowed in this version of mySQL. IS there any update on this? I could not find any info on your web site. Thanks KP __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.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: Graphical client
Try SQLyog - A Windows based Front End for MySQL. http://www.webyog.com/sqlyog/download.html Rgds Insane - Original Message - From: Natale Babbo [EMAIL PROTECTED] To: Massimo Bandinelli [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 27, 2002 9:27 PM Subject: Re: Graphical client check mysql site at http://www.mysql.com/downloads/index.html Bye --- Massimo Bandinelli [EMAIL PROTECTED] ha scritto: Does anyone know a good graphical mysql client for windows and linux? Massimo Bandinelli System Administrator mob +39 335 7324615 - Register.it S.p.A. - Gruppo DADA tel +39 199 REGIST (+39 199 734478) fax +39 035 3230312 http://we.register.it mailto:[EMAIL PROTECTED] - 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 __ Per te Blu American Express è gratis! http://it.yahoo.com/mail_it/foot/?http://www.americanexpress.it/land_yahoo - 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: displaying a letter based on a query value
Greetings... I thin you need to look into the enum datatype. It stores data as integer but when queried it will return data in text. Rgds Insane SQLyog - The Definitive GUI for MySQL http://www.webyog.com/sqlyog/download.html - Original Message - From: Alex Behrens [EMAIL PROTECTED] To: MYSQL [EMAIL PROTECTED] Sent: Monday, November 25, 2002 3:54 AM Subject: displaying a letter based on a query value Hey All, I'm working on a site that displays all the players on my hockey team and I want to the page to indicate the captains automatically. Right now im using the following query to display all the captains, however, captains are indicated by a 1, is it possible to display a C when a 1 is found? How would i do this? select captain from stats where captain 0 and number = '23' group by number; this returns a 1 for any player with the number that matches being a captain, however it display a 1 is it possible to make that 1 displayed as a C on my page? mysql Thanks! -Alex Big Al Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - 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: Error 1148 The error used Command is not allowed with this MySQL-Version
Greetings I think the path for the file is not correct. Try giving the complete path with (\) in the directory name changed to (/). Also specify the escaping characters properly. For more information you can check out the MySQL docs on LOAD LOCAL INFILE. Rgds Insane SQLyog - The Definitive Windows GUI for MySQL http://www.webyog.com/sqlyog/download.html - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 20, 2002 5:57 PM Subject: Error 1148 The error used Command is not allowed with this MySQL-Version Hello, I downloded MySQL-Version 3.23 for Windows XP from MySQL-webpage. If I try to load a Database from a textfile I got message Error 1148 The error used Command is not allowed with this MySQL-Version. I used following Command: LOAD DATA LOCAL INFILE verlagdaten.txt INTO TABLE verlag; Any ideas for help? Best regards, Klaus Wagner - 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
Journals on MySQL
Can somebody suggest some good English magazines on MySQL ? Rgds Insane - 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: Does mysql_real_connect allocate memory?
Greetings You dont have to do mysql = new mysql; it is dont automatically. Rgds Insane SQLyog - The Definitive Win32 MySQL Front End http://www.webyog.com/sqlyog/download.html - Original Message - From: Anna Fowles-Winkler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 20, 2002 1:28 AM Subject: Does mysql_real_connect allocate memory? Hi, Does the MySQL C API function mysql_real connect allocate memory or do I need to do it? This is what my code currently does: MYSQL *mysql; mysql = new MYSQL mysql_init(mysql); mysql_real_connect(mysql, host, user, password, dbase, 0, 0, 0); Thanks, Anna - 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: Mysql and use rmanagement
Greetings MySQL-Front has problems with User Manager module. It does not creates permission correctly. Try SQLyog at http://www.webyog.com/sqlyog/download.html Rgds Insane - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 20, 2002 12:22 AM Subject: re: Mysql and use rmanagement krisbekkers, Monday, November 18, 2002, 11:55:37 PM, you wrote: katdb I have a 'simple' question regarding the mysql privileges. katdb The database at home: katdb version 4.04 beta max katdb all of my tables are innodb tables. (except the mysql privileges table) katdb As of version 4.02 of mysql the database supports the use of MAX_QUERIES_PER_HOUR, katdb MAX_CONNECTIONS_PER_HOUR and MAX_UPDATES_PER_HOUR. katdb ' --- katdb I have two questions: katdb 1. On what level does these apply: on the global level (for a specific user) katdb a database level, table level or column level. katdb The max_connections could be applicable to the global level. But the max_updates, katdb Max_queries are can they be restricted to a database or a table as follows: katdb grant select on database.table to 'test'@'%' with max_updates_per_hour katdb 100 katdb so that in this case the database.table will allow only 100 updates. (or katdb is that dug too deep) All these limits are applied on the global level. katdb 2. Is the following a bug, or do I mis something out there katdb I use MySqlFront (and a home made project) for managing the accounts on the katdb server parsing the stuff that the show grants returnes me. katdb Following stuff occures: katdb I issue a grant (on a non-existing user, but even when the user already exist. katdb as follows (note this was for testing purposes) katdb GRANT Select ON *.* TO 'test'@'%' with Grant option MAX_QUERIES_PER_HOUR katdb 4 MAX_UPDATES_PER_HOUR 100 MAX_CONNECTIONS_PER_HOUR 20 katdb When I do immediatly after the grant (without flushing privileges) a show katdb grants for 'host0002104'@'%' I get the following result katdb GRANT SELECT ON *.* TO 'test'@'%' WITH GRANT OPTION MAX_QUERIES_PER_HOUR katdb 4 MAX_UPDATES_PER_HOUR 100 MAX_CONNECTIONS_PER_HOUR 20 katdb When I then issue a flush privileges the show grants for 'host0002104'@'%' katdb returns me (incorrectly) following result katdb GRANT SELECT, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES ON *.* katdb TO 'test'@'%' WITH GRANT OPTION katdb All of the max_ have gone. I tested it with mysql command-line program and privileges were displayed correctlly. Seems, it's a MySQLFront problem ... -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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 - 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: MySQLDump BLOB Columns
No. Just escape the fields properly. Rgds Insane SQLyog The Definitive GUI for MySQL ( http://www.sqlyog.com ) - Original Message - From: Mike Hillyer [EMAIL PROTECTED] To: MySQL Mailing List [EMAIL PROTECTED] Sent: Sunday, November 17, 2002 12:17 AM Subject: MySQLDump BLOB Columns Hello All; I am setting up a backup system for a client and am thinking to use mysqldump on a daily cron job to back up my SQL database. Does anyone know if I will have any concerns using mysqldump with a table that contains BLOB columns? (No larger than 15 megs for any given file) Mike Hillyer - 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
Lost Connection During Query
Greetings I have a MySQL server with my ISP. Previously I was able to connect to the server using any client. But now when I connect it says lost connection during query ? What is the reason ? Rgds Insane - 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
MySQL Equivalent Datatype
Greetings Can somebody point to any resource where I can get the equivalent datatype of MySQL for SQL Server, Oracle and Access Rgds Insane - 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
SSH Connection
Greetings I am writing a C app wherein I have to connect to MySQL server whcih is on SSH connection. How can I connect to the server using mysql_real_connect () Any ideas ? Its urgent Rgds insane - 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: True/False
Use enum. Rgds Insane SQLyog - The Definitive Win32 GUI for MySQL http://www.sqlyog.com - Original Message - From: Tony Roberts [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 08, 2002 4:56 PM Subject: True/False I am new to MySQL and I am attempting a new project to help me learn. I the past I have used a Boolean data type for True/False, Yes/No type data. What data type should be used to achieve the storage of this type of data in MySQL? I have bought the reference manual (a good buy IMHO) but so far can't find the answer. Regards Tony Roberts Mailbox Solutions Ltd [EMAIL PROTECTED] 01777 700 600 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.389 / Virus Database: 220 - Release Date: 16/09/02 - 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: mysql quota
I think you can set a max quota for a table. Insane - Original Message - From: Henry Umansky [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 21, 2002 8:08 PM Subject: mysql quota I want to let users on my system use MySQL, but I want them to have some sort of quota. Is there anyway to create a max database size with MySQL? I could just chown the directory in /var/lib/mysql, but that means I would have to create a username for each person and set filesystem quota. I really don't want to do that, I just want them to use mysql from a remote machine or through PHP. Henry Umansky University of Pittsburgh Systems/Programmer III www.pitt.edu/~hmust2 [EMAIL PROTECTED] (412)624-4357 - 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: C-API and multiple resultsets
Greetings... Yes. If you want to traverse two result set in the same time then use the mysql_store_result(). If you don't have a big resultset coming then probably mysql_store_result() in the same connection is a better option. Otherwise you have to use two connections. Rgds Insane SQLyog - The Definitive Win32 GUI for MySQL http://www.sqlyog.com - Original Message - From: Stefan Fleiter [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 1:16 AM Subject: C-API and multiple resultsets Hi! If I use mysql_use_reult() of the C-API, I must use two connections to traverse two different result sets at the same time. Is that right? Thanx, Stefan sql, query - 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
Is BACKUP / RESTORE making my table corrupted
Greetings... I used BACKUP command to backup all the tables in a database which has only MyISAM tables ( since backup only works with MyISAM table ). Everything was OK. Then after some time I did the RESTORE COMMAND, but before that I deleted all the tables in the database...in two tables,,,i got this error... Delete link points outside datafile at 0 and in another two tables i get this error... Couldn't fix table with quick recovery: Found wrong number of deleted records. I am using MySQL 3.23.44 in WinXP. Is there any problem in Backup / Restore or I am doing something wrong ? Whats wrong. Thanks in advance. Rgds Ritesh - 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
Insert Error
Greetings... I have a table in database ch whose create statement is as follows - CREATE TABLE `chn1` ( `id` int(10) NOT NULL auto_increment, `chn` varchar(10) NOT NULL default 'Pagal', `name ` varchar(50) default '', `chn3` text, PRIMARY KEY (`id`) TYPE=ISAM ; Now when I giving a insert statement like this - insert into chn.chn1 ( id, chn, name , chn3 ) values ( '10', 'Pagal', 'Chagal', 'I am a bad boy' ) MySQL is giving me an error : Error Code : 1054 Unknown column 'name' in 'field list' As you see there exists a column name field ? I checked out and there was a space after name in the column defination. If I remove the space it works ? How come a space causes an error because I am giving space after the column field also ? Can anybody shade a light on it. Thanks in advance. Rgds Insane - 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: Question about state of tables
Check out the tables_priv and db table in the mysql database. It has all the permissions of the MySQL. Insane SQLyog - The Definitive Win32 GUI for MySQl http://www.webyog.com - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 10:43 AM Subject: Question about state of tables Hello; newbie to this list. I wonder if there is a clear method of obtaining a user's permissions on a table. The reason I ask is that I am attempting to setup a catalog solution for a user I am hosting, and I believe I have provided access to the d/b but I need to confirm. I thought I might get this using mysqladmin, but it does not seem available. Is there a log somewhere of transactions on the table? Mark == Mark Jaffe | (408) 972-9638 (home) Chief Wizard| (408) 807-1530 (cell/page/voicemail) Computer Wizards| (425) 795-6421 (FAX) [EMAIL PROTECTED] | http://www.wizdev.net/ - 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: SHOW question
Greetings... In the show tablesif there is no database selected in the Server...it will give an error that no database is selected. In the second query...it will always return a resultsetmaybe an empty resultset if there are no fields in the table. hope it helps. Insane SQLyog - The Definitive Win32 GUI for MySQL http://www.sqlyog.com - Original Message - From: Fabio Checconi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 21, 2002 8:36 PM Subject: SHOW question I'm writing a program using the C API. When I do a query SHOW TABLES am I sure that on every installation it will return a result set of one column containing the tables name, or there are systems where that's not true ? Am I sure that from a SHOW FIELDS FROM table i'll get a result set with the column name in the first field and the type in the second (with other info on other fields) ? - 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: Suggestions for GUI clients for mysql.
If your users are on Windows, try out SQLyog for which I am a beta tester. Its very simple to use and fast. Download it at http://www.webyog.com/sqlyog Insane - Original Message - From: Rafael E. Herrera [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, October 19, 2002 3:54 AM Subject: Suggestions for GUI clients for mysql. Hello, I'm brand new to mysql. I've installed the necessary packages in my linux box to have mysql running. I can run a number of administration tools, like mycc and phpMyAdmin. However, to convince the people here to use it, I need an application that will let me create forms for data entry and searches. phpMyAdmin lets me insert and search a database, but the interface is not user friendly (the users here are not computer experts, and tend to go the MS way if you let them.) I've done some searches, but have not been able to find the kind of program I want yet. Any suggestion will be appreciated. -- Rafael - 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: Which files to download/install - problems running MySQL
Greetings... In windows, in general the settings are done by default so that you can start it with the default case. To start the server go to the bin directory and just enter mysqld. I dont think you need to enter --standalone or something like that. By default a root user is created with 'root' password or it is blank ( i dont remember exactly ). When you start mysqldit wont close the command prompt...it will be just there showing you the information of the process. Either you can close the command window by clicking on the X or you can just keep it there. In another command window, goto the bin directory and start with mysql -hlocalhost -uroot -p If the password is root then type root as password or press Enter if its blank. After you get connected you can start executing querties. If you are adverse to command line then try using SQLyog, its a GUI to MySQL for Windows. http://www.sqlyog.com Insane SQLyog - The Definative MySQL GUI for MySQL http://www.sqlyog.com - Original Message - From: Nikki Mason [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, October 19, 2002 7:46 PM Subject: Which files to download/install - problems running MySQL Hi, I wish to learn SQL, and as some of my friends already use MySQL, they recommended that I too use it. Please can you tell me what I need to download and install to get me going. I have: Pentium III 450Mhz, 256Mb Ram Windows 98 I don't have a C or C++ compiler installed. My PC is not connected to a network - it is standalone. I had earlier downloaded just the zip file for version 4.0.4-beta (Windows). I unzipped it and ran the 'setup' program. Once setup had completed I tried the test on the server - at no point had I run the Admin program or created the my.cnf or my.ini. I opened a dos window and from the directory c:\mysql\bin entered: mysqld --standalone No other text was shown in the dos window and it appeared to hang. The whole computer also seemed to 'hang'. I had to use ctrl C to kill the application and get back normal operation to my PC. I then tried manually creating the file c:\my.cnf and populated with the information given in the installation instructions. The server still hung. I then tried using the admin program with the similar results - the green traffic light was showing, but the dos window that was displayed appeared 'hung' and again the PC itself seemed to have hung - it operated extremely slowly. The task manager showed the admin tool as 'not responding'. What have I/am I doing wrong? Regards, Nikki Mason mailto:nikki_mason;btopenworld.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: Security
I belive it will work in Windows Insane - Original Message - From: Terry Cheryl Haimann [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 17, 2002 4:24 PM Subject: Security I was reading a book at BN yesterday which left me with the impression that in MySQL you can do the following: Define a group with specific security access. Then define a list of users that inherit this groups security settings. Is this correct? If so, will this work under the Windows version? Terry - 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: Mysql Blob type
If its a binary data then you have to properly escaped it with \ otherwise it wont get inserted Rest is same like any other insert statement. Insane SQLyog - The Definative GUI for MySQL http://www.webyog.com/sqlyog - Original Message - From: Mario Nicoletti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 18, 2002 2:27 PM Subject: Mysql Blob type How I treat, the Mysql Blob type when I do a INSERT/SELECT query ( OS Linux RedHat 7.3)? Does anyone know a solution ? - 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: ERROR 2013: Lost connection to MySQL server during query
I had similar problem in my case. The solution was that maybe you are accessing the column which has data which is greater then the specified in Max_data_allowed in my.cnf. Change it to something more and I hope that the problem is solved ? Insane SQLyog - The Definative GUI For MySQL http://www.sqlyog.com/ - Original Message - From: Animesh [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, October 19, 2002 2:23 AM Subject: ERROR 2013: Lost connection to MySQL server during query Hi All,, I am getting this error and mysqld is dying out while tring to access a particular table in a particular databae while others don't fail.. ERROR 2013: Lost connection to MySQL server during query Plz Help as early as possible. Regards, Animesh [EMAIL PROTECTED] DeepRoot Linux Pvt. Ltd. Bangalore, India - 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: How to : Export BLOB
If you use mysqldump, escape the fields with proper escaping characters. You will get a proper dump. Rgds Insane SQLyog - The Definative GUI for MySQL http://www.webyog.com/sqlyog - Original Message - From: Jean-Francois nadeau [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 15, 2002 11:44 PM Subject: How to : Export BLOB Hi all, I use a mix of innodb and MyIsam tables under 3.23.52. As mysqldump does not supports BLOB, how do you export / import databases for backup puposes. I dont want to stop the engine to backup or use a tool that exports all databases (like Innodb hot backup). I want to backup a selected database which contains BLOB in Innodb and MyIsam tables.Any perl script available ? Thanks for your help Jeff - 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: Copy table with column attributes
I have a table tbl_version_history which has a primary key and an index. Through this query I am able to create a copy tbl_version_history_copy with all the index. Just replace the stuff with yours and probably it will help. create table `tbl_version_history_copy` ( primary key ( FLD_REG_NUM ) ,key `NewIndex1` ( `FLD_REG_NUM`, `FLD_VERSION_CODE`, `FLD_ADD_DATETIME` ) ) select * from `tbl_version_history` Rgds Insane - Original Message - From: David Yee [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 15, 2002 11:40 PM Subject: Copy table with column attributes Hi all. What's the quickest way to copy a table so that all column attributes such as auto_increment and primary key along with all indexes get copied over? I like using: create table new_table select * from old_table But it doesn't copy any indexes or those special attributes I mentioned over to the new table. I know this can be done using mysqldump but I'm wondering if there's something quicker (less involved). Thanks. David - 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: Number of tables
Greetings... I belive MySQL is powerful enuf for the mentioned type of data. I have a database in win2k with 100 tables and the size of the database is 8 GB. It performs fantastic, faster the MS SQL Server which I had before. I have MyISAM tables. Rgds Insane SQLyog - The Definative Win32 GUI For MySQL http://www.webyog.com/sqlyog - Original Message - From: Peter Stöcker [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 14, 2002 1:08 PM Subject: Number of tables Hi there! Does anybody know whether it is possible for MySQL to handle round about 500-600 tables in one database or not (Win2k)? Where is the maximum? I want to work with dynamically created tables. Thanks, Peter Keine verlorenen Lotto-Quittungen, keine vergessenen Gewinne mehr! Beim WEB.DE Lottoservice: http://tippen2.web.de/?x=13 - 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: Efficiency Query
Greetings... MySQL can handle datas hundreds times greater then that very efficiently so dont you worry about handling 500 MB. My database has 8GB of data and it performs best. So dont worry. Rgds Insane - Original Message - From: Alberto Ruiz Cristina [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Monday, October 14, 2002 6:27 PM Subject: Efficiency Query Hi all I am new to MySql and I am thinking about using it for managing a database, which would have a approximated length of 500 Mb. It is formed of vectors. Trouble is that I am worried about the ability of MySql to handle that amount of data. Do you know about any article or study about MySql efficiency? If not, maybe you can just tell me your own experience. Thank you in advance! Alberto Ruiz Spain - 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: Use host
Greetings... Host tables are used to give privileges of a very esoteric type to user who are connecting from differnt host with differnt permissions. I think the MySQL documents, privilege section has a detailed working of host table. It is the best I have seen till now. Rgds Insane - Original Message - From: Alexander Burbello [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 14, 2002 9:53 PM Subject: Use host Hi, I would like to know when I use the table Host. Why does she exists? query, sql - 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: about use Dev-cpp and C++
Greetings.. Is iut necessary that you usee STL. Other wise MySQL C API are much more easy to maintain and program. Even SQLyog which I am a beta tester is written using MySQL C API and its very fast. Rgds Insane - Original Message - From: wang tianyi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 14, 2002 9:30 PM Subject: about use Dev-cpp and C++ hi i use windows2000/xp and Dev-cpp(a C++ compiler) , and want to connect with mysql, but now , i not know STL much. how can i do , who can show me a source code? thanks. i already download STLport ,but i not know how to use it ! :( - 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: index in mysql
When you specify a column with primary an index of name Primary is made on the column. For making a column unique, you have to first make a index on it which is of type UNIQUE. So automaticallt a index is made on it. Rgds Insane - Original Message - From: Inbal Ovadia [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, October 13, 2002 4:42 PM Subject: index in mysql Hi all, I have a quation about index: In mysql, if i create table table_name with column loc_name (and another columns), and the col_name has PRIMARY KEY and UNIQUE constraints, Is an index created atoumaticly on this column? Thanks, Inbal - 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: Storing results from a Query in an existing Table
Greetings.. The MySQL Documents will be a nice place. Maybe this will help if you want to copy all the data as well as columns from the - create table target_db.target_table select Country,Varietal,Producer,Vineyard,Year,Size from sourcedb.source_table (this will create the table with the existing datas ) to do only structure copy ( i.e without any data ) use the following SQL create table target_db.target_table select Country,Varietal,Producer,Vineyard,Year,Size from sourcedb.source_table where 1=0 Hope it helps. Insane SQLyog - The Definative Win32 GUI For MySQL http://www.webyog.com/sqlyog - Original Message - From: Tim Johnson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, October 12, 2002 10:33 PM Subject: Storing results from a Query in an existing Table Hello All: I have learned to extract columns from one table and create a new table from those columns-i.e: CREATE TABLE Wines SELECT Country,Varietal,Producer,Vineyard,Year,Size FROM AH; Now I would like to SELECT the same columns from other tables and append them to Wines. I have tried the following: LOAD DATA SELECT Country,Varietal,Producer,Vineyard,Year,Size FROM EUR INTO TABLE Wines; and MySQL finds me lacking in imagination ... :-( How may I accomplish this? And where is documentation on this topic? TIA -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.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: copy one database to another
Greetings... I dont think that there is any SQL statement to do that. As of changing the name, You can just go to the data directory of MySQL and change the name of the directory of the database. MySQL stores each database as a directoyr so changing the name of the directory will change the name of the database. I have tried this with MyISAM and ISAM tables, not sure of other table types. Rgds Insane SQLyog - The Definative GUI for MySQL http://www.webyog.com/sqlyog - Original Message - From: Scott Pippin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 11, 2002 4:25 AM Subject: copy one database to another I have one database(test) i would like to copy over to (test1). Ehat is the syntax to do this? Is there any to just change the name of the database? Thanks in advance (query, mysql) - 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: MySQL Search
Greetings... I am developing an application on MySQL using the MySQL API's. I have .sql file with 1 insert statement. I want to run all the queries in one shot. mysql_real_query() allows me to execute only one query at a time ? So what do you think is the best approach to execute all the queries in the most optimed way. Even the binary mysql allows to do that. How they do it? Sorry, I have not gone through the code of that software, due to constraint in time. Any help will be appreciated ? Greetings Insane - 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
How to find whether a key is fulltext
Greetings.. I am doing show keys from db.tablename but how can I know whether the key if fulltext or not. I get to know the key is unique or not by checking Not_Unique column in the returned resultset. How to find a key is fulltext. Thx Insane sql,query,mysql - 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 find whether a key is fulltext
Greetinsg... When I am doing show index from db.tablename, the columns I am gettings are - Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment Which one of these will tell me whether a key is fulltext or not. Rgds Ritesh SQLyog ( http://www.webyog.com ) The Definative GUI for MySQL - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Insanely Great [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 7:16 PM Subject: Re: How to find whether a key is fulltext At 18:19 +0530 10/1/02, Insanely Great wrote: Greetings.. I am doing show keys from db.tablename but how can I know whether the key if fulltext or not. I get to know the key is unique or not by checking Not_Unique column in the returned resultset. SHOW KEYS shows this information in the Index_type column. How to find a key is fulltext. Thx Insane sql,query,mysql - 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: MySQLGUI: Win32 zipped binary seems corrupted
Greetings.. Even the MySQLGui does not work for me. It is not getting downloaded. What should I do ? Insane SQLyog ( http://www.webyog.com/sqlyog ) The Definative GUI for MySQL - Original Message - From: Pavel Hlouek [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 30, 2002 11:34 PM Subject: MySQLGUI: Win32 zipped binary seems corrupted Hi, I've just tried to download the Win32 binaries of the MySQLGUI tool. I recieved about 50kB. When I tried to unpack the archive, WinCommander told me, that the zip archive is corrupted. Hope it helps, thanx guys for wonderfull MySQL. Pavel __ Reklama: E-mail zdarma na cely zivot: http://email.seznam.cz - 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: Urgent!!
Greetings... I believe that ASP works well with MySQL thru ODBC. As of learning other technologies it really depends what all you require. Still MySQL works best with PERL and PHP. Rgs Insane SQLyog ( http://www.webyog.com/sqlyog ) The Definative Front End for MySQL - Original Message - From: Ibrahim Al-Tawil [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 29, 2002 10:21 PM Subject: Urgent!! Hi, I have a certain task to be done, which is a Database Driven website based on MySQL operated on Linux, my Question is: Can I develope such a site using ASP (Active Server Pages)? So, I will avoid spending a lot of time in learning other technology instead of ASP. and also if there is special requirements in order to do it. Best Regards. I.M.A _ Send and receive Hotmail on your mobile device: http://mobile.msn.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
Setting Permission For Column Level Only
Greetings... I want to create a user which will have only Select privileges in two columns a particular table. For that I creates a entry in the User table in MySQL and set it as default with N in all. Also I entered some rows in the Columns_Priv table. Now my question is - Do I have to enter records in db and tables_priv table with the user name and all privileges set to N or default to make the column privileges work or if I enter a row in the columns_priv table, that will do. Rgds Insane SQLyog ( http://www.webyog.com/sqlyog ) The Definative Front End for MySQL - 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: Setting Permission For Column Level Only
Thx Well I have one more question What is the exact GRANT SQL statement for giving column level privilege. Whatever text I have read till now allow me to give table level privilege. I am unable to give a column level privilege. I have a db..product with tables prod_user and prod_detialsprod_user has three columns id, name, address. I want to give a user permission for select only on id, name and not on address ? Any ideas ? Insane SQLyog ( http://www.webyog.com/sqlyog ) The Definative Front End for MySQL - Original Message - From: Clayburn W. Juniel, III [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 30, 2002 7:00 AM Subject: Re: Setting Permission For Column Level Only On Sunday, September 29, 2002, at 10:17 24h, Insanely Great wrote: Greetings... I want to create a user which will have only Select privileges in two columns a particular table. For that I creates a entry in the User table in MySQL and set it as default with N in all. Also I entered some rows in the Columns_Priv table. Now my question is - Do I have to enter records in db and tables_priv table with the user name and all privileges set to N or default to make the column privileges work or if I enter a row in the columns_priv table, that will do. You have to enter data into the tables_priv table, but NOT the db table. I believe all the fields in the tables_priv table need to be filled except Table_priv. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.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: Copying a Table
Greetings... It is possible. Say for eg. If you want to copy the structure and data of the db table in mysql table. you can use the following statement - create table `db_copy` ( primary key ( Host, Db, User ) ) select * from `db` If you cant to copy only the structure then you can use a query like this - create table `db_copy` ( primary key ( Host, Db, User ) ) select * from `db` where 1 = 0 Hope It helps Insane http://www.webyog.com/sqlyog The definative GUI client for MySQL - Original Message - From: Shaun Bramley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, September 28, 2002 10:48 PM Subject: Copying a Table Hello all, I have yet to find this bit of information within the documentation. Is it possible to copy the contents of a table? If so how? Shaun mysql, query - 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: MySQL as a desktop DB
In also belive that MySQL is very good in a single environ ment. You can try out some very good GUI front end clients like MySQL-Front and SQLyog. Since MySQL-Front has been discontinued, SQLyog is a very good option. Insane - Original Message - From: Gerben Gieling [EMAIL PROTECTED] To: Michael T. Babcock [EMAIL PROTECTED]; David Lloyd [EMAIL PROTECTED] Cc: Adam Parker [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 12:54 PM Subject: RE: MySQL as a desktop DB The combination of Access front end with MySQL or PostgreSQL works great. However there is a disadvantage in using Microsoft Office applications. If you use Visual Basic code to program the behaviour of your front end (You probably will). The front end will run great until the next major update of MSOffice. It will again make a lot of changes without backward compatibility. This needn't be a problem If you are in control of the migration. But, if your IT department decides to migrate to a new version of MS Office catching you unprepared, your database will be without functional or with a misbehaving front end until you fix the code. I quit using Access and migrated my front end to Apache/PHP running on the same (linux) server as the database (an old pc found in the trashbin because it wasn't fast enough to run windows 95). -Original Message- From: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Sent: September 25, 2002 17:34 To: David Lloyd Cc: Adam Parker; [EMAIL PROTECTED] Subject: Re: MySQL as a desktop DB David Lloyd wrote: MySQL in a single user environment is a pain in the arse because of its lack of an Access Like front end that is actually useful and featureful (Access is crap, but it's a better database frontend than currently exists). I've never done it, but have you tried Access linked to MySQL through MyODBC? PS, SQL ... Query ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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: what about the stability?
Greetings... I believe MySQL is stable and fast enuf for your puprpose. And its pretty easy to start up. Insane - Original Message - From: Bence Szabo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 7:52 PM Subject: what about the stability? Hi, This is my first mail to mysql list, so sorry if it is a well known (answered) question. I read lot of articles, lists before and I can not decide what about the stability of mysql when I use tables with large numers of records and many sessions? Are there any experiences with it? (Our planned system about 5M records and intensive web based queryes, I don't know exactly estimated how many concurrent sessions) Thanks -- This mail sent by Bence Szabo [EMAIL PROTECTED] - 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: MySQL as a desktop DB
I think MySQL will be more faster in Desktop environment and if you are adverse to using the text based interface to MySQL then you can try out some GUI avaiable in the market. The best I know are MySQL-Front and SQLyog but since MySQL-Front has been discontinued you can try SQLyog at http://www.webyog.com/sqlyog Insane - Original Message - From: Adam Parker [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 3:11 AM Subject: MySQL as a desktop DB I currently use MS Access as a single-user desktop database. The database is getting quite large. The largest table has 300,000 rows. I am considering upgrading the database. How suitable is MySQL as a single-user desktop database? How does it compare to Access when it is used like this? Obviously MySQL would have advantages if I intended to use it as a server database with concurrent users. But is it faster than Access in the single-user environment, when dealing with large databases? Thanks for any help. - 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