MySQL Datadir under rhel6
Hi Folks, I am trying to change the datadir for mysql. For this I performed the following steps: 1: Create a new location for my datadir, e.g.: /media/spare/databases 2: Changed the ownership and permissions of this directory, e.g. chown -R mysql:mysql /media/spare/databases and chmod -R 755 /media/spare/databases - All upper directories have x permission, to go through 3: Stop mysqld, e.g. /etc/init.d/mysqls stop 4: Edit the /etc/my.cnf, wait... there was no my.cnf, also not under /etc/mysql/my.cnf. So I created /etc/my.cnf using defaults (got them from another rhel installation). 5: Start server, e.g. /etc/init.d/mysqld start, worked fine and /etc/my.cnf was loaded without errors or warning, also not in the logs - Stopped server again 6: Copied all files from /var/lib/mysql to /media/spare/databases, except logfiles and checked the permission again - everything fine 7: Changed the datadir entry to /media/spare/databases, trying to start the server it crashed, no error on the console, nothing in the logs After some tries a gave up and tried another method: 1: Changes everything back to default 2: Created a symlink for my database under /var/lib/mysql pointing to /media/spare/databases 3: chown, chmod for the link and the target dir 4: Using mysql console, trying to create the db, I got an error (code 13), so I can't create a db, with the same name as the symlink (in my.cnf symlinks are enabled) 5: Deleted the link, created the db, stopped mysqld, copied the content from /var/lib/mysql/myDB to /media/spare/databases/myDB, checked permission etc. 6: Deleted the myDB directory and created a symlink for myDB to /media/spare/databases/myDB. 7: mysqld starts now, but myDB isn't found Any ideas from your side? With best from GER __ Mario Deng -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Full-text search and queries sensitive to accents
Hi all: I read in mysql documentation that searches are case-insensitive by default but this default behaviour can be changed using a latin1_bin collation. But, is there any way to make searches sensitive or unsensitive to accents, umlauts, etc.? I suppose that queries are accent sensitive by default. Is there any way to change this in mysql 5.1? Thanks in advance, Mario Barcala -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
50% full text threshold
Hi all: I have been reading mysql 5.1 documentation and it says that default 50% threshold for natural language searches can be changed in storage/myisam/ftdefs.h but, what I have to change to allow indexing of all words? This percentage is not explicit in the file, so I don't know what I have to change. Thanks in advance, Mario Barcala -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Full text search and highlight results
Hi all: I was reading documentation and searching into mail archives but I didn't find a solution to the following question: Is there any way to highligh results from a full-text search? I know some tricky methods using PHP but I want to know if mysql (5.0 or 5.1 versions) offers some methos or function to do this. I want to write the keywords in context (KWIC) boldface and some previous an following words around them normalface. Thanks in advance, Mario Barcala -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problems with mysql 4.1+suse 10
hi, i got a problemas in mysql with suse 10 enterprise server, the error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1. when i treat to create a new data base, appears this message. please i need help. thanks.
Re: error in login
On Mon, Jul 09, 2007 at 04:33:04PM -0500, Héctor S. Mendoza O. wrote: The problem persists, with /usr/bin/mysql or with a php application, same sympthoms On the local host (where the mysqld resides) I do the same command and get a ERROR 1045 (28000): Access denied for user 'web19_u1'@'db1.intranet' (using password: YES). If I change this to hlocalhost I can login correctly. Change the host entry to db1.intranet in your user table for the user web19_u1. I had the same problem on my mysql machine. I changed the host entry to the full qualified hostname and that was fine. Don't forget to flush the privileges ;-) Greetings Mario -- - | havelsoft.com - Ihr Service Partner für Open Source | | Tel: 033876-21 966 | | Notruf: 0173-277 33 60 | | http://www.havelsoft.com| | | | Inhaber: Mario Günterberg | | Mützlitzer Strasse 19 | | 14715 Märkisch Luch | - pgpZuexb9lTSS.pgp Description: PGP signature
Re: migrating 4.0 to 5.0
On Mon, Mar 05, 2007 at 08:30:13AM +0100, Matthias Henze wrote: hi, i've still serious trouble in migrating databases createted with 4.0 to 5.0. the problems is still the charset. i'm connecting to mysql with php and when i try to use the 5.0 db german special chars are messed up. afaik 4.0 uses latin charset and 5.0 utf8 by default. can some one please give me a hint how to migrate ? i think i'm just too stupid :-) Hi... convert your mysql-dumpl.sql or whatever with iconv to utf-8. Greetings Mario -- - | havelsoft.com - Ihr Service Partner für Open Source | | Tel: 033876-21 966 | | Notruf: 0173-277 33 60 | | http://www.havelsoft.com| | | | Inhaber: Mario Günterberg | | Mützlitzer Strasse 19 | | 14715 Märkisch Luch | - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Does casing of Table names matter on Linux
On Wed, Feb 28, 2007 at 03:05:54PM +0530, abhishek jain wrote: Hi Friends, I have been developing one application over Windows and now i want to move/port that into linux, i want to know will the casing of the table name matter on linux ie if i have table name as tab1 and i execute query like select * from TAb1 ,will it make an effect. I have found that this is not a problem on windows but it is on linux, i want a sol. for that a i can not change all the table names as in some places it is in small case and in other places it is in capital case. Pl. help me, Hi, Windows is by the way not case sensitive, Linux/Unix is always case sensitive. The MySQL tables are files in filesystem in restrictions for the os you use. It is better, maybe for portable code, to use general uppercase or lowercase names for tables. Greetings Mario -- - | havelsoft.com - Ihr Service Partner für Open Source | | Tel: 033876-21 966 | | Notruf: 0173-277 33 60 | | http://www.havelsoft.com| | | | Inhaber: Mario Günterberg | | Mützlitzer Strasse 19 | | 14715 Märkisch Luch | - pgpWjdEfW5beo.pgp Description: PGP signature
Re: charactersets
On Wed, Feb 28, 2007 at 09:39:40AM +0100, Matthias Henze wrote: hi, 1. is ist possible to switch mysql 5.0 completely to UTF-8 ? Yes. 2. an option would be to convert my data from latin1 to UTF-8 how can i do this ? Export your 4.x databse with mysqldump and convert it with iconv. Greetings Mario -- - | havelsoft.com - Ihr Service Partner für Open Source | | Tel: 033876-21 966 | | Notruf: 0173-277 33 60 | | http://www.havelsoft.com| | | | Inhaber: Mario Günterberg | | Mützlitzer Strasse 19 | | 14715 Märkisch Luch | - pgp7hqGVSbbap.pgp Description: PGP signature
Re: Installation Gone Haywire
On Tue, Feb 27, 2007 at 06:01:44PM -0500, [EMAIL PROTECTED] wrote: Hi; Hi have you run mysql_install_db on your production server? Greetings Mario -- - | havelsoft.com - Ihr Service Partner für Open Source | | Tel: 033876-21 966 | | Notruf: 0173-277 33 60 | | http://www.havelsoft.com| | | | Inhaber: Mario Günterberg | | Mützlitzer Strasse 19 | | 14715 Märkisch Luch | - pgpq0aLit89C9.pgp Description: PGP signature
Move from mysql 4.0.24 to 5.0.22
Hello, i would like to move my Databases from one linux host (running 4.0.24) to a diffrent linux box (running 5.0.22). 4.0.24 is running with charset latin1, therefore i also selected that charset when i did my import on 5.0.22. Although, i get (charset?) format erros such as Gästebuch instead of Gästebuch. Any idea what export or import option i need to look at/use? Thanks, Mario -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
searching every occurrence of a term in a text field
Hi all having a table with one text field in which I store text (sic!) I need to extract from it every occurence of a term (or a phrase) with its context, litteraly extract 30 char before and 30 char after the term I have searched. thx for any suggestions ciao Mario -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
searching every occurrence of a term in a text field
Hi all having a table with one text field in which I store text (sic!) I need to extract from it every occurence of a term (or a phrase) with its context, litteraly extract 30 char before and 30 char after the term I have searched. thx for any suggestions ciao Mario -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
newbie question about sp
I'm trying to call this simple store procedure on my XP with mysql Ver 14.3 Distrib 5.0.0-alpha, for Win95/Win98 (i32), server is 5.0.0-alpha-max-debug-log: CREATE PROCEDURE test_repeat () BEGIN SET @x = 1000; REPEAT SET @x = @x + 1; UNTIL @x 10 END REPEAT; END it seems to go in a loop that block the system instead of exit immediatly from the repeat loop, is there some stupid error I can't see or there are problem with repeat statement in version I am using? thx all Mario -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
count(*) in V4.0.18/V4.1
Hi, I have a strange problem in the return types of the query: select count(*) from table gives in MySQL Version 4.0.18 an return type of long. In Version 4.1.1 its an char (0). The query goes vi MyODBC to MySQL. I checked the ODBC Trace to see the different return types. Does anyone know about this problem? Are there any server variables to get the right result? I already checked the manual/bug/changes section of MySQL. But I did get any ideas. I hope somebody can help me. Thanks in advance. Mario -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Use of Parameters
I need to use this sentence with parameter but I couln't have which is the symbol that is equal to parameter. For instance: SELECT * FROM EMPLOYEES WHERE last_name LIKE ? + % ? means parameter This sentence is right in SQL and also you can use in Access or SQL SERVER but MySql say there is a mistake near to LIKE. What can I do? Mario. Lic. en Cs. de la Computacion Mario Lucero San Luis - Argentina Sucre 692. Depto D3 TE: 54-2652-421219 - Do You Yahoo!? Todo lo que quieres saber de Estados Unidos, América Latina y el resto del Mundo. Visíta Yahoo! Noticias.
View Users in MySQL 4
Hello! Got a database I'd like to know what user/s have access to this database. I am able to login to MySQL and can do SHOW DATABASES, Now, I know there's a user supposedly called kong using an specific database. How can I tell if that is so? I am new to MySQL, being this the 1st time I ever use SQL commands. Thanks! __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Needing help about PHP+mysql on RedHat 9.
Thank you. It was the king of advice that I needed, because I was unaware of the existence of this parameter. I was struggling with the lack of mysql support when I tried to use the new RedHat 9. When I finally solved that problem, I became confused with the inability to transmit variable values through the POST method, that is why I asked for help. Now I can help others with the same dilemma. Thanks, indeed. p --- John Nichel [EMAIL PROTECTED] wrote: Mario Miyojim wrote: I am trying to revive an existing LAMP system. I recently installed RedHat9. I had several LAMP applications working under RedHat 7.1, but now they don't function properly. Chances are, register_globals was on with your old installation, and now it is off by default in php. Either turn it on in the php.ini (not-recommended), and restart your webserver, or rewrite your code to work with globals off (recommended). Things like $PHP_SELF would now be, $_SERVER['PHP_SELF']. Look here http://us3.php.net/register_globals Also, you'll get more help with an item such as this from a php mailing list. -- By-Tor.com It's all about the Rush http://www.by-tor.com __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Needing help about PHP+mysql on RedHat 9.
Thank you. Now I read tutorials at the new PHP web site, so my old scripts are refurbished and are functional. I initialize every variable like this: $var1 = $_POST['var1']; for example, and values are correctly passed. Mario p --- Chris [EMAIL PROTECTED] wrote: You could try http://us2.php.net/ , http://us3.php.net/ , or http://us4.php.net/ . This isn't a PHP mailing list, but I'll answer your question briefly. __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Needing help about PHP+mysql on RedHat 9.
I am trying to revive an existing LAMP system. I recently installed RedHat9. I had several LAMP applications working under RedHat 7.1, but now they don't function properly. For instance, I have many scripts that use the FORM ACTION=?php print($PHP_SELF) METHOD=post construct, but they are not working as they should. I tried to get help from the PHP home site, but www.php.net has been unreacheable to me for several days. I am considering a desperate attempt to go back to RedHat 7.1 because that configuration supported my PHP scripts, but now I can't even read the updated PHP manual. Please, if anyone knows how to circumvent this problem, help me! Thanks __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql replication question(s)
Hi All, I'm having a few issues getting things up and running in regards to replication. I believe I have everything setup correctly the slave is roughly in the same spot as the master as far as the logs are concerned. However, when I make changes in the master db I don't see them show up in the slave db? show master status: 'mhqedi02-bin.012','622609','','' show slave status: 'mhqedi02','replicant','7003','60','mhqedi02-bin.012','630264','royedi01-relay-bin.001','630874','mhqedi02-bin.007','Yes','Yes','','','0','','0','629259','630874' show process list (slave): '3','system user','none','','Connect','20139','Reading master update','' '4','system user','none','','Connect','20139','Slave: waiting for binlog update','' my main concern is that the time on the process list is so long. Am I missing anything? I noticed there is a show hosts command to run on the master. When I run this I get an empty set back. Is this needed? Thanks for your help, Mario __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql replication question(s)
Hi All, I'm having a few issues getting things up and running in regards to replication. I believe I have everything setup correctly the slave is roughly in the same spot as the master as far as the logs are concerned. However, when I make changes in the master db I don't see them show up in the slave db? show master status: 'mhqedi02-bin.012','622609','','' show slave status: 'mhqedi02','replicant','7003','60','mhqedi02-bin.012','630264','royedi01-relay-bin.001','630874','mhqedi02-bin.007','Yes','Yes','','','0','','0','629259','630874' show process list (slave): '3','system user','none','','Connect','20139','Reading master update','' '4','system user','none','','Connect','20139','Slave: waiting for binlog update','' my main concern is that the time on the process list is so long. Am I missing anything? I noticed there is a show hosts command to run on the master. When I run this I get an empty set back. Is this needed? Thanks for your help, Mario __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Import Database from MySQL3.x to MySQL 4.x
Hello! I want to import a MySQL 3.x Databse to my new shiny MySQL4.x. I did a backup with /usr/local/mysql-standard-4.0.14-pc-linux-i686/bin/mysqldump -u root -p --opt -A mysql_lamp_backup.`date '+%Y.%m.%d'`.sql And i tried to import it to MySQL4.x with: /usr/local/mysql/bin/mysql -u root -p mysqlbak The error: ERROR 1064 at line 598: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-en' at line 1 This is teh line 598: CREATE DATABASE /*!32312 IF NOT EXISTS*/ blabla-en; IF i change the name to blabla_en, it works fine. Another issue: ERROR 1064 at line 830: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '! ,'poll','Questions','','',10,'r',11.61,11,10,0011,'','A'), ANd this 830 line ist just far to long to post it :) So do i have a general problem or what did i do wrong so far? Cheers, Mario -- COMPUTERBILD 15/03: Premium-e-mail-Dienste im Test -- 1. GMX TopMail - Platz 1 und Testsieger! 2. GMX ProMail - Platz 2 und Preis-Qualitätssieger! 3. Arcor - 4. web.de - 5. T-Online - 6. freenet.de - 7. daybyday - 8. e-Post -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Recreate mysql
Hi! (B (BI'm a newbie in experimental mode and have just deleted /ALL/ databases on a (BMySQL server, i.e. including the one ("mysql") that contains all the (Badministrative stuff like users, privileges, etc. Is there some way to (Brecreate some default version of that database short of reinstalling the (Bserver? Thx! (B (B (B-- (BMySQL General Mailing List (BFor list archives: http://lists.mysql.com/mysql (BTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Recreate mysql
"Victoria Reznichenko" [EMAIL PROTECTED] wrote: (B (B "Mario" [EMAIL PROTECTED] wrote: (B (B I'm a newbie in experimental mode and have just deleted /ALL/ databases (Bon a (B MySQL server, i.e. including the one ("mysql") that contains all the (B administrative stuff like users, privileges, etc. Is there some way to (B recreate some default version of that database short of reinstalling the (B server? Thx! (B (B Run mysql_install_db script. (B (B (BOK, thanks, that helped - once or twice. After some more "experimenting", (Bunfortunately, all access attempts are now denied. After running (Bmysql_install_db over and over again (with no error mesages) and countless (Battempts to set the password using mysqladmin with all possible (Bcombinations of usernames, passwords, hosts and sockets I can think of (B(there are not that many of course), I still cannot connect. So, I'm now (Bleft wondering if there isn't a way to reinitialize the server to some (B/well/-defined state from which I can restart building tables??? Thx (B (B (B (B-- (BMySQL General Mailing List (BFor list archives: http://lists.mysql.com/mysql (BTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
server has gone away Error
I' m developing a client application using C-Api functions . Server and Client reside on the same machine, so I connect the Server via Unix socket . If I call the mysql_real_query after the wait_timeout expired on the server side , my client crashes. The Manual speaks about the ability of catch the server has gone away Error, Why I haven't ?
Bad field type translation
I found the following error with mysql server version 3.23.52. mysql select snb,id_servicio from Abonados_Servicios where snb=1144293549; 9 rows in set (0.01 sec) mysql select snb,id_servicio from Abonados_Servicios where snb=1144293549; 9 rows in set (45.61 sec) mysql describe Abonados_Servicios; Field Type Null Key Default Extra snb char(10) PRI id_servicio char(2) PRI estadochar(1) A fecha_altadatetime -00-00 00:00:00 fecha_bajadatetime YES NULL fecha_ultima_modificacion datetime YES NULL User char(8) select count(*) from Abonados_Servicios; 1590987 As you can see , the snb field is char(10) type. When you run the first sql statement : select snb,id_servicio from Abonados_Servicios where snb=1144293549; it takes : 9 rows in set (0.01 sec) to complete which is a good performance. But when you run the second sql statement : select snb,id_servicio from Abonados_Servicios where snb=1144293549; it takes : 9 rows in set (45.61 sec) to complete. I'd like to ask you if it wouldn't be better to rise an error or a warning for the second statement instead of taking such amount of time. Thanks Mario Gatica - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to update the database through an applet?
PHP works fine to update a mysql database on the server. But I would like to access a device connected to the serial port or a USB port on the client computer through an applet and store this information in the database on the server. I have tried to find an example of such a transaction on the net, unsuccessfully. Has anybody out there experiences with this kind of problem? It could be any solution, such as PHP + javascript, or PHP all by itself. Is there a good publication talking about this issue? Thank you Mario __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql Blob type
How I treat, the Mysql Blob type when I do a INSERT/SELECT query ( OS Linux RedHat 7.3)? Does anyone know a solution ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql_query
Hello! I am a bloody newbie in this whole mysql area, so please forgive me for such a silly question ;) I have expected to get the text from the field with this code. $result=MYSQL_QUERY( SELECT mail_1 FROM table_mail WHERE rechner_nr='Rechner1'); echo $result; As result i get: Resource id #2 But i exspected: [EMAIL PROTECTED] I hope i hae exlained it well. Cheers, Mario - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_query
Great, thanks a lot! From: Henk Huizinga [mailto:[EMAIL PROTECTED]] Mario, This is actually an PHP question. You forgot the following code : $resultquery = mysql_fetch_row($result); echo $resultquery[0]; Cheers, Henk -Original Message- From: Mario Ohnewald [mailto:[EMAIL PROTECTED]] Sent: dinsdag 24 september 2002 09:50 To: [EMAIL PROTECTED] Subject: mysql_query Hello! I am a bloody newbie in this whole mysql area, so please forgive me for such a silly question ;) I have expected to get the text from the field with this code. $result=MYSQL_QUERY( SELECT mail_1 FROM table_mail WHERE rechner_nr='Rechner1'); echo $result; As result i get: Resource id #2 But i exspected: [EMAIL PROTECTED] I hope i hae exlained it well. Cheers, Mario - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Forgot mysql-root password
Hi! I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux What i did (http://www.mysql.com/doc/en/Resetting_permissions.html): # rcmysql stop # mysqld --skip-grant-tables Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 020918 12:42:39 Aborting 020918 12:42:39 mysqld: Shutdown Complete How can i solve this Problem? I have alread reinstalled mysql, but unforunatelly i keeps its password. Cheers, Mario - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Forgot Mysql-Root Password
Hi! I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux What i did (http://www.mysql.com/doc/en/Resetting_permissions.html): # rcmysql stop # mysqld --skip-grant-tables Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 020918 12:42:39 Aborting 020918 12:42:39 mysqld: Shutdown Complete How can i solve this Problem? I have alread reinstalled mysql, but unforunatelly i keeps its password. Cheers, Mario - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Forgot mysql-root password
AH..thx a lot everybody! -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Mittwoch, 18. September 2002 15:34 To: [EMAIL PROTECTED] Subject: re: Forgot mysql-root password Mario, Wednesday, September 18, 2002, 1:50:25 PM, you wrote: MO I am using SuSE7.3 and mysqld Ver 3.23.41 for suse-linux MO What i did (http://www.mysql.com/doc/en/Resetting_permissions.html): MO # rcmysql stop MO # mysqld --skip-grant-tables MO Fatal error: Please read Security section of the manual to find out how to MO run mysqld as root! MO 020918 12:42:39 Aborting MO 020918 12:42:39 mysqld: Shutdown Complete MO How can i solve this Problem? I have alread reinstalled mysql, but MO unforunatelly i keeps its password. run safe_mysqld --skip-grant-tables instead of mysqld. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Statistics
Hi All, some body knows mysql statistics: # Programers in the world # sites with MySQL database # Companies to support MySQL # sites in with MySQL database Thanks for your help Mario - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Statistics
Hi All, some body knows mysql statistics: # Programers in the world # sites with MySQL database # Companies to support MySQL # sites in with MySQL database Thanks for your help Mario - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 measure the size of MYSQL database?
On Thu, Sep 06, 2001 at 12:31:34PM +0530, [EMAIL PROTECTED] wrote: hello how can we get the size of Mysql database. niraj BN3 Hosted Customer Service Solution, basic service FREE. CRM enable your web site in 5 minutes! http://www.bn3.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 If you are using Linux the following should help: du -hs /var/lib/mysql/ HTH, -- Mario Witte [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
SQL/92 99 Information
Hi, All. Some body nows how I can get a SQL/92 and 99 information. TIA Mario Espinoza Ll. Consultores STI, S.C. [EMAIL PROTECTED] Av. Guadalupe # 618, Col. Chapalita Guadalajara, Jal. México. +52 3122-9004 Ext. 213 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: About installing MySQL on Linux 7.1
On Thu, Aug 09, 2001 at 02:45:23PM +0800, Alan wrote: Excuse Me, I'm a starter to Linux. I've downloaded the MySQL-3.23.40-1 for my Linux OS. They are in .rpm form. How can I install the software properly on Linux! = I try to follow the instructions mentioned in manual.txt but it didn't = work. Can you help me and tell my how to install it? Thanks! Hi, Normally a simple rpm -ivh mysql-3.23.40-1.rpm (or whatever the file is called) should do it. If it doesn't, can you post the output of rpm to this list? Did you download the right package? Which distribution do you use? BTW: Perhaps your distribution has a version numer of 7.1, but the newest Linux kernel is 2.4.7 ;) With regards, -- Mario Witte [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: Kernel crash caused by mysql?
On Fri, Aug 03, 2001 at 03:42:28AM -0700, Van wrote: Mario Witte wrote: Memory or motherboard. How many sticks of RAM do you have in the machine? Are they the same speed (p100/p133, etc.)? What kind of motherboard? Is updatedb running at this time? (might be a hard-drive croaking while trying to update the locate database). There are 2x256 MB and 2x128MB sticks in there, all at a spped of 133. Please don't ask me what kind of motherboard we're running in there, but that shouldn't be a problem. Updatedb is running around midnight, but I just found out that cron.hourly could be a problem in there as we experienced another crash tonight which was at 1:59, the crash yesterday occured at 4:59. Always around the full hour. I've tried and disabled cron.hourly for now, hoping it will help. Seems like it wasn't a problem of mysql, it was just mysql which was killed and thus appeared in the kerne ltrace or something. Seems your machine might have a wrong hardware component somewhere. I'd check it out if it's a production machine. We sure will, but the system is located about 500 kilometers from where our bureau is, so I hope it will stay alive at least over the weekend :-) mysqld can't run as the only service. You can't run anything without initd. Ok, you won! ;) Thanks for your fast help, With regards, -- Mario Witte [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: Newbie need help on MySQL on RH 7.1
On Wed, Aug 01, 2001 at 08:19:45PM -0400, Stonix wrote: Hi, I installed a RH 7.1, and I installed all the packages for apache, php and mysql. I don't know how to check if mysql server is running. On my machine cannot connect to mysql server. Hi, try executing the following command: ps ax|grep mysql If the server is running you should get an output like: 351 ?S 0:00 /bin/sh /usr/bin/safe_mysqld 403 ?S 0:00 /usr/libexec/mysqld 443 ?S 0:00 /usr/libexec/mysqld 444 ?S 0:00 /usr/libexec/mysqld 4152 pts/2S 0:00 grep mysql If there is no such output or just grep mysql try executing /etc/init.d/mysql start to start the server manually. HTH, -- Mario Witte [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
Requirement of INFO
Is there any performance difference between running a query on a compressed MyIsam Table rather than a normal MyIsam Table ? Thanks in advance Bye
Mysql performance monitoring?
Hello, I'm searching for a tool which will provide statistics about the usage of a mysql-server like avg queries/minute, cpu load etc. I've tried mysqler and liked it, but couldn't get it to start as a daemon. Are there any similar tools out there? Thanks in Advance, -- Mario Witte [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 performance monitoring?
Cricket looks great, I think I'll have to try it ASAP. For the moment I just found a utility called mrtg-mysql which puts mysql-stats into mrtg. Statistics aren't very extensive but enough for the moment. -- Mario Witte [EMAIL PROTECTED] On 2001.07.13 07:19:08 -0200 Van wrote: Mario Witte wrote: Hello, I'm searching for a tool which will provide statistics about the usage of a mysql-server like avg queries/minute, cpu load etc. I've tried mysqler and liked it, but couldn't get it to start as a daemon. Are there any similar tools out there? Thanks in Advance, -- Maria: Might be some folks working on it at mrtg, but, I think that one died. SNMP stuff is over kill for that, but, would add some value. http://myops.sourceforge.net/ is a start I've made, with the intentions of incorporating mysql monitoring, but, alas, so much to do, and, so little time. Some work has been done, but, I haven't had the time to port it to anything useful, yet. Mostly, some c apps, still sitting on my workstation. If you like the approach at the link above, I'd love to hear some suggestions. There are also a couple other projects that might be brewing on sourceforge, but, you'll have to search around a little. Also, check out Cricket, which is the next evolution of mrtg. They might have some contributors dealing with this subject. Hope that gives you some ideas. I like the question a lot. Best Regards, Van -- = Linux rocks!!! http://www.dedserius.com/ = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Many Unauthenticatd Users
On 2001.07.10 05:46:25 -0200 Gerlinde Fischer wrote: Hi, maybe you should use when connecting to mysql with the webserver instead of pconnect connect. Pconnect is persistent and is staying as long as you have set the wait_timeout. It is set to 28800 sec by default. Regards Gerlinde At 15:17 09.07.01 -0200, you wrote: On 2001.07.09 11:04:35 -0200 Don Read wrote: Stop Apache (or whatever the source of your logins), shut down restart mysqld, then check/repair the tables in the mysql database; might want check any other high activity tables also. restart Apache. We already tried that. As long as we keep the webservers causing most of the traffic down everything works fine. When reactivating those servers the problem reappears. Maybe mysql has problems inserting data into a table while doing a huge delete-query on the same table? (Around 2am the server has to delete something between 60 and 90 entries while still inserting new data into the table). -- Mario Witte [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 BLITZ Internet Service GmbH Kronacher Strasse 41 D-96052 Bamberg, Germany Tel. +49/951/9685160, Fax +49/951/9685164 http://www.blitz.net Hello, meanwhile we found a solution to the problem. After updating all server and clients to the mysql 3.23.39 the server stopped spawning those dead threads and about an hour later all dead threads had timed out. We still don't know why the problem occured so suddenly (the system had worked for weeks without any interruption before), but it doesn't occur anymore. With regards, -- Mario Witte [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
Many Unauthenticatd Users
Hello, we are running a mysql-3.23-39 server under Suse 7.1 which has to do a very high number of insert-queries (somewhere around 600 queries/minute). But since yesterday the server kepps on spawing processes which are reported to belong to Unauthenticated user and in state Login. This continues until max_connections is reached and then the server quits without further error messages. (Neither in the error log nor in the query-log). We have already tried reinserting all data from a dump, using a different server and different mysql-version. It shouldn't be a load problem, because before the problem occured the server (a Compaq Proliant with a 933 Mhz Xeon cpu) was running on a load average below 0.10. Any help will be appreciated, Thanks in Advance, -- Mario Witte [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: Version question: -log no -log ?
- Original Message - From: [EMAIL PROTECTED] To: Mario Kent [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 1:40 PM Subject: Re: Version question: -log no -log ? Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. You have written the following: I installed 3.23.38 from source on a linux server, a status simply says: Server version: 3.23.38 Now, I just installed 3.23.39 from source on another linux server and it displays: Server version: 3.23.39-log I want to know what the -log means and how it got in there. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Version question: -log no -log ?
- Original Message - From: [EMAIL PROTECTED] To: Mario Kent [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 1:40 PM Subject: Re: Version question: -log no -log ? Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. You have written the following: I installed 3.23.38 from source on a linux server, a status simply says: Server version: 3.23.38 Now, I just installed 3.23.39 from source on another linux server and it displays: Server version: 3.23.39-log I want to know what the -log means and how it got in there. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Version question: -log no -log ?
I installed 3.23.38 from source on a linux server, a status simply says: Server version: 3.23.38 Now, I just installed 3.23.39 from source on another linux server and it displays: Server version: 3.23.39-log I want to know what the -log means and how it got in there. [In order to get this message to post I must work in a few keywords, so I'll just mention that this message has nothing to do with a query or a specific table, but it is in reference to the MySQL database server, which of course speaks 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
How I can run a script in MySQLManager
Hi, All. I have a problem to run a script in mysqlmanager. I have file generated with mysqldump with the data definition of my database, but the error show is (You have an error in your SQL syntax near ';). Has anyone encountered this problem . Thanks. Mario Espinoza Ll. Consultares STI, S.C. [EMAIL PROTECTED] Av. Guadalupe # 618, Col. Chapalita. Guadalajara, Jal. México. +52 3121-0411 Ext. 213 +52 3121-0548 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
some question about create db
I have to create a database from an application (written in perl) how can I do? how can I create a db if the user is not a root? which command can I use? Thank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to do a query using a file?
I have to buitd a big database. I have to create table, insert row in database and then do the same thing on another computer. I'd like to do that using a file in whiich I write all ... but how can I do? Thank you in advance. Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql can't start: help!
I use RedHat (last release) I try to use Mysql but It doesen' works: I post you some lines can help you to understand the error. how can create a table, use Mysql? Thank you in advance, Mario. - [root@localhost mysqld]$ mysqladmin vesion mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mys .sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql. ists! - [root@localhost mysql]# ./mysql.server start [root@localhost mysql]# Starting mysqld daemon with databases from /var/lib/mysql 010430 10:37:02 mysqld ended - [root@localhost log]# tail mysqld.log 010430 10:22:19 mysqld ended 010430 10:24:50 mysqld started 010430 10:24:50 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist 010430 10:24:50 mysqld ended 010430 10:37:02 mysqld started 010430 10:37:02 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist 010430 10:37:02 mysqld ended - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 do a query using a file?
query: load data local infile file.txt into table my_table Thank you. But for creating an entire and complex database? I mean If you have to create 40 table?!? there is a way to do it by ascii file? I write the SQL commands once and then I can recreate the db whth tables in different computers. Thank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 can't start: help!
Please check the manual both about common problems and how to post problems in list. This error can depend on which MySQL version you installed. Is it RPM, binary or source installation? Check the manual again I'm very sorry for take a noice to mailing list... but I try it! i try also with safe_mysqld and some other command but it dont work! For the version should be ritht : It was istalled by RedHat (last version!) I need mysql for thesis and I have to develop a free software... so sorry if I make noice but I hope my work will be userfull for somebody of you in the future. Mario. I use RedHat (last release) I try to use Mysql but It doesen' works: I post you some lines can help you to understand the error. how can create a table, use Mysql? Thank you in advance, Mario. - [root@localhost mysqld]$ mysqladmin vesion mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mys .sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql. ists! - [root@localhost mysql]# ./mysql.server start [root@localhost mysql]# Starting mysqld daemon with databases from /var/lib/mysql 010430 10:37:02 mysqld ended - [root@localhost log]# tail mysqld.log 010430 10:22:19 mysqld ended 010430 10:24:50 mysqld started 010430 10:24:50 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist 010430 10:24:50 mysqld ended 010430 10:37:02 mysqld started 010430 10:37:02 /usr/libexec/mysqld: Table 'mysql.host' doesn't exist 010430 10:37:02 mysqld ended Please check the manual both about common problems and how to post problems in list. This error can depend on which MySQL version you installed. Is it RPM, binary or source installation? Check the manual again - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
mysqlgui: help.
I tried mysqlgui: mysqlgui-linux-static-1.7.5]$ ./mysqlgui but it didn't works well: It can't connect to mysql. Why? How can I do to connect for example to a database called "visia" with pw "pw_visia" from an user called "rino" in "localhost"? mysqlgui ask me a password: what password it want? Tank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to connect MySql with Java?
I'd like to use MySql with Java (under Linux) bu I can't be able to do that: how can I do? Thank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to make SQL command by a file?
It is easy make an error while writing SQL coimmand to create table, etc... So I'd like to write this command (CREATE TABLE) in a file then run this command in mysql: How can I do? how can I write it? Thank you in advance. Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how can I get code example of manual?
I'd like to write a simple application with API of MySql. I see "4.4.1 A Simple Exaple" of the manual but I can't find the file "simple1.cc" that should be in my computer... but there isn't. How can install it? thank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How compile a C/C++ program which use API for mysql?
I have write a simple program in C/C++. this program use API for Mysql (linux) the question is : How to compile this programs? Tank you in advance, Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 have a table very very big?
Thank you for your response (I said right?!? sorry for my little english!) what you say is very interesting!!! Where can I read more about RAID_TYPE ecc... (the 3 solution you said?)? Now I'm writing the program in C and I have not meet this problem but I will :-( Just for curiosity: I have to study the flow of data in a net : I'm working in a network desing. If somebody is doing that or is interested we can exchange experiences and suggestions. Thank you again. Mario. Il 16:51, gioved 15 marzo 2001, scrivesti: Hi Mario, I think I had the same problem as you, and got som help... You have three ways of doing this: 1. Switch to a FileSystem that supports bigger Files 2. Use MERGE, create a lot of small tables and use MERGE in you select Querys, The manual is quit god at explaining how to do this, but I'll think you will find the limitations about INSERT as irritating as I 3. Use the --with-raid option. This is what I do. You need to recompile the mysqld using --with-raid when configuering it. This way you can create tables Using: RAID_TYPE=1 RAID_CHUNKS=XX RAID_CHUNKSIZE=YY The RAID_CHUNKS tells the mysql how many separate files it will split the DB into. IE. RAID_CHUNKS=100 will create 100 datafiles, wich each can be 2GB = 2 000 GB. More about this in CREATE TABLE. The problem with this is the indexfile, wich now is the problem (max 2GB) But I'll will reach that in about 2 weeks so ill figure something out by then. /roger I have to store data for Internet desining (10-20 Gb at Day) so I have to use a data base very fast: MySql is fast? I have to put 10-20 Gb of data every day: but I can have a table only of 2Gb (I know that reading manual of Mysql). How to do a table so big? Thank you in advance, Rino. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get Your Private, Free E-mail from MSN Hotmail at 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to have a table very very big?
I have to store data for Internet desining (10-20 Gb at Day) so I have to use a data base very fast: MySql is fast? I have to put 10-20 Gb of data every day: but I can have a table only of 2Gb (I know that reading manual of Mysql). How to do a table so big? Thank you in advance, Rino. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ordering a table by myiasmchk?
If I order a table using myiasmchk then, when I put other row in the table, this thable is still ordered or I have to reorder again? Thank you in advance,Mario. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php