Converting from MS SQL Server to MySQL
I am sure conversion questions are asked a lot, I need to move what is a MS SQL Server database to a MySQL database, both table stuctures, data, and a web application with a very large number of queries. I am looking for any advice on this undertaking, things to be mindful of and such, and if anyone knows a good site that explains more on this topic, links would also be very appreciated. My ultimate goal is to port it successfully so none of the queries crash later on. Thanks in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Converting from MS SQL Server to MySQL
The *best* way to do this is via conversion software. I find that for table creation and data transfer, http://dbtools.com.br has the best free tool. It converts all your Access and SQL based databases over to MySQL without any hitches. Really good help files and web site as well. Intelligent Converters also has a good tool, but it's not free (http://convert-in.com) J.R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 1064?
Hi, I am comparable new to mySQL, so sorry if I might bother you with a newby Problem: When I connect to the database via phpMyAdmin or via the mySQL Command Line Tool as root I have problems creating a view (root has all privelegs, and the pure select statement works fine in the line before): the statement create view test as select Name from user; brings the german error message: #1064 - Fehler in der Syntax bei 'view test AS SELECT Name FROM user' in Zeile 1. in english at about: #1064 - Error with the syntax at 'view test AS SELECT Name FROM user' in row 1. OK, this might be a syntax-error, but what is wrong on this syntax??? The select statement works I have checked the create view a thousand times. Thank you very much in advance Klaus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Converting from MS SQL Server to MySQL
Hi, I am sure conversion questions are asked a lot, I need to move what is a MS SQL Server database to a MySQL database, both table stuctures, data, and a web application with a very large number of queries. I am looking for any advice on this undertaking, things to be mindful of and such, and if anyone knows a good site that explains more on this topic, links would also be very appreciated. My ultimate goal is to port it successfully so none of the queries crash later on. Well, there are differences in datatypes, defaults and more like that stuff, so it might be a bit more work. To get a head-start, an automated migration tool might help, of course. Make sure to check out the Schema Migrator tool in Database Workbench ( www.upscene.com ) - it might help you a lot. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
4.0.18 repeatedly restarts
Hello, After upgrating mysql 4.0.7 to 4.0.18/FreeBSD 4.6.2, the mysqld restarts each time it receives a remote connect from another client machine. Here is what is written into the log: 040415 08:51:00 mysqld started 040415 8:51:00 Warning: setrlimit returned ok, but didn't change limits. Max open files is 22154 (request: 25010) 040415 8:51:00 Warning: Changed limits: max_connections: 5000 table_cache: 8572 040415 8:51:01 InnoDB: Started /usr/local/mysql40/libexec/mysqld: ready for connections. Version: '4.0.18-log' socket: '/tmp/mysql4.sock' port: 3310 Number of processes running now: 0 040415 08:51:15 mysqld restarted 040415 8:51:15 Warning: setrlimit returned ok, but didn't change limits. Max open files is 22154 (request: 25010) What the client gets is the error ERROR 2013: Lost connection to MySQL server during query Connections from the same server, both using unix socket or tcp port, get through without any problems. The mysql 4.0.18 was compiled from ports with the linuxthreads option. 4.0.7 is working fine on the same machine. Any help will be greatly apprecialted. Thanks Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 1064?
Klaus Neudecker [EMAIL PROTECTED] wrote: Hi, I am comparable new to mySQL, so sorry if I might bother you with a newby Problem: When I connect to the database via phpMyAdmin or via the mySQL Command Line Tool as root I have problems creating a view (root has all privelegs, and the pure select statement works fine in the line before): the statement create view test as select Name from user; brings the german error message: #1064 - Fehler in der Syntax bei 'view test AS SELECT Name FROM user' in Zeile 1. in english at about: #1064 - Error with the syntax at 'view test AS SELECT Name FROM user' in row 1. OK, this might be a syntax-error, but what is wrong on this syntax??? The select statement works I have checked the create view a thousand times. MySQL doesn't support VIEWs yet. -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld_multi
Date: Wed, 14 Apr 2004 13:26:10 -0400 To: [EMAIL PROTECTED] From: Pingouin Team [EMAIL PROTECTED] Subject: mysqld_multi Message-Id: [EMAIL PROTECTED] Hi, I need help. I have my old mysql server running in my web server and I can't stop it for make the test of the new version (3.28 to 4.0). I have installed with compilation of the source code and configure my socket, var and port. I have make a config file with the --example: [mysqld_multi] mysqld = /home/benoit/mysql/bin/safe_mysqld mysqladmin = /home/benoit/mysql/bin/mysqladmin user = multi_admin password = multipass [mysqld2] socket = /home/benoit/tmp/mysql.sock port = 3310 pid-file = /home/benoit/mysql/var/pingouin.pid datadir = /home/benoit/mysql/var language = /home/benoit/mysql/share/mysql/english And I start my MySQL with ./mysqld_multi --config-file=/home/benoit/mysql/etc/my.cnf start 2 but when I execute that command line MySQL start and stop. In the log, I can see just that: mysqld_multi log file version 2.2; run: Wed Apr 14 13:01:02 2004 Starting MySQL servers Starting mysqld daemon with databases from /home/benoit/mysql/var 040414 13:01:05 mysqld ended Why the server do not stay online? Thank you, Benoit Tremblay -- NerdzTeam [EMAIL PROTECTED] ### Servus, to know what stops your MySQL Daemon you must look in your Log-File of this one. I don't know where it is in your system but it helps to add a separate one in [mysqld2] err-log = /var/log/mysql2d/mysqld.log and then look for the real problem (probably permissions ;-) But maybe you should wait an moment, because I have with this mysqld_multi a problem who can give you some trouble, too! As soon as I start the second Daemon the Socket of the first (main) Daemon disappears!! You can connect over TCP, but by default it tries the Socket at localhost. I have MySQL 5.0 running and maybe you haven't got this problem, but think about it. I posted about my Problem to the List (mysqld_multi kills socket from previous Daemon from 2004-04-07), but up to now I haven't got an answer and still don't know whats going on with my Sockets! (Has someone an Idea ??) Best regards, Tobias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Changeing a columns type with alter
Hello list, Could anyone help me on how I go about if I would like to change a coulmns type from say INT to FLOAT? Should I use the ALTER command? I cant seem to find any info on it in the manual. Regards /Jonas
Re: Changeing a columns type with alter
Doh! dont bother I found it in the manual ALTER TABLE t1 CHANGE c1 c1 BLOB; /Jonas - Original Message - From: Jonas Lindén [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 15, 2004 9:46 AM Subject: Changeing a columns type with alter Hello list, Could anyone help me on how I go about if I would like to change a coulmns type from say INT to FLOAT? Should I use the ALTER command? I cant seem to find any info on it in the manual. Regards /Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySql 4.1.1 slow login
Hi all, I have win2k server machine, if this machine online, i could login to MySQL 4.1.1 on RH 9 is about 1 second, but if this machine offline connection establish in about 10 seconds, then i try connect to mysql 4.0.17 in SuSe machine its done in about 1 second. I connect to mysql server from my win2k machine with MySQL Front.So I uninstall MySQL 4.1.1 and reinstall 4.0.17, and connection done in 1 second again even my Win2K server machine offline. Can anyone explain this behavior of MySQL 4.1.1? regards, Hendro -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Timeout Question
Paul Maine [EMAIL PROTECTED] wrote: I am running MySQL version 4.0.18 on a Windows 2000 server system. If I log in locally as an administrator and issues a command such as DESCRIBE TABLE some_table; - everything works fine. If I come back at a later time and run the same command again - it fails because of some type of timeout. If I immediately execute the same command again - it works. What timeout controls this behavior? Take a look at wait_timeout and interactive_timeout variables: http://dev.mysql.com/doc/mysql/en/Server_system_variables.html -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: permissions of ordinary users?
beginner [EMAIL PROTECTED] wrote: Hi, i got mysql 4.0.13 on my machine. When i installed it, i did only basic stuff to get it running (bascilly hit setup). Now, i'm getting a little bit closer to mysql (the system starts to became more friendly), but i got the following problem: - if i log as shellmysql this user seems to have access to modify all databases (i would want it to happen only when i log as shell mysql -h localhost -u root -p ) On Windows user ''@'localhost' has all privileges. How can i configure mysql NOT to accept logins with only shell mysql , i mean without beeing a specified user? Remove entries for anonymous user: DELETE FROM user WHERE user=''; FLUSH PRIVILEGES; -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: foreign keys help
saiph [EMAIL PROTECTED] wrote: i'm studing foreign keys but my sql code does not react as would imagine when i insert inconsistent data. i.e. create database urls; use urls; create table caths ( name varchar(7) primary key ) type = innodb; create table urls ( name varchar(10) primary key, home varchar(30) unique, cath varchar(7), constraint fk foreign key(cath) references caths(name) on update cascade on delete set null ) type = innodb; load data local infile caths.lst into table caths; load data local infile urls.lst into table urls; why it it possible to insert urls such as: mysql mysql.com dev-null when dev-null in not a value of the attribute caths.name? Because your tables are not InnoDB. Check if InnoDB is enabled: SHOW VARIABLES LIKE have_innodb; -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
international LIKE in 4.1.1-alpha
Hi! Win2000, MySql 4.1.1-alpha, cp1251 select '' like '%%'- 1 select ' ' like '%%'- 0 It's a pity 8( Hint : select ' ' like '%%%'- 1(change leading % to %%) Variables: character_set_system=utf8 character_set_server=cp1251 character_set_database=cp1251 character_set_client=cp1251 character_set_connection=cp1251 character_set_results=cp1251 Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installing MySQL-3.23.54-1 pkg on RaQ4i
Hi All, I am trying to install MySQL-3.23.54-1 pkg on a RaQ4i (from pgkmaster.com), which is something I have done on numerous occasions without problem. However, this RaQ for some reason does not have /tmp/mysql.sock installed when the package is installed. When I uninstall the pkg, the script warns that /tmp/mysql.sock could not be removed as it does not exist. I have installed the pkg and uninstalled and each time the same thing, no /tmp/mysql.sock!! Can I simply copy this from one of my other servers into /home/mysql and then create a sym link to it in /tmp?? Any assistance will be greatly appreciated. TIA Phil. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: chroot and run as user on SuSE 9
Duh...never mind. I found the answer buried in my old notes. I'm building a dynamic binary since I'm using SSL. In case anyone else has the same issue, you need a lib/libnss_compat.so.whatever in your chroot environment. Works like a charm. Steve At 09:58 PM 4/14/2004, Steve Slater wrote: Has anyone seen this one? This is with MySQL 4.1.1 source RPM MySQL-4.1.1-0.src.rpm on SuSE 9. Using the MySQL binary RPM, I can --chroot=/path and --user=mysql, and it works fine. But if I compile the binaries mysql on SuSE 9 it doesn't work correctly. If I run as root (--user=root) it starts fine. If I run as mysql (--user=mysql) or any other user, I get this: Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! I compiled the binaries into packages using the spec file that ships with MySQL-4.1.1-0.src.rpm. Anyone else seen that or have a clue why? Thanks! Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: international LIKE in 4.1.1-alpha
Juri Shimon [EMAIL PROTECTED] wrote: Hi! Win2000, MySql 4.1.1-alpha, cp1251 select 'ÃÎÍ×ÀÐÀ' like '%ÃÎÍ×ÀÐÀ%'- 1 select 'ÎËÅÑß ÃÎÍ×ÀÐÀ' like '%ÃÎÍ×ÀÐÀ%'- 0 It's a pity 8( Hint : select 'ÎËÅÑß ÃÎÍ×ÀÐÀ' like '%%ÃÎÍ×ÀÐÀ%'- 1(change leading % to %%) Variables: character_set_system=utf8 character_set_server=cp1251 character_set_database=cp1251 character_set_client=cp1251 character_set_connection=cp1251 character_set_results=cp1251 I was able to repeat it on 4.1.1 but your example worked fine on 4.1.2. -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Server not configured as slave
jim [EMAIL PROTECTED] wrote: Does this machine have a valid server-id? Run show variables like 'server_id' from the mysql monitor. Interesting. The my.cnf says server-id = 75 but the show_variables; command says server_id 0 (zero). Why would that be, and could it be the problem? Where is my.cnf located? Does MySQL server read my.cnf? Also, is there anything in the *.err file on this machine? Nothing but record of server startups and shutdowns. -Original Message- From: jim To: [EMAIL PROTECTED] Sent: 4/14/04 3:26 PM Subject: Server not configured as slave Hi, Can anyone suggest some troubleshooting tips when setting up a slave and getting the error: ERROR 1200: The server is not configured as slave, fix in config file or with CHANGE MASTER TO ? The master is already running with other slaves. I have granted permission and copied the relevant config file information from the other slaves to the new slave. -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
export to csv or excel
Hi, Do you know a good tool to export mysql tables to csv or excel files? It should be able to run on a Linux system, and should be able to be scheduled (cron job). I worked with EMS Mysql Export on a Windows system, this worked fine, but I can't get it to work on the Linux system. I also tried with SELECT ... INTO OUTFILE ... but this gives problems when there are end-of-line characters in the data. Thanks, Bart
Query 2 DBs
Hi, 2 DBs sitting on different machines, any idea of how to run the query? Select a.*, b.field1 from computernam.db1.table1 a, computername.db2.table1 b where a.fieldx = b.fieldx where computername is host for DB. regards Yahoo! Messenger - Communicate instantly...Ping your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Complicated Inner Joins
Here's another rotter! I searched UseNet and read that in MySQL you cannot have a sub-select, but I'm lost as to how to split this into two selects? SELECT distinct p.ProjectID ,p.ProjectName FROM tbl_project AS p INNER JOIN ( ( (tbl_UnitType AS ut INNER JOIN tbl_RateType AS r ON ut.RateType = r.RateType) INNER JOIN (tbl_SubProject AS sp INNER JOIN (Select * FROM tbl_ProjectResource WHERE UserID = '#rptUserID#' AND Deleted = 0 AND ((ActivityDate) Between #datDateFrom# And #datDateTo#) ) AS pr ON sp.SubProjectID = pr.SubProjectID) ON ut.Unit = pr.Unit ) INNER JOIN tbl_RateTypeCategoryCharge AS rt ON pr.RateTypeCategoryChargeID = rt.RateTypeCategoryChargeID ) ON p.ProjectID = sp.ProjectID WHERE ut.reportDisplay = 1 zzapper (vim, cygwin, wiki zsh) -- vim -c :%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg? http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query 2 DBs
Hi, 2 DBs sitting on different machines, any idea of how to run the query? Select a.*, b.field1 from computernam.db1.table1 a, computername.db2.table1 b where a.fieldx = b.fieldx where computername is host for DB. As far as I know, you cannot. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: international LIKE in 4.1.1-alpha
Juri Shimon [EMAIL PROTECTED] wrote: I was able to repeat it on 4.1.1 but your example worked fine on 4.1.2. Where I can get it? Binaries currently are not available, but you can install it from development source tree: http://dev.mysql.com/doc/mysql/en/Installing_source_tree.html -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
please ignore
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 please ignore - -- ~ |...| ~ | _ _|Victor Medina M | ~ |\ \ \| | _ \ / \ |Linux - Java - MySQL | ~ | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | ~ | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | ~ |/_/_/|_|_| /_/ \_\|Tel: +58-241-8507325 - ext. 325 | ~ ||Cel: +58-412-8859934 | ~ ||geek by nature - linux by choice | ~ |...| -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFAfnQ38WJSBCrOXJ4RAoLdAKCzq8I7IyYWdeOZhAearCOtdiy5SACff13C rXyNw+3aprFYN2v5pd+PELs= =ppFP -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: export to csv or excel
Use phpmyadmin. Damn good for data dump in any format you wish... -Original Message- From: Bart De Man [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 6:59 AM To: [EMAIL PROTECTED] Subject: export to csv or excel Hi, Do you know a good tool to export mysql tables to csv or excel files? It should be able to run on a Linux system, and should be able to be scheduled (cron job). I worked with EMS Mysql Export on a Windows system, this worked fine, but I can't get it to work on the Linux system. I also tried with SELECT ... INTO OUTFILE ... but this gives problems when there are end-of-line characters in the data. Thanks, Bart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ignore
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, i been having problems with my mail server, just ignore this message. - -- ~ |...| ~ | _ _|Victor Medina M | ~ |\ \ \| | _ \ / \ |Linux - Java - MySQL | ~ | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | ~ | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | ~ |/_/_/|_|_| /_/ \_\|Tel: +58-241-8507325 - ext. 325 | ~ ||Cel: +58-412-8859934 | ~ ||geek by nature - linux by choice | ~ |...| -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFAfoF68WJSBCrOXJ4RAvAHAJ45Row9Tx9YX4dljRSfKLuyBvATRQCeKt2/ xpEhRCE3zNsfJnyHjgfTQrw= =U2t2 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: export to csv or excel
I use a PERL module called Spreadsheet::WriteExcel. You can get it from CPAN at http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-0.42/. I generate tons of reports monthly using cron to fire off PERL scripts that output my data as Excel spreadsheets using this module. Implementation is fairly easy and the documentation that comes with the module is clearly written with tons of examples. Jack Jack Coxen IP Network Engineer TelCove 712 North Main Street Coudersport, PA 16915 814-260-2705 -Original Message- From: Bart De Man [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 6:59 AM To: [EMAIL PROTECTED] Subject: export to csv or excel Hi, Do you know a good tool to export mysql tables to csv or excel files? It should be able to run on a Linux system, and should be able to be scheduled (cron job). I worked with EMS Mysql Export on a Windows system, this worked fine, but I can't get it to work on the Linux system. I also tried with SELECT ... INTO OUTFILE ... but this gives problems when there are end-of-line characters in the data. Thanks, Bart
Re: Installing MySQL-3.23.54-1 pkg on RaQ4i
mysql.sock only exists while the server is running. Your package install/uninstall scripts are broken. Phil Ewington - 43 Plc wrote: Hi All, I am trying to install MySQL-3.23.54-1 pkg on a RaQ4i (from pgkmaster.com), which is something I have done on numerous occasions without problem. However, this RaQ for some reason does not have /tmp/mysql.sock installed when the package is installed. When I uninstall the pkg, the script warns that /tmp/mysql.sock could not be removed as it does not exist. I have installed the pkg and uninstalled and each time the same thing, no /tmp/mysql.sock!! Can I simply copy this from one of my other servers into /home/mysql and then create a sym link to it in /tmp?? Any assistance will be greatly appreciated. TIA Phil. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql error file
So I am guessing this is not a bug, and that I will have to modify the script myself? -Original Message- From: Luc Foisy Sent: Monday, April 12, 2004 4:34 PM To: Michael Stassen; MYSQL-List (E-mail) Subject: RE: mysql error file Michael wrote: mm... Have you looked in /etc/rc.d/init.d/mysql to see what, exactly, it oes when you tell it to start? Michael I briefly looked in there. This is the same script it uses to start MySQL, and was installed with the rpm of MySQL. I would think it should come with all available options already... To me, it doesn't look like it even reads that option from the my.cnf file. It doesn't look like its reading any option from mysqld_safe group. Pasting the whole thing, so I don't have to work with file attaching. #!/bin/sh # Copyright Abandoned 1996 TCX DataKonsult AB Monty Program KB Detron HB # This file is public domain and comes with NO WARRANTY of any kind # MySQL daemon start/stop script. # Usually this is put in /etc/init.d (at least on machines SYSV R4 based # systems) and linked to /etc/rc3.d/S99mysql and /etc/rc0.d/K01mysql. # When this is done the mysql server will be started when the machine is # started and shut down when the systems goes down. # Comments to support chkconfig on RedHat Linux # chkconfig: 2345 90 90 # description: A very fast and reliable SQL database engine. # Comments to support LSB init script conventions ### BEGIN INIT INFO # Provides: mysql # Required-Start: $local_fs $network $remote_fs # Required-Stop: $local_fs $network $remote_fs # Default-Start: 3 5 # Default-Stop: 3 5 # Short-Description: start and stop MySQL # Description: MySQL is a very fast and reliable SQL database engine. ### END INIT INFO # If you install MySQL on some other places than /, then you # have to do one of the following things for this script to work: # # - Run this script from within the MySQL installation directory # - Create a /etc/my.cnf file with the following information: # [mysqld] # basedir=path-to-mysql-installation-directory # - Add the above to any other configuration file (for example ~/.my.ini) # and copy my_print_defaults to /usr/bin # - Add the path to the mysql-installation-directory to the basedir variable # below. # # If you want to affect other MySQL variables, you should make your changes # in the /etc/my.cnf, ~/.my.cnf or other MySQL configuration files. basedir= # The following variables are only set for letting mysql.server find things. # Set some defaults datadir=/var/lib/mysql pid_file= if test -z $basedir then basedir=/ bindir=/usr/bin else bindir=$basedir/bin fi PATH=/sbin:/usr/sbin:/bin:/usr/bin:$basedir/bin export PATH if test -z $pid_file then pid_file=$datadir/`/bin/hostname`.pid else case $pid_file in /* ) ;; * ) pid_file=$datadir/$pid_file ;; esac fi mode=$1# start or stop parse_arguments() { for arg do case $arg in --basedir=*) basedir=`echo $arg | sed -e 's/^[^=]*=//'` ;; --datadir=*) datadir=`echo $arg | sed -e 's/^[^=]*=//'` ;; --pid-file=*) pid_file=`echo $arg | sed -e 's/^[^=]*=//'` ;; esac done } # Get arguments from the my.cnf file, # groups [mysqld] [mysql_server] and [mysql.server] if test -x ./bin/my_print_defaults then print_defaults=./bin/my_print_defaults elif test -x $bindir/my_print_defaults then print_defaults=$bindir/my_print_defaults elif test -x $bindir/mysql_print_defaults then print_defaults=$bindir/mysql_print_defaults else # Try to find basedir in /etc/my.cnf conf=/etc/my.cnf print_defaults= if test -r $conf then subpat='^[^=]*basedir[^=]*=\(.*\)$' dirs=`sed -e /$subpat/!d -e 's//\1/' $conf` for d in $dirs do d=`echo $d | sed -e 's/[ ]//g'` if test -x $d/bin/my_print_defaults then print_defaults=$d/bin/my_print_defaults break fi if test -x $d/bin/mysql_print_defaults then print_defaults=$d/bin/mysql_print_defaults break fi done fi # Hope it's in the PATH ... but I doubt it test -z $print_defaults print_defaults=my_print_defaults fi parse_arguments `$print_defaults mysqld mysql_server mysql.server` # Safeguard (relative paths, core dumps..) cd $basedir case $mode in 'start') # Start daemon if test -x $bindir/safe_mysqld then # Give extra arguments to mysqld with the my.cnf file. This script may # be overwritten at next upgrade. $bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file # Make lock for RedHat / SuSE if test -w /var/lock/subsys then touch /var/lock/subsys/mysql fi else echo Can't execute $bindir/safe_mysqld from dir $basedir fi ;; 'stop') # Stop daemon. We use a signal here to avoid having to know the # root password. if test -s $pid_file then mysqld_pid=`cat $pid_file` echo Killing mysqld with pid $mysqld_pid kill $mysqld_pid # mysqld should remove
RE: MySQL Cluster
You can also use pae for any one process to address 4 GB of ram on a 32 bit system. -- DVP -Original Message- From: Tim Cutts [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 2:05 PM To: Adam Erickson Cc: [EMAIL PROTECTED] Subject: Re: MySQL Cluster On 14 Apr 2004, at 10:57 pm, Adam Erickson wrote: (This is probably not the best place for this post, but here goes...) The (soon to be released) MySQL cluster software docs use a sample cluster node configured with Dual Xeons and 16GB of ram. MySQL has never been able to use more than 2 gigs of system memory (on 32 bit platforms.) With MySQL Cluster, will MySQL finally start using the memory paging trick Oracle and others have been using for years? Otherwise, what is the point of having 16 gigs of ram for one MySQL server? Disk cache. Tables which MySQL doesn't have in its own buffers but which nevertheless are frequently accessed will already be in RAM, and therefore faster to access. Even so, you'd probably do better with a 64 bit processor with that amount of memory. Tim -- Dr Tim Cutts Informatics Systems Group Wellcome Trust Sanger Institute Hinxton, Cambridge, CB10 1SA, UK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Reminder: uc2004.vbmysql.com
Hello Everyone; I thought I would take a chance to remind you all of the blog collection and image gallery available at http://uc2004.vbmysql.com We have had over 30 blog entries posted since the conference started, written by several bloggers and encourage more to contribute. If you were not able to make it to the conference this is shaping up to be a great resource for getting session notes from the attendees. Regards, Mike Hillyer www.vbmysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
InnoDB
MySQL Experts: I am new for MySQL database. We have a 4.0.18 MySQL sit on Linux box. I am reading on InnoDB. And having a question. How do I know the table is configured by InnoDB instead of normal table ? Should I at least see some entry in the /etc/my.cnf to indicate that InnoDB is configured? Thanks in advance. Jenny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: InnoDB
Hi Jenny, mysql SHOW VARIABLES LIKE '%have%'; ++---+ | Variable_name | Value | ++---+ | have_bdb | YES | | have_crypt | NO| | have_innodb| YES | | have_isam | YES | | have_raid | NO| | have_symlink | YES | | have_openssl | NO| | have_query_cache | YES | ++---+ 8 rows in set (0.03 sec) You might find the following helpful http://www.codeant.com/tutorials/mysql/MySQLTutorial.html Matt -Original Message- From: Chen, Jenny [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 10:23 AM To: '[EMAIL PROTECTED]' Subject: InnoDB MySQL Experts: I am new for MySQL database. We have a 4.0.18 MySQL sit on Linux box. I am reading on InnoDB. And having a question. How do I know the table is configured by InnoDB instead of normal table ? Should I at least see some entry in the /etc/my.cnf to indicate that InnoDB is configured? Thanks in advance. Jenny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.656 / Virus Database: 421 - Release Date: 4/9/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.656 / Virus Database: 421 - Release Date: 4/9/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: InnoDB
How do I know the table is configured by InnoDB instead of normal table ? Do a show table status or a show create table name_of_my_table Should I at least see some entry in the /etc/my.cnf to indicate that InnoDB is configured? No, but if you don't want to use innodb you can add skip-innodb in the /etc/my.cnf Marc. -Message d'origine- De : Chen, Jenny [mailto:[EMAIL PROTECTED] Envoyé : jeudi 15 avril 2004 18:23 À : '[EMAIL PROTECTED]' Objet : InnoDB MySQL Experts: I am new for MySQL database. We have a 4.0.18 MySQL sit on Linux box. I am reading on InnoDB. And having a question. How do I know the table is configured by InnoDB instead of normal table ? Should I at least see some entry in the /etc/my.cnf to indicate that InnoDB is configured? Thanks in advance. Jenny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Cluster
On Wed, 14 Apr 2004, Tim Cutts wrote: On 14 Apr 2004, at 10:57 pm, Adam Erickson wrote: (This is probably not the best place for this post, but here goes...) The (soon to be released) MySQL cluster software docs use a sample cluster node configured with Dual Xeons and 16GB of ram. MySQL has never been able to use more than 2 gigs of system memory (on 32 bit platforms.) With MySQL Cluster, will MySQL finally start using the memory paging trick Oracle and others have been using for years? Otherwise, what is the point of having 16 gigs of ram for one MySQL server? Disk cache. Tables which MySQL doesn't have in its own buffers but which nevertheless are frequently accessed will already be in RAM, and therefore faster to access. Well ... that doesn't tie in with what I'm reading about mysql cluster, namely it being a main memory database where all data is kept in memory. I guess you can probably run multiple instances of the cluster node on one machine, having the data split across them in a fairly transparent manner. However, there is ... very minimal technical information available on mysql.com about exactly what mysql cluster (ie. mysql on top of NDB) is and what it is really designed for. I looked at the NDB API docs in the bitkeeper tree, which help a bit ... but not all that much. It doesn't look like the current ndb code has any PAE support ... at least on Unix. It does some AWE-ish calls on windows but I don't think those are to actually allows more than somewhere between 2 and 4 gigs per process the way it is being used, unless I am missing something. My overview so far is that it is designed for very though transaction rate systems, with a large number of fairly simple transactions, and also possibly systems with a large amount of read activity. All of this needs to be on a moderately sized data set, since the design is based on it being an in memory database. In any case, since the NDB storage engine is used in place of myisam or innodb... even if it could address more memory using PAE, that wouldn't mean other storage engines could. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Strange Index Usage: select ... where foo = 90 on a varchar
On Apr 13, 2004, at 2:01pm, Michael Stassen wrote: You shouldn't be surprised. This is normal behavior. interchangeStatus is a varchar, so select fileName from outDocInterchange where interchangeStatus = 91; requires that interchangeStatus be converted to an int for each row so it can be compared to 91, rendering the index useless. On the other hand, select fileName from outDocInterchange where interchangeStatus = '91'; compares interchangeStatus to a string, which the index is designed to do. In general, an index on a column won't help if the column is input to a function. Shouldn't MySQL just cast the constant integer to a string instead? Perhaps this optimization isn't done. Also, I'm not completely sure, but I think this type of query was indexed in 3.23. Or more precisely, these queries didn't become slow until after I upgraded to 4.0.18 (from 3.23.40). Granted, ultimately I needed (and did) change the column type, but I'm curious to see if why the behavior changed. Could someone running 3.23 check the output of: explain select * from bar where foo=1 (1 without quotes) explain select * from bar where foo='1' (1 with quotes) (foo is an indexed varchar column) Is only one indexed, or are they both indexed? - Max -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Strange Index Usage: select ... where foo = 90 on a varchar
On Thu, 15 Apr 2004, Max Campos wrote: On Apr 13, 2004, at 2:01pm, Michael Stassen wrote: You shouldn't be surprised. This is normal behavior. interchangeStatus is a varchar, so select fileName from outDocInterchange where interchangeStatus = 91; requires that interchangeStatus be converted to an int for each row so it can be compared to 91, rendering the index useless. On the other hand, select fileName from outDocInterchange where interchangeStatus = '91'; compares interchangeStatus to a string, which the index is designed to do. In general, an index on a column won't help if the column is input to a function. Shouldn't MySQL just cast the constant integer to a string instead? Perhaps this optimization isn't done. Also, I'm not completely sure, but I think this type of query was indexed in 3.23. Or more precisely, these queries didn't become slow until after I upgraded to 4.0.18 (from 3.23.40). Granted, ultimately I needed (and did) change the column type, but I'm curious to see if why the behavior changed. Except there are multiple ways that something that is numerically equal to 91 can be represented as a string, eg. 91.0, 91, etc. So using the index would result in different behaviour in some situations. I think that if things worked how I would like them, mysql wouldn't automatically do the cast at all so it would be obvious that something that is possibly unexpected is happening. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 5.0.0-alpha-max-debug running on localhost as ODBC@localhost
This appears when I attempt to open phpMyAdmin. It doesn't matter what account I set in the config.inc.php file, I continue to get this error. How do I change this so that another account logs in to the localhost? I unfortunately had to reboot my server and this became the result. I notice that I can log in to MySQLCC and the command line as root without a problem. Thanks
Fatal error 1236 (replication)
Our master suffered a power failure. When fixed we brought up its only slave and found that it wouldn't replicate. The error log revealed that the slave was requesting replication from an impossible position: Slave SQL thread initialized, starting replication in log 'dbm-bin.041' at position 117415283, relay log './dbs1-relay-bin.016' position: 117415850 Slave I/O thread: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'dbm-bin.041' at position 117415283 Error reading packet from server: Client requested master to start replication from impossible position (server_errno=1236) Got fatal error 1236: 'Client requested master to start replication from impossible position' from master when reading data from binary log Slave I/O thread exiting, read up to log 'dbm-bin.041', position 117415283 Master status: mysql show master status; +-+--+--+--+ | File| Position | Binlog_do_db | Binlog_ignore_db | +-+--+--+--+ | dbm-bin.043 | 89536436 | | | +-+--+--+--+ I'm guessing the slave is out of sync because the master wasn't able to flush its data to disk before failing. Is it possible to recover from this situation -- perhaps by modifying master.info and relay-log.info? Or should I start over with a new snapshot of the master? Thanks, Paul -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: please ignore
That's a lot of stuff to ignore but I managed to do so successfully -Ursprüngliche Nachricht- Von: Victor Medina [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 15. April 2004 13:39 An: [EMAIL PROTECTED] Mysql. Com Betreff: please ignore -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 please ignore - -- ~ |...| ~ | _ _|Victor Medina M | ~ |\ \ \| | _ \ / \ |Linux - Java - MySQL | ~ | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | ~ | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | ~ |/_/_/|_|_| /_/ \_\|Tel: +58-241-8507325 - ext. 325 | ~ ||Cel: +58-412-8859934 | ~ ||geek by nature - linux by choice | ~ |...| -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFAfnQ38WJSBCrOXJ4RAoLdAKCzq8I7IyYWdeOZhAearCOtdiy5SACff13C rXyNw+3aprFYN2v5pd+PELs= =ppFP -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Cluster
MySQL just announced their MySQL Cluster product. But the minimum requirements for it include a Xeon/Itanium/Opteron CPU and a SCSI drive with a RAID1 controller. Why is that? Seems strange. http://www.mysql.com/products/cluster/faq.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Slow Connection from PHP to MySQL 5.0
Hi Folks. I've seen similar questions asked both here, and via a google search - but I haven't found an answer which has helped yet - so heres hoping!! I run a Linux webserver which has PHP 4 installed, and am currently prototyping a design using MySQL 5.0-alpha on Windows 2K professional. The two servers are on different subnets of a LAN, but are able to talk to each other unrestricted (all TCP services I have tried work perfectly, e.g. SMTP, FTP). The problem is that connections from PHP to MySQL seem to take 4-5 seconds (after which any queries within the connection go through in normal lengths of time - only the connection time itself is long). Although I have a fully functional internal DNS server, I thought name resolution might be an issue. I amended my PHP pages (they inherit a global 'data connection' object which is used as a wrapper) to connect to the Win2k box by IP address - and the problem persists. Has anyone else encountered this, and are there any ideas? Connections from the same Linux box with PHP to another Linux box on the same subnet as the Win2k box running MySQL 4 work perfectly - so is it possible this is a MySQL 5 issue? I am using the 'old connections' flag (but have tried both with it off and on, since I am not actually using a password for the connection at present). Any suggestions will be most gratefully received! Cheers, Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL cluster
Hi All, Is there some version of MySQL cluster available for downloading at the moment? If yes, where is it? Thanks in advance. Cheers, Wensheng -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SELECT ?
Hi, Is it possible to select all records from one table that don't have an entry in another table. Something like: SELECT t1.* FROM 'TABLE1' AS t1, 'TABLE2' AS t2 WHERE t1.cv = 1 AND t1.id != t2.id So in this mock example there is an id in one table, but the id is not in another table (The second id will be in the second table someday just not today). Not sure if this is possible at all or not, but thought I would ask. Regards, Justin Palmer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL cluster
On Thu, Apr 15, 2004 at 03:05:01PM -0400, Wensheng Deng wrote: Is there some version of MySQL cluster available for downloading at the moment? If yes, where is it? Thanks in advance. MySQL Cluster is currently only available in source form as part of the MySQL 4.1 BitKeeper repository (which means it will show up in the nightly snapshots at http://downloads.mysql.com/snaps.php soon), it will be part of the source download for MySQL 4.1.2 when that is released, and binaries will be included in 4.1.2 or later 4.1 releases for those platforms that MySQL Cluster supports. Jim Winstead MySQL AB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SELECT ?
Absolutely, do a left join and check for NULL values from the other table. SELECT t1.* FROM t1 LEFT JOIN t2 ON t1.id=t2.id WHERE t2.id IS NULL The left join retains all records in the first table regardless of matches in the second. You then filter out those records with a null value in a table 2 field. On Apr 15, 2004, at 3:46 PM, Justin Palmer wrote: Hi, Is it possible to select all records from one table that don't have an entry in another table. Something like: SELECT t1.* FROM 'TABLE1' AS t1, 'TABLE2' AS t2 WHERE t1.cv = 1 AND t1.id != t2.id -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: SELECT ?
Hi, Thanks. So what you are saying is if a record is not there it is considered NULL? Regards, Justin Palmer -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 12:54 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: SELECT ? Absolutely, do a left join and check for NULL values from the other table. SELECT t1.* FROM t1 LEFT JOIN t2 ON t1.id=t2.id WHERE t2.id IS NULL The left join retains all records in the first table regardless of matches in the second. You then filter out those records with a null value in a table 2 field. On Apr 15, 2004, at 3:46 PM, Justin Palmer wrote: Hi, Is it possible to select all records from one table that don't have an entry in another table. Something like: SELECT t1.* FROM 'TABLE1' AS t1, 'TABLE2' AS t2 WHERE t1.cv = 1 AND t1.id != t2.id -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
InnoDB corruption
Hi, Im using Win98 with mysql 4.0.1-alpha-max-debug. My main database has only InnoDB tables and, I dont know how, some tables were corrupted. My problem is using the CHECK statement I can find where the corruptions are but I cant repair them with REPAIR (error message: table handler doesnt support REPAIR). What should I do? Here are the CHECK results from my corrupted tables. Please, somebody help me. Thank u very much Dirso. -- TableName: CLIENT dbcmanager.CLIENT,check,warning,Found 5 partsShould be: 2 parts dbcmanager.CLIENT,check,status,OK -- TableName: DEPTO dbcmanager.DEPTO,check,warning,Found 5 partsShould be: 0 parts dbcmanager.DEPTO,check,status,OK -- TableName: PDV dbcmanager.PDV,check,warning,1 clients is using or hasn't closed the table properly dbcmanager.PDV,check,status,OK -- TableName: PRODUCT dbcmanager.PRODUCT,check,warning,2 clients is using or hasn't closed the table properly dbcmanager.PRODUCT,check,warning,Found 15624 partsShould be: 5468 parts dbcmanager.PRODUCT,check,status,OK -- TableName: SELL dbcmanager.SELL,check,warning,Size of indexfile is: 123904 Should be: 67584 dbcmanager.SELL,check,status,OK -- TableName: TROCA dbcmanager.TROCA,check,warning,Found 1 partsShould be: 0 parts dbcmanager.TROCA,check,status,OK -- TableName: cheques_track dbcmanager.cheques_track,check,warning,1 clients is using or hasn't closed the table properly dbcmanager.cheques_track,check,error,Size of datafile is: 1410124 Should be: 1410164 dbcmanager.cheques_track,check,error,Corrupt --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.651 / Virus Database: 417 - Release Date: 5/4/2004
Error ?
Hi, I get this error from a query: #1066 - Not unique table/alias: 't2' What does it mean? Can anyone point me to a place where I can look up what these codes actually mean? Any help would be great. Regards, Justin Palmer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FW: Error ?
The query that generated this error was: SELECT t1. * FROM `wat_student_profile` AS t1, `wat_student_job` AS t2 LEFT JOIN t2 ON t1.student_id = t2.student_id WHERE t1.cv != '' AND t1.sevis_id = '' AND t2.student_id = NULL LIMIT 0 , 30 Regards, Justin Palmer -Original Message- From: Justin Palmer [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 1:28 PM To: [EMAIL PROTECTED] Subject: Error ? Hi, I get this error from a query: #1066 - Not unique table/alias: 't2' What does it mean? Can anyone point me to a place where I can look up what these codes actually mean? Any help would be great. Regards, Justin Palmer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Error ?
Hi, Can anyone give me a hint to what this error message is trying to say. Thanks, Justin Palmer -Original Message- From: Justin Palmer [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 1:38 PM To: [EMAIL PROTECTED] Subject: FW: Error ? The query that generated this error was: SELECT t1. * FROM `wat_student_profile` AS t1, `wat_student_job` AS t2 LEFT JOIN t2 ON t1.student_id = t2.student_id WHERE t1.cv != '' AND t1.sevis_id = '' AND t2.student_id = NULL LIMIT 0 , 30 Regards, Justin Palmer -Original Message- From: Justin Palmer [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 1:28 PM To: [EMAIL PROTECTED] Subject: Error ? Hi, I get this error from a query: #1066 - Not unique table/alias: 't2' What does it mean? Can anyone point me to a place where I can look up what these codes actually mean? Any help would be great. Regards, Justin Palmer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Error ?
Your join syntax is incorrect. Check out: http://dev.mysql.com/doc/mysql/en/JOIN.html In particular, you join against an alias (t2), when you need to join on an actual table. On Thu, 2004-04-15 at 14:25, Justin Palmer wrote: Hi, Can anyone give me a hint to what this error message is trying to say. Thanks, Justin Palmer -Original Message- From: Justin Palmer [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 1:38 PM To: [EMAIL PROTECTED] Subject: FW: Error ? The query that generated this error was: SELECT t1. * FROM `wat_student_profile` AS t1, `wat_student_job` AS t2 LEFT JOIN t2 ON t1.student_id = t2.student_id WHERE t1.cv != '' AND t1.sevis_id = '' AND t2.student_id = NULL LIMIT 0 , 30 Regards, Justin Palmer -Original Message- From: Justin Palmer [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 1:28 PM To: [EMAIL PROTECTED] Subject: Error ? Hi, I get this error from a query: #1066 - Not unique table/alias: 't2' What does it mean? Can anyone point me to a place where I can look up what these codes actually mean? Any help would be great. Regards, Justin Palmer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- |- Garth Webb -| |- [EMAIL PROTECTED] -| signature.asc Description: This is a digitally signed message part
RE: Error ?
Sounds to me like it doesn't the the alias name T2 but might need the full table name. Hi, Can anyone give me a hint to what this error message is trying to say. Thanks, Justin Palmer -Original Message- From: Justin Palmer [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 1:38 PM To: [EMAIL PROTECTED] Subject: FW: Error ? The query that generated this error was: SELECT t1. * FROM `wat_student_profile` AS t1, `wat_student_job` AS t2 LEFT JOIN t2 ON t1.student_id = t2.student_id WHERE t1.cv != '' AND t1.sevis_id = '' AND t2.student_id = NULL LIMIT 0 , 30 Regards, Justin Palmer -Original Message- From: Justin Palmer [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 1:28 PM To: [EMAIL PROTECTED] Subject: Error ? Hi, I get this error from a query: #1066 - Not unique table/alias: 't2' What does it mean? Can anyone point me to a place where I can look up what these codes actually mean? Any help would be great. Regards, Justin Palmer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
command not found: trying to start mysql
binary 4.1 on Linux. to start mysql, i have to be in: /usr/local/mysql and execute: ./bin/mysql -u root mysql If i'm in another directory, I get command not found: trying to start mysql. Seems to me this is a PATH issue. I had binary 4.0 working here at one time, but I'm delete most if not all of those files. Don
Learning curve
Hi all! I'm wondering if anyone can help me find out how much time/training is needed to accomplish my task using MySQL. My background: I'm fresh to the world of MySQL and databases in general. I do have some fundamental knowledge in the area of programming and databases, but nothing too in-depth. My story: I work for a University that is seemingly falling behind the technical times. My department is using MS Access as the primary software for handling data, but we're still mainly hard-copy for our records-management. Obviously, there are problems with keeping hard-copy for everything. I was buried in paperwork for a short while before I decided to create simple databases/forms using OpenOffice.org, since it was so easy. Someone in management noticed the consistency emerging from my office and inquired. When I told them about my databases, they decided everyone in the department could benefit from them and assigned the project of making this available to all. My problem: My databases are single-user systems for use in OpenOffice.org and would be difficult to roll them out to my entire team. I don't want to install OO.o on everyones computer and I don't want to learn MS Access as it is known for being a temporary solution. So I need something that can keep up with the times and can be rolled out easily (web interface?). I also need to be able to append scanned images to records (PDF or JPEG?). This is all pretty complex and I'm definitely not technically equipped to create this just yet. MySQL?: I believe a good question would be whether or not MySQL would be a good solution for this. What do you think? Also, how long would it take me to learn the necessary information? Lastly, how long would it take to develop such a system? I appreciate your time and information! Thanks, Mike T. Caskey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Indexing a TEXT column
Using mysql 3.23.53, i have a table with approx 1.000.000 records, and only 3 columns. One of these (called 'value') is usually between 50 and 150 characters, but occasionally jumps to a current maximum of 570 characters, so I figured I had to go for the TEXT type. now I tried to add an index on this column. Using length 150 does not work : mysql just bails out pretending everything went fine, but there's no index to be seen. Using length 100 does create the index, but afterwards any query on that column will return 0 results. So the index is bogus (although it is 27MB !) I'm a bit reluctant to upgrade to 4.x, since I'm afraid other stuff will break. can anyone help me out here ? thanks ! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Learning curve
Mike T. Caskey wrote: Hi all! I'm wondering if anyone can help me find out how much time/training is needed to accomplish my task using MySQL. My background: I'm fresh to the world of MySQL and databases in general. I do have some fundamental knowledge in the area of programming and databases, but nothing too in-depth. My story: I work for a University that is seemingly falling behind the technical times. My department is using MS Access as the primary software for handling data, but we're still mainly hard-copy for our records-management. Obviously, there are problems with keeping hard-copy for everything. I was buried in paperwork for a short while before I decided to create simple databases/forms using OpenOffice.org, since it was so easy. Someone in management noticed the consistency emerging from my office and inquired. When I told them about my databases, they decided everyone in the department could benefit from them and assigned the project of making this available to all. My problem: My databases are single-user systems for use in OpenOffice.org and would be difficult to roll them out to my entire team. I don't want to install OO.o on everyones computer and I don't want to learn MS Access as it is known for being a temporary solution. So I need something that can keep up with the times and can be rolled out easily (web interface?). I also need to be able to append scanned images to records (PDF or JPEG?). This is all pretty complex and I'm definitely not technically equipped to create this just yet. MySQL?: I believe a good question would be whether or not MySQL would be a good solution for this. What do you think? Also, how long would it take me to learn the necessary information? Lastly, how long would it take to develop such a system? I appreciate your time and information! Thanks, Mike T. Caskey If you are determined to do a little extra work ( over what's required for Access ), I'd go for PHP. I've completely converted our sales DB front-ends from Access to PHP and it is a lot better. It's much faster, MUCH more stable and we can provide remote access to the DB. But it certainly is more work to get it running and to make changes. I've seen code floating around for uploading images to a MySQL DB via a PHP-driven web site. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Learning curve
Mike - You didn't indicate your department, so I'm not sure what your background is. Your message, overall, is a bit scary, as any university that far behind right now would be worrisome. I'm not exactly sure what you're asking for (as you didn't ouline your requirements), but I would first take a look on sites like sourceforge or freshmeat for systems that already do what you want. I'm sure the kind of record keeping you do has been done before. But as to your main quesiton, it is very doable. You just need to keep in mind multi-user issue like record locking. Search the archives for messages by me about record locking for an elegant way to do it via a flag field. If you can't find it, let me know, and I'll type it up again. j- k- On Thursday 15 April 2004 02:06 pm, Mike T. Caskey said something like: Hi all! I'm wondering if anyone can help me find out how much time/training is needed to accomplish my task using MySQL. My background: I'm fresh to the world of MySQL and databases in general. I do have some fundamental knowledge in the area of programming and databases, but nothing too in-depth. My story: I work for a University that is seemingly falling behind the technical times. My department is using MS Access as the primary software for handling data, but we're still mainly hard-copy for our records-management. Obviously, there are problems with keeping hard-copy for everything. I was buried in paperwork for a short while before I decided to create simple databases/forms using OpenOffice.org, since it was so easy. Someone in management noticed the consistency emerging from my office and inquired. When I told them about my databases, they decided everyone in the department could benefit from them and assigned the project of making this available to all. My problem: My databases are single-user systems for use in OpenOffice.org and would be difficult to roll them out to my entire team. I don't want to install OO.o on everyones computer and I don't want to learn MS Access as it is known for being a temporary solution. So I need something that can keep up with the times and can be rolled out easily (web interface?). I also need to be able to append scanned images to records (PDF or JPEG?). This is all pretty complex and I'm definitely not technically equipped to create this just yet. MySQL?: I believe a good question would be whether or not MySQL would be a good solution for this. What do you think? Also, how long would it take me to learn the necessary information? Lastly, how long would it take to develop such a system? I appreciate your time and information! Thanks, Mike T. Caskey -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Proces table entries
Hi, When trying to improve system performance of my webserver, I found out that there are 10 entries of [mysqld] in the Unix proces table (ps aux), even when there are only one or two processes visible with the mysqladmin proceslist command. Those entries in the Unix proces table consume much memory and make the system slower than necessary. Does anyone have a hint about how to limit the number of Unix processes. I do have another (test) system, which is working fine. This system has about one entry in the Unix proces table for each mysql thread (as expected). However I cannot spot any differences in configuration between both systems. (at least not in my.cnf). See output underneath. Thanks for your time Rob # ./mysqladmin -uroot -p processlist Enter password: ++--+---++-+--+---+--+ | Id | User | Host | db | Command | Time | State | Info | ++--+---++-+--+---+--+ | 1 | root | localhost || Query | 0| | show processlist | ++--+---++-+--+---+--+ [EMAIL PROTECTED] bin]# ps aux -H | grep mysqld root 4320 0.0 0.8 3496 624 pts/1S23:47 0:00 grep mysqld root 4189 0.0 1.4 4072 1112 ?S21:56 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe mysql 4208 0.0 17.0 49356 13280 ? S21:56 0:01 [mysqld] mysql 4209 0.0 17.0 49356 13280 ? S21:56 0:00 [mysqld] mysql 4210 0.0 17.0 49356 13280 ? S21:56 0:00 [mysqld] mysql 4211 0.0 17.0 49356 13280 ? S21:56 0:00 [mysqld] mysql 4212 0.0 17.0 49356 13280 ? S21:56 0:00 [mysqld] mysql 4213 0.0 17.0 49356 13280 ? S21:56 0:00 [mysqld] mysql 4214 0.0 17.0 49356 13280 ? S21:56 0:00 [mysqld] mysql 4215 0.0 17.0 49356 13280 ? S21:56 0:00 [mysqld] mysql 4216 0.0 17.0 49356 13280 ? S21:56 0:00 [mysqld] mysql 4217 0.0 17.0 49356 13280 ? S21:56 0:00 [mysqld] [EMAIL PROTECTED] bin]# :
AW: command not found: trying to start mysql
Try ls to see whether safe_mysqld is in the directory and the run: Safe_mysqld Note! You have to be root to run the mysqld demon HTH Babs -Ursprüngliche Nachricht- Von: Don Dachner [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 15. April 2004 21:48 An: [EMAIL PROTECTED] Betreff: command not found: trying to start mysql binary 4.1 on Linux. to start mysql, i have to be in: /usr/local/mysql and execute: ./bin/mysql -u root mysql If i'm in another directory, I get command not found: trying to start mysql. Seems to me this is a PATH issue. I had binary 4.0 working here at one time, but I'm delete most if not all of those files. Don -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Multi-User Issues
Hi Joshua, I would love to here more about multi-user issues (like record locking). I searched the archives by the title and by your name with no luck. If you don't feel like going into detail, could you point out some good links to learn more about the subject. Regards, Justin Palmer -Original Message- From: Joshua J. Kugler [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 3:27 PM To: [EMAIL PROTECTED] Subject: Re: Learning curve Mike - You didn't indicate your department, so I'm not sure what your background is. Your message, overall, is a bit scary, as any university that far behind right now would be worrisome. I'm not exactly sure what you're asking for (as you didn't ouline your requirements), but I would first take a look on sites like sourceforge or freshmeat for systems that already do what you want. I'm sure the kind of record keeping you do has been done before. But as to your main quesiton, it is very doable. You just need to keep in mind multi-user issue like record locking. Search the archives for messages by me about record locking for an elegant way to do it via a flag field. If you can't find it, let me know, and I'll type it up again. j- k- On Thursday 15 April 2004 02:06 pm, Mike T. Caskey said something like: Hi all! I'm wondering if anyone can help me find out how much time/training is needed to accomplish my task using MySQL. My background: I'm fresh to the world of MySQL and databases in general. I do have some fundamental knowledge in the area of programming and databases, but nothing too in-depth. My story: I work for a University that is seemingly falling behind the technical times. My department is using MS Access as the primary software for handling data, but we're still mainly hard-copy for our records-management. Obviously, there are problems with keeping hard-copy for everything. I was buried in paperwork for a short while before I decided to create simple databases/forms using OpenOffice.org, since it was so easy. Someone in management noticed the consistency emerging from my office and inquired. When I told them about my databases, they decided everyone in the department could benefit from them and assigned the project of making this available to all. My problem: My databases are single-user systems for use in OpenOffice.org and would be difficult to roll them out to my entire team. I don't want to install OO.o on everyones computer and I don't want to learn MS Access as it is known for being a temporary solution. So I need something that can keep up with the times and can be rolled out easily (web interface?). I also need to be able to append scanned images to records (PDF or JPEG?). This is all pretty complex and I'm definitely not technically equipped to create this just yet. MySQL?: I believe a good question would be whether or not MySQL would be a good solution for this. What do you think? Also, how long would it take me to learn the necessary information? Lastly, how long would it take to develop such a system? I appreciate your time and information! Thanks, Mike T. Caskey -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Locking tables
I've found a nice shell script to use to backup my server's MySQL databases. https://sourceforge.net/projects/automysqlbackup/ However, when I tried this earlier today it resulted in a corrupt table. Now the table in question is one I've had issues with for other reasons, but it has over 2 mil records in it when only partially built. What I need to do is put a lock on the database/tables before the script is run. The script allows for a pre post shell script to run. So what do I need to do before running any backup scripts to ensure the tables will not be corrupted during any kind of shell operation? Do I have to stop services like mysqld or httpd before hand? Does anyone use MySQL 4.0.18 and the hot copy instead? I'm using 4.0.17-max Mark Súsol --- u l t i m a t e CreativeMedia Web | Print | CD Media | eCommerce www.ultimatecreativemedia.com Ph: 301-668-0588 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Proces table entries
At 23:51 +0200 4/15/04, Rob Schuurman wrote: Hi, When trying to improve system performance of my webserver, I found out that there are 10 entries of [mysqld] in the Unix proces table (ps aux), even when there are only one or two processes visible with the mysqladmin proceslist command. Those entries in the Unix proces table consume much memory and make the system slower than necessary. Are you sure they're not just threads of the same mysqld process? Does anyone have a hint about how to limit the number of Unix processes. I do have another (test) system, which is working fine. This system has about one entry in the Unix proces table for each mysql thread (as expected). However I cannot spot any differences in configuration between both systems. (at least not in my.cnf). See output underneath. Thanks for your time Rob # ./mysqladmin -uroot -p processlist Enter password: ++--+---++-+--+---+--+ | Id | User | Host | db | Command | Time | State | Info | ++--+---++-+--+---+--+ | 1 | root | localhost || Query | 0| | show processlist | ++--+---++-+--+---+--+ [EMAIL PROTECTED] bin]# ps aux -H | grep mysqld root 4320 0.0 0.8 3496 624 pts/1S23:47 0:00 grep mysqld root 4189 0.0 1.4 4072 1112 ?S21:56 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe mysql 4208 0.0 17.0 49356 13280 ? S21:56 0:01 [mysqld] mysql 4209 0.0 17.0 49356 13280 ? S21:56 0:00 [mysqld] mysql 4210 0.0 17.0 49356 13280 ? S21:56 0:00 [mysqld] mysql 4211 0.0 17.0 49356 13280 ? S21:56 0:00 [mysqld] mysql 4212 0.0 17.0 49356 13280 ? S21:56 0:00 [mysqld] mysql 4213 0.0 17.0 49356 13280 ? S21:56 0:00 [mysqld] mysql 4214 0.0 17.0 49356 13280 ? S21:56 0:00 [mysqld] mysql 4215 0.0 17.0 49356 13280 ? S21:56 0:00 [mysqld] mysql 4216 0.0 17.0 49356 13280 ? S21:56 0:00 [mysqld] mysql 4217 0.0 17.0 49356 13280 ? S21:56 0:00 [mysqld] [EMAIL PROTECTED] bin]# : -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Query Question
Hi, I am wondering if this is possible: Say I have a table with 2 columns, Column_Count and Column_TotalCount; Is it possible to use a query to select all rows from the table where Column_Count is greater than Column_TotalCount? Like this: SELECT * FROM mytable WHERE Column_Count Column_TotalCount; Thanks.
Re: Query Question
Hello, Friday, April 16, 2004, 12:50:21 AM, you wrote: M Is it possible to use a query to select all rows from the table M where Column_Count is greater than Column_TotalCount? M Like this: M SELECT * FROM mytable WHERE Column_Count Column_TotalCount; Perhaps you ought to try it before posting? ;) -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Multi-User Issues
Just to get a general feel for interest: Should I just whip up something quick and dirty and post to the mailing list, or should I work up a nice page or two and put it on a web site? Anyone else interested? Warnring: to work up something, it might be a week or two as school is getting really busy right now, but I'd love to do it, as I've used MySQL in multi-user environments. j- k- On Thursday 15 April 2004 03:05 pm, Justin Palmer said something like: Hi Joshua, I would love to here more about multi-user issues (like record locking). I searched the archives by the title and by your name with no luck. If you don't feel like going into detail, could you point out some good links to learn more about the subject. Regards, Justin Palmer -Original Message- From: Joshua J. Kugler [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 3:27 PM To: [EMAIL PROTECTED] Subject: Re: Learning curve Mike - You didn't indicate your department, so I'm not sure what your background is. Your message, overall, is a bit scary, as any university that far behind right now would be worrisome. I'm not exactly sure what you're asking for (as you didn't ouline your requirements), but I would first take a look on sites like sourceforge or freshmeat for systems that already do what you want. I'm sure the kind of record keeping you do has been done before. But as to your main quesiton, it is very doable. You just need to keep in mind multi-user issue like record locking. Search the archives for messages by me about record locking for an elegant way to do it via a flag field. If you can't find it, let me know, and I'll type it up again. j- k- On Thursday 15 April 2004 02:06 pm, Mike T. Caskey said something like: Hi all! I'm wondering if anyone can help me find out how much time/training is needed to accomplish my task using MySQL. My background: I'm fresh to the world of MySQL and databases in general. I do have some fundamental knowledge in the area of programming and databases, but nothing too in-depth. My story: I work for a University that is seemingly falling behind the technical times. My department is using MS Access as the primary software for handling data, but we're still mainly hard-copy for our records-management. Obviously, there are problems with keeping hard-copy for everything. I was buried in paperwork for a short while before I decided to create simple databases/forms using OpenOffice.org, since it was so easy. Someone in management noticed the consistency emerging from my office and inquired. When I told them about my databases, they decided everyone in the department could benefit from them and assigned the project of making this available to all. My problem: My databases are single-user systems for use in OpenOffice.org and would be difficult to roll them out to my entire team. I don't want to install OO.o on everyones computer and I don't want to learn MS Access as it is known for being a temporary solution. So I need something that can keep up with the times and can be rolled out easily (web interface?). I also need to be able to append scanned images to records (PDF or JPEG?). This is all pretty complex and I'm definitely not technically equipped to create this just yet. MySQL?: I believe a good question would be whether or not MySQL would be a good solution for this. What do you think? Also, how long would it take me to learn the necessary information? Lastly, how long would it take to develop such a system? I appreciate your time and information! Thanks, Mike T. Caskey -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query Question
I did try it, and it doesn't work, I was looking for Ideas that will work. Hello, Friday, April 16, 2004, 12:50:21 AM, you wrote: M Is it possible to use a query to select all rows from the table M where Column_Count is greater than Column_TotalCount? M Like this: M SELECT * FROM mytable WHERE Column_Count Column_TotalCount; Perhaps you ought to try it before posting? ;) -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how to rewrite this query without using temporary table
Hi, I have 2 tables.patientrecall_table and appointment_table.The patientrecall_table used to store what is the nextrecall date for the patient while the appointment_tablewill store all the appointments made.Now, I'd like to get through this:"Patients Due for Recall, but No Scheduled Appointment between certain date."In other words, I will need to:select those patients who their next recall date greater thantoday date AND they don't have appointment made between thedate from and date to. Currently, what I did was using the temporary table approach.And it was working fine. create temporary table tmpA(ssn varchar(9) not null);insert into tmpA select ssn from appointment_table where (appdate between '2004-04-15' and '2004-04-30') group by ssn;select a.ssn from patientrecall_table as aleft join tmpA as bon a.ssn=b.ssnwhere a.nrd=current_date and b.ssn is null;drop table tmpA; Is there any other ways that I can use instead of using the temporary table? Please advise. Thank you. //*** mysql desc patientrecall_table;+---++--+-++---+| Field | Type | Null | Key | Default | Extra |+---++--+-++---+| ssn | varchar(9) | | PRI | | || nrd | date | | | -00-00 | |+---++--+-++---+2 rows in set (0.00 sec) mysql desc appointment_table;+-+-+--+-++---+| Field | Type | Null | Key | Default | Extra |+-+-+--+-++---+| appdate | date | | | -00-00 | || ssn | varchar(9) | | | | || remark | varchar(50) | | | | |+-+-+--+-++---+3 rows in set (0.00 sec) Server version: 4.0.18-nt //***
Re[2]: Query Question
Hello, Friday, April 16, 2004, 12:56:32 AM, you wrote: M I did try it, and it doesn't work, I was looking for Ideas that will work. Obviously not, because that's exactly how you do it. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query Question
At 16:56 -0700 4/15/04, MYSQL wrote: I did try it, and it doesn't work, I was looking for Ideas that will work. Looks to me like it should work. Try this and see what you get: SELECT Column_Count, Column_TotalCount, Column_Count ColumnTotalCount FROM mytable; That'll show you what's in the columns, as well as the result of the comparison. Might be instructive. Hello, Friday, April 16, 2004, 12:50:21 AM, you wrote: M Is it possible to use a query to select all rows from the table M where Column_Count is greater than Column_TotalCount? M Like this: M SELECT * FROM mytable WHERE Column_Count Column_TotalCount; Perhaps you ought to try it before posting? ;) -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Query Question
It should work if both columns are numerical. Say int, decimal, float, double and so on. Babs -Ursprüngliche Nachricht- Von: MYSQL [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 16. April 2004 01:50 An: mysql Betreff: Query Question Hi, I am wondering if this is possible: Say I have a table with 2 columns, Column_Count and Column_TotalCount; Is it possible to use a query to select all rows from the table where Column_Count is greater than Column_TotalCount? Like this: SELECT * FROM mytable WHERE Column_Count Column_TotalCount; Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can not get an answer here - how to force the index block size to be the same?
It seems to be either a hard question or stupid question:). Is there anyway in Version 4.1.1 I can force all the indexes to have same block size? Say 2048? If it is plain impossible without changing the source code, please let me know. I really appreciate any help on this. Thanks HT __ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can not get an answer here - how to force the index block size to be the same?
I don't know the answer to your question but I'm curious to know why you would want to do this. Normally, that sort of detail is handled by the database and should not be a consideration for any user of the database. In other words, your queries should work regardless of whether the block sizes for indexes are the same or differ. I would be quite surprised if MySQL - or any decent relational database - gave you a way to control those block sizes. Or is this really a locking question? I'm not sure how MySQL handles the management of index pages and the corresponding data pages that they represent but DB2 (mainframe) gives you some control over whether indexes use full pages or subpages to let you minimize the number of rows locked by a given user. The more subpages you use, the fewer data pages get locked. However, you also tend to need more index space than if you didn't use subpages. Rhino - Original Message - From: Haitao Jiang [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Thursday, April 15, 2004 8:34 PM Subject: Can not get an answer here - how to force the index block size to be the same? It seems to be either a hard question or stupid question:). Is there anyway in Version 4.1.1 I can force all the indexes to have same block size? Say 2048? If it is plain impossible without changing the source code, please let me know. I really appreciate any help on this. Thanks HT __ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can not get an answer here - how to force the index block size to be the same?
At 17:34 -0700 4/15/04, Haitao Jiang wrote: It seems to be either a hard question or stupid question:). Is there anyway in Version 4.1.1 I can force all the indexes to have same block size? Say 2048? If it is plain impossible without changing the source code, please let me know. Why do you care about this? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Server not configured as slave
jim [EMAIL PROTECTED] wrote: Does this machine have a valid server-id? Run show variables like 'server_id' from the mysql monitor. Interesting. The my.cnf says server-id = 75 but the show_variables; command says server_id 0 (zero). Why would that be, and could it be the problem? Where is my.cnf located? Does MySQL server read my.cnf? That was it! In this instance, the my.cnf was in /usr/local/mysql/. Moving it in to data/ fixed the problem, though I don't know why. I thought I was telling the startup script to find the file in mysql/ . Thanks very much to all who helped. Also, is there anything in the *.err file on this machine? Nothing but record of server startups and shutdowns. -Original Message- From: jim To: [EMAIL PROTECTED] Sent: 4/14/04 3:26 PM Subject: Server not configured as slave Hi, Can anyone suggest some troubleshooting tips when setting up a slave and getting the error: ERROR 1200: The server is not configured as slave, fix in config file or with CHANGE MASTER TO ? The master is already running with other slaves. I have granted permission and copied the relevant config file information from the other slaves to the new slave. -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
repeated/duplicated query problem
Hello fellow listoers, Long time reader first time poster. :P I just recently installed a MySQL server to back-end a mail system (PHP webmail, SMTP, and IMAP servers). Everything is working pretty well, but I have a reallt odd problem I can't difure out. I've asked a few times in #Mysql on freenode.net and noone has seen it before; hoepfully someone here can help me troubleshoot it or fix it. First some info: Pentium 4 3.20 GHz w/HT (2 logical CPUs) 1GB RAM FreeBSD 4.9 MySQL 4.0.18 (via ports) When I was setting up the whitelist/blacklist stuff in webmail, I noticed it was adding two records for every one entry on the list (when I added [EMAIL PROTECTED], two would be put in the db). Deleting them also removed two, so I didn't notice at first. After screwing up some things and discovering a huge table with lots of duplicates, I started watching the logs. After spending probably hours playing with loops and other PHP things I noticed that, at the end of each script I ran, the last (and only the last) query got repeated. If I was adding a user to the whitelist, the final INSERT query was sent/processed two times. I hacked around this (had to get it up and running :( sigh) by adding a null 'SELECT '' from table... query, which was sone twice. Since this was the last query, the real queries were only done once, so its a patch but not a fix. I watched as I checked with my IMAP clients (Mozilla and PHP) and the password SELECT query was repeated. I watched as I sent myself some email and some of the queries from the SMTP server were repeated. Luckily these are all SELECTs; I do any INSERTs, UPDATEs, and MODIFYs manually right now, except for spam settings mentioned above, but this will change in the future. Basically I'm saying it isn't a PHP issue, or a script looping issue, and seems to me like a MySQL (and/or FreeBSD) issue. I guess it could be a client issue, but it's odd that every application accessing the server has the same problem. Maybe a FreeBSD MySQL client/library port problem. Based on talks in #mysql, I watched the logs when using the mysql client (both localhost socket file and over TCP like the other servers), and mysql only ran the commands once -- no duplications. I'm pretty stumped as to what the problem is and what to do about it, or even how to diagnose the problem. I'm not sure if it duplicates the last query on a per-connection basis, or something else...but it only duplicated the last query in the PHP scripts (probably on a per-connection basis). Thanks, Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
how to rewrite this query without using temporary table
Lorenzo, Try this: select P.ssn from patientrecall_table as P left join appointment_table as A on P.ssn = A.ssn and appdate between '2004-04-15' and '2004-04-30' where P.nrd = current_date and A.ssn is null Before applying the where clause, the left join will have - a row for each appointment in the given range - a row for each patient who doesn't have an appointment Then the where clause throws away the ones with appointments. regards, Bill From: lorenzo.kh [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: how to rewrite this query without using temporary table Date: Thu, 15 Apr 2004 12:03:04 +0800 I have 2 tables. patientrecall_table and appointment_table. The patientrecall_table used to store what is the next recall date for the patient while the appointment_table will store all the appointments made. Now, I'd like to get through this: Patients Due for Recall, but No Scheduled Appointment between certain = date. In other words, I will need to: select those patients who their next recall date greater than today date AND they don't have appointment made between the date from and date to. Currently, what I did was using the temporary table approach.And it was = working fine. create temporary table tmpA(ssn varchar(9) not null); insert into tmpA select ssn from appointment_table=20 where (appdate between '2004-04-15' and '2004-04-30') group by ssn; select a.ssn from patientrecall_table as a left join tmpA as b on a.ssn=3Db.ssn where a.nrd=3Dcurrent_date and b.ssn is null; drop table tmpA; Is there any other ways that I can use instead of using the temporary = table? Please advise. Thank you. //*** mysql desc patientrecall_table; +---++--+-++---+ | Field | Type | Null | Key | Default| Extra | +---++--+-++---+ | ssn | varchar(9) | | PRI || | | nrd | date | | | -00-00 | | +---++--+-++---+ 2 rows in set (0.00 sec) mysql desc appointment_table; +-+-+--+-++---+ | Field | Type| Null | Key | Default| Extra | +-+-+--+-++---+ | appdate | date| | | -00-00 | | | ssn | varchar(9) | | || | | remark | varchar(50) | | || | +-+-+--+-++---+ 3 rows in set (0.00 sec) Server version: 4.0.18-nt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can not get an answer here - how to force the index block size to be the same?
Paul Because I want to use the load index into cache... to pre-load the indexes into cache. But I can not use this feature since the block size of indexes are different (1024 vs. 2048), and the load index into cache.. complains about it. Any idea? Thanks a lot! Haitao --- Paul DuBois [EMAIL PROTECTED] wrote: At 17:34 -0700 4/15/04, Haitao Jiang wrote: It seems to be either a hard question or stupid question:). Is there anyway in Version 4.1.1 I can force all the indexes to have same block size? Say 2048? If it is plain impossible without changing the source code, please let me know. Why do you care about this? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com __ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can not get an answer here - how to force the index block size to be the same?
Because if you want to pre-load indexes into cache, you need to have same block size for all indexes of a table. --- Rhino [EMAIL PROTECTED] wrote: I don't know the answer to your question but I'm curious to know why you would want to do this. Normally, that sort of detail is handled by the database and should not be a consideration for any user of the database. In other words, your queries should work regardless of whether the block sizes for indexes are the same or differ. I would be quite surprised if MySQL - or any decent relational database - gave you a way to control those block sizes. Or is this really a locking question? I'm not sure how MySQL handles the management of index pages and the corresponding data pages that they represent but DB2 (mainframe) gives you some control over whether indexes use full pages or subpages to let you minimize the number of rows locked by a given user. The more subpages you use, the fewer data pages get locked. However, you also tend to need more index space than if you didn't use subpages. Rhino - Original Message - From: Haitao Jiang [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Thursday, April 15, 2004 8:34 PM Subject: Can not get an answer here - how to force the index block size to be the same? It seems to be either a hard question or stupid question:). Is there anyway in Version 4.1.1 I can force all the indexes to have same block size? Say 2048? If it is plain impossible without changing the source code, please let me know. I really appreciate any help on this. Thanks HT __ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
help! recover from running mysql_fix_privilege_tables on mysql4.0
While trying to fix some problems with the user access privileges on mysql4.0 alpha, I run the mysql_fix_privilege_tables script. http://dev.mysql.com/doc/mysql/en/Upgrading-grant-tables.html As the result, I can't get to the database, even using the root login. I tried to recover root password using the information in the following page without luck http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html Any help is very appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Slightly OT: MySQL + PHP and escaping data to output to a web page
Hi all. Yes I know this is a little off-topic, but also a little on-topic... I have a user who likes to use the 'less than' sign ( ) in notes he enters into the DB. When I print them out to a web page, they are interpreted as an HTML code and everything after them '' is not printed. I'm currently using: replace(replace(NoteText, '', '#060'), '', '#062') as NoteText to replace the offending characters with HTML escape codes. Is there a cleaner way of doing this? Thanks! Dan -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PHP + MySQL Not Playing Nice Any More
So I'm using PHP and MySQL to serve up a game and all is going well until today. The first problem came when for some reason the game was sending apache as the username to access the db (which is not what I have in the dbconnect file) and output some errors. I checked the page it was complaining about and all was good so I use phpmyadmin to login and admin my db but now even phpmyadmin won't let me in and I know I haven't touched the config file since I first set it up. Does MySQL do this very often or is it a PHP error and not a MySQL one and if this is a PHP error where do I look to fix it? -- Joseph A. Nagy, Jr. http://joseph-a-nagy-jr.homelinux.org Political Activist Extraordinaire Peace, Life, Liberty The only fallacy is the inaction on our part to stave off the worst of horrors, the stripping of personal freedom. -- Joseph A. Nagy, Jr. January 2004 pgp0.pgp Description: PGP signature
Re: Locking tables
Did I really ask that tough a question? Anyone? On 4/15/04 7:38 PM, Mark Susol | Ultimate Creative Media [EMAIL PROTECTED] wrote: I've found a nice shell script to use to backup my server's MySQL databases. https://sourceforge.net/projects/automysqlbackup/ However, when I tried this earlier today it resulted in a corrupt table. Now the table in question is one I've had issues with for other reasons, but it has over 2 mil records in it when only partially built. What I need to do is put a lock on the database/tables before the script is run. The script allows for a pre post shell script to run. So what do I need to do before running any backup scripts to ensure the tables will not be corrupted during any kind of shell operation? Do I have to stop services like mysqld or httpd before hand? Does anyone use MySQL 4.0.18 and the hot copy instead? I'm using 4.0.17-max Mark Súsol --- u l t i m a t e CreativeMedia Web | Print | CD Media | eCommerce www.ultimatecreativemedia.com Ph: 301-668-0588 Mark Súsol --- u l t i m a t e CreativeMedia Web | Print | CD Media | eCommerce www.ultimatecreativemedia.com Ph: 301-668-0588 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP + MySQL Not Playing Nice Any More
On 4/15/04 11:46 PM, Joseph A. Nagy, Jr. [EMAIL PROTECTED] wrote: So I'm using PHP and MySQL to serve up a game and all is going well until today. The first problem came when for some reason the game was sending apache as the username to access the db (which is not what I have in the dbconnect file) and output some errors. I checked the page it was complaining about and all was good so I use phpmyadmin to login and admin my db but now even phpmyadmin won't let me in and I know I haven't touched the config file since I first set it up. Does MySQL do this very often or is it a PHP error and not a MySQL one and if this is a PHP error where do I look to fix it? This seems more like a change was made in your hosting environment, unrelated to php or mysql. I've seen this happen when sites were moved into safe moded environments. Mark Súsol --- u l t i m a t e CreativeMedia Web | Print | CD Media | eCommerce www.ultimatecreativemedia.com Ph: 301-668-0588 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Slightly OT: MySQL + PHP and escaping data to output to a web page
On 4/15/04 11:49 PM, Daniel Kasak [EMAIL PROTECTED] wrote: I'm currently using: replace(replace(NoteText, '', '#060'), '', '#062') as NoteText to replace the offending characters with HTML escape codes. Is there a cleaner way of doing this? You can try the php command: htmlspecialchars($NoteText, ENT_NOQUOTES); ref: http://us3.php.net/htmlspecialchars Best place for php questions is www.sitepoint.com Mark Súsol --- u l t i m a t e CreativeMedia Web | Print | CD Media | eCommerce www.ultimatecreativemedia.com Ph: 301-668-0588 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Slightly OT: MySQL + PHP and escaping data to output to a web page
Mark Susol | Ultimate Creative Media wrote: On 4/15/04 11:49 PM, Daniel Kasak [EMAIL PROTECTED] wrote: I'm currently using: replace(replace(NoteText, '', '#060'), '', '#062') as NoteText to replace the offending characters with HTML escape codes. Is there a cleaner way of doing this? You can try the php command: htmlspecialchars($NoteText, ENT_NOQUOTES); ref: http://us3.php.net/htmlspecialchars Best place for php questions is www.sitepoint.com Coool. Thanks! I'll check out sitepoint as well. Dan -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]