Re: [newbie question] how do you change the default charset of MySQLunder windows
Hi Paul, I does not matter if you use the my.ini in the Windows directory or the my.cnf in the c: root, but the last one will be used first. You my.cnf (and my.ini also) should look like this: ---stat of my.cnf [mysqld] default-character-set=hungarian default-table-type=InnoDB innodb_data_file_path = ibdata1:10M:autoextend:max:2000M innodb_data_home_dir = c:\mysql\ibdata innodb_log_group_home_dir = c:\mysql\ibdata\logs innodb_log_arch_dir = c:\mysql\ibdata\logs set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=8M set-variable = innodb_log_buffer_size=1M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=48M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 ---end of my.cnf This is a simple my.cnf I use under WinNT for InnoDB tables as default table type, and 'hungarian' as default character set. Basically you need only the first two lines. But the point is, that the default-character-set line must be in the [mysqld] section, because the mysql daemon (or service under WinNT) will take only commands only in this section into consideration. Bye, Daniel At 15:44 2002.10.30. +0800, you wrote: Thanks Daniel, I've looked for the "my.cnf" file but couldn't find it but I found a "my.ini" under the c:\Winnt directory, with the following content: [WinMySQLAdmin] Server=c:/mysql/bin/mysqld-nt.exe I've tried appending the line "default-character-set=big5" to it and restarted MySQL but doesn't seem to do the trick. Should I create a "my.cnf" in the C: root instead with the "default-character-set" to it? Thanks a lot! Paul - Original Message - From: "Daniel Kiss" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 3:06 PM Subject: Re: [newbie question] how do you change the default charset of MySQL under windows > Hi > > You have to write a line like this into your my.cnf (in the C: root directory): > > default-character-set=... > > or whatever you like. You can find examples in your mysql directory for the > my.cnf file. > Oh, yes! You're from Hong Kong. So maybe you need this: > > default-character-set=big5 > > Bye, > Daniel > > At 14:47 2002.10.30. +0800, you wrote: > >Hi all, > > > >I've checked the doco and found that it can be changed by ./configure under > >Linux, but how do I change the default charset of MySQL under Win2K. Do I > >have to re-compile the source or better yet can I change it on the fly or > >using WinMySQLAdmin or something? > > > >TIA > > > >Paul > > > > > >- > >Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > >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: [newbie question] how do you change the default charset of MySQL under windows
Thanks Daniel, I've looked for the "my.cnf" file but couldn't find it but I found a "my.ini" under the c:\Winnt directory, with the following content: [WinMySQLAdmin] Server=c:/mysql/bin/mysqld-nt.exe I've tried appending the line "default-character-set=big5" to it and restarted MySQL but doesn't seem to do the trick. Should I create a "my.cnf" in the C: root instead with the "default-character-set" to it? Thanks a lot! Paul - Original Message - From: "Daniel Kiss" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 3:06 PM Subject: Re: [newbie question] how do you change the default charset of MySQL under windows > Hi > > You have to write a line like this into your my.cnf (in the C: root directory): > > default-character-set=... > > or whatever you like. You can find examples in your mysql directory for the > my.cnf file. > Oh, yes! You're from Hong Kong. So maybe you need this: > > default-character-set=big5 > > Bye, > Daniel > > At 14:47 2002.10.30. +0800, you wrote: > >Hi all, > > > >I've checked the doco and found that it can be changed by ./configure under > >Linux, but how do I change the default charset of MySQL under Win2K. Do I > >have to re-compile the source or better yet can I change it on the fly or > >using WinMySQLAdmin or something? > > > >TIA > > > >Paul > > > > > >- > >Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > >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: Backup DB
Hi, Shut your database down, backup all files, and restart it If you use InnoDB you can do a hot backup like Oracle (the implementation of InnoDB is near of Oracle), but it's not free. I can't say more about this, but it's in the documentation about InnoDB. You can also keep a differential between two backup (in case the last backup is corrupted) using binary log of MySQL (use --log-bin at startup). I just begin to test it... To do a backup of all you database(s) you can use mysqldump. The dump contains "create datase, table, ..." and "insert ..." orders. Being beginner, I'm also interested about backup stuff, I hope somebody will complete my post. Sam. -Message d'origine- De : Amol Sonaikar [mailto:amol@;kenati.com] Envoyé : mercredi 30 octobre 2002 06:27 À : [EMAIL PROTECTED] Objet : Backup DB HI All I am new to mysql. We have a small application which runs on mysql db. We want to backup the database for mysql. What is the easiest method to that ? Do we have to move datafiles or import export like oracle ? If you can send me a specific link or article for backup and recovery for mysql , I'll be very much thankful. Thanks Amol Oracle 8i DBA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [newbie question] how do you change the default charset of MySQLunder windows
Hi You have to write a line like this into your my.cnf (in the C: root directory): default-character-set=... or whatever you like. You can find examples in your mysql directory for the my.cnf file. Oh, yes! You're from Hong Kong. So maybe you need this: default-character-set=big5 Bye, Daniel At 14:47 2002.10.30. +0800, you wrote: Hi all, I've checked the doco and found that it can be changed by ./configure under Linux, but how do I change the default charset of MySQL under Win2K. Do I have to re-compile the source or better yet can I change it on the fly or using WinMySQLAdmin or something? TIA Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
[newbie question] how do you change the default charset of MySQL under windows
Hi all, I've checked the doco and found that it can be changed by ./configure under Linux, but how do I change the default charset of MySQL under Win2K. Do I have to re-compile the source or better yet can I change it on the fly or using WinMySQLAdmin or something? TIA Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: access2mysql data types
MySQL does not have a boolean type. For yes/no or true/false information, I usually use an enumerator (enum) and define the "false" value first and the "true" second. (So "no" would be first and "yes" second.) Then, when I query for the value in that field, I can ask for it minus one, and I get a numerical value that can be translated more easily into a boolean value, where "false" is 0 and "true" is 1. MySQL assigns the value of 1 to the first element of the enumerator and reserves 0 for errors, so that's why you have to subtract. If you simply query for the value of the field, you will get "false," "true," "no," "yes," or whatever -- but, if you put any arithmetic operator into your SQL statement, MySQL will send you the results of calculation using the numerical internal representation instead. create table boolean_table(boolean enum("false","true")); insert into boolean_table values("true")); If I am working in C or PHP or another language that treats 0 as false and 1 as true, I can do this sort of test with the results -- or the reverse -- (this example is in C) -- if (!row[0]) puts("The value is false."); Amittai Aviram [EMAIL PROTECTED] - Original Message - From: "Angelo Carmo" <[EMAIL PROTECTED]> aTo: <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 8:36 PM Subject: access2mysql data types > > Hi people, > > what is the best type to substitute the boolean type of msaccess tables. > Or mysql databases support the boolean type? > > Angelo. > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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
Backup DB
HI All I am new to mysql. We have a small application which runs on mysql db. We want to backup the database for mysql. What is the easiest method to that ? Do we have to move datafiles or import export like oracle ? If you can send me a specific link or article for backup and recovery for mysql , I'll be very much thankful. Thanks Amol Oracle 8i DBA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Thread Thrashing and 3.23.53a
On Wed, Oct 30, 2002 at 05:56:52AM +0100, Mark wrote: > > Is this all true? Bummer. :( I just upgraded to 3.23.53 (from > .49). I cannot afford to get these huge load averages on my news > server. Nor can I afford thread thrashing. I just had to let myself > be talked into upgrading. See if I still have the .49 binary. *Some* users had problems with the pre-built binaries under load. MySQL AB found a problem with their custom glibc and fixed it recently. That seems to have resovled it. > Seriously, are there any MySQL developers here on the list who can > tell me why this happens? If at all. There are. In fact, if you check the archives, I think that Lenz dicussed it a week or so ago. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 84 days, processed 1,770,312,959 queries (241/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Thread Thrashing and 3.23.53a
Is this all true? Bummer. :( I just upgraded to 3.23.53 (from .49). I cannot afford to get these huge load averages on my news server. Nor can I afford thread thrashing. I just had to let myself be talked into upgrading. See if I still have the .49 binary. Seriously, are there any MySQL developers here on the list who can tell me why this happens? If at all. - Mark System Administrator Asarian-host.org --- "If you were supposed to understand it, we wouldn't call it code." - FedEx - Original Message - From: "heath boutwell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 11:34 PM Subject: Re: Thread Thrashing and 3.23.53a > Jeremy, > > Thanks for mytop. Its a great tool and its been a > great help in diagnosing our problems. > > I saw where a few of the others claimed the latest > binaries resolved the issues. Its not clear whether > their problem was the same others were experiencing > (those whose probs were corrected w/ .53a were > complaining of 'out of sync' errors which seems > different than the type of CPU throttling myself and > others have observed). > > Anything over 50 queries a second for even a short > time brought the cpu to its knees. Mysqld processes > were eating up all the cpu and the server becomes > practically non-responsive. > > With the older binaries, we avgd 20 queries second > with bursts up to 200-300 with no problem. The load > average stayed around .50 or so and went to around 3 > under heaviest load conditions. > > With the latest binary (installed under thus far lower > usage) we are seing 13 queries a second but the load > average stays at 1.3 which is not a good sign. It > looks like we will see a meltdown under even moderate > load conditions. > > The weekends our the heaviest times for us and I will > keep the list posted on what happens as I know there > were many others that struggled with this over the > past year and found no resolution other than > downgrading to ancient versions of the binaries. > > 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
Re: Thread Thrashing and 3.23.53a
On Tue, Oct 29, 2002 at 08:25:00PM -0800, heath boutwell wrote: > --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > > Can you post the output of SHOW VARIABLES? > | > | key_buffer_size | 402649088 Hm. That's a 384MB key buffer. And you have 2GB of RAM. If the sum of your *.MYI files is more than 384MB, try increasing that to match. What's mytop say about your key efficiency? > | max_join_size | 4294967295 Wow. You doing really big joins? > thanks for taking a look at these... Other than that, I don't see anything terribly odd (unless I missed something). The only thing left to look at is SHOW STATUS. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 84 days, processed 1,770,166,363 queries (241/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Thread Thrashing and 3.23.53a
--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > Can you post the output of SHOW VARIABLES? | +-+ | back_log| 50 | basedir | / | binlog_cache_size | 32768 | character_set | latin1 | character_sets | latin1 big5 czech euc_kr gb2312 | concurrent_insert | ON | connect_timeout | 5 | datadir | /var/lib/mysql/ | delay_key_write | ON | delayed_insert_limit| 100 | delayed_insert_timeout | 300 | delayed_queue_size | 1000 | flush | OFF | flush_time | 0 | have_bdb| NO | have_gemini | NO | have_innodb | NO | have_isam | YES | have_raid | NO | have_openssl| NO | init_file | | interactive_timeout | 28800 | join_buffer_size| 131072 | key_buffer_size | 402649088 | language| /usr/share/mysql/english/ | large_files_support | ON | locked_in_memory| OFF | log | OFF | log_update | OFF | log_bin | OFF | log_slave_updates | OFF | log_long_queries| ON | long_query_time | 3 | low_priority_updates| OFF | lower_case_table_names | 0 | max_allowed_packet | 1047552 | max_binlog_cache_size | 4294967295 | max_binlog_size | 1073741824 | max_connections | 250 | max_connect_errors | 10 | max_delayed_threads | 20 | max_heap_table_size | 16777216 | max_join_size | 4294967295 | max_sort_length | 1024 | max_user_connections| 0 | max_tmp_tables | 32 | max_write_lock_count| 4294967295 | myisam_max_extra_sort_file_size | 256 | myisam_max_sort_file_size | 2047 | myisam_recover_options | 0 | myisam_sort_buffer_size | 67108864 | net_buffer_length | 16384 | net_read_timeout| 30 | net_retry_count | 10 | net_write_timeout | 60 | open_files_limit| 0 | pid_file| /var/lib/mysql/primary.pid | port| 3306 | protocol_version| 10 | record_buffer | 2093056 | record_rnd_buffer | 2093056 | query_buffer_size | 0 | safe_show_database | OFF | server_id | 0 | slave_net_timeout | 3600 | skip_locking| ON | skip_networking | OFF | skip_show_database | OFF | slow_launch_time| 2 | socket | /var/lib/mysql/mysql.sock | sort_buf
Re: Thread Thrashing and 3.23.53a
On Tue, Oct 29, 2002 at 07:37:09PM -0800, heath boutwell wrote: > > --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > >You're disk-bound, not CPU bound. Notice all the idle CPU time? And > >the fact that the "b" column always has one process listed, while "r" > >only does once in a while. > > 2 gigs of ram -- don't really know why we'd be disk bound. The > my.cnf is pretty well optimized. > > I guess the real verdict will come once we get a better load surge. > The higher load avgs I'm seeing now aren't exactly inspiring > confidence though. Can you post the output of SHOW VARIABLES? -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.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: Thread Thrashing and 3.23.53a
> --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: >You're disk-bound, not CPU bound. Notice all the idle CPU time? And >the fact that the "b" column always has one process listed, while "r" >only does once in a while. 2 gigs of ram -- don't really know why we'd be disk bound. The my.cnf is pretty well optimized. I guess the real verdict will come once we get a better load surge. The higher load avgs I'm seeing now aren't exactly inspiring confidence though. Thanks again. sql, query __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.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
access2mysql data types
Hi people, what is the best type to substitute the boolean type of msaccess tables. Or mysql databases support the boolean type? Angelo. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyIsam Table Damage
SQL ... I have a myisam table that registers documents in my database .. There is a longtext field for the actual document data in HTML the table (file , MYD) is about 1.2 MB, but from 300 records it had only reports 6 ... I use repair table extended and works fine until I get and error no enough memory for blob 88602 ... What parameters do I have to change so this can work ? thanks in advance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Access2MySQL
[EMAIL PROTECTED] wrote: Hi all, After setting the field data type in MySQL to Text, which is the same data type for Access data type where the data is being imported from, the import process was succeful and the same number of rows was imported, BUT I don't see any data in the MySQL, all I see is Null, Null. any comment ?? Sam You can use the 'MyAccess' program, which is an Access plugin. There's an Access 97 version and also an Access 2000 version which works with Access 2002. While it does work well, there was something about the way it converted field types which made me a little suspicious, but I can't quite remember why. When it works, it does work well. Just keep an eye on it... You can find a link to it on the MySQL site, in the 'contributed software' section I think. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.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: Access2MySQL
I use MySQLFront and is creats the tables and imports the data with one click never had a problem Alan > -Original Message- > From: [EMAIL PROTECTED] [mailto:Sam4Software@;aol.com] > Sent: Wednesday, 30 October 2002 9:15 > To: [EMAIL PROTECTED] > Subject: Access2MySQL > > > Hi all, > > After setting the field data type in MySQL to Text, which is the > same data > type for Access data type where the data is being imported from, > the import > process was succeful and the same number of rows was imported, BUT I > don't see any data in the MySQL, all I see is Null, Null. any > comment ?? > > Sam > > > 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 > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Thread Thrashing and 3.23.53a
On Tue, Oct 29, 2002 at 03:56:04PM -0800, heath boutwell wrote: > > --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > > Well, "load average" can be misleading. > > > > Can you maybe share the output of "vmstat 1" or "vmstat 5" for a > > minute's worth of time? It's be good to see what the CPUs states look > > like. It is a lot of system time? User time? Both? > > Load average of 1.5 seems high when we are only averaging 14 queries > per sec (nothing else going crazy running on the box) > >procs memoryswap io system cpu > r b w swpd free buff cache si sobibo incs us sy id > 0 1 0972 810004 569536 286708 0 0 9 14 9 0 5 11 > 1 1 0972 809604 569536 286708 0 0 0 4 147 188 20 7 73 > 1 1 0972 809008 569536 286708 0 0 011 158 165 20 7 73 > 0 1 0972 809488 569536 286708 0 0 0 7 158 207 17 11 72 > 1 1 0972 807248 569536 286708 0 0 0 8 149 132 14 5 80 > 0 1 0972 809072 569536 286708 0 0 0 6 164 264 40 8 51 > 0 1 0972 808984 569536 286712 0 0 011 172 267 23 7 71 You're disk-bound, not CPU bound. Notice all the idle CPU time? And the fact that the "b" column always has one process listed, while "r" only does once in a while. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.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: Thread Thrashing and 3.23.53a
On Tue, Oct 29, 2002 at 02:34:44PM -0800, heath boutwell wrote: > --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > > I've read others who've said it fixed the problem > > for them. Did you > > check the archives? > > Jeremy, > > Thanks for mytop. Its a great tool and its been a great help in > diagnosing our problems. Excellent. Good to hear. > I saw where a few of the others claimed the latest binaries resolved > the issues. Its not clear whether their problem was the same others > were experiencing (those whose probs were corrected w/ .53a were > complaining of 'out of sync' errors which seems different than the > type of CPU throttling myself and others have observed). I read of folks who had used earlier binaries and couldn't handle any significanly workloads. Their load average would go through the roof and threads would all seem to lockup on the server. > Anything over 50 queries a second for even a short time brought the > cpu to its knees. Mysqld processes were eating up all the cpu and > the server becomes practically non-responsive. > > With the older binaries, we avgd 20 queries second with bursts up to > 200-300 with no problem. The load average stayed around .50 or so > and went to around 3 under heaviest load conditions. > > With the latest binary (installed under thus far lower usage) we are > seing 13 queries a second but the load average stays at 1.3 which is > not a good sign. It looks like we will see a meltdown under even > moderate load conditions. > > The weekends our the heaviest times for us and I will keep the list > posted on what happens as I know there were many others that > struggled with this over the past year and found no resolution other > than downgrading to ancient versions of the binaries. Well, "load average" can be misleading. Can you maybe share the output of "vmstat 1" or "vmstat 5" for a minute's worth of time? It's be good to see what the CPUs states look like. It is a lot of system time? User time? Both? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 84 days, processed 1,766,760,219 queries (241/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: i almost hate queires, please help!!!
Here's what I did. Based on the same query (the one you provided) as below I executed the following: select mgrname, pjname from managers, projects, pocs WHERE pjid = 'x' AND pocs.pjid = projects.pjid AND pocs.pmyid = 'x' AND pocs.altid = 'x' AND (pocs.pmyid = managers.pmyid OR pocs.altid = managers.altid) and it worked fine. However, what I now get is both names of managers associated with pjid ='x' in two seperate lines. What I mean is, instead of getting project.name | primary name | alternate name I get project name | primary name , project name | alternate name. What I want is the first example project name | primary name | alternate name .all on the same row. Is this achieved by an outer join? If so, can somone give me a syntax example or point me to some good reading online? - Original Message - From: "David Gilmour" <[EMAIL PROTECTED]> To: "Randy Hammons" <[EMAIL PROTECTED]> Sent: Monday, October 28, 2002 8:31 PM Subject: Re: i almost hate queires, please help!!! > Randy, > > See below > - Original Message - > From: "Randy Hammons" <[EMAIL PROTECTED]> > To: "mysql" <[EMAIL PROTECTED]> > Sent: Tuesday, October 29, 2002 4:17 PM > Subject: i almost hate queires, please help!!! > > > > here's my table syntax: > > > > create table Projects > > ( PjID int unsigned auto_increment not null primary key, > >PjNumber varchar(40) not null, > >PjName tinytext not null, > >PjDesc tinytext, > >PJEcd varchar(30), > >PJCost varchar(30), > >LastUpdate char(30) > > ); > > > > create table Managers > > ( MgrID int unsigned auto_increment primary key, > >MgrName varchar(40) not null, > >PrimaryID int unsigned not null, > >AlternateID int unsigned not null > > ); > > > > create table PjStatus > > ( StatID int unsigned auto_increment not null primary key, > >PjID int unsigned not null, > >Actions longtext, > >Status varchar(10) > > ); > > > > create table POCs > > ( PjID int unsigned not null, > >pmyid int unsigned not null, > >altid varchar(5) not null, > > > > I only have two records stored in my database currently. You'll notice > the > > "managers" table has 3 id's for each manager. MGRid is the PK only reason > > for that. PrimaryID and Alternate ID are both for tracking purposes. A > > manager might be the "primary" manager (meaning the one ultimately > > responsible for the project) or he may be an alternate (backing somone > else > > up who is the primary). Therefore, these two columns will have a one to > > many relationship with the POCs table. Here's what I want to do: > > > > define a query that will select * from the POCs table and display that > info > > via a php script in a table. Simple enough right? WRONG! I know plently > > about php but jack about SQL. My query is as follows: > > > > select mgrname, pjname > > from managers, projects, pocs > > where pjid = 'x' > > and pmyid = 'x' > > and altid = 'x' > > > > Try > select mgrname, pjname > from managers, projects, pocs > where pjid = 'x' > and pmyid = 'x' > and pmyid=managers.Mgrid > > If you want the altid you will need to do an outer join. whcih you will need > to read up about > > > NOW! This should give me an output like this: > > > > +--+ > > |__pjname|___mgrname(primary)___|___mgrname(alternate)_| > > | testproject testprimary1 testprimary2 > > > > Instead, what I get is the name of the project with EVERY single manager > > that I have loaded. Now I only have two records (or 2 projects) loaded > into > > this database, but I have over 90 different project managers loaded (don't > > ask why, lost a bet on that one). So what happens is, I get the > > "testproject" name for the pjname and I get it replicated 94 different > times > > for each and every manager that I have loaded. So it seems like every > > single manager is associated with this project. WTF am I doing wrong? > This > > is going on 11 days trying to figure this out. Am I doing the joins wrong > > or something? Does my table design not allow me to do what I'm trying to > > do? Should I instead be trying to nest 3 queries in one and display the > > output side by side (sort of like the html talbe theory???)?? > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > 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-m
Re: Thread Thrashing and 3.23.53a
--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > I've read others who've said it fixed the problem > for them. Did you > check the archives? Jeremy, Thanks for mytop. Its a great tool and its been a great help in diagnosing our problems. I saw where a few of the others claimed the latest binaries resolved the issues. Its not clear whether their problem was the same others were experiencing (those whose probs were corrected w/ .53a were complaining of 'out of sync' errors which seems different than the type of CPU throttling myself and others have observed). Anything over 50 queries a second for even a short time brought the cpu to its knees. Mysqld processes were eating up all the cpu and the server becomes practically non-responsive. With the older binaries, we avgd 20 queries second with bursts up to 200-300 with no problem. The load average stayed around .50 or so and went to around 3 under heaviest load conditions. With the latest binary (installed under thus far lower usage) we are seing 13 queries a second but the load average stays at 1.3 which is not a good sign. It looks like we will see a meltdown under even moderate load conditions. The weekends our the heaviest times for us and I will keep the list posted on what happens as I know there were many others that struggled with this over the past year and found no resolution other than downgrading to ancient versions of the binaries. Thanks, __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.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
Access2MySQL
Hi all, After setting the field data type in MySQL to Text, which is the same data type for Access data type where the data is being imported from, the import process was succeful and the same number of rows was imported, BUT I don't see any data in the MySQL, all I see is Null, Null. any comment ?? Sam 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
InnoDb referencing key bug?
In Jannie's problem, CREATE TABLE pub_access_type( access_type_id INT UNSIGNED NOT NULL, access_type_name VARCHAR(25), PRIMARY KEY(access_type_id) ) TYPE=INNODB; CREATE TABLE pub_user( user_id INT UNSIGNED, parent_id INT, user_fname VARCHAR (25), user_lname VARCHAR (25), user_password VARCHAR (25), INDEX par_ind(parent_id), FOREIGN KEY parent_id REFERENCES pub_access_type(access_type_id) ON DELETE SET NULL ) TYPE=INNODB; MySQL correctly refuses to create pub_user because it has been asked to reference an unsigned key, pub_access_type(access_type_id), with the signed key parent_id. Jannie found that MySQL accepts the incorrect key reference if the referencing key is aliased ... ... FOREIGN KEY pub_user(parent_id) ... ... But consider what will happen when parent_id wraps around. Looks like a bug. PB - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Lost connection to MySQL server during query
What are the possible causes for this error message ? This problem occured right after I restarted mysqld on my machine. I can access mysql on localhost without any failure, either in command mode, telnet or via httpd with PHP, but connection via PHP on remote machine fails. Here's what I see if I try to telnet, seams like the service is simply dropping the connection. [root@intranet CAMusage]# telnet 10.0.6.2 3306 Trying 10.0.6.2... Connected to 10.0.6.2. Escape character is '^]'. Connection closed by foreign host. Here's what I see in mysqld.log : Number of processes running now: 1 mysqld process hanging, pid 30546 - killed 021029 16:46:23 mysqld restarted /usr/libexec/mysqld: ready for connections ... and in queries.log : /usr/libexec/mysqld, Version: 3.23.41-log, started with: Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock Time Id CommandArgument Any help would be very appreciate. BTW, I run mysql-3.23.41 Thanks a bunch. --- Frederic Trudeau Consultant, PHP Coder, Development [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: Thread Thrashing and 3.23.53a
On Tue, Oct 29, 2002 at 01:28:01PM -0800, heath boutwell wrote: > > Can anyone that was experiencing the thread thrashing problems with > the other binaries confirm that this has been with resolved with > 53a? I've read others who've said it fixed the problem for them. Did you check the archives? -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 84 days, processed 1,765,829,730 queries (241/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Limit General Log to specific databases
On Tue, Oct 29, 2002 at 02:38:49PM -0600, Don Arnett wrote: > > I can't find any info on this, so doubt that it's possible. Is there a way > to have General Logging enabled, but not log every database on the server? > I have one database that I'd like to not be logged (too much activity), but > don't have the option of moving it to a separate server. You're out of luck, I'm afraid. You could try post-processing the log to remove the stuff you don't want, but MySQL doesn't have anything built in to help you. If you were using the binary log, however, you could specify datbase-specific filtering. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 84 days, processed 1,765,811,285 queries (241/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thread Thrashing and 3.23.53a
Can anyone that was experiencing the thread thrashing problems with the other binaries confirm that this has been with resolved with 53a? I have installed the new binaries and will report what is observed here after periods of heavy load. Others on the list experienced the same occurances. Previously, upgrading from 3.23.32 to .53 proved to be disasterous as mysql would throttle the cpu to the point of no return. .32 was great under high load and proved to be very stable for us. Thanks, __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.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
Re: Query - Top Ten
SELECT ... ORDER BY score LIMIT 10 PB - - Original Message - From: "Kevin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 1:11 PM Subject: Query - Top Ten > Hello, > > I have a table with the following structure and values: > > CustomerIDScore > > 4 8 > 2 6 > 3 2 > 3 8 > 4 7 > 2 7 > > I would like to query for the top ten customer averages. Is this possible in > a single query? > > The result will be something like: > > CustomerID Average Score > 4 7.5 > 2 6.5 > 3 5 > > TIA. > > 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 > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Query - Top Ten
> Hello, > > I have a table with the following structure and values: > > CustomerIDScore > > 4 8 > 2 6 > 3 2 > 3 8 > 4 7 > 2 7 > > I would like to query for the top ten customer averages. Is > this possible in > a single query? Try: select CustomerID, avg(score) as A from table_name group by CustomerID order by A desc limit 10 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query - Top Ten
Hello, I have a table with the following structure and values: CustomerIDScore 4 8 2 6 3 2 3 8 4 7 2 7 I would like to query for the top ten customer averages. Is this possible in a single query? The result will be something like: CustomerID Average Score 4 7.5 2 6.5 3 5 TIA. 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
mysql crashes when the slave is started with incorrect master info
>Description: When a slave is pointing to a non-existing master, doing "slave start/slave stop" will sometimes cause the MySQL server to crash >How-To-Repeat: mysql> change master to master_host='bogus', master_log_file=''; Query OK, 0 rows affected (0.00 sec) mysql> slave start; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:2 Current database: *** NONE *** ERROR 1198: This operation cannot be performed with a running slave, run SLAVE STOP first The server doesn't always crash. When I type "slave start/slave stop", I maybe see a crash 10% of the time. >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: mysql crashes when the slave is started with incorrect master info >Severity: >Priority: >Category: mysql >Class: >Release: mysql-3.23.53a (Official MySQL RPM) >Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.53a, 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.53a-Max Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 1 min 34 sec Threads: 1 Questions: 2 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.021 >Environment: System: Linux exads28 2.4.18-smp #21 SMP Thu Oct 24 23:35:15 PDT 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Oct 24 13:43 /lib/libc.so.6 -> libc-2.2.4.so -rwxr-xr-x1 root root 1282588 Sep 4 2001 /lib/libc-2.2.4.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --enable-local-infile --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info --includedir=/usr/include --mandir=/usr/share/man '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' CXX=gcc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 2013
I am receiving an error 2013: Lost Connection to MySQL server during query when I try to remotely log onto mysql. If I am at the Linux box, and I type mysql -u -p I can connect, but if I do a mysql -h -u -p it gives me this message. Also, I cannot connect from another machine at all. Stopping mysql fails every time. My version is 3.23.32. Thanks for any help/ideas!
RE: Altering Table errors
Then, why..., if I wait a little longer, does the alter command work? I do not change the the permissions in the meantime. I just wait. Alan > -Original Message- > From: gerald_clark [mailto:gerald_clark@;suppliersystems.com] > Sent: Tuesday, 29 October 2002 1:38 > To: Alan McDonald > Cc: [EMAIL PROTECTED] > Subject: Re: Altering Table errors > > > Error 13 is an operating system privilege violation error. > the user 'mysql' does not own or have access to something in > the database. > > Alan McDonald wrote: > > >MySQL > > > > > >I asume that when I add a field or rename a field etc and get the errcode > >13, that I must wait til a connection timeout has occurred to be able to > >make this structural change. While I'm developing, is there a > quicker way to > >do this? > >Stopping/starting the service is not that quick.. Is there another way? > > > >thanks > >Alan > > > > > > > >- > >Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > >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
upgrading mysql
Perhaps a simple question. The solaris server we have has an older mysql. I don't know which version since I did not install it. The mysql main file is now segment faulting for some reason. I restored a backup but its not working either. It just worked a few days ago. I assume the file is now corrupted because of this? Can I just upgrade mysql? Will all databases have to be added again? I really just need the main mysql file replaced, but I don't know an easy way to do that. The original build directory is long past gone. Is upgrading a decent solution for this, or what else might I try? Thanks, Aaron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Limit General Log to specific databases
I can't find any info on this, so doubt that it's possible. Is there a way to have General Logging enabled, but not log every database on the server? I have one database that I'd like to not be logged (too much activity), but don't have the option of moving it to a separate server. Thanks Don Sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Create child table question
Jannie, In CREATE TABLE ... TYPE=InnoDB with a foreign key ref, MySQL seems to want a type def and NOT NULL in the definition of the column to be used as a foreign key. PB - - Original Message - From: "Jannie Qu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 10:18 AM Subject: Create child table question > sql, query, mysql > > Hi, all, > I met a problem with creating the following table: pub_user. > -- Parent table > CREATE TABLE pub_access_type( > access_type_id INT UNSIGNED NOT NULL, > access_type_name VARCHAR(25), > PRIMARY KEY(access_type_id) > ) TYPE=INNODB; > -- Child table > CREATE TABLE pub_user( > user_id INT UNSIGNED, > parent_id INT, > user_fname VARCHAR (25), > user_lname VARCHAR (25), > user_password VARCHAR (25), > INDEX par_ind(parent_id), > FOREIGN KEY pub_user(parent_id) REFERENCES pub_access_type(access_type_id) > ON DELETE SET NULL > ) TYPE=INNODB; > > If I use "FOREIGN KEY pub_user(parent_id) REFERENCES pub_access_type.." > Table "pub_user" will be created, but if I use "FOREIGN KEY (parent_id) > REFERENCES pub_access_type" I will get the following error: > ERROR 1005: Can't create table '.\staging\pub_user.frm' (errno: 150) > > I found a similar script which don't use tablename when "foreign key (column > name...) > Here it is: > CREATE TABLE parent1 > (id INT NOT NULL, > name varchar(10), > PRIMARY KEY (id) > ) TYPE=INNODB; > CREATE TABLE child1 > (id INT, name varchar(10), parent_id INT, tellphone varchar(10), > INDEX par_ind(parent_id), > FOREIGN KEY (parent_id) REFERENCES parent1(id) > ON DELETE SET NULL > ) TYPE=INNODB; > > > I wonder why my scripts must specify tablename? > > Thank you, > Jing > > > > > > _ > Choose an Internet access plan right for you -- try MSN! > http://resourcecenter.msn.com/access/plans/default.asp > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: using load_file...problems
i also figured out that load_file only works on the local server, not from clients...duh! thanks! -Original Message- From: Egor Egorov [mailto:egor.egorov@;ensita.net] Sent: Tuesday, October 29, 2002 12:19 PM To: [EMAIL PROTECTED] Subject: re: using load_file...problems Shon, Tuesday, October 29, 2002, 7:01:47 PM, you wrote: SS> i am trying to insert data into a blob column. its not working. i have tried SS> setting --local-infile=1. i tried granting file to my user and got an error. SS> i have read the manaul (for all you smarties who like to rtfm everyone) and SS> still don't get it. here is what i did for grant SS> grant file on db.tablename to user; SS> ERROR 1144: Illegal GRANT/REVOKE command. Please consult the manual which SS> privileges can be used. SS> in the above case "user" already exists. FILE is a global level privilege, you can give FILE_priv on a table. -- 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
Re: Need help installing PHP (Linux) with MySQL and Apache
I have been successful (after days of trying) with Apache 2.0.43 , PHP 4.2.3 on Redhat 7.3 I compiled php with ./configure --with-mysql --with-apxs2=/apth/to/apxs (apxs is under /path/to/apache2/bin) After 'make' and 'make install' you will find libphp4.so in /path/to/apache2/modules Then I added the following lines in httpd.conf LoadModule php4_module modules/libphp4.so AddType application/x-httpd-php php SetOutputFilter PHP Have fun Andrea Forghieri - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 from MS SQL to MySQL
Have you looked at using the Microsoft DTS tool with the MyODBC? Setting this up should be straightforward. I hope this helps -Original Message- From: Gator [mailto:gator@;acs.bz] Sent: Tuesday, October 29, 2002 12:34 PM To: [EMAIL PROTECTED] Subject: Replication from MS SQL to MySQL Does anyone know of a way to have automatic replication of a MS SQL database to MySQL? I have an active database in MS SQL and I need one of the tables replicated over into a MySQL database on Linux. It would be nice to have real time replication, but even if it was updated every 10 minutes would be fine. Any helpful pointers in the right direction would be appreciated. Thanks - Jack - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Replication from MS SQL to MySQL
Does anyone know of a way to have automatic replication of a MS SQL database to MySQL? I have an active database in MS SQL and I need one of the tables replicated over into a MySQL database on Linux. It would be nice to have real time replication, but even if it was updated every 10 minutes would be fine. Any helpful pointers in the right direction would be appreciated. Thanks - Jack - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Create child table question
sql, query, mysql Hi, all, I met a problem with creating the following table: pub_user. -- Parent table CREATE TABLE pub_access_type( access_type_id INT UNSIGNED NOT NULL, access_type_name VARCHAR(25), PRIMARY KEY(access_type_id) ) TYPE=INNODB; -- Child table CREATE TABLE pub_user( user_id INT UNSIGNED, parent_id INT, user_fname VARCHAR (25), user_lname VARCHAR (25), user_password VARCHAR (25), INDEX par_ind(parent_id), FOREIGN KEY pub_user(parent_id) REFERENCES pub_access_type(access_type_id) ON DELETE SET NULL ) TYPE=INNODB; If I use "FOREIGN KEY pub_user(parent_id) REFERENCES pub_access_type.." Table "pub_user" will be created, but if I use "FOREIGN KEY (parent_id) REFERENCES pub_access_type" I will get the following error: ERROR 1005: Can't create table '.\staging\pub_user.frm' (errno: 150) I found a similar script which don't use tablename when "foreign key (column name...) Here it is: CREATE TABLE parent1 (id INT NOT NULL, name varchar(10), PRIMARY KEY (id) ) TYPE=INNODB; CREATE TABLE child1 (id INT, name varchar(10), parent_id INT, tellphone varchar(10), INDEX par_ind(parent_id), FOREIGN KEY (parent_id) REFERENCES parent1(id) ON DELETE SET NULL ) TYPE=INNODB; I wonder why my scripts must specify tablename? Thank you, Jing _ Choose an Internet access plan right for you -- try MSN! http://resourcecenter.msn.com/access/plans/default.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with mysql on windows
Hi, It's possible, to have some software/scripts which run in out of environment space. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Norris, Joseph" <[EMAIL PROTECTED]> To: "Mysql_List (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 7:32 PM Subject: problem with mysql on windows > Group, > > We have been running along with little or no problems with mysql installed > on windows 2000. Just recently I have been noticing a creation - great qty > of creation of temp files in my script directories. > > I have all of my scripts on C drive with mysql on my D drive using junction > to make a logical link from c to d for all mysql files in data directory. > > The temp files contain nothing, but still the question - why are they being > created when they were not being created before. > > Any and all ideas appreciated. > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: logging
Don, - Original Message - From: "Don Arnett" <[EMAIL PROTECTED]> To: "'Heikki Tuuri'" <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 8:12 PM Subject: logging > > I'm new to this list. I couldn't find a search facility for searching > previous answers. If there is one, please let me know. please address these general questions to [EMAIL PROTECTED] You can search the mailing list with http://www.google.com/advanced_group_search?hl=en There is an archive at http://lists.mysql.com/ > I'm trying to determine if mysql logging can be adjusted to exclude > certain databases. I have not found anything that indicates that this > is possible. I have a database that has a lot of activity and receives > data from another database on the same server, so moving it to a > separate server is not an option. But I would like to turn off General > Logging for this database if possible. > > Thanks > Don Regards, Heikki sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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
help displaying results from a mysql query with php
Instead of echo htmlspecialchars( stripslashes($row["$i"])); use echo htmlspecialchars( stripslashes($row[0])); In fact , if you increase $i you increase the column thus , in the first cycle you see col 0 , in the second col 1 for more information visit http://www.php.net/manual/en/function.mysql-fetch-row.php Have fun Andera Forghieri - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: InnoDB, Foreign Key
From: Heikki Tuuri To: Serdioukov Edouard Cc: [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 7:23 PM Subject: Re: InnoDB, Foreign Key Edouard, I tested this on Linux using mysql-max-3.23.51, the .tar.gz distro. It worked ok. Are you sure you were using 3.23.51? Starting from 3.23.50, InnoDB does not check a foreign key constraint when the column value is NULL. The behavior you had would have happened with 3.23.49a, for example. http://www.innodb.com/ibman.html#InnoDB_foreign_keys Regards, Heikki sql query heikki@hundin:~/mysql-max-3.23.51-pc-linux-gnu-i686/bin> mysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.51-max-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> CREATE TABLE t_Folders ( -> FOLDER_ID integer NOT NULL, -> FOLDER_NAME varchar(50) NOT NULL, -> PARENT integer NULL, -> PRIMARY KEY (FOLDER_ID), -> KEY XIE1t_Folders (PARENT), -> FOREIGN KEY (PARENT) REFERENCES t_Folders (FOLDER_ID) ON DELETE CASCADE -> ) TYPE=INNODB; Query OK, 0 rows affected (0.03 sec) mysql> INSERT INTO t_Folders VALUES (1, 'Notes', NULL); Query OK, 1 row affected (0.01 sec) mysql> select * from t_Folders; +---+-++ | FOLDER_ID | FOLDER_NAME | PARENT | +---+-++ | 1 | Notes | NULL | +---+-++ 1 row in set (0.01 sec) mysql> mysql> mysql> show create table t_Folders; +---+--- --+ | Table | Create Table | +---+--- --+ | t_Folders | CREATE TABLE `t_Folders` ( `FOLDER_ID` int(11) NOT NULL default '0', `FOLDER_NAME` varchar(50) NOT NULL default '', `PARENT` int(11) default NULL, PRIMARY KEY (`FOLDER_ID`), KEY `XIE1t_Folders` (`PARENT`), FOREIGN KEY (`PARENT`) REFERENCES `test.t_Folders` (`FOLDER_ID`) ON DELETE CAS CADE ) TYPE=InnoDB | +---+--- --+ 1 row in set (0.00 sec) mysql> - Original Message - From: Serdioukov Edouard To: Heikki Tuuri Sent: Tuesday, October 29, 2002 6:55 PM Subject: RE: Question ... - Original Message - ... From: Serdioukov Edouard To: [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 3:42 PM Subject: Question Hello I use Linux Red Hat 7.3 and MySQL-max version 2.23.51. And I have one problem. I created table: CREATE TABLE t_Folders ( FOLDER_ID integer NOT NULL, FOLDER_NAME varchar(50) NOT NULL, PARENT integer NULL, PRIMARY KEY (FOLDER_ID), KEY XIE1t_Folders (PARENT), FOREIGN KEY (PARENT) REFERENCES t_Folders (FOLDER_ID) ON DELETE CASCADE ) TYPE=INNODB; And when I try insert this record INSERT INTO t_Folders VALUES (1, 'Notes', NULL); I get error message: 'ERROR 1216: Cannot add a child row: a foreign key constraint fails'. On Windows all is ok in this case. Can you advise? Thank you Eduard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem with mysql on windows
Group, We have been running along with little or no problems with mysql installed on windows 2000. Just recently I have been noticing a creation - great qty of creation of temp files in my script directories. I have all of my scripts on C drive with mysql on my D drive using junction to make a logical link from c to d for all mysql files in data directory. The temp files contain nothing, but still the question - why are they being created when they were not being created before. Any and all ideas appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[SOLVED] Re: MySQL Import Script Works on Master Not on Slaves
Sorry to have bothered the list, for anyone's info... You have to have the CDF files on `all' servers, not just the MASTER in order for the mysqlimport to work. Robert B. On Tue, 29 Oct 2002, zxcv wrote: > > Hello all, > > I have a cron job that: > > 1 - truncates some working tables [WORKS | BOTH] > 2 - does a mysqlimport on some CDF files [WORKS | MASTER_ONLY] > 3 - truncates a selection of production tables [WORKS | BOTH] > 4 - select from working into production tables [WORKS | BOTH] > > Step 4 doesn't work on the slaves since there is no data in the working > tables... > > Am I missing something? > > Robert B. > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: using load_file...problems
Shon, Tuesday, October 29, 2002, 7:01:47 PM, you wrote: SS> i am trying to insert data into a blob column. its not working. i have tried SS> setting --local-infile=1. i tried granting file to my user and got an error. SS> i have read the manaul (for all you smarties who like to rtfm everyone) and SS> still don't get it. here is what i did for grant SS> grant file on db.tablename to user; SS> ERROR 1144: Illegal GRANT/REVOKE command. Please consult the manual which SS> privileges can be used. SS> in the above case "user" already exists. FILE is a global level privilege, you can give FILE_priv on a table. -- 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
Compiling MySql on Solaris 9
Hi Wim, I'm no expert with compilers and mysql either, but I have gotten mysql to compile sucessfully on Solaris 9 using gcc 2.95.2. If you look at http://www.mysql.com/downloads/mysql-3.23.html , in the source code download section, you'll see that they recommend using the compiler gcc-2.95.2, however they still offer instructions for building with other version of gcc. So, I used gcc-2.95.2 and the 3.23.52 source code (it appears they've got 3.23.53 up now). I did the following for configuring: setenv CC gcc setenv CFLAGS "-O3" setenv CXX gcc setenv CXXFLAGS "-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/local/mysql3.23.52 --with-low-memory --with-extra-charsets=complex --enable-assembler --with-libwrap gmake (The --with-libwrap is to provide tcp-wrapper support, which is the whole reason I'm using source code. The binaries don't come with this support). If you'd like to build with other versions of gcc you can find build instructions for different platfroms at: http://www.mysql.com/doc/en/MySQL_binaries.html unforntuantely, they don't have Solaris 9. It compiled fine, and installed fine. However, I'm having problems running all the tests. They don't fail, they just hang, although I'm able to use mysql normally. I'm curently looking into why these test cases are hanging. I hope this helps some. Stephen >Hello all, > >I'm new to this list and I was wandering if one of you would be able to >help me with the following problem. > >I've been trying, unsuccessfully, to compile mysql 3.23.51 on Solaris 9 >(sparc). I'm using gcc 3.2 and bintools 2.13. I used the following >configure command: ./configure -prefix=/usr/local/mysql -with-innodb > >Whatever I try I get the same errors (see end of message) when trying to >compile. I looked and the only references to compile errors in this >module I can find have to do with memory constraints. I tried the >low-memory option, but no difference. When looking at the sql_lex.cc >module it seems to reference some things from lex.h which is not >included, but including it will fix some of these errors but not all. > >I was going to try to compile 3.23.52 instead but sourceforge tells me >that there are no files for 3.23.52. and a max binary for Solaris 9 is >not available yet. > >Any and all help/advice/pointers would be greatly appreciated, thanks in >advance. > >Wim > > >make[1]: Entering directory `/software/mysql-3.23.51/sql' >g++ -DMYSQL_SERVER >-DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\"" >-DDATADIR="\"/usr/local/mysql/var\"" >-DSHAREDIR="\"/usr/local/mysql/share/mysql\"" >-DHAVE_CONFIG_H -I../innobase/include -I./../include >-I./../regex-I. -I../include -I.. -I.-O3 >-DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti >-DHAVE_RWLOCK_T -c sql_lex.cc >sql_lex.cc: In function `void lex_init()': >sql_lex.cc:85: `symbols' undeclared (first use this function) >sql_lex.cc:85: (Each undeclared identifier is reported only once for >each > function it appears in.) >sql_lex.cc:87: `sql_functions' undeclared (first use this function) >sql_lex.cc: In function `int find_keyword(LEX*, unsigned int, bool)': >sql_lex.cc:168: `get_hash_symbol' undeclared (first use this function) >make[1]: *** [sql_lex.o] Error 1 >make[1]: Leaving directory `/software/mysql-3.23.51/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
using load_file...problems
sql/mysql i am trying to insert data into a blob column. its not working. i have tried setting --local-infile=1. i tried granting file to my user and got an error. i have read the manaul (for all you smarties who like to rtfm everyone) and still don't get it. here is what i did for grant grant file on db.tablename to user; ERROR 1144: Illegal GRANT/REVOKE command. Please consult the manual which privileges can be used. in the above case "user" already exists. thanks, shon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: getting name of columns
> How can i extract names of columns from table? I am doing select * > from table, then i want to get name of columnsis it possible? "show columns from XXX" where XXX is the name of the table. sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Import Script Works on Master Not on Slaves
Hello all, I have a cron job that: 1 - truncates some working tables [WORKS | BOTH] 2 - does a mysqlimport on some CDF files [WORKS | MASTER_ONLY] 3 - truncates a selection of production tables [WORKS | BOTH] 4 - select from working into production tables [WORKS | BOTH] Step 4 doesn't work on the slaves since there is no data in the working tables... Am I missing something? Robert B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need a little query help
If you know the total number of amenities, n, then you could try this: SELECT h.ID, count(*) as total FROM AmenityLink al, Hotels h where al.HotelID=h.ID AND ShowHotel = 1 AND PostCode = '$postcode' group by h.ID having total=n Hope it helps. Cheers, Clemente Zamora GlobalReservas (http://www.clementezamora.com) "Chris Mason" <[EMAIL PROTECTED]> wrote: > > Asunto: Need a little query help > Fecha: Mon, 28 Oct 2002 08:08:41 -0400 > De: "Chris Mason" <[EMAIL PROTECTED]> > A: <[EMAIL PROTECTED]> > > I am trying to select some data from a hotel database I am putting on > the web. Currently I am using two temporary tables and three queries to > get the data, but I suspect it can be done in one query by a better > knowledge of SQL. > The tables are > > Hotels: > ID, > PostCode, > ShowHotel > > AmenityLink: > ID, > HotelID, > AmenityID, > Value > > I have the postcode as $postcode and one or more amenities = 'y'; > > I want to find all active hotel IDs with PostCode = $postcode and having > the amenityid, ignoring the amenity value as I will test for that later. > > SELECT Hotels.ID FROM Hotels, AmenityLink > WHERE Hotels.ID = AmenityLink.HotelID > AND ShowHotel = 1 > AND PostCode = '$postcode' > AND > (AmenityLink.AmenityID = $amenityid[1] OR AmenityLink.AmenityID = > $amenityid[2] ) > > The problem is, it is easy to test for one amenity, but I need to test > that the hotel has all of the amenities. The query above returns all the > hotels that have ANY of the amenities, I need the hotels having ALL of > the amenties only. > > Thanks for any assistance. > > Chris Mason > [EMAIL PROTECTED] > Box 340, The Valley, Anguilla, British West Indies > Tel: 264 497 5670 Fax: 264 497 8463 Cell: 264 235 5670 > http://www.anguillaguide.com/ The Anguilla Guide > Talk to me in real time: > Yahoo:netconcepts_anguilla > US Fax and Voicemail: (815)301-9759 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Multiple MySQL running
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
Re: C-API and multiple resultsets
Insanely Great wrote: Hi! If you want to traverse two result set in the same time then use the mysql_store_result(). If you don't have a big resultset coming then probably mysql_store_result() in the same connection is a better option. Otherwise you have to use two connections. Thanx, just wanted to be sure. Greetings, Stefan sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL and OpenLDAP for Unix accounts
I currently have an authentication server on my home network setup to do LDAP authentication. However, I would like to modify the LDAP server to use MySQL to store the information on the backend. I know that OpenLDAP supports SQL back-ends (I believe through ODBC, but I could be wrong) but I can't find any information on how to setup such a system. Ideally, I would eventually like to modify my Samba PDC to use OpenLDAP (and, hence, MySQL as well). Can anyone give me any guidance on setting this up? Can you point me to any useful documentation? I'd really appreciate it!! (Yes, I know that the folks at OpenLDAP recommend that you not use SQL to store information for performance reasons. This is more for my own benefit, and is strictly an educational exercise to get me more familiar with MySQL) Steve Nakhla [EMAIL PROTECTED] __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.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
RE: Query and export to a Excel file
If you have Excell you can use the Get External Data to get the data from MySQL using MyODBC. Also you can use MSQuery to query the database and send the result to Excel. Another way would be to write a macro that uses ADO and process the results into the workbook. HTH JFernando *** sql *** -Original Message- From: Ma, Billy [mailto:bma@;go2uti.com] Sent: October 29, 2002 04:41 To: [EMAIL PROTECTED] Subject: Query and export to a Excel file hi all, my problem is, do you know how can i query and export a file in Excel format except use third parties software. regards, Billy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: "FullTest" as the column name
* blah > Hi, > I want to use MySQL to store ESM (Symantec Enterprise > Security Manager) > data. The problem is that in one of their table, there is a field named > "FullText". "FULLTEXT" is a reserved word in mysql. Use backticks: mysql> create table ESMMessage2 (`FullText` text NOT NULL); -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Rows examined / sent
> # Query_time: 17 Lock_time: 6 Rows_sent: 207550 > Rows_examined: 207550 > SELECT ID FROM sys_users; If this is really the query that you want to do, there really isn't much you can optimize. You're asking for every ID in the table, so MySQL has to examine every row, and send every row. You can try to eliminate the lock time, though. Your query spent 6 seconds waiting for a read lock, so there was some other query updating the table. To avoid this, you can use InnoDB tables which use concurrency locking, so you can still read the rows even if somebody else is trying to update them. > I'd like to optimize this. 17 seconds is too much. How do you > guys judge > the actual CPU impact of the process that is sending 207550 > rows back to > the query originator? Can it be neglected - and should we rather > optimize the query itself, that is the process of examining the rows. It's not the CPU impact, but the data transfer impact. You're moving 207550 integers, or about 800KB of data. If you really need all that data, you're going to have to wait for it to be transferred. > > In other words: > > Should we try to make Rows_examined: a value like 1000 or so. > Or can we > keep it like this and rather fix Rows_sent to e.g.: 1000. You probably don't really need all the ID numbers in the table. What you should do is figure out which rows you really want, and select them out of the table, rather than selecting all the rows and then processing them somehow on the client side. > > Thanks, > Markus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: CONSTRAINT symbol
At 7:58 -0600 10/29/02, Chris Boget wrote: I see the above referenced throughout the documentation in the context of foreign keys. What are the possible choices for "CONSTRAINT symbol". I've searched the docs and have come up empty in this regard. It doesn't much matter, given that it's ignored if present anyway. If you're wondering about the allowable values, it should be a name (similar to a table or column name). Chris sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Rows examined / sent
Hi, from my slow queries logfile: # Query_time: 17 Lock_time: 6 Rows_sent: 207550 Rows_examined: 207550 SELECT ID FROM sys_users; 1 row = 1 user. mySQL gets queried through PHP. I'd like to optimize this. 17 seconds is too much. How do you guys judge the actual CPU impact of the process that is sending 207550 rows back to the query originator? Can it be neglected - and should we rather optimize the query itself, that is the process of examining the rows. In other words: Should we try to make Rows_examined: a value like 1000 or so. Or can we keep it like this and rather fix Rows_sent to e.g.: 1000. Thanks, Markus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Many Thanks ... now works fine! Natale Babbo --- Joseph Bueno <[EMAIL PROTECTED]> ha scritto: > Hi, > > Make sure that your system starts at runlevel 3 on > boot. If you start your machine with X11, chances > are > that its runlevel is 5. > > Check your /etc/inittab file and look for a line > with "initdefault" keyword: > id:3:initdefault: > > If you start at runlevel 5, you should create a > symbolic > link in /etc/init.d/rc5.d > > Hope this helps, > -- > Joseph Bueno > > Natale Babbo wrote: > > > Many Thanks > > > > No problems with mysql.server script ... it works > fine > > if i start it manual like this: > > shell> mysql.server start > > or > > shell> mysql.server stop > > ... also symbolic link in /etc/init.d/rc3.d is ok. > > > > The only problem is that MySQL service doesn't > start > > at boot. > > > > Natale Babbo. > > > > > > > > > > --- Iikka_Meriläinen > > ha scritto: > 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 * > > >** > > > > > __ Mio Yahoo!: personalizza Yahoo! come piace a te http://it.yahoo.com/mail_it/foot/?http://it.my.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
Re: mysql service on linux
Hi, Make sure that your system starts at runlevel 3 on boot. If you start your machine with X11, chances are that its runlevel is 5. Check your /etc/inittab file and look for a line with "initdefault" keyword: id:3:initdefault: If you start at runlevel 5, you should create a symbolic link in /etc/init.d/rc5.d Hope this helps, -- Joseph Bueno Natale Babbo wrote: > Many Thanks > > No problems with mysql.server script ... it works fine > if i start it manual like this: > shell> mysql.server start > or > shell> mysql.server stop > ... also symbolic link in /etc/init.d/rc3.d is ok. > > The only problem is that MySQL service doesn't start > at boot. > > Natale Babbo. > > > > > --- Iikka_Meriläinen > ha scritto: > 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: getting name of columns
> How can i extract names of columns from table? I am doing select * > from table, then i want to get name of columnsis it possible? Use desc or describe. http://www.mysql.com/doc/en/DESCRIBE.html David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql service on linux
Are you sure you boot into run level 3, and not 5? Check your /etc/inittab for id:3:initdefault Natale Babbo wrote: Many Thanks No problems with mysql.server script ... it works fine if i start it manual like this: shell> mysql.server start or shell> mysql.server stop ... also symbolic link in /etc/init.d/rc3.d is ok. The only problem is that MySQL service doesn't start at boot. Natale Babbo. --- Iikka_Meriläinen <[EMAIL PROTECTED]> ha scritto: > 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 * ** __ Mio Yahoo!: personalizza Yahoo! come piace a te http://it.yahoo.com/mail_it/foot/?http://it.my.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
getting name of columns
Hello, How can i extract names of columns from table? I am doing select * from table, then i want to get name of columnsis it possible? -- Best regards, Martin mailto:corwin@;corwin.sk for filter - sql and query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: getting name of columns
Try: Desc name_table - Original Message - From: Martin Hudec <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 12:31 PM Subject: getting name of columns > Hello, > > How can i extract names of columns from table? I am doing select * > from table, then i want to get name of columnsis it possible? > > > -- > Best regards, > Martin mailto:corwin@;corwin.sk > > for filter - sql and query > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql service on linux
Many Thanks No problems with mysql.server script ... it works fine if i start it manual like this: shell> mysql.server start or shell> mysql.server stop ... also symbolic link in /etc/init.d/rc3.d is ok. The only problem is that MySQL service doesn't start at boot. Natale Babbo. --- Iikka_Meriläinen <[EMAIL PROTECTED]> ha scritto: > 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 * > ** > __ Mio Yahoo!: personalizza Yahoo! come piace a te http://it.yahoo.com/mail_it/foot/?http://it.my.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
CONSTRAINT symbol
I see the above referenced throughout the documentation in the context of foreign keys. What are the possible choices for "CONSTRAINT symbol". I've searched the docs and have come up empty in this regard. Chris sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[no subject]
Courrier recu par moi-meme. ; 29 Oct 2002 03:57:13 - Message recu de: unknown (helo CAGMAW200710) par 207.35.122.83 avec SMTP; 29 Oct 2002 03:57:13 - Message-ID: <002301c27f52$dc1cb570$[EMAIL PROTECTED]> From: "blah" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: "FullTest" as the column name Date: Tue, 29 Oct 2002 08:55:37 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600. Hi, I want to use MySQL to store ESM (Symantec Enterprise Security Manager) data. The problem is that in one of their table, there is a field named "FullText". I have tried to create it in the CREATE TABLE statement and it gives me this message : mysql> create table ESMMessage2 (FullText text NOT NULL); ERROR 1064: You have an error in your SQL syntax near 'NOT NULL)' at line 1 I have also tried to create the table, and then add the column with an ALTER TABLE: mysql> alter table ESMMessage add (FullText text NOT NULL); ERROR 1064: You have an error in your SQL syntax near 'NOT NULL)' at line 1 Would it be possible to have a column with this name ? How ? Yan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Need a little query help
> -Original Message- > From: Chris Mason [mailto:masonc@;masonc.com] > [...] > The problem is, it is easy to test for one amenity, but I need to test > that the hotel has all of the amenities. The query above > returns all the > hotels that have ANY of the amenities, I need the hotels having ALL of > the amenties only. Try turning the problem around. Instead of including only the hotels having all desired amenities, you might get the results you want by excluding any hotels _lacking_ a desired amenity. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: C-API and multiple resultsets
Greetings... Yes. If you want to traverse two result set in the same time then use the mysql_store_result(). If you don't have a big resultset coming then probably mysql_store_result() in the same connection is a better option. Otherwise you have to use two connections. Rgds Insane SQLyog - The Definitive Win32 GUI for MySQL http://www.sqlyog.com - Original Message - From: "Stefan Fleiter" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 1:16 AM Subject: C-API and multiple resultsets > Hi! > > If I use mysql_use_reult() of the C-API, I must use two connections > to traverse two different result sets at the same time. > > Is that right? > > Thanx, > Stefan > > > sql, query > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB, Foreign Key
Edouard, you have a foreign key referencing a column in its own table. PB - - Original Message - From: "Serdioukov Edouard" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 3:23 AM Subject: InnoDB, Foreign Key Hello I use Linux Red Hat 7.3 and MySQL-max version 2.23.51. I have one problem. I created table: CREATE TABLE Folders ( FOLDER_ID INTEGER NOT NULL, FOLDER_NAME VARCHAR(50) NOT NULL, PARENT INTEGER NULL, PRIMARY KEY (FOLDER_ID), KEY XIE1_Folders (PARENT), FOREIGN KEY (PARENT) REFERENCES Folders (FOLDER_ID) ON DELETE CASCADE ) TYPE=INNODB; And when I try to execute this statement: INSERT INTO Folders VALUES (1, 'Main', NULL); I get error message: 'ERROR 1216: Cannot add a child row: a foreign key constraint fails'. On Windows all is ok in this case. Can you advise? Thank you Eduard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: jus a question about tables
Are you adding a row per click? I have just done the same and my table looks like this... === CREATE DATABASE marketing; CREATE TABLE bsafeLinks (date DATE NOT NULL, clicks INT(255) NOT NULL); ALTER TABLE bsafeLinks ADD PRIMARY KEY (date); ... I basically have one row per day for the site I want to monitor. Every time someone clicks I add 1 to clicks like this.. === UPDATE bsafelinks SET clicks = clicks + 1 WHERE date = CURDATE() ... I have some other code which creates the record if it does not exist... insert into bsafelinks (date,clicks) values (CURDATE(),'0') . And this does the test to see if the date record exists... = select date, clicks from bsafelinks where date = DATE . If you want hourly stats - add hour in after "date" and have as part of the primary key. Hope this helps. Kevin -Original Message- From: svens [mailto:[EMAIL PROTECTED]] Sent: 29 October 2002 12:52 To: [EMAIL PROTECTED] Subject: jus a question about tables So I have question. is it ok if I put all data in one table by days (by date) in resul I will have lot of rows day 20021025 - 45000 rows day 20021026 - 23445 rows day 20021027 - 389023 rows day 20021028 - 78632 rows total = 536100 rows of data I count web page hits and hosts by hourly rotate and date (and one month will be woosh tons of data millions of rows) all this data is in one table so is it ok? and when I need to get some statistics data then I query by date and name and ip - and so on ? or I need to seperate or move each day in some history table and active table will hold only active day of data ? for me is better to keep all data in one table of course but who knows how to do better ? if there is way to do better of course :) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 service on linux
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? Thank in advance. Natale Babbo __ Mio Yahoo!: personalizza Yahoo! come piace a te http://it.yahoo.com/mail_it/foot/?http://it.my.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
jus a question about tables
So I have question. is it ok if I put all data in one table by days (by date) in resul I will have lot of rows day 20021025 - 45000 rows day 20021026 - 23445 rows day 20021027 - 389023 rows day 20021028 - 78632 rows total = 536100 rows of data I count web page hits and hosts by hourly rotate and date (and one month will be woosh tons of data millions of rows) all this data is in one table so is it ok? and when I need to get some statistics data then I query by date and name and ip - and so on ? or I need to seperate or move each day in some history table and active table will hold only active day of data ? for me is better to keep all data in one table of course but who knows how to do better ? if there is way to do better of course :) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HLP: Mysql newbie.....
I would appreciate it if some one can do a hand hold on this one. I need to convert from Access to mysql but still using MS Access Front End, I understand this is done via ODBC link to the mysql server and this is my problem. Due to my lack of command line knowledge and no GUI on the Cube for MYSQL I am having difficulty in setting up the server and ODBC link. So I could do with knowing how to start. 1) Set up and check mysql server on cube 2) create ODBC link from Windows to Cube Server mysql Cheers Liam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Query and export to a Excel file
Whoops - sorry... I meant use "select field1,field2 into outfile '/somepath/somename.xls' from table1 where this=that;" Select into outfile is explained here http://www.mysql.com/doc/en/SELECT.html Please don't use mysqldump - that was my mistake (writing two emails at once - sorry!) Andrew, Sql,query -Original Message- From: Andrew Braithwaite Sent: Tue 29 October 2002 09:58 To: 'Ma, Billy'; [EMAIL PROTECTED] Subject: RE: Query and export to a Excel file Hi, You can use mysqldump (http://www.mysql.com/doc/en/mysqldump.html) to dump the file into a tab delimited text file or cvs. You will be able to open it in excel in those formats. Alternatively (if you want to get a bit more involved) there is a perl module you could use called Spreadsheet::WriteExcel which will allow you to render a generic excel spreadsheet with query results and whatever formatting/formulas you want in the spreadsheet too. Hope this helps.. Andrew sql, query -Original Message- From: Ma, Billy [mailto:bma@;go2uti.com] Sent: Tue 29 October 2002 09:41 To: [EMAIL PROTECTED] Subject: Query and export to a Excel file hi all, my problem is, do you know how can i query and export a file in Excel format except use third parties software. regards, Billy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
InnoDB, Foreign Key
Hello I use Linux Red Hat 7.3 and MySQL-max version 2.23.51. I have one problem. I created table: CREATE TABLE Folders ( FOLDER_ID INTEGER NOT NULL, FOLDER_NAME VARCHAR(50) NOT NULL, PARENT INTEGER NULL, PRIMARY KEY (FOLDER_ID), KEY XIE1_Folders (PARENT), FOREIGN KEY (PARENT) REFERENCES Folders (FOLDER_ID) ON DELETE CASCADE ) TYPE=INNODB; And when I try to execute this statement: INSERT INTO Folders VALUES (1, 'Main', NULL); I get error message: 'ERROR 1216: Cannot add a child row: a foreign key constraint fails'. On Windows all is ok in this case. Can you advise? Thank you Eduard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 2013: Lost connection to MySQL server during query
Hi, I have MySQL version 3.23.41 and when I connect from localhost, it's OK. Hovewer, when I connect via IP (f.e. mysql -h IP, or from other computer in Internet), then MySQL resut error ERROR 2013: Lost connection to MySQL server during query. This is a part of variable from MySQL on the my server: | connect_timeout | 5 | max_allowed_packet | 1047552 | max_binlog_cache_size | 4294967295 | max_binlog_size | 1073741824 | max_connections | 100 | max_connect_errors | 10 | max_delayed_threads | 20 | max_heap_table_size | 16777216 | max_join_size | 4294967295 | max_sort_length | 1024 | max_user_connections| 0 | net_buffer_length | 16384 | net_read_timeout| 30 | net_retry_count | 10 | net_write_timeout | 60 | open_files_limit| 0 | pid_file| /var/run/mysqld/mysqld.pid | port| 3306 | protocol_version| 10 | record_buffer | 131072 | record_rnd_buffer | 131072 | query_buffer_size | 0 | safe_show_database | OFF | server_id | 0 | slave_net_timeout | 3600 | skip_locking| ON | skip_networking | OFF | skip_show_database | OFF Please, where is error, or what is wrong? Ing. Jan Tobolík, Czech Republic programmer, administrator tel: 777/ 01 01 77 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error-1044
Hi All I have a database named "bugs" on server and and a user assigned for it named "bugs" only. This database is used for Bugzilla database and till today it was running fine. However there were some changes done by system administrator and then the connectivity from the application stopped. I am connecting from root user to the server and if I issue a command # mysql -D bugs -u bugs@localhost It gives the error "Access denied for the user bugs@localhost" (Error - 1044) However If I issue the command #mysql -D bugs -u bugs Then it connects to the bugs database using user bugs. However my Application scripts which contains "bugs@localhost" at many places, which cannot be changed. In short I would like to connect to bugs database using "bugs@localhost" how I should do that ??? The sys admin don't know what exactly he has done .. I have seen the tables in "mysql" database namely "user" and "db" which stores the database settings. In both the the "HOST" column is set to "localhost" value. Can you please help me out. Thanks in Advance Amol - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: RE: Altering Table errors
Alan, Monday, October 28, 2002, 10:13:45 PM, you wrote: AM> But after a while it does, cause I only have to wait a while with no AM> activity on the database, and the command executes. So it's not permissions Do you use MySQL server on Windows? There was a bug with lower_case_table_names=1 on Windows when error 13 occurs .. >> -Original Message- >> From: gerald_clark [mailto:gerald_clark@;suppliersystems.com] >> Sent: Tuesday, 29 October 2002 1:38 >> To: Alan McDonald >> Cc: [EMAIL PROTECTED] >> Subject: Re: Altering Table errors >> >> >> Error 13 is an operating system privilege violation error. >> the user 'mysql' does not own or have access to something in >> the database. >> >> Alan McDonald wrote: >> >> >MySQL >> > >> > >> >I asume that when I add a field or rename a field etc and get the errcode >> >13, that I must wait til a connection timeout has occurred to be able to >> >make this structural change. While I'm developing, is there a >> quicker way to >> >do this? >> >Stopping/starting the service is not that quick.. Is there another way? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[6]: [PHP-DB] database synchronization
Hello, see below... -- Best regards, Martinmailto:corwin@;corwin.sk Tuesday, October 29, 2002, 10:51:17 AM, you wrote: PL> Hi PL> If the records are all independant - ie travel agent (TA) A has their own PL> records and so does TA B then REPLACE INTO MainDB SELECT * FROM PL> Travel_agent_A_DB so the main database is just receiveing updated records PL> from the TAs. Yes they are independenteach record has column named originTA where i will put ID of TA which is originator of record PL> Travel agent logs in to master php driven site . PL> master php driven site logs TA IP PL> master php driven site makes connection to TA mysql using IP Looks like i will have to write script which will monitor connection to MySQL port on master php driven site... PL> master php driven site gets new/updated records PL> master php driven site writes new/updated records to master DB okay understand ;) PL> If more than one travel agent can update the same record then you risk PL> corrupting the data. If they do not have a live connection to the master PL> then the record they update may itself be out of date. The only way I can PL> see of doing this is soem system that locks a record for the period that TA PL> might take updating it. so on MainDB (our slave server :)i will create database for each partner with designated unique name for ex. Travel_agent_A_DB...here will i put all updated info..or I will put it to mainDBthat risk of corruption is out of talk, because each record will have its id of origin (Travel_agent_A_DB).at least I hope...:) and each travel agent will update only their records(...WHERE idorigin="Travel_agent_A")... I think with this i can forget about that riskthey are updating only their recordsnot anyone else's...in example Travel_agent_A offers Greece in 10 days from 19.6.2003 to 29.6.2003...same destination Travel_agent_B offers Greece in 10 days from 19.6.2003 to 29.6.2003...same destination Travel_agent_A sells out all he can in to this days...but agent_B still has few places ;)) update will work as followsagent_A will update his set of records...setting them all sold outagent_B will update his set of records setting ten places left to be sold PL> Perhaps PL> TA A login PL> TA grab record, mark as locked PL> TA B gets 'locked record' message PL> TA A updates record and writes back to master PL> record marked as not locked Looks good...if my upper solution will not work i will try to use this... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 segfault
mike, Tuesday, October 29, 2002, 4:21:40 AM, you wrote: maddn> After upgrading mysql to 3.23.53, mysqld would segfault every time accessing a certain database. After running checks maddn> on the database and making sure everything was okay, I started mysqld up in gdb. maddn> Program received signal SIGSEGV, Segmentation fault. maddn> [Switching to Thread 2051 (LWP 12699)] maddn> 0x0012a12c in _nss_dns_gethostbyaddr_r (addr=0x81b9f68, len=4, af=2, result=0x337ca4, buffer=0x81bbfc8 "\b33", buflen=1024, maddn> errnop=0x431c68, h_errnop=0x431864) at nss_dns/dns-host.c:223 maddn> 223 nss_dns/dns-host.c: No such file or directory. maddn> in nss_dns/dns-host.c maddn> (gdb) bt maddn> #0 0x0012a12c in _nss_dns_gethostbyaddr_r (addr=0x81b9f68, len=4, af=2, result=0x337ca4, buffer=0x81bbfc8 "\b33", maddn> buflen=1024, maddn> errnop=0x431c68, h_errnop=0x431864) at nss_dns/dns-host.c:223 maddn> #1 0x002fc919 in __gethostbyaddr_r (addr=0x81b9f68, len=4, type=2, resbuf=0x337ca4, buffer=0x81bbfc8 "\b33", buflen=1024, maddn> result=0x431860, h_errnop=0x431864) at ../nss/getXXbyYY_r.c:200 maddn> #2 0x002fc6fb in gethostbyaddr (addr=0x81b9f68, len=4, type=2) at ../nss/getXXbyYY.c:131 maddn> #3 0x080ac720 in ip_to_hostname () maddn> #4 0x080acecb in check_connections () maddn> #5 0x080ad341 in handle_one_connection () maddn> #6 0x00137c6f in pthread_start_thread (arg=0x431be0) at manager.c:284 maddn> #7 0x00137d5f in pthread_start_thread_event (arg=0x431be0) at manager.c:308 maddn> How-To-Repeat: maddn> Not sure if it'll be repeatable on other machines maddn> Fix: maddn> Turning of name resolution fixes the problem, so does using the binary for 3.23.53 Mike, compiling MySQL server from source is tricky and complicated. Installation of MySQL official binaries is more recommended. -- 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
RE: Query and export to a Excel file
Hi, You can use mysqldump (http://www.mysql.com/doc/en/mysqldump.html) to dump the file into a tab delimited text file or cvs. You will be able to open it in excel in those formats. Alternatively (if you want to get a bit more involved) there is a perl module you could use called Spreadsheet::WriteExcel which will allow you to render a generic excel spreadsheet with query results and whatever formatting/formulas you want in the spreadsheet too. Hope this helps.. Andrew sql, query -Original Message- From: Ma, Billy [mailto:bma@;go2uti.com] Sent: Tue 29 October 2002 09:41 To: [EMAIL PROTECTED] Subject: Query and export to a Excel file hi all, my problem is, do you know how can i query and export a file in Excel format except use third parties software. regards, Billy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 update user
Marco, Tuesday, October 29, 2002, 7:22:44 AM, you wrote: MB> I need your expert and slow guided assistance. MB> I would like someone to explain to me the correct mysql commands MB> monitor to achive the following correctly. MB> It would greatly help if you work for a hosting company. MB> The question is: MB> User asks to be given access to mysql database for his hosting MB> account. MB> username: marco MB> pssword: mysecret MB> database name: lotsofusers. MB> Of first I set the administrative and root password using the document here: MB> ftp://216.94.9.36/Setting%20the%20Root%20and%20Administrative%20Passwords.doc MB> Then What I would like to do is: MB> allow another user access to create and complete control over his MB> database, inside tables and data information inside the database MB> (we are talking about total control, creation, editing and deletion, MB> (the ins and outs of that database assigned to the user called: "marco": MB> Enter the following command at your shell prompt: MB> mysql -u root -p lotsofusers MB> I am in. MB> Then here is where I get bit stuck. MB> I would some one to teach me how to do for that user MB> and allow him/website to have access to that database and that database MB> alone, having complete control over it. MB> Using the example I have given you please teach me how to do so in detail?. MB> I look forward to be taken a novice, As I have gone through the docs online. MB> and it was not a great teacher!. Online manual contains enough info about your question :) Read about GRANT: http://www.mysql.com/doc/en/GRANT.html It's easy to set permissions using GRANT. if you want to give all rights on the certain database you can do it like GRANT ALL ON database_name.* TO 'user_name'@'host_name' IDENTIFIED BY 'user_password'; -- 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
re: Bug using truncation in 4.0.4-beta
sbs, Tuesday, October 29, 2002, 7:31:03 AM, you wrote: samdldlds> Description: samdldlds> Special case: using SELECT with truncation doesn't return some records samdldlds> when the searched query appears at the end of the line. Note that the last record will samdldlds> be matched and returned because there is a space character at the end. samdldlds> I am using ft_min_word_len = 1; Currently phrase search doesn't work with operators. If they work for somebody, it's a bug, too :-) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Re[4]: [PHP-DB] database synchronization
Hi If the records are all independant - ie travel agent (TA) A has their own records and so does TA B then REPLACE INTO MainDB SELECT * FROM Travel_agent_A_DB so the main database is just receiveing updated records from the TAs. Travel agent logs in to master php driven site . master php driven site logs TA IP master php driven site makes connection to TA mysql using IP master php driven site gets new/updated records master php driven site writes new/updated records to master DB If more than one travel agent can update the same record then you risk corrupting the data. If they do not have a live connection to the master then the record they update may itself be out of date. The only way I can see of doing this is soem system that locks a record for the period that TA might take updating it. Perhaps TA A login TA grab record, mark as locked TA B gets 'locked record' message TA A updates record and writes back to master record marked as not locked HTH Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net tel. 0121-242-1473 --- -Original Message- From: Martin Hudec [mailto:corwin@;corwin.sk] Sent: 29 October 2002 09:18 To: Peter Lovatt Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re[4]: [PHP-DB] database synchronization Hello Peter, okay :)))so far I understand...buthmmm let me explain I have server of travel agencies records (we need to update this, so it is slave) with stable IPand then bunch of other computers (from these we are updating...so they are all masters) in various travel agencies...but not all of them have stable IP (some joins using dialup...some have stable line)...some girl there updates database...and they may not be on net:). So in this case i have one slave and many masters. solution one: My server (slave) has to periodically check for updateswhen masters have stable IP I can make list of IPs and then connect to each server and take binary update log...and use itbut what can i do when master has dynamic IP? So i discard this solution solution two...better...from my point of view ;): Masters with stable IP will update in period of for example 4 hoursmasters with dynamic IP will update when they are online (girl browsing on chatting sites ;)))that puts the question if there is possible to make remote update (sending binlog from master to slave and automatically updating slave)(but if i understood your previous mail...synchronization (replication) is done automaticaly the question two is what if this master is running Windows 98 with MySQL-win for example? Is that possible to make also in windows? I will try to post this also to mysql list -- Best regards, Martinmailto:corwin@;corwin.sk Tuesday, October 29, 2002, 10:05:00 AM, you wrote: PL> Hi PL> Replication works continuously when the two databases are in contact with PL> each other, unless you specify otherwise. Likewise, if you connect PL> periodically, MySql will synchronise the two databases itself. PL> With replication, MySql logs everything the master does. When a slave logs PL> in (you can have any number of slaves) it checks the master logs to see how PL> up to date it is, and 'catches up' with the master. PL> Once it is set up correctly you don't need to do anything yourself. PL> HTH PL> Peter PL> --- PL> Excellence in internet and open source software PL> --- PL> Sunmaia PL> www.sunmaia.net PL> tel. 0121-242-1473 PL> --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Query and export to a Excel file
hi all, my problem is, do you know how can i query and export a file in Excel format except use third parties software. regards, Billy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: database synchronization
On Tue, Oct 29, 2002 at 01:02:51AM -0800, Lalit Chandwani wrote: > Hi all, > > i have a mysql database on my local machine , the same database is > my server i want to synchronize the datbases both side. > > is there any login or tool or mysql support for database > synchronization How about MySQL's built-in replication? -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 84 days, processed 1,754,276,669 queries (241/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Database sync
Hello Peter, okay :)))so far I understand...buthmmm let me explain I have server of travel agencies records (we need to update this, so it is slave) with stable IPand then bunch of other computers (from these we are updating...so they are all masters) in various travel agencies...but not all of them have stable IP (some joins using dialup...some have stable line)...some girl there updates database...and they may not be on net:). So in this case i have one slave and many masters. solution one: My server (slave) has to periodically check for updateswhen masters have stable IP I can make list of IPs and then connect to each server and take binary update log...and use itbut what can i do when master has dynamic IP? So i discard this solution solution two...better...from my point of view ;): Masters with stable IP will update in period of for example 4 hoursmasters with dynamic IP will update when they are online (girl browsing on chatting sites ;)))that puts the question if there is possible to make remote update (sending binlog from master to slave and automatically updating slave)(but if i understood your previous mail...synchronization (replication) is done automaticaly the question two is what if this master is running Windows 98 with MySQL-win for example? Is that possible to make also in windows? I will try to post this also to mysql list -- Best regards, Martinmailto:corwin@;corwin.sk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query and Reports
Hi , i have a mysql database , can i store the query defination as a table in the databse ? As we use save query in MS access as tables or like views in Ms SQL SERVER thanks __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.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
Re[4]: [PHP-DB] database synchronization
Hello Peter, okay :)))so far I understand...buthmmm let me explain I have server of travel agencies records (we need to update this, so it is slave) with stable IPand then bunch of other computers (from these we are updating...so they are all masters) in various travel agencies...but not all of them have stable IP (some joins using dialup...some have stable line)...some girl there updates database...and they may not be on net:). So in this case i have one slave and many masters. solution one: My server (slave) has to periodically check for updateswhen masters have stable IP I can make list of IPs and then connect to each server and take binary update log...and use itbut what can i do when master has dynamic IP? So i discard this solution solution two...better...from my point of view ;): Masters with stable IP will update in period of for example 4 hoursmasters with dynamic IP will update when they are online (girl browsing on chatting sites ;)))that puts the question if there is possible to make remote update (sending binlog from master to slave and automatically updating slave)(but if i understood your previous mail...synchronization (replication) is done automaticaly the question two is what if this master is running Windows 98 with MySQL-win for example? Is that possible to make also in windows? I will try to post this also to mysql list -- Best regards, Martinmailto:corwin@;corwin.sk Tuesday, October 29, 2002, 10:05:00 AM, you wrote: PL> Hi PL> Replication works continuously when the two databases are in contact with PL> each other, unless you specify otherwise. Likewise, if you connect PL> periodically, MySql will synchronise the two databases itself. PL> With replication, MySql logs everything the master does. When a slave logs PL> in (you can have any number of slaves) it checks the master logs to see how PL> up to date it is, and 'catches up' with the master. PL> Once it is set up correctly you don't need to do anything yourself. PL> HTH PL> Peter PL> --- PL> Excellence in internet and open source software PL> --- PL> Sunmaia PL> www.sunmaia.net PL> tel. 0121-242-1473 PL> --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Benefits of using ENUM vs. a TINYINT "mask"?
Assume my db will have millions of records and frequent selects. If I plan on have a field that can be one of multiple states (A, B, C or All), is it better to store as ENUM or TINYINT (as a mask, such that A = 1, B = 2, C = 3 and if I know that, then All = 6, and none = 0). I'm only talking SPEED here in SELECT queries, not the added benefit of having a 'multiple enum' as it were. Furthermore, assume a record has two fields that are both binary (true/false) toggles. This could be represented as: Field_A enum("true", "false"), Field_B enum("true", "false") OR Field_AB enum("A", "B", "Both", "None") OR # using the mask idea from above Field_AB tinyint(1) unsigned Is there any benefit to using one method over the other (again, speedwise only)? My gut tells me the last is better, albeit a bit more confusing to those who don't know what the number represents, but I'm not sure if the query is optimized somehow before getting processed with an ENUM down to numbers anyways. Another thing, say I have Field enum("true", "false") And later ALTER TABLE to be Field enum("on", "off") Will all the records 'update' to the right name automatically, or will they all still show 'true'/'false'? Lastly, should I be using a "SET" instead of "ENUM" for this? Daevid. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
database synchronization
Hi all, i have a mysql database on my local machine , the same database is my server i want to synchronize the datbases both side. is there any login or tool or mysql support for database synchronization thanks in advance. = --- Dream Team Network Solutions Pvt. Ltd., C-97 , shastri nagar,Opp. PNB, jodhpur. ( india ) - 342001 PHONE : 91-0291-308074 , 75 VISIT http://www.dreamteamonline.com --- __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.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