Re: Database type question
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi! I guess you're not a subscriber of the MySQL Newsletter. Subscribe to it - it's very useful! Your question was answered a couple of days ago in ta newsletter article: http://www.mysql.com/newsletter/2002-12/a91.html Regards, Iikka On Thu, 19 Dec 2002, Richard E. Perlotto II wrote: I am looking at an application that will be could be potentially writing hundreds of records a second (syslog) to a MySQL database. I expect to reach millions of records (if not billions) in time. I will be doing a variety of types of queries on the data which will be anything from summarization of certain types of data to full pattern matching. So, my question is which of the database formats would be best suited for this type of environment? The MyISAM seem to work well on receiving the data, but the InnoDB database style seems better suited for the queries. Any ideas anyone? Richard - 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 Iikka Meriläinen Vaala, Finland E-mail: [EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE+AjNPCVGYZ+r4ZncRAvVOAJ4pswyFWizkCnSbHOv47HQmSip7hACbBiWT qzLWClrkqxVCroVNrp3Ob1o= =eIxR -END PGP SIGNATURE- - 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: win2k update
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Is there a patch update from .3 to .4? So that I don't have to reinstall it on my win2k box? If I have to reinstall it do I need to first uninstall .3 first? You have to reinstall. But that isn't a big problem - after new installation copy the data and configuration files into the new server and get going. You don't have to uninstall .3 (hmm.. what major version you might mean?) before installing .4. Don't reinstall into the same directory. If something goes wrong, you can always revert to the previous, working installation. Iikka Sh*t.. SQL QUERY Iikka Meriläinen Vaala, Finland E-mail: [EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE+AWq9CVGYZ+r4ZncRAi+cAJ4xixt3NX3C7tVsM9kBfsmZONOiGwCfWurj UKhCXx7Zs/mfAzANQ8IcfD0= =MW3d -END PGP SIGNATURE- - 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: INSERT
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, 8 Dec 2002 [EMAIL PROTECTED] wrote: I have a ntext data type on SQLServer7, and I have the following statement: ^^ First, cross-posting like this is stupid. Second, it's not needed. Third, (could be 1. + 2:) This is a MySQL list, not an MS SQL Server list. Please send your questions on MS SQL Server to sql_beginners list or to an appropriate newsgroup. People here are interested in MySQL. These messages only add noise to this list, as many people's expertise concentrates on MySQL, not other SQL implementations. Thanks, and Best Regards, Iikka ps. didn't want to be rude, but these questions are simply out of line here. :-) Iikka Meriläinen Vaala, Finland E-mail: [EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE99DhRCVGYZ+r4ZncRAnfRAJ913TLa41cAvKG8PeZKqnq0h7If/wCeKf/p atNdoENCDwzN4i4QTj7lz+o= =z34a -END PGP SIGNATURE- - 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: Replication between Windows MSSQL and UNIX MYSQL
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, 8 Dec 2002, shawn xu wrote: We have an application software which uses MSSQL 7.0 or 2000 server on Windows. Now we want to use the MSSQL as a master, and MYSQL on UNIX as a slave. How can we configure Windows MSSQL and UNIX MYSQL both sides to implement replication? Any idea? Thanks in advance. Hi, With the normal replication supported by MySQL OR the replication schemes (merge, transactional, snapshot) supported by MSSQL it's not possible. But have you tried to schedule certain DTS transformation on MSSQL that format the data properly and then send them to MySQL via ODBC? Iikka Iikka Meriläinen Vaala, Finland E-mail: [EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE99DkCCVGYZ+r4ZncRAu13AKCSK2DnfzQQq7TSY0lv7BniqVx5WQCeO/L/ uk3w+BU4KKUVzzWeaoRChy0= =TKr0 -END PGP SIGNATURE- - 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 port number
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 4 Dec 2002, R. Hannes Niedner wrote: On 12/4/02 9:04 AM, Mike At Spy [EMAIL PROTECTED] wrote: How can I tell what port number mysql is running on? I need it for a chat program. :) Default is 3306 And with -P=123 or --port=123 for mysqld you can specify any server port you'd like your server to run on. Regards, Iikka Iikka Meriläinen Vaala, Finland E-mail: [EMAIL PROTECTED] -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE97xG8CVGYZ+r4ZncRAkKuAJ9BlXVwcii5C/zep+g3kh3GTuu/3wCgl/H8 VCssqRZS8ggqiFdtqBI50is= =kbxs -END PGP SIGNATURE- - 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: My SQL
On Mon, 25 Nov 2002, Miki Tan wrote: Hello, I am Miki Tan from Gleneagles Medical Centre. I am interested in MySQL database development. 1.Can I know with platform is suit for MYSQL ? Hi, and welcome to the wonderful world of open-source database development! See this for platform notes: http://www.mysql.com/doc/en/Which_OS.html Linux, Solaris and Windows NT are good and easy choices. Iikka Iikka Meriläinen Vaala, Finland E-mail: [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
Re: Grant - questions
Hi! RTFM :-) These URLs will help you: http://www.mysql.com/doc/en/User_names.html http://www.mysql.com/doc/en/GRANT.html http://www.mysql.com/doc/en/Adding_users.html Iikka On Tue, 26 Nov 2002, Darryl Hoar wrote: Greetings, I created a database. I am having problems connecting to the database remotely. Getting Access Denied. If I log into the machine that the database is on and mysql -u darryl -ppassword I get in. If I try to connect from another machine, Access denied for [EMAIL PROTECTED]. How do I setup the username/permissions correctly for remote access ? thanks, Darryl - 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 Iikka Meriläinen Vaala, Finland E-mail: [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
Re: Is it possible to export data from access to MySQL?
Hi! Yes, it's possible. Export your Access data to standard csv files, and then use mysqlimport with appropriate parameters to import the csvs into MySQL. The MySQL manual has excellent guidance on using mysqlimport or LOAD DATA INFILE statements (which can do the same as mysqlimport). Iikka On Tue, 26 Nov 2002, Steve Jackson wrote: Is it possible to export data from MS Access into MySQL? If so how? I have a huge amount of data that will take weeks to input and I've convinced my boss to use MySQL rather than any other DB because of it's compatibility with PHP. However I (probably hastily) *assumed* that there would be a way to export the data. Any ideas? Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 - 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 Iikka Meriläinen Vaala, Finland E-mail: [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
Re: Where is 4.1 source
On Thu, 21 Nov 2002, Daniel Kiss wrote: Hi all, Where can I download MySQL version 4.1 source code? Hi, There are no 4.1 source distributions yet, see this: http://www.mysql.com/doc/en/Installing_source_tree.html You need to download the bits via BK. Iikka Meriläinen Vaala, Finland E-mail: [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
Re: mysql problem
On Wed, 20 Nov 2002, Francesco wrote: Hello, I tried to execute the following query: SELECT studenti.* FROM studenti,valutazioni LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid WHERE valutazioni.sid IS NULL; Hi! I think you don't have to specify valutazioni in the FROM subclause (is it the correct term?). SELECT studenti.* FROM studenti LEFT JOIN valutazioni ... Iikka and give me the following error message: ERROR 1066: Not unique table/alias: 'valutazioni' I have the Mysql 4.0.1 alpha version. I want to know what is the problem. ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Windows cnf file location
On Tue, 12 Nov 2002, John Chang wrote: Is there a good or bad reason to create the config file in the MySQL folder? IMHO, usually no. But if you have several differently configured server instances, it might make things more logical. On production servers which logs do you turn on? Error log (which is automatically on) and I also use slow query logging. For replication you need binary logging. Query logging is hardly needed on production machines (it slows things down, use it on your development box). Typically what things do you set on in the config file on a production server? http://www.mysql.com/doc/en/Server_parameters.html might help you. Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Windows cnf file location
Hi! On Tue, 12 Nov 2002, John Chang wrote: Where is the config file for MySQL on windows? Is that where I tell it to use a log file? By default is it off? Thank you. For example, in c:\winnt\my.ini or in c:\my.cnf You can specify a custom config file location to mysqld with the --defaults-file=c:\blah.cnf parameter. You can configure mysqld to use a log file by adding a line log into my.cnf. Query logging is off by default, indeed. Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: password MYSQL
Hi! First, try connecting from the command-line mysql client. mysql -u root -p -h ser.ver.ip.addr Then enter your password (if you don't have a root password you can dismiss -p) Also, if that works, try resetting cookies from your browser, as phpMyAdmin relies on cookie authentication. Iikka On Tue, 12 Nov 2002, John Chang wrote: I just changed the root password for MYSQL from the default and now it gives me the error Access is denied when I try to connect using phpMyadmin. It doesn't even ask for a password. How can I login in? Thank you. - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: mysqld refuse to die
On Sat, 9 Nov 2002, Jack Chen wrote: I have just figured out: kill -9 xxx (process number) Hi! Did you try just 'kill xxx'? How about 'mysqladmin shutdown'? 'kill -9' is an extremely cruel way to bring a server down. You may get corrupted databases that way, although sometimes it's the only option. Regards, Iikka On Sat, 9 Nov 2002, Jack Chen wrote: Hi All, Please help me with this problem: For some reason, I could not bring down my mysqld by running mysqld stop An error message indicate: fail What's going on? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: mysqld_multi
On Thu, 7 Nov 2002, Chris Raymer wrote: Yes, that is what I meant. Thank you for the clarification and response. Any ideas on maximizing *server* performance besides the usual db-specific optimizations like indexing? If not too much trouble, could you give me a brief explanation why I would not see a performance boost if running separate servers on the same box? My thoughts, if have one MySQL server running on one box with 10 databases, and 1 or 2 of those databases are getting the majority of the requests and tying up the processes, seems like the other 8 would suffer. Hi! You can think of server instances as you'd think of databases. If one server instance (say, that with one or two heavily-loaded databases) gets a lot of requests, the other server instances suffer. With separate server instances you'll suffer from additional overhead. If you require different server configuration for different databases, then you'll have to install two or more separate server instances. Hope this clears it. :-) Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: mysqld_multi
On Wed, 6 Nov 2002, Paul DuBois wrote: At 13:22 -0600 11/6/02, Raymer, Chris wrote: Any opinions on running mysqld_multi? Our architecture, X-serve, 2GBs RAM,Dual Procs, 480 GB stogage as Master MySQL server replicated to a less impressive server. Seems logical to separate the heavy-hitter dbs to their own servers and take more advantage of the server's resources. What's this got to do with mysqld_multi, which is used for running multiple servers on the *same* machine? Hi! Maybe Mr. Raymer means that he would get more performance when running multiple _MySQL_ servers (i.e. instances) on a same _physical_ server (i.e. box). Getting more performance this way is unfortunately a false assumption, though. More stability, perhaps, but not performance. Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 service on linux
On Tue, 29 Oct 2002, Natale Babbo wrote: Hi all, I'm using Linux Suse 8.0. I copied the file mysql.server located in /usr/local/mysql/support-files to /etc/init.d directory. I made a simbolic link to mysql.server script in /etc/init.d/rc3.d but MySQL doesn't appear to start at the boot time. Anyone can help me? Hi! Try starting mysqld with --console --standalone parameters and see if it starts at all. If yes, you've got a problem with your startup scripts. Check any paths in those and check that your symbolic link works. Also try running the script in /etc/init.d/rc3.d (the symbolic link in this case) manually after the system startup. Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Multiple MySQL running
Hi! Just specify different ports, data and base directories for those instances (using command-line parameters -P, --basedir and --datadir respectively, for example). Instance 1 startup: mysqld-nt -P=3306 --basedir=e:/mysql1 --datadir=e:/mysql1/data --console --standalone Instance 2 startup: mysqld-nt -P=3307 --basedir=e:/mysql2 --datadir=e:/mysql2/data --console --standalone If I remember this right, you can do this with services on Windows, too, but it will get trickier then. On *nix change the paths, but it should work the same way otherwise. mysqld-nt changes to mysqld. Best regards, Iikka On Tue, 29 Oct 2002, GAY Samuel wrote: Hi, I'm a new user of MySQL (but not of databases...), and new member of this mail-list, and I hope I don't bother anyone with a question already asked (and with my english...). I'm interested in the InnoDB part of MySQL because I thing it's more reliable than other table's type, and because it provide transactions. I have to use multiple database on the same serveur, but not in the same InnoDB structure. Then I have to create one MySQL instance for each database. If one crashes the others could run, and I can easely move a database on another serveur if needed. The documentation speek about recompiling MySQL to do this... it surprises me, I think I didn't understand something. How can I run multiple instance of MySQL on one server (like Oracle) ? Thanks in advance. Sam. - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: root password
On Sat, 26 Oct 2002 [EMAIL PROTECTED] wrote: Hi, I am learning MySql and was going through the manual.html in the /usr/share/doc/mysql.../Docs/ I know SQL already and made some changes to the user table of mysql database. The server is running but I cant get a privileged access. I changed password=y for root user. Now the hostname.err (in my case munshi.err) says that Hi, On SQL level, one should change his/her password by using the PASSWORD() function. Like this: UPDATE USER SET password=PASSWORD('blah') WHERE user='root'; Not sure how you changed it, but this is the better way. Then FLUSH PRIVILEGES; See below for a solution for your problem. :-) 021026 13:03:43 mysqld started 021026 13:03:44 Found invalid password for user: 'root@localhost'; Ignoring user 021026 13:03:44 Found invalid password for user: I guess that I need to change the password somewhere, but I cant access the mysql databsae, Thanks in advance. Start mysqld with --skip-grant-tables and reset your passwords. Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 :-)
On Mon, 28 Oct 2002 [EMAIL PROTECTED] wrote: This has probably been asked a thousand times before but only once from me. I am able to programme in MS Access to quite a high level to which I have now realised its limitations, where is the best place to start learning and reading up on MYSQL, I am not really a book reader as I prefer to do things by trial and error but have not got a clue as to how mysql works Hi! See www.mysql.com/doc There is a tutorial section in the manual, it's not a big one, but you should be able to get started with it. The reference manual is excellent for further learning, too. Paul DuBois's book 'MySQL' is also very good. Also, searching Google with these 'mysql tutorial' will help... :-) Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: backups without revealing password
On Mon, 28 Oct 2002, David T-G wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all! I would like to dump my mysql databases to cold files for separate backups; we're too cheap to buy the database agent that will do it live. I started with mysqldump --user=root --password=showtheworld --all-databases ... as I've seen in numerous scripts posted to this list, but of course that shows the world my DB root password if you happen to run top at the right time (or are the adventurous type who might run a script to, say, look for and log any mysql commands). My next step was to create dumpster user with no password grant select on *.* to dumpster@localhost so that I can run mysqldump --user=dumpster --all-databases ... and at least protect all of my writing privs -- but now the DB id of a user that can obviously read every bit of data in there is also exposed. What I need is a way to connect to the database from a cron job without exposing the password in the environment. What amazes me is that even confidential databases at large companies are accessed through scripts with the passwords embedded -- and the scripts are often world-readable! Is there anything analagous to an ssh key pair so that only an OS user connecting with the DB id private key can get in to do the select and run the mysqldump? Or am I barking up the wrong tree and should I instead do something else to cleanly and securely back up the databases? Hi! See http://www.mysql.com/doc/en/Secure_connections.html and its subsections. I think GRANT ... REQUIRE X509 and x509 certificates could help you. Even then you have expose your password but it won't help a cracker as he doesn't have your certificate. I haven't used this personally, and the documentation is pretty thin on this subject, unfortunately. Best regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 MySQL server from remote windows m/c
On Mon, 28 Oct 2002, aman mysql wrote: Hi all How do I access a remote MySQL server (on LINUX platform), from a windows application. What drivers I need to download and from where? Hi! You don't need any special drivers. Just the MySQL command-line client will do the job. It can be downloaded from www.mysql.com along with the server package. How do I set permissions on the mysql server to let be accessed by the remote windows machine. See http://www.mysql.com/doc/en/GRANT.html for details on how to set up new users and permissions. You'll need something like GRANT all ON *.* TO yourusername IDENTIFIED BY 'yourpassword'; This will give your users a broad set of permissions, please have a look at the docs if you want to restrict those. Best regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 stop the mySQL service ?
On Mon, 28 Oct 2002, Alice Tan wrote: run in the DOS, i got this error .. am i doing wrongly ? C:\mysql\binmysqladmin shutdown mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'ODBC@localhost' (Using password: NO)' Hi, mysqladmin -u root -p shutdown And then enter your root password. Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: RedHat 8 and mysql-server-3.23.52-3
On Wed, 23 Oct 2002, Gelu Gogancea wrote: My dear friend, Same to you TCP/IP is a protocol with KNOWLEDGE at ICMP level(see RFC792 ). The DNS server have a different purpose(see RFC 1034 or RFC 952 HostNames table). Ping work at ICMP level. Well well.. but it can't send ICMP echo packets to a hostname. Even ICMP knows nothing about pure hostnames. The KERNEL is responsible about what is happened in the OS including the TCP/IP protocol. The TCP/IP IPV4/IPV6 and functions like socket(),accept(),listen(),bind()...etc are implemented on the KERNEL Did I say they werent? level...also the sockaddr structure type and many others. Functions like gethostbyname(),gethostbyaddr(),res_init,res_query()...etc and hostent structure type are implemented in glibc. Correct. Without all this, the TCP/IP communication CAN NOT EXIST. MySQL have the own way/functions for resolving hostnames but which is based on the glibc functions. The glibc defines the SYSTEM CALLS and others functions and it used by the C/C++ compiler. In fact by adding IP address in /etc/hosts, the glibc function gethostbyaddr() reserve the RIGHT MEMORY SIZE FOR IT(seems to be a recast to int type). If the IP address/Alias is not present in hosts, this function make an wrong allocation memory and for this MySQL daemon is crashed. That's it. Seems to be. Got it. :-) In my previous e-mail i don't say nothing about Domain Class(A,B,C) or canonical name or reverse lookup or other things which is on DNS responsibility.I try to say about how it work and was my wish to not to be too technical. Not in those words, but you talked about host resolving. That is certainly DNS functionality. You talked about SERVER... it can be understood in many different ways. But it seems to me that this issue is resolved and over. Best regards, Iikka - Original Message - From: Iikka Meriläinen [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 2:11 PM Subject: Re: RedHat 8 and mysql-server-3.23.52-3 Hi! On Wed, 23 Oct 2002, Gelu Gogancea wrote: Hi Iikka, My opinion: Doesn't matter what type of client it is(whatever OS).TCP/IP it's the same for all.One property of the SERVER it to resolving hosts.And this is done by IP-hostname mapping/resolving is usually done by DNS servers, not the MySQL server, assuming that they're not running on the same box. :-) There are several ways for resolving addresses. using KERNEL functions.By adding in hosts file(in the SERVER MACHINE) the IP address of the client machine which want to connect to the SERVER, help SERVER for resolving the hostname.KERNEL make a lookup to the hostnames which is associate with the IP address. AFAIK, IP-to-hostname mapping isn't done by _kernel_ functions. At least the Linux kernel knows very little about hostnames. Some exotic Unixes may implement this differently, but no operating system I'm aware of has kernel interfaces for name resolution. Making the server recognize the client correctly with an updated /etc/hosts seems logical enough. It's strange, though, to have to make changes on the server for clients to be able to connect. For using this functions IS NEED TO HAVE the properly system call library which is(in this case) GLIBC.2.2.40.If some incompatibilities(BUGS) exists between this, a lot of problems can be raised after compilation.For this reason EGOR send a strongly message to all to make a downgrade to a version of glibc which is stable. Here you get it right. glibc is much more responsible for ip-hostname-mapping than the operating system kernel itself. Kernel implements the IP protocol with dotted-format addresses, and it expects user-mode libraries to do any necessary conversions. That is, when you do this: ping www.google.com the ping binary calls a couple of conversion functions in user-mode libraries so that it can pass a real IP address to the kernel/protocol interface. - 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: RedHat 8 and mysql-server-3.23.52-3
Hi! On Wed, 23 Oct 2002, Gelu Gogancea wrote: Hi Iikka, My opinion: Doesn't matter what type of client it is(whatever OS).TCP/IP it's the same for all.One property of the SERVER it to resolving hosts.And this is done by IP-hostname mapping/resolving is usually done by DNS servers, not the MySQL server, assuming that they're not running on the same box. :-) There are several ways for resolving addresses. using KERNEL functions.By adding in hosts file(in the SERVER MACHINE) the IP address of the client machine which want to connect to the SERVER, help SERVER for resolving the hostname.KERNEL make a lookup to the hostnames which is associate with the IP address. AFAIK, IP-to-hostname mapping isn't done by _kernel_ functions. At least the Linux kernel knows very little about hostnames. Some exotic Unixes may implement this differently, but no operating system I'm aware of has kernel interfaces for name resolution. Making the server recognize the client correctly with an updated /etc/hosts seems logical enough. It's strange, though, to have to make changes on the server for clients to be able to connect. For using this functions IS NEED TO HAVE the properly system call library which is(in this case) GLIBC.2.2.40.If some incompatibilities(BUGS) exists between this, a lot of problems can be raised after compilation.For this reason EGOR send a strongly message to all to make a downgrade to a version of glibc which is stable. Here you get it right. glibc is much more responsible for ip-hostname-mapping than the operating system kernel itself. Kernel implements the IP protocol with dotted-format addresses, and it expects user-mode libraries to do any necessary conversions. That is, when you do this: ping www.google.com the ping binary calls a couple of conversion functions in user-mode libraries so that it can pass a real IP address to the kernel/protocol interface. Personally, i can't do that because i have installed and others applications which require this version(2.2.40) of glibc.For me was a compromised solution because i use Red Hat 8.0 and MySQL 4.0.4 for testing purpose.My applications run under Suse 7.x with MySQL 3.x (MyISAM). The problem was for who which make have installed MySQL from Source Distribution or Red Hat distribution. I hope you understand exactly what i try to say.Unfortunately (for me),my english is not so good . Yep, I saw it. :-) But got your point anyway though. Best regards, Iikka - Original Message - From: Iikka Meriläinen [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 9:25 AM Subject: Re: RedHat 8 and mysql-server-3.23.52-3 On Tue, 22 Oct 2002, Gelu Gogancea wrote: Hi, No.On the server machine.The hosts is the way for resolving hostnames.In other Unix system, like SCO, to put the IP address and the alias in hosts is indispensable. Well, I meant that the client machine in this case seems to be a *NIX, so the /etc/hosts of _that_ machine should be updated. Of course, depending on where the error comes from. In this case it seems to be on the client side - although the client computer seems to be running Unix. Iikka - Original Message - From: Iikka Meriläinen [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 3:01 PM Subject: Re: RedHat 8 and mysql-server-3.23.52-3 On Tue, 22 Oct 2002, Gelu Gogancea wrote: Hi, Try to put in the /etc/hosts the IP address of the machine which must connect to the server. Hi! I guess you mean the /etc/hosts on the client machine? Right? Also, updating your real DNS records might prove useful in the long run. Best regards, Iikka I have recently installed RedHat 8 and the following RPMs: [root@chimp etc]# rpm -q mysql mysql-3.23.52-3 [root@chimp etc]# rpm -q mysql-server mysql-server-3.23.52-3 I am having problems connecting to the server remotely through the TCP connection, the firewall is completely disabled: njc2@hilton njc2/mysql/bin mysqladmin -h chimp.battlemonkey.net -p version Enter password: mysqladmin: connect to server at 'chimp.battlemonkey.net' failed error: 'Lost connection to MySQL server during query' I can connect fine from the localhost to the socket: [root@chimp etc]# mysqladmin version -p Enter password: mysqladmin Ver 8.23 Distrib 3.23.52, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.52-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock
Re: RedHat 8 and mysql-server-3.23.52-3
On Tue, 22 Oct 2002, Gelu Gogancea wrote: Hi, No.On the server machine.The hosts is the way for resolving hostnames.In other Unix system, like SCO, to put the IP address and the alias in hosts is indispensable. Well, I meant that the client machine in this case seems to be a *NIX, so the /etc/hosts of _that_ machine should be updated. Of course, depending on where the error comes from. In this case it seems to be on the client side - although the client computer seems to be running Unix. Iikka - Original Message - From: Iikka Meriläinen [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 3:01 PM Subject: Re: RedHat 8 and mysql-server-3.23.52-3 On Tue, 22 Oct 2002, Gelu Gogancea wrote: Hi, Try to put in the /etc/hosts the IP address of the machine which must connect to the server. Hi! I guess you mean the /etc/hosts on the client machine? Right? Also, updating your real DNS records might prove useful in the long run. Best regards, Iikka I have recently installed RedHat 8 and the following RPMs: [root@chimp etc]# rpm -q mysql mysql-3.23.52-3 [root@chimp etc]# rpm -q mysql-server mysql-server-3.23.52-3 I am having problems connecting to the server remotely through the TCP connection, the firewall is completely disabled: njc2@hilton njc2/mysql/bin mysqladmin -h chimp.battlemonkey.net -p version Enter password: mysqladmin: connect to server at 'chimp.battlemonkey.net' failed error: 'Lost connection to MySQL server during query' I can connect fine from the localhost to the socket: [root@chimp etc]# mysqladmin version -p Enter password: mysqladmin Ver 8.23 Distrib 3.23.52, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.52-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 2 min 21 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.007 This is the first part of /etc/my.cnf. [client] #password = your_password port= 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port= 3306 socket = /var/lib/mysql/mysql.sock skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= table_cache=64 set-variable= sort_buffer=512K set-variable= net_buffer_length=8K set-variable= myisam_sort_buffer_size=8M log-bin server-id = 1 Could it be something to do with the startup/stop script because I noticed something else odd. The script works for starting the daemon: [root@chimp etc]# /sbin/service mysqld start Starting MySQL:[ OK ] But not for stopping it: [root@chimp etc]# /sbin/service mysqld stop Stopping MySQL:[FAILED] I can only stop the daemon with: [root@chimp etc]# mysqladmin -p shutdown Thanks in advance, nicholas calugar - 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: RedHat 8 and mysql-server-3.23.52-3
On Tue, 22 Oct 2002, Gelu Gogancea wrote: Hi, Try to put in the /etc/hosts the IP address of the machine which must connect to the server. Hi! I guess you mean the /etc/hosts on the client machine? Right? Also, updating your real DNS records might prove useful in the long run. Best regards, Iikka I have recently installed RedHat 8 and the following RPMs: [root@chimp etc]# rpm -q mysql mysql-3.23.52-3 [root@chimp etc]# rpm -q mysql-server mysql-server-3.23.52-3 I am having problems connecting to the server remotely through the TCP connection, the firewall is completely disabled: njc2@hilton njc2/mysql/bin mysqladmin -h chimp.battlemonkey.net -p version Enter password: mysqladmin: connect to server at 'chimp.battlemonkey.net' failed error: 'Lost connection to MySQL server during query' I can connect fine from the localhost to the socket: [root@chimp etc]# mysqladmin version -p Enter password: mysqladmin Ver 8.23 Distrib 3.23.52, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.52-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 2 min 21 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.007 This is the first part of /etc/my.cnf. [client] #password = your_password port= 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port= 3306 socket = /var/lib/mysql/mysql.sock skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= table_cache=64 set-variable= sort_buffer=512K set-variable= net_buffer_length=8K set-variable= myisam_sort_buffer_size=8M log-bin server-id = 1 Could it be something to do with the startup/stop script because I noticed something else odd. The script works for starting the daemon: [root@chimp etc]# /sbin/service mysqld start Starting MySQL:[ OK ] But not for stopping it: [root@chimp etc]# /sbin/service mysqld stop Stopping MySQL:[FAILED] I can only stop the daemon with: [root@chimp etc]# mysqladmin -p shutdown Thanks in advance, nicholas calugar ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Privileges - Does Anybody knows how to answer to me?
On Tue, 15 Oct 2002, Alexander Burbello wrote: Hi, I read the book, but there is not explain about it. I would like to know when I give privileges to the user, in the table level, and after I give privileges in the database level. Do I replace the privileges? There are two tables ('db' and 'tables_priv') in mysql database. I gave privileges, for example, to the table 'tables_priv', I give only 'select' privilege to the table Tb01. But I give other privileges, now to the table 'db'. I gave 'insert', 'delete' and 'update' privileges to the database 'Test'. Now the user has privileges to: - 'select' the table 'Tb01' - ''insert', 'delete' and 'update' the database 'Test'. Right --- What can he do? Can he insert or delte on the table tb01? Can he select data in all the tables of the database 'Test'? Hi! Well, testing that ought not to be too difficult. ;-) Just run a couple of statements as those users and see what they can accomplish. MySQL states pretty clearly when you don't have sufficient access to something. Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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
On Mon, 14 Oct 2002, Alberto Ruiz Cristina wrote: 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. Hi, Honestly speaking, 500 mb of almost _any_ data is nothing for MySQL. It can handle even several hundreds of gigabytes of data, assuming it is well organized and the queries are optimized. Do you know about any article or study about MySql efficiency? If not, maybe you can just tell me your own experience. My own experience is limited to fairly small systems, but I guess that for example, Mr. Jeremy Zawodny (an active participant on this list) could tell more about using MySQL in _really_ high-loaded systems. See any of his signatures for examples.. ;-) Quite impressive numbers, there. Anyway, MySQL efficiency is awesome. If you don't really require transaction support in your application, consider using MyISAM as your table handler. Best regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Diferences between check and analyze
On Mon, 14 Oct 2002, Alexander Burbello wrote: I make always confuse, what is the diference between the command CHECK and ANALYZE. Hi, ANALYZE TABLE checks through and updates the key distribution information of a table (affects join order). CHECK TABLE check the table for errors. It also updates key statistics for MyISAM tables. CHECK TABLE equals myisamchk -m [table] with MyISAM tables. All of this can be found on the manual, too. And much more, actually. Best regards, Iikka Oh by the way: SQL ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Default data dir
On Mon, 14 Oct 2002, Niranjan Patel wrote: I get that point but is there any other way we can change the path . Hi, You can reposition your entire data directory by using the --datadir=/path/to/new/data/dir command line parameter to mysqld. This repositions all databases, and you have to copy the directory structure under the current data directory into the new directory (permission tables, for example). Best regards, Iikka Thanks Niranjan --- Jeff Kilbride [EMAIL PROTECTED] wrote: You can relocate an entire database with a symbolic link: ln -s /path/to/database/files /var/lib/mysql/database_name --jeff - Original Message - From: Niranjan Patel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 14, 2002 10:50 AM Subject: Default data dir Hello In my case Default data files directory is /var/lib/mysql. I want to store all files of one database in another directory. Is there a way we can specify data directory per database. Or else can we change the entire data directoy of mysql. I tried to change it using my.cnf but I guess i missed something. can someone point me to exact steps Thanks Niranjan __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.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 __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 Tables across machines
On Mon, 14 Oct 2002, Dennis wrote: Is there a way to copy a table from one mySQL machine to another without implementing replication? The goal is be able to grab a copy of a table from some other machine (without regard to master/slave relationships) in some programmatic way without having to do a dump, copy file and rebuild. Something like: Copy Server:dbase:table to localhost:dbase:table Hi, I've never tried this in real life, but I can't see why xcopy data\db\*.* (frm/MYD/MYI for MyISAM tables) server2\data\db The file copying across the network could be done via FTP, SMB or anything that is good for your platform. Not sure on this either, but do platforms/OSes with 32/64-bit stuff cause problems? How about the byte order? Anyone wiser than me, please comment on this! :-) Have you tried building a script that automates the mysqldump process? Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: information about the tables in the database
On Wed, 9 Oct 2002, Inbal Ovadia wrote: Hi all, There is a way to know if I have table x in my db? Let's say some catalog tables that hold information about the db like tables name etc. and i can do query like select tables from catalogName and get all the tables in the db Hi, I guess that's not possible. SHOW TABLES shows your tables in the database, but unfortunately you can't do something like SELECT * FROM (SHOW TABLES) WHERE Tables_in_xx = 'blahblah' Of course you can create a table that contains metadata for your tables, but you would have to update it manually. Or you could have an external program scanning your data directories for added/removed table files. Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: information about the tables in the database
On Wed, 9 Oct 2002, Brian Reichert wrote: On Wed, Oct 09, 2002 at 03:43:15PM +0200, Inbal Ovadia wrote: Hi all, There is a way to know if I have table x in my db? Let's say some catalog tables that hold information about the db like tables name etc. and i can do query like select tables from catalogName and get all the tables in the db 'show tables' But can you do a SELECT on the result set from that statement? Please let me know if it's possible. Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: startup on win2000 as service not working.
On Tue, 8 Oct 2002, Steve Bradwell wrote: Hi everyone, I have recently moved my mysql server from a win98 machine to a win2000 machine. After running the self extracting setup for mysql, I copied my existing my.ini file over from the win 98 box, made neccesary changes to start mysqld-max-nt from correct dir, I copied the my.ini file because of the Innodb settings I had setup on the win98 machine. I then copied over my Ibdata, and IbLogs directories and their contents to the win2000 box, and the replaced the data directory with the one from the 98 box. I then started mysql from the command prompt with mysqld-max-nt --console it said ...Innodb: Flushing modified pages from the buffer pool... Innodb: Started Ready for connections... And all works fine, however when I restarted the pc, and winmysqladmin.exe was started as a service, the server is not started, I get the red light and no server, or table information. If I then go and start it through the console and run winmysqladmin.exe All my information appears like normal. Can anyone suggest what I should do? Hi, Run mysqld-max-nt --install first in order to install your new MySQL as a service. Then it should work, at least you should be able to start the service by entering 'net start mysql'. Best regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Limiting size of individual databases?
On Tue, 8 Oct 2002, Jesse Sheidlower wrote: I'm sure this is a common requirement, but the only thing I could find in the docs or in a book or two was an unanswered version of the same question at http://www.mysql.com/doc/en/CREATE_DATABASE.html . I'm setting up MySQL on a small ISP and would like to be able to restrict the size of individual databases to something like 25M. What's the best way of getting this done? The server is running Solaris, if it's necessary to do it through the OS insteady of through MySQL. Hi, Unfortunately you'll have to use Solaris disk quotas for that. Make sure that the table files of each restricted-space user count towards their personal quotas. This means that you have to create a separate OS account for each user you want to restrict with the quota. This also means that the table files must be owned by those restricted users. I hope this quota feature will be added into MySQL in the future. Best regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: startup on win2000 as service not working.
Hi, First run 'mysqld-nt --remove' then 'mysqld-max-nt --install' This removes the old installation of the service and then inserts a new InnoDB-enabled registration. Iikka On Tue, 8 Oct 2002, Steve Bradwell wrote: Hi, I checked the path, it is correct. I also tried from c:\mysql\bin\mysqld-max-nt --install and got the following, The service already exists! The current server installed: C:/mysql/bin/mysqld-nt.exe So what I can tell is I am not running mysqld-max-nt like I thought I was, but my.ini has all my Innodb definitions. Any idea of what I should do, again if I start mysqld-max-nt --console from command prompt The server runs fine and when I start winmysqladmin.exe, all server info is correct including databases etc, however when I restart the pc, and winmysqladmin.exe starts from the startup folder the server does not start. Thanks again, Steve -Original Message- From: Bruce Lewis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 12:10 PM To: Steve Bradwell; [EMAIL PROTECTED] Subject: Re: startup on win2000 as service not working. Check your ini file to make sure the path reflects the proper location of the database. Bruce - Original Message - From: Steve Bradwell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 8:14 AM Subject: startup on win2000 as service not working. Hi everyone, I have recently moved my mysql server from a win98 machine to a win2000 machine. After running the self extracting setup for mysql, I copied my existing my.ini file over from the win 98 box, made neccesary changes to start mysqld-max-nt from correct dir, I copied the my.ini file because of the Innodb settings I had setup on the win98 machine. I then copied over my Ibdata, and IbLogs directories and their contents to the win2000 box, and the replaced the data directory with the one from the 98 box. I then started mysql from the command prompt with mysqld-max-nt --console it said ...Innodb: Flushing modified pages from the buffer pool... Innodb: Started Ready for connections... And all works fine, however when I restarted the pc, and winmysqladmin.exe was started as a service, the server is not started, I get the red light and no server, or table information. If I then go and start it through the console and run winmysqladmin.exe All my information appears like normal. Can anyone suggest what I should do? Thanks alot, Steve. - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Mysqld to listen from an other port than 3306 (2)
On Mon, 7 Oct 2002, Stéphane Pinel wrote: What is the best strategy to make mysqld listen from another port than 3306 ? In fact we have 2 servers that handle mysql. The first is listening at port 3306 but we need that the second one listen from another port in order to run in our local network IP Port Mapping What is the simple way to do that ( MacOS X ). Hi, Consider using --port=1234 parameter to mysqld. Also, if Mac OS supports it, you can specify those parameters along with numerous others in my.cnf. Best regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: GRANT question
Hi, Yes, you're right. GRANT and REVOKE do not need FLUSH PRIVILEGES afterwards. Flushing is only needed when manually updating the grant tables via normal INSERT/UPDATE/DELETE commands. Regards, Iikka On Wed, 2 Oct 2002 [EMAIL PROTECTED] wrote: If i use GRANT and REVOKE to change user privileges, it is my understanding that i don't have to issue a FLUSH PRIVILEGES statement. Is this correct? Our sysadmin rebooted the MySQL server this morning, and there were some privilege problems afterward. I had to reset the privileges for some mysql users. The only thing i can think of is that there were some pending privilege changes that were read by mysqld for the first time when the server restarted. any other theories about why this would happen? regards, sean peters [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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 on SQLyog
On Tue, 1 Oct 2002, Kevin Tsay wrote: Dear Listers: I've installed MySQL over my Linux (RedHat 7.3) and SQLyog over my laptop. When I start SQLyog and type in the mySQLHostAddress: 10.0.5.210 User Name: root Password: Port: 3306 Itis giving me the error: Host 'kevin.sitesmith.com' is not allowed to connect to this MySQL server. Do I need to setup or change anything on MySQL DB in order for this connection to go through ? Hi, You need to grant the root user access to your server from the host you're trying to connect from. See the Technical Reference on GRANT statement for help on how to do that. Best regards, Iikka Thanks --Kevin - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Table says it is read only but it is not from file system level
On Tue, 1 Oct 2002, Rochester, Dean wrote: I am running an sql insert against a mysql table version 3.23.52 When from the file system level the table has the following permissions. rw-rw-r-- table.frm rw-rw-r-- table.MYD rw-rw-r-- table.MYI Hi, Please verify that the user mysqld runs as has access to those tables. Somehow you didn't show us the owners and groups of those table data files. For example, running as 'mysql' user, doing 'chown mysql *' will suffice. BTW, the whole data directory should be owned by the mysqld-running user. Regards, Iikka When the sql runs it says the table is read only. I am connecting to the table as root and I have set the password too. I am using java to do this sql operation. I can select items from the table, but can not insert them. Thanks in advance Dean-O - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Please Help!
On Tue, 1 Oct 2002, DeNewbie wrote: I am a newbie and I am having a chronic problem getting mysql started up and running. I got so frustrated that I uninstalled the mysql rpms and started over again but its hasn't helped my situation. My whole problem revolves around mysql_install_db setup. This is what I am doing and its simply giving me problems. All I want to do is enter the root and host paswords but I can't get past the root password setup. PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root password 'new-password' I input this; cords-orj86jfje:/usr/bin # mysqladmin -u root password sqlpass mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! How do I correct this situation. Why am I having such a hard time entering these passwords. I can't even enter the root password. I'm nearly giving up. Hi, Really, please check that the server itself _is_ running _and_ the socket file exists at the mentioned location. If the server is down, start it in your mysql directory by entering bin/mysqld_safe (if using MySQL 4.x) or bin/safe_mysqld (if using 3.xx). Regards, Iikka ps. The manual has a section on those can't-connect things (at least I think I've seen this somewhere before). ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 a quotas?
On Mon, 30 Sep 2002, Victoria Reznichenko wrote: Jiri, Sunday, September 29, 2002, 11:18:51 PM, you wrote: JM I'm solving problem how to set up quota on MySQL db. I've look for that JM in mailing lists and docummentation but with no success. JM Can someone help me with this problem? You can do it using disk quotas. Just out of curiosity, how will the user know whether the disk was full (quota exceeded) or has other errors occurred when he/she, for example, inserts a row that doesn't fit into the quota? After reading the manual on full disk conditions, I got the picture that the inserting thread gets stuck, and checks for free space once in a minute. Does the user running the inserting thread get a specific error, others thatn a note in the error log? Best regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: automating import process
On Sun, 29 Sep 2002 [EMAIL PROTECTED] wrote: The script so far is like this: ./mysql -u 'root' -ppassword use import_test1; When it executes, it just waits at the mysql prompt. It does not seem to recognize that I want to input use import_test1; Can anyone help? Sure! You have to create a script file that contains the SQL statements you are about to run. ./mysqld -u root -ppassword myscript.sql Edit myscript.sql to contain your SQL code. Best regards, Iikka Thanks. Peter On Fri, 27 Sep 2002, [ISO-8859-1] Iikka Meriläinen wrote: Hi, use this: mysql -u root -ppassword It's important NOT to put a space between -p and the real password. Having a password in a script is unsafe at its best, though. I'm not sure if you have any other options than to put it that way or enter it manually each time you run the script. Regards, Iikka On Sat, 28 Sep 2002 [EMAIL PROTECTED] wrote: Hi Carl, Thanks for your reply. I have created a shell script but I get stuck on the part where it asks to input password. How do I get the script to input the password that I put in? So far my script looks like this: ./mysql -u 'root' -p echo abc The script executes, but it just waits for the password after it executes the line: ./mysql -u 'root' -p Can anyone help with this? Thanks. Peter On Mon, 5 Aug 2002, Carl McNamee wrote: I'm assuming that you are using some form of unix in this. From the system prompt type mysql -u root -ppassword import_test1. If this works just put it into a script (bash, perl, whatever) and run it either from the command line or via cron if you want it automated. Carl McNamee Systems Administrator Billing Concepts (210) 949-7282 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 03, 2002 11:58 PM To: [EMAIL PROTECTED] Subject: automating import process Hi, I want to try to automate a phonebook list import process into MySQL database. The phonebook was originally created with MS Access and exported into a text file. I upload that text file onto my server and I proceed with the following import process. Using Telnet I type: # ./mysql -u 'root' -p It then asks Enter password: I then select the database to use mysql use import_test1; I delete the previous phonebook list table because the import process does not know that it should replace the previous records even though there have been changes mysql use import_test1; mysql exit Bye I then import by doing the following: [root@ns2 bin]# ./mysqlimport --local -u root -p --fields-terminated-by=, import_test1 phone2.txt Enter password: import_test1.phone2: Records: 53 Deleted: 0 Skipped: 0 Warnings: 1 I was wondering is there anyway to automate this process in a script? I have never written a script in Linux before. If I can automate this process, what kind of script should I use? Thanks. Peter - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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
Re: Basic RPM installation?
Hi, You indeed have to su to root to get things working. safe_mysqld as root didn't work because your PATH environment wasn't correctly set because you didn't use this: su - su - makes the new shell the user's login shell, resetting environment variables and reading configuration files to re-set them correctly. With su - it will work as expected. You would have got it working with this, though: /usr/bin/safe_mysqld or ./safe_mysqld when you were in /usr/bin. Best regards, Iikka On Sat, 28 Sep 2002, DeNewbie wrote: In my first posting I had the following problem; mike@cords-orj86jfje:/usr/bin safe_mysqld [1] 1759 mike@cords-orj86jfje:/usr/bin cat: /var/lib/mysql/cords-orj86jfje.pid: Permission denied rm: cannot unlink `/var/lib/mysql/cords-orj86jfje.pid': Permission denied Fatal error: Can't remove the pid file: /var/lib/mysql/cords-orj86jfje.pid /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied Please remove it manually and start /usr/bin/safe_mysqld again mysqld daemon not started I removed the cords-orj86jfje.err file from /var/lib/mysql/cords-orj86jfje.err and I performed the mysql_install_db script all over again, now I have this problem in that I get the same response even after removing the cords-orj86jfje.err file. mike@cords-orj86jfje:/usr/bin safe_mysqld [1] 1059 mike@cords-orj86jfje:/usr/bin Starting mysqld daemon with databases from /var/lib/mysql /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied tee: /var/lib/mysql/cords-orj86jfje.err: Permission denied 020928 10:47:57 mysqld ended tee: /var/lib/mysql/cords-orj86jfje.err: Permission denied [1]+ Exit 1 safe_mysqld mike@cords-orj86jfje:/usr/bin cd /var/lib/mysql mike@cords-orj86jfje:/var/lib/mysql ls mysql test mike@cords-orj86jfje:/var/lib/mysql ls -l total 1 drwx--x--x2 mysqlroot 506 Sep 2 14:20 mysql drwxr-xr-x2 mysqlroot 35 Sep 2 14:20 test I have the safe_mysql in my /usr/bin but I get this; mike@cords-orj86jfje:~ cd /usr/bin mike@cords-orj86jfje:/usr/bin safe_mysql [1] 1118 bash: safe_mysql: command not found [1]+ Exit 127safe_mysql mike@cords-orj86jfje:/usr/bin ls safe* safe-rm safe_mysqld mike@cords-orj86jfje:/usr/bin su Password: cords-orj86jfje:/usr/bin # safe_mysql [1] 1126 bash: safe_mysql: command not found [1]+ Exit 127safe_mysql cords-orj86jfje:/usr/bin # What do I do from here ??? Thanks, DeNewbie - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: automating import process
Hi, use this: mysql -u root -ppassword It's important NOT to put a space between -p and the real password. Having a password in a script is unsafe at its best, though. I'm not sure if you have any other options than to put it that way or enter it manually each time you run the script. Regards, Iikka On Sat, 28 Sep 2002 [EMAIL PROTECTED] wrote: Hi Carl, Thanks for your reply. I have created a shell script but I get stuck on the part where it asks to input password. How do I get the script to input the password that I put in? So far my script looks like this: ./mysql -u 'root' -p echo abc The script executes, but it just waits for the password after it executes the line: ./mysql -u 'root' -p Can anyone help with this? Thanks. Peter On Mon, 5 Aug 2002, Carl McNamee wrote: I'm assuming that you are using some form of unix in this. From the system prompt type mysql -u root -ppassword import_test1. If this works just put it into a script (bash, perl, whatever) and run it either from the command line or via cron if you want it automated. Carl McNamee Systems Administrator Billing Concepts (210) 949-7282 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 03, 2002 11:58 PM To: [EMAIL PROTECTED] Subject: automating import process Hi, I want to try to automate a phonebook list import process into MySQL database. The phonebook was originally created with MS Access and exported into a text file. I upload that text file onto my server and I proceed with the following import process. Using Telnet I type: # ./mysql -u 'root' -p It then asks Enter password: I then select the database to use mysql use import_test1; I delete the previous phonebook list table because the import process does not know that it should replace the previous records even though there have been changes mysql use import_test1; mysql exit Bye I then import by doing the following: [root@ns2 bin]# ./mysqlimport --local -u root -p --fields-terminated-by=, import_test1 phone2.txt Enter password: import_test1.phone2: Records: 53 Deleted: 0 Skipped: 0 Warnings: 1 I was wondering is there anyway to automate this process in a script? I have never written a script in Linux before. If I can automate this process, what kind of script should I use? Thanks. Peter - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 all messedup ... :'( .....
Hi, Er, I don't want to be rude, but those dots drive me crazy. Could you include more details? What version of MySQL running now? Running as a service r from the command line? You can't even log in? What does MySQL client say? I suggest using the command line client for early troubleshooting, just to make sure the problem isn't elsewhere. Did you do a proper uninstall? I mean, if you had your previous mysqld installed as a service, did you uninstall that service first? Are you using your old grant tables or the clean, new ones that ship with the setup package? Or are you logging in as 'root'? Or as a different user? Double check your passwords and try an empty password for 'root', too. Also, please see http://www.mysql.com/doc/en/Access_denied.html for some common causes of Access Denied errors. Regards, Iikka On Thu, 26 Sep 2002, toby - wrote: ok guys i ve actually done it fo myslf ... :'( mysql s all screwedup ... i reinstalled it last night and myadmin too ... now ... ive created two users and databases n ... wolla i cnt even login ... :'( i feel like banging my head against da walls vat in earth is with this thing workin prefect last week n ever since i had my hard disk formatted its all out i made the users at cmd mode o i ve win 2k pro, apache 1.3.24 , php 4.2.2 mysql 3.23.39 (now) and phpmyadmin 2.2.6 (installed from binary) and plz ... id b eternally gratefull if any one of u guys cud come online on msn n hlp me plz . all screwedup . toby _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 all messedup ... :'( .....
Hi again, Sorry, you _did_ mention your MySQL version... wrote the reply in quite a hurry. Why aren't you using the latest version (3.23.52)? Iikka On Thu, 26 Sep 2002, toby - wrote: ok guys i ve actually done it fo myslf ... :'( mysql s all screwedup ... i reinstalled it last night and myadmin too ... now ... ive created two users and databases n ... wolla i cnt even login ... :'( i feel like banging my head against da walls vat in earth is with this thing workin prefect last week n ever since i had my hard disk formatted its all out i made the users at cmd mode o i ve win 2k pro, apache 1.3.24 , php 4.2.2 mysql 3.23.39 (now) and phpmyadmin 2.2.6 (installed from binary) and plz ... id b eternally gratefull if any one of u guys cud come online on msn n hlp me plz . all screwedup . toby _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 all messedup ... :'( .....
Did you check Egor's last message to you on the list? After starting mysqld with --skip-grant-tables you should be able to connect with this: mysql -u root on the server, otherwise use mysql -u root -h your.server.ip.address It won't be of much help if you can't get 'root' working. Please try to get that right first and then check your own account. Best regards, Iikka On Thu, 26 Sep 2002, toby - wrote: u think that d make much of a difference :( ... i cant work with the thing any more yaar rather cant make it work . the thing that i waz actually playin with last week ... :S and i jst cannot recall how i handled it last time i installed it on n all ... though i had my myadmin's config files saved on my disk and i ve copied them bak but still nuthin this is the error i keep gettin now Error MySQL said: Access denied for user: 'sir@localhost' (Using password: YES) nomatter where i try to acess it from ... from cmd i can do this : mysql --user sir@localhost n it letts me in but not mysql --user sir --pass password * i get the same error: Access denied for user: 'zaban@localhost' (Using password: YES) n im lost and ve a demo tomorrow aftrnoon n im doomed :'( thnx a million anyway fo ur time n concern i really appriciate it toby . From: Iikka Merilinen [EMAIL PROTECTED] To: toby - [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: mysql all messedup ... :'( . Date: Thu, 26 Sep 2002 16:59:11 +0300 (EEST) Hi again, Sorry, you _did_ mention your MySQL version... wrote the reply in quite a hurry. Why aren't you using the latest version (3.23.52)? Iikka On Thu, 26 Sep 2002, toby - wrote: ok guys i ve actually done it fo myslf ... :'( mysql s all screwedup ... i reinstalled it last night and myadmin too ... now ... ive created two users and databases n ... wolla i cnt even login ... :'( i feel like banging my head against da walls vat in earth is with this thing workin prefect last week n ever since i had my hard disk formatted its all out i made the users at cmd mode o i ve win 2k pro, apache 1.3.24 , php 4.2.2 mysql 3.23.39 (now) and phpmyadmin 2.2.6 (installed from binary) and plz ... id b eternally gratefull if any one of u guys cud come online on msn n hlp me plz . all screwedup . toby _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx ** * Iikka Merilinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** _ Send and receive Hotmail on your mobile device: http://mobile.msn.com ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Newbie Question...
Hello, Start your mysqld with --safe-show-database parameter (or edit your my.cnf, respectively). Regards, Iikka On Thu, 26 Sep 2002, Saleem wrote: Hi, I have mysql-3.23.32-1.7 machine, and the problem I have is that is that all users are able to see all databases in mysql How can I restrict each user to only view the database he's been assigned permission for? Thanks in advance! Saleem - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Max NB of MyISAM tables / DB ( Ext3 linux )
Hello, If the number of files is your concern, have you considered using InnoDB? It spans tables across any number of data files you want. The performance is great, too. Best regards, Iikka On Wed, 25 Sep 2002, David Bordas wrote: Hi list, I've just a little question for the end. I planned to have around 10K tables under a DB and this number surelly grow up to 20K. I know that a database is a directory and a table is 3 files. I just want to know is mysql have a limit in the number of table per database. If not, i know that ext3 can have ten of thousands files in a directory. But commande like 'ls' will become slower and slower ... Is this also slowing mysql ? Thanks - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Set Path Environment
Hi, Just to clarify a bit, the file in \windows is called winstart.bat, but it seems to be discontinued in Windows XP (may not be available in W2K either). In Windows NT it works, though. In NT/W2K/XP the most efficient way to modify these variables _and_ persist them is through My Computer-Properties... as I noted in an earlier message. After thinking this a bit, it'd be very nice if the MySQL setup program offered an option to automatically add mysql\bin to the PATH environment variable (whoever is responsible of the setup, please consider this!) on Windows. Best regards, Iikka On Wed, 25 Sep 2002, Leonardo Javier Belén wrote: Try to modify the autoexec.bat if you are using Win9x or the Path User env in Winnt. Another choice in some systems is to modify DOSTART.bat or something like that in \windows. A way to keep the previous setting of the PATH env is to issue a stat like SET PATH=%PATH%;c:\mysql; ... I hope this helps. Leonardo Javier Belen. AFIP-AR Spam: sql, query, mysql - Original Message - From: William Martell [EMAIL PROTECTED] To: MySQL Main List [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 11:38 PM Subject: Fw: Set Path Environment This is more information regarding the Path for my machine. It shows the default PATH information and the PATH information after I perform the SET PATH command. It also shows how MySQL responds after I type MySQL at the command prompt. Thanks in Advance, William C:\path PATH=C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem C:\SET PATH=C:\mysql\bin;C:\perl\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\W bem C:\path PATH=C:\mysql\bin;C:\perl\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\W bem C:\mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 to server version: 3.23.52-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql - Original Message - From: William Martell [EMAIL PROTECTED] To: MySQL Main List [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 9:33 PM Subject: Set Path Environment Hello All, I am having trouble with MySQL in dos. When I type in mysql from the c:\ prompt, I get the following error: C:\mysql 'mysql' is not recognized as an internal or external command, operable program or batch file. I tried the SET PATH command and this works fine when I have dos open. But when I start another session of dos later the settings are gone. Does anyone know how to set this as the default path?? Thank you very much for your assistance and have a nice day. William - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 ????
On Wed, 25 Sep 2002, toby - wrote: thnx iikkaa im bsorry ... i ve win2k pro, apache 1.3.24 n php 4.2.2 all workin fine . my mysql4.0.1 alfa is givin me these night-mares cud this be the problem 4.0.1 ALFA ? it was a win zip file i guess not the source but a binary . plz do lemme know what can i do n thnx a lot again toby .. Error on rename of '.\zabandb\ctnt_inf.MYI' to '.\zabandb\#sql2-5b0-7e.MYI' (Errcode: 13) perror 13 -- Permission denied So it's probably due to your NTFS file/directory permission on Windows. Please try this if _nothing_ else seems to help: grant Everyone RWXD (full) rights to the whole data directory. This has, of course, a major problem with security but that way you could check if it's really a permissions problem. Also, a more secure way to accomplish this is to run the MySQL service as a ordinary user (rather than the SYSTEM account) and grant that user full rights to the whole data directory structure (make sure the subdirectories and files get their correct permissions, too). Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 ????
No. Not in MySQL or phpMyAdmin but on the operating system / file system level instead. Open up the data directory in My Computer on your server, then right-click that directory, select Security tab, there add Everyone or the use that MySQL service runs as to the list and select Full Access. Then click Advanced permissions or something like that below the permissions list (I'm not sure, running Finnish Windows 2000 right now). However, check the lower checkbox on the Permissions tab in order to enable permissions inheritance from a upper level to a lower one. You might have to shut down MySQL during the permissions change. Regards, Iikka On Wed, 25 Sep 2002, toby - wrote: thnx Iikka pardon my ignorance but i ve no clue as how to give RWXD except through phpmyadmin and this is the situation there on the home of phpmyadmin ... Edit Delete Grants % root No Select Insert Update Delete Create Drop Reload Shutdown Process File Grant References Index Alter Edit Delete Grants localhost root No Select Insert Update Delete Create Drop Reload Shutdown Process File Grant References Index Alter Edit Delete Grants % sir Yes Select Insert Update Delete Create Drop Reload Shutdown Process File Grant References Index Alter Edit Delete Grants localhost zaban Yes Select Insert Update Delete Create Drop Reload Shutdown Process File Grant References Index Alter --- some how i ve got 2 roots instead of 1 n both my users ... zaban sir given me the same accessdenied error ... code 13 :s i HAVE given them all the rights i possibbly cud ... editting the grants and even revoking them ... but nothing seem to b workin n im lost at sea :'( n no clue vat to do ... i feel like takin the whole thing out n reinstallin it ... :S vat else can i do thnx a zillion guyz ... toby . From: Iikka Meriläinen [EMAIL PROTECTED] To: toby - [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: access denied Date: Wed, 25 Sep 2002 15:08:04 +0300 (EEST) On Wed, 25 Sep 2002, toby - wrote: thnx iikkaa im bsorry ... i ve win2k pro, apache 1.3.24 n php 4.2.2 all workin fine . my mysql4.0.1 alfa is givin me these night-mares cud this be the problem 4.0.1 ALFA ? it was a win zip file i guess not the source but a binary . plz do lemme know what can i do n thnx a lot again toby .. Error on rename of '.\zabandb\ctnt_inf.MYI' to '.\zabandb\#sql2-5b0-7e.MYI' (Errcode: 13) perror 13 -- Permission denied So it's probably due to your NTFS file/directory permission on Windows. Please try this if _nothing_ else seems to help: grant Everyone RWXD (full) rights to the whole data directory. This has, of course, a major problem with security but that way you could check if it's really a permissions problem. Also, a more secure way to accomplish this is to run the MySQL service as a ordinary user (rather than the SYSTEM account) and grant that user full rights to the whole data directory structure (make sure the subdirectories and files get their correct permissions, too). Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** _ Chat with friends online, try MSN Messenger: http://messenger.msn.com ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 Error
Hello, Your Apache is OK, but you've got a PHP version that's not configured with the --with-mysql option. You need to recompile PHP if you've installed from the source. Regards, Iikka On Wed, 25 Sep 2002, Peter Goggin wrote: I have got apache and mysql running on my linux server. When connecting to my web site I get the following error: Fatal error: Call to undefined function: mysql_close() in /usr/local/www/vantweststamps/databaselogin.php on line 15 Does this mena the apache server has not been linked to the mysql functions? Regards Peter Goggin - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 Error
Hi, Getting a bit off-topic... I'm not sure whether you can add functionality to an already compiled PHP installation. Maybe your best bet is to recompile your PHP, that way you can get the latest version, and with only the functionality you want. Just remember to enable --with-mysql during the configuration. The source package at www.php.net has a good installation guide. Regards, Iikka On Wed, 25 Sep 2002, Peter Goggin wrote: The php is as installed from the redhat distribution for 7.3 from the Next handbooks. Do I need to down load a later version of PHP or cn I modify what is already installed? Regards Peter Goggin - Original Message - From: Iikka Meriläinen [EMAIL PROTECTED] To: Peter Goggin [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 10:30 PM Subject: Re: Mysql Error Hello, Your Apache is OK, but you've got a PHP version that's not configured with the --with-mysql option. You need to recompile PHP if you've installed from the source. Regards, Iikka On Wed, 25 Sep 2002, Peter Goggin wrote: I have got apache and mysql running on my linux server. When connecting to my web site I get the following error: Fatal error: Call to undefined function: mysql_close() in /usr/local/www/vantweststamps/databaselogin.php on line 15 Does this mena the apache server has not been linked to the mysql functions? Regards Peter Goggin - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Set Path Environment
Hello, On Windows 9x edit your c:\autoexec.bat On Windows NT/2000/XP/.NET, right-click My Computer, then Properties, then on XP click Advanced tab and then Environment Variables. On NT/2000 this procedure is about the same, only the Environment stuff is on a different tab. Then re-run autoexec.bat or reload your command prompt, respectively. Best regards, Iikka On Tue, 24 Sep 2002, William Martell wrote: Hello All, I am having trouble with MySQL in dos. When I type in mysql from the c:\ prompt, I get the following error: C:\mysql 'mysql' is not recognized as an internal or external command, operable program or batch file. I tried the SET PATH command and this works fine when I have dos open. But when I start another session of dos later the settings are gone. Does anyone know how to set this as the default path?? Thank you very much for your assistance and have a nice day. William - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 ????
Hello, If you're on *NIX platform, use this: chown mysql * in your data directory. To make things sure, chown every data file to mysql user (I assume you've created it during install). On Windows, check the permissions. I apologize for being inaccurate, but you didn't specify what operating system you're using and whether you have installed MySQL from source or from a binary package. Regards, Iikka On Mon, 23 Sep 2002, toby - wrote: thnx gerald but i still dont know what to do to fix this thing up will someone pleez enlighten me on how to thnx a million ... toby . From: gerald_clark [EMAIL PROTECTED] To: toby - [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: access denied Date: Mon, 23 Sep 2002 09:02:55 -0500 mysql does not own its files. toby - wrote: ok guyz im lost im creating my tables and after i ve created em i tried to change two of the fields to FULLTEXT and this is what i get : Database zabanDb running on localhost Error SQL-query : ALTER TABLE `ctnt_inf` ADD FULLTEXT(`summary`) MySQL said: Error on rename of '.\zabandb\ctnt_inf.MYI' to '.\zabandb\#sql2-5b0-7e.MYI' (Errcode: 13) ACCESS DENIED ! ! ! ! ! what the hell is rong with this thing ? cud anyone help me plz _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.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 _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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-Front
Hello, As they say on the site, it is discontinued. My guess is that there were no active developers. Quite a shame, though, as MySQLFront was simply the best frontend for MySQL. I _really_ hope that someone will pick up the development from where it was left off and continue the development of this excellent frontend. Best regards, Iikka On Sun, 22 Sep 2002, Kevin Smith wrote: Hi All, Does anyone know what happened to the MySQL-Front project, which was at http://www.anse.de/mysqlfront/ ? Thanks, Kevin - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: transactions...
On Mon, 23 Sep 2002, Daniel Kiss wrote: Hi! At 00:56 2002.09.23._ -0300, you wrote: Do I loose too much performance using InnoDB tables in autocommit mode instead of using MyISAM tables? The real quiestion is: Why do you want to use InnoDB tables when you don't want to use its transaction safe features? The reason for prefering InnoDB over MyISAM? Performance. Most benchmarks show InnoDB is slightly faster than MyISAM, and not to mention its some other benefits. But the performance could be a reason on its own to use InnoDB. I don't mean that MyISAM is bad, not at all. It's simpler to use, after all. But what I mean is that InnoDB can be used in all tasks MyISAM is suitable for, and some tasks will be done faster using InnoDB. Best regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** 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
Re: Problems to create privilege tables on Windows NT
Hello, The privilege tables exist already after the install - you don't need to create them manually afterwards. The root user has no password and can connect from localhost only. Best regards, Iikka On Fri, 20 Sep 2002, José Fernández wrote: I have installed MySQL on Windows NT, and I have found that I need to create the privilege tables. I have seen in the documentation that I must use the mysql_install_db.sh script, but I think that it is intended to use in Linux or Unix, not with Windows. I say this due to I have not found it in any of the hard disks that has my PC, where I have installed MySQL. Please how can I create the privilege tables in my Windows NT system? Many Thanks José Fernández ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: installin mysql on win 2000
Hello Ryan, No real problems with Windows 2000 Server and Adv. Server. Install SP3 before MySQL as the SP installation might remove the MySQL service registration in some cases. The setup process itself is an extremely straightforward one, taking just two or three minutes. The manual has good information on how to install MySQL as a service and whether to choose MAX or normal version for regular use etc. etc. You might want to use phpMyAdmin to administer your MySQL server (if you have a PHP/Apache box available). Another good (although discontinued) frontend is MySQLFront. phpMyAdmin has the advantage that you don't need a Windows box to work with it, any computer with a browser is sufficient. Best regards, Iikka On Wed, 18 Sep 2002, Ryan Cavanaugh wrote: I will begining to install mysql on my server in a few days. I have never done this before. Is there anything i need to know, any problems mysql has with 2000 server? Any help is appreciated. Ryan - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Regarding Mysql4.0
Hello, The normal binary packages don't include source code. You have to download the source code package (also available from those download pages). For most users this will suffice, but the source is also available on BitKeeper server (see the Technical Reference for installing from the source tree). There is no specific source download for -max versions as the code is the same as in normal versions. Regards, Iikka On 17 Sep 2002, ch kalyan wrote: hello sir,, I have downloaded Beta version of Mysql 4.0.3 I didnt find any source code in it.. Will u please inform me how can i get source code in it Thanking u... Kalyan __ Give your Company an email address like ravi @ ravi-exports.com. Sign up for Rediffmail Pro today! Know more. http://www.rediffmailpro.com/signup/ - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Win2000 error message when Starting mysql
Hello, This error doesn't give any information on what is exactly wrong with MySQL. See mysql\data\mysql.err or mysql\data\yourhostname.err logs for more information. Also check your my.cnf. Regards, Iikka On Tue, 17 Sep 2002, Chris Stanley wrote: When I try to start Mysql service under services on a Win2000 machine I get the following error message. 'Could not Start the MySql service on local computer. Error 1067: The process terminated unexpectedly' I am new to MySql so any help given will be much appreciated. Thankyou in advance Chris Stanley - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: mysqlbug
Hello, Check your working directory (type pwd) and check if the scripts directory exists at all (type ls). What version did you install and on what operating system? Was it a binary or a source release? Regards, Iikka On Tue, 17 Sep 2002, Winnie Kwok wrote: after install mysql [root@localhost mysql]./scripts/mysql_install_db bash:./scripts/mysql_install_db:no such file or directory Is the files not install ? _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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
About the 4.1 release
Hello, When will the 4.1 source tree be made accessible by the public? How about the first official 4.1 release? Any estimates? Best regards, Iikka sql query ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: simple query question
See http://www.innodb.com Regards, Iikka ps. The MySQL manual also offers some rough guidelines on where InnoDB excels. On Fri, 13 Sep 2002, Meidling, Keith, CTR, OSD-C3I wrote: I've seen a lot about 'InnoDB'. What is it? -Original Message- From: Weaver, Walt [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 4:09 PM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: simple query question I'd use the InnoDB table type and establish a primary key/foreign key relationship (parent-child) between the two. That way referential integrity will be done for you by the database. --Walt Weaver Bozeman, Montana -Original Message- From: Chris Burger [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 1:57 PM To: [EMAIL PROTECTED] Subject: simple query question I have I hope a simple query question. I have two tables 1 One has customer id and a store id and transaction information 2 Second has a store id and store information There is multiple transactions in the first table, however there is only one record for each store id in the second table. What I need to make sure is that for every store id in the first table I have a corresponding store id record in the second table? Any suggestions would be appreciated. Chris Burger - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Goodday
Simply having that Attn: mysql , row in it. The word 'mysql' passes through the filter. Not making that Ocita G less of an idiot, though. On Tue, 10 Sep 2002, Clive Smart wrote: How did this get past the filters? Ocita Gabriel wrote: Attn: mysql , My name is Ocita G, the manager, credit and foreign bills of Ecobank Plc. I am writing in respect of a foreign customer of my bank with account number 14-255-2004/utb/t who perished in a plane crash [Korean Air Flight 801] with the whole passengers aboard on August 6, 1997. Since the demise of this our customer, I personally has watched with keen interest to see the next of kin but all has proved abortive as no one has come to claim his funds of usd.20.5 m, [twenty million five hundred thousand united states dollars] which has been with my branch for a very long time. On this note, I decided to seek for whom his name shall be used as the next of kin as no one has come up to be the next of kin. And the banking ethics here does not allow such money to stay more than Six years, because money will be recalled to the bank treasury as unclaimed after this period. In view of this I got your contact through a trade journal after realizing that your name and country is similar to the deceased. I will give you 25% of the total. Upon the receipt of your response, I will send you by fax or e-mail the application, bank's fax number and the next step to take. I will not fail to bring to your notice that this business is hitch free and that you should not entertain any fear as all modalities for fund transfer can be finalized within five banking days, after you apply to the bank as a relation to the deceased. When you receive this letter. Kindly send me an e-mail signifying Your decision including your private Tel/Fax numbers for quick communication. Respectfully submitted, Ocita G. - 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 . -- | _ __ ___ | | | |/ / ___/ __ \/ ___| Clive W. Smart | | | | / / /__/ /_/ / / R D Director | | | |/|/ / ___/ __ |\_ \WEBServ a div. | | | / /__/ /_/ /__/ /of Melange Hold | | |_/|_//_//ERV [EMAIL PROTECTED] | || | Tel: +27 11 372-9800 Fax: +27 11 372-9801 | || - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Stopping Running Queries...
Hello, Use mysqladmin processlist command to see the thread that's eating up resources, then use mysqladmin kill to kill that thread. mysqladmin documentation offers much more information on this topic. You can also use SHOW PROCESSLIST and KILL SQL commands to achieve that. Regards, Iikka On Thu, 5 Sep 2002, James Kelty wrote: mysql,query Hello, Maybe I'm an idiot, but I can't find any documentation on how to stop running queries interactively. The only thing I can come up with is to stop and restart the server. I don't want to do that. Basically, if a user does something stupid, and sparks off a query that is hogging resources, I'd like to be able to kill that query so everyone else can get on with life. How is this, if it can be done, accomplished? Thanks! -James - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 max
Hello, As of this writing, MySQL doesn't support stored procedures. It will most probably support them in 4.x versions to come. However, there are millions of web pages that use PHP in conjunction with MySQL without stored procs, although they would certainly benefit of them, but those sites work fine. Regards, Iikka On Thu, 5 Sep 2002, Edward Peloke wrote: I am new to MySql and am trying to learn PHP in conjunction with MySql. The webpage that I want to create will benefit from stored procedures. Are these available with MySqlMax? If so, is it setup the same way as MySql? Thanks, Eddie - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 max
Hello, Yes, there might be very strong reasons to use the Max version. Most people are using Max because it has InnoDB support. I'm not sure about your specific needs, but see this URL for more guidance on which version to choose: http://www.mysql.com/doc/en/mysqld-max.html Regards, Iikka On Thu, 5 Sep 2002, Edward Peloke wrote: So is there really any benefit to using MySql Max? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Iikka Meriläinen Sent: Thursday, September 05, 2002 3:53 PM To: Edward Peloke Cc: [EMAIL PROTECTED] Subject: Re: mysql max Hello, As of this writing, MySQL doesn't support stored procedures. It will most probably support them in 4.x versions to come. However, there are millions of web pages that use PHP in conjunction with MySQL without stored procs, although they would certainly benefit of them, but those sites work fine. Regards, Iikka On Thu, 5 Sep 2002, Edward Peloke wrote: I am new to MySql and am trying to learn PHP in conjunction with MySql. The webpage that I want to create will benefit from stored procedures. Are these available with MySqlMax? If so, is it setup the same way as MySql? Thanks, Eddie - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: Using mySQL in Batch mode
Hello, In the directory you have your .sql script, run this: mysql myquery.sql Remember to change the file name, though. :-) Regards, Iikka On Thu, 5 Sep 2002, Horacio Santoyo wrote: Hello mySQL users, I'm a new mySQL user, just installed it two days ago. I have a quick question... I have a .sql script that I want to run on mySQL server. I have a Windows XP machine and when I read the mySQL manual, I think they were talking about a Unix machine. This is what the manual said to do... shell mysql batch-file But my command line looks like this... mysql so how do I run the script? This is probably a real simple question, but I can't figure it out yet. Thanks --Horacio - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: performance tunning 4.x
Hello, A MySQL developer would be able to answer to these questions more accurately, but I'll try to answer _logically_. So don't bet a million dollars on the correctness of my answer. NOTE: The query cache does not return stale data. When data is modified, any relevant entries in the query cache are flushed. If I have a select statement like: select col1, col2 from table1 where col1='A' 1) will the cache be flushed if someone changes a non-referenced column for one of the retrieved rows: Update table1 set col3 = 'x' where col1='A' this update changes col3 that falls within the Where of the query but it affects a column that is not returned by the query. I think this flushes the cache. Think about a situation where col1 is a computed column that derives its values from the data in col3. When col3 is updated, the value of col1 in the query cache would become invalid. 2) or will the cache be flushed if someone changes a row that falls outside of the query's Where clause: This shouldn't explicitly flush the cache, but I don't know the details of the implementation. This insert shouldn't have any effect on the aforementioned SELECT query, because col1 here is 'D'. insert into table1 (col1, col2, col3) values('D', 'x', 'y'); This last query updates the same table as the select query, but the row that is added is outside the range of the query's where clause. So how smart is the cache? a) Is it smart enough to allow table updates and if the update doesn't affect the query, will it continue to use the cache? (This requires a lot of intelligence.) b) Or will any update to the rows that fall within the range of the query (regardless of whether the column is in the query) will flush the cache? c) Or will any update to the table automatically flush the cache? MONTY: I would like to see the Explain command to say if it is using the cache or not (CACHE:Yes/No). This would help developers make better use of the cache if they know how what affects it. Mike ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 Service Pack 3
Hello, Reinstall your MySQL service using mysqld((-max)-nt) --install SP3 somehow manages to remove the service registration in some cases. Regards, Iikka On Thu, 29 Aug 2002, Marc Hus wrote: Hello, I have a very strange problem with all of the Windows versions of MySQL. I upgraded to Service Pack 3 for Windows 2000 Server and now MySQL will not work period. Has anyone ran into this problem and or know of a fix? Marc - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: performance tunning 4.x
Hello, Yes, there are lots of good documentation: First, the official MySQL Technical Reference, Section 5 at http://www.mysql.com/doc/en/index.html Then scroll down to 5 MySQL Optimisation and read those. Also, check this: http://www.devshed.com/Server_Side/MySQL/Optimize/page1.html It's a bit older, but still useful. And finally, use www.google.com. :-) Regards, Iikka On Wed, 28 Aug 2002, Sean Hager wrote: Are there any documents on how to performance tune mySQL 4.x? sean. - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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: performance tunning 4.x
On Wed, 28 Aug 2002, Sean Hager wrote: In the Ziff Daveis eWeek benchmark http://www.eweek.com/article/0,3658,s=708a=23115,00.asp )I noticed the following: MySQL's great performance was due mostly to our use of an in-memory query results cache that is new in MySQL 4.0.1. When we tested without this cache, MySQL's performance fell by two-thirds. I couldn't find any information in the online document on how to configure this in-memory query results chache. Can anyone point me to some information on how to do this? Hi, Start by looking at the MySQL documentation: http://www.mysql.com/doc/en/Query_Cache.html Read the entire 6.9 section. It offers quite a bit of information on how the cache operates, how you should configure it and so on. Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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
Hello, sorry for a late answer, but here it comes. On Tue, 27 Aug 2002, Mylin Campos wrote: I'm a newbie with mysql. I have a few question and would really appreciate it if you can help me. I'm creating a database for a payroll system. I actually finish with my entity relationship diagram. What should be the next step? I know I should create the database already but while reading the mysql documentation I've been encountering so many questions that I'm getting all confused on where to start. Right, if you have the root account or any other account that has enough privileges, the right way to start is to create your own database. For now stick with the default settings for that, they are OK. First, where does the priviledges come in? Specifically the alter, drop, select, insert (etc) priviledges come in? Or does this concern the database administrator which is not my concern since I'm only the software developer. Every time you run a query on MySQL it checks whether you have enough permissions to do so or not. If not, it returns an error. If you are the owner of your database (I suppose you are), you have all rights to that database, including ALTER, DROP, CREATE and so on. As the owner you also have SELECT, INSERT, UPDATE, DELETE at your disposal, along with others. If you read the manual beginner's section very carefully, I think you will grasp the permissions topic fairly well. It's important to remember that users are defined using username/hostname pairs. That is, for example, you can have different privileges, depending on whether you login from your work computer or your home computer, as they have different IP addresses and host names. Should I create the tables and then what next? Yep, create tables. Then insert/dump your data into them. Or do anything that suits your needs. :-) Mysql does not a have a feature like access where you link one key to another by dragging one field to another. does this mean that linking the tables in mysql is done manually via the sql statements? That's because MySQL is just a database backend, Access has the Jet engine that it uses as a separate DLL, MySQL clients are available but their current functionality is a bit limited in some cases. MySQLFront is a good one to start with. You can use Access, too, to use MySQL but all its graphical features won't work, though. phpMyAdmin is fairly efficient, but it requires you to have a web server running PHP. For most of your daily work you can use any graphical frontend you want to, but for the more advanced (mostly administrative) tasks you will want to learn enough pure SQL to accomplish those tasks more effectively. A URL for graphical MySQL frontends: http://www.mysql.com/downloads/gui-clients.html MyCC is pretty OK, but its development is still underway. Hope this helps, feel free to ask further questions as needed. Best regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 do I recover a broken table?
Hello, If you're using MyISAM tables, shut down your server and run myisamchk For example, myisamchk \mysql\data\dbname\*.MYI See the MySQL Technical Reference for detailed syntax and usage information. However, it seems like your table is corrupted, indeed. Regards, Iikka On Tue, 27 Aug 2002 [EMAIL PROTECTED] wrote: Hi I have a table that returns the following error message as soon as I run a query that reads out more then 300 posts from the table ERROR 1030: Got error -1 from table handler The strange part is that the table works without any problem except when I try to select more then 300 posts. I have tried to use the analyze and recover commands but I only get the message that the table doesn't support these commands. Happy for any help I can get to try recover the table without having to read out all the data and recreate the table. /Magnus - 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 size in AIX
On Tue, 27 Aug 2002, Scott Pippin wrote: I found out my AIX box's maximum file size is 2GB. What can I do if I will have MySQL tables that are possibly over 2GB? Hello, There are basically two things you should consider: 1) Switch to InnoDB tables and create several data files just under 2GB each 2) Use MyISAM RAID option This requires you to compile your MySQL with --with-raid configuration parameter. Then MySQL will create separate 00, 01, 02, 03 and so on directories with a piece of your table in each of them. See Manual section 6.5.3 (CREATE TABLE syntax) for detailed coverage. You will want RAID_TYPE=STRIPED configuration since that facilitates for the spreading of the .MYD files. Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 service does not start
Hello, See mysql\data\[hostname].err or mysql\data\mysql.err for what might have gone wrong. Also, you could try starting your mysqld with the following (not as a service): mysqld-(max-)nt --console --standalone Then, if there's something wrong in the error log, you can copy/paste the last lines of it into here and I or somebody else will figure out what's wrong. Regards, Iikka Btw, this message would be better suited for the win32 list. ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** On Wed, 21 Aug 2002, Saeed Karshenas wrote: I did not have any problem installing mysql ver 3.23.52 on Windows NT workstation or xp pro, however, on Windows 2000 server mysql service does not start. When I try to start it I get error 1067-the process terminated unexpectedly. In all cases I install the software on drive D and create the my.ini file and set environment variables. Any solutions? Thanks. S. Karshenas - 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: Too many connections
Hello, Edit your my.cnf and add the following line in the [mysqld] section: set-variable = max_connections=500 or set it to anything you need. Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** On Tue, 20 Aug 2002, Mansoor Alam wrote: Dear Sir, We are facing a problem related to mysql connections. The error saying that:- TOO MANY CONECTONS OPEN: Mysql server max_connections variable is currently set to 100, please tell me how i can change the max_connections value. Thank you, Mansoor Alam. - 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: Root logining problems!
Hello, I really hope that Red Hat hasn't changed the root default password to something else. Start mysqld with --skip-grant-tables parameter, then try your mysqladmin command you were trying to execute. If it works then, your grant tables are screwed up somehow.When you're running with --skip-grant-tables, change your root password to something you can use later. Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** On Mon, 19 Aug 2002, Alex Mamtchenkov wrote: I Have a problem with logining to MySQL with root. I am runnig Red Hat Linu 7.3 and I just have installed MySQL 3.23.49 frjm the rpm package, which I got with Red Hat Linux 7.3. So I read documentation an made as following: shell mysql_install_db I tryed thi one mysqladmin -u root drop test That what I got: 'Access denied for user: 'root@localhost' (Using password: NO)' I didn't changed any config files or anything else! And every time I am trying to connect MySQL server with root i got this message. But other users can connect to it freely. What shoul I do to connect to MySQL server with root to create the batabase? -- Best regards, Alex Mamcthenkov URL: http://www.leonid.maks.net/~alex/ ICQ UID: 1635188550 Tel: +357 25 340931 - 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: Instalation problems
Hi, Try installing it in Safe Mode. Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** On Sun, 18 Aug 2002 [EMAIL PROTECTED] wrote: To whom it may concern, I had a bad starts!!! I was trying to start working with MySQL with Windows 98 so I downloaded the file myodbc-21.50.39-win95.zip to install the drivers for ODBC, after unzip this file (obviously) I executed the file SETUP.EXE receiving the following message: Insufficient Memory or Disk Space, which is difficult to belive because I have a Pentium 4 with 256 Mb of RAM and a Hard Disk with 30 Gb of free space. What I am doing bad? I would appreciate a lot your help. Kind regards, Daniel Roldán - 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: Lost connections on Freebsd
Hello, Some basic points about these problems: 1) have you another application/mysqld listening on the same tcp port? 2) have you tried different versions (switching between 3.23 and 4.x series, for example) 3) try compiling from the source with a bit different configuration parameters 4) do your connections drop if you're connecting from the localhost? How about from other hosts? How about connecting with other clients? Just don't give up. I've never seen a MySQL-related problem that nobody has been able to solve. I don't believe this isn't about anything big. And probably there are lots of more people active on this list next week, somebody of them might be able to solve your problem. :-) Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** On Sun, 18 Aug 2002, Gelu Gogancea wrote: My dear friend, If you put the problem in this way .maybe it's a good ideea to go to the church and make some rosary for solving your problem. Bye - Original Message - From: Chris Knipe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 18, 2002 9:06 PM Subject: Re: Lost connections on Freebsd Fair enough, But then why is MySQL the *only* thing I am having problems with? MySQL's not the only application running on the box, it's not the only application opening / closing tcp sockets, its not the only thing opening / closing file sockets *shrugs*... Maybe I should just rm -rf / and reinstall. - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: Chris Knipe [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, August 18, 2002 8:01 PM Subject: Re: Lost connections on Freebsd For sure Bad file descriptor error occur because your kernel it's not able to create handler for the new open file(don't forget...socket it's also a file ) which must be open. _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Chris Knipe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 18, 2002 8:14 PM Subject: Re: Lost connections on Freebsd ...or you have too many open files in the system.You reach the max. number of files which can be opened by the OS.Try to increase file-max from /proc/sys/fs. Highly doubtful. It's a brand new server installation, exactly the same as all my others, and it's not doing half as much as the others are The box runs mysql, apache, and exim... With less than 50 processes running at any given time... It's FreeBSD as well btw, /proc/fs/ doesn't exist :P -SNIP- DESCRIPTION The fstat utility identifies open files. A file is considered open by a process if it was explicitly opened, is the working directory, root directory, active executable text, or kernel trace file for that process. If no options are specified, fstat reports on all open files in the sys- tem. -SNIP- 749 open files reported... Far less than the maximum. -- 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 - 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 password file
Hi, If I understood your message right, the answer is no. The only place passwords are stored is the mysql database, so they're physically located in the mysql.MYD file. They're encrypted there, too. Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** On Sun, 11 Aug 2002, Dave Reinhardt wrote: is there a password file accessable from root 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 - 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: File path
Hello Alexander, Yes, it is possible. Start your mysqld(-max)(-nt) instances with --defaults-file=C:\windows\my.ini option and it should work. Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** On Mon, 12 Aug 2002, Alexander Burbello wrote: Hi all, How can I change the file paht c:\windows\my.ini. Is possible I have two files because I want to start two instances in same machine. I would like to change like that: - c:\windows\my.ini - c:\windows\my2.ini Regards Alexander sql, query ___ Yahoo! PageBuilder O super editor para criação de sites: é grátis, fácil e rápido. http://br.geocities.yahoo.com/v/pb.html - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - 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: lost mysql database tables
Hello Dave, Phew... what a situation! ;-) You can always run mysql_install_db script on *NIX, but it clears your existing permissions. On Windows you can do an xcopy for your mysql database from the distribution package, but that doesn't save your permissions, either. First, though, make sure that you really don't have any disk files in the data\mysql directory. If there are any .MYD and .MYI files, they can contain your permissions. The .frm files can then be copied from another similar server (they only contain the table definitions, not the actual data). What about backups? ;-) Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** On Sun, 11 Aug 2002, Dave Reinhardt wrote: I seem to have lost the mysql database tables. I have other databases that work. what is the best way to add the right tables to mysql Dave - 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: instance
Hello Alexander, You can easily have two or more instances (mysqld processes) of MySQL running on the physically same server as long as they have different data directories. You possibly could, in theory, have a system where several mysqld processess share the same data directory (still having different databases) but this approach is _extremely_ tricky to get working reliably. About the need of several server instances, you could use another MySQL for production use (possibly with the normal port, stable table handlers etc.), meanwhile having another instance for development use, running on a different port. The good point of this approach is that if the development instance crashes due to some strange experiment (as mine sometimes does :-), it won't affect the production instance in any way. Of course, you should try to separate your production and development environments, but it's not always affordable. Regards, Iikka ** * Iikka Meriläinen * * IT Support * * Vaalan kunta * * -- * * E-mail: [EMAIL PROTECTED] * ** On Wed, 17 Jul 2002, Alexander Burbello wrote: When I want to run two servers with different configuration. Can I run in the same machine and two running? Alexander sql, query ___ Yahoo! Encontros O lugar certo para encontrar a sua alma gêmea. http://br.encontros.yahoo.com/ - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - 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: Concept
Hi, If you mean the concept (in Oracle) where an instance is effectively one database, the architectures differ a whole lot. Whereas Oracle, as I said, creates an instance for each database it's running, MySQL can handle several databases within one server process instance. The concept of data files is different, too. In Oracle you can define tablespaces that can span one or more datafiles. Then you create your tables into those tablespaces (--data files). MySQL, by default, creates three files per table: [tblname].MYI (indices built on the table), [tblname].MYD (the actual data - this is often the biggest file in a physical table representation), and [tblname].frm within which lies the definition (column names, data types etc.) of the table. MySQL doesn't have real control files like Oracle, it uses my.cnf instead to supply some values to the server that can't be specified runtime. You can, however, control the behaviour of the mysqld(-nt).exe by using some of the command-line startup parameters, if you like. Hope this helps! :-) Regards, Iikka ** * Iikka Meriläinen * * IT Support * * Vaalan kunta * * -- * * E-mail: [EMAIL PROTECTED] * ** On Tue, 16 Jul 2002, Alexander Burbello wrote: I would like to know if MySQL has the same concept like Oracle has about Instance? or phisical structure like datafiles, control files, etc. - 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