Help with join in query
I have the following query. select sum(a.attendhours), s.attendhours from attendance a, attsum s where a.siteid = s.siteid and a.assignmentid = s.assignmentid and a.attenddate = s.attenddate and a.siteid = 'XXX' and a.attenddate = '-XX-XX' group by a.assignmentid, a.attenddate; I want it to return those values where sum(a.attendhours) does not equal s.attendhours. What more do I need to add to my query to accomplish this? Thanks in Advance Scott Pippin [EMAIL PROTECTED]
Re: Crystal Reports MySQL
I haven't tested it but I am using version 10 with no problems. See the announcement made by business objects at the MySQL users conference: http://www.mysql.com/news-and-events/press-release/release_2005_10.html I hope this helps. Scott Pippin [EMAIL PROTECTED] Kerry Frater [EMAIL PROTECTED] 04/28/05 6:09 AM I have MySQL the downloaded ODBC drivers. I am looking to use Crystal Reports to design run my own reports on my tables. Can anyone tell me if the V11 Standard will happily work with MySQL or do I need a different version? Kerry
RE: Crystal Reports MySQL
Should be. You should be able to download a trial and try it out. Kerry Frater [EMAIL PROTECTED] 04/28/05 3:26 PM Thanks for the reply Scott. I found the press release interesting. I have V9 Dev version and need runtime version for another site. I can buy V11 but wasn't sure if the STD version was enough to set a report and run it with MySQL. Kerry -Original Message- From: Scott Pippin [mailto:[EMAIL PROTECTED] Sent: 28 April 2005 15:11 To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: Crystal Reports MySQL I haven't tested it but I am using version 10 with no problems. See the announcement made by business objects at the MySQL users conference: http://www.mysql.com/news-and-events/press-release/release_2005_10.html I hope this helps. Scott Pippin [EMAIL PROTECTED] Kerry Frater [EMAIL PROTECTED] 04/28/05 6:09 AM I have MySQL the downloaded ODBC drivers. I am looking to use Crystal Reports to design run my own reports on my tables. Can anyone tell me if the V11 Standard will happily work with MySQL or do I need a different version? Kerry
32 bit vs. 64 bit
What knid of performance difference can I expect between 2 xeon 3ghz 32bit compared with 2 IBM Power5 64bit processors if memeory and everything else is the same? Thanks, Scott Pippin [EMAIL PROTECTED]
Re: MySQL 100% CPU Spikes
Any information on how I can go about doing this, or maybe some documentation on improving the speed. The problem is two of the databases I think, both are around 1.1MB each and: Try putting an explain before your select statement: http://dev.mysql.com/doc/mysql/en/EXPLAIN.html this will show you if it is your query that is causing the problem. Database1: 13736 data records Database2: 77312 data records. Is this excessive ? Not even close. We currently have a database of 4 gb and 75 tables. One of our tables has over 2 million rows. Even this is small as compared to some of the other databases I have seen. Hope this helps. Scott Pippin [EMAIL PROTECTED]
connectorJ and upgrade to MySQL 4.1
MySQL 4.1.1 Connector/j 3.1 nightly - 20040212 I recently upgraded to MySQL 4.1 and am trying to get connector/J to work. I downloaded the 3.1 nithly build from 20040212 and start mysql 4.1 with the --old-passwords option. I also ran mysql_fix_privilege_tables option. MyODBC does work with the --old-passwords option. I get the following error when I try to access the database: [2/12/04 8:45:06:611 MST] 696f4a0d SystemOut O java.sql.SQLException: Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream ** BEGIN NESTED EXCEPTION ** java.io.IOException MESSAGE: Unexpected end of input stream STACKTRACE: java.io.IOException: Unexpected end of input stream at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1096) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:626) at com.mysql.jdbc.Connection.createNewIO(Connection.java:1562) at com.mysql.jdbc.Connection.init(Connection.java:491) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346) at java.sql.DriverManager.getConnection(DriverManager.java:538) at java.sql.DriverManager.getConnection(DriverManager.java:188) at com.mtc.sys.Scusers.init(Scusers.java:84) at com.mtc.ims.ed.servlet.AcadStatusServlet.service(AcadStatusServlet.java:146) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174) at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313) at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116) at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283) at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42) at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:974) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:555) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200) at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119) at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276) at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71) at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:182) at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334) at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56) at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618) at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593) ** END NESTED EXCEPTION ** Scott Pippin [EMAIL PROTECTED]
Re: Creating Innodb Database
In the MySQLdocumentation, it does not clearly explains how a Tablespace is created. Under Creating a Tablespace heading ( 14.4.4), it says how a Innodb database is created but not tablespace. Also how exactly you create an Innodb Database. Well it says in the documentation that when you enter the cmd mysqld it creates an Innodb Database, what if I want to have more than one Innodb Database within a server. Do I have to run multiple instances of mysqld. Can someone help here? Add the following to your config file - Note: this is for 4.0.x - not sure if 4.1.1 is different. # Uncomment the following if you are using Innobase tables innodb_data_home_dir=/usr/local/mysql/libdata innodb_data_file_path=libdata1:1000M;libdata2:1000M;libdata3:1000M innodb_log_group_home_dir = /usr/local/mysql/innologs innodb_log_arch_dir = /usr/local/mysql/innologs set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=5M innodb_flush_log_at_trx_commit=2 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=200M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=120 This will create 3 files where the innodb tables will be put. With 4.0.x and before you can not assign tables to a particular file(tablespace). You can do this with 4.1 however. You can create as many databases as you need since it is the table that are InnoDB and not the database itself. I hope this helps. Soctt Pippin [EMAIL PROTECTED]
RE: Installing MySQL on Linux, HELP!
I was going to output a new list of installed packages to ensure that mysql was in there, but rpm -qa | ./installed_packages doesn't seem to work at the moment...I can't restart the server right now, so perhaps I could kill and restart some process? However, this is from yesterday's output: The RPM database can become corrupted, causing the rpm -qa to hang. To rebuild the database follow the following instructions: ps -ef |grep rpm - kill all rpm processes rm -rf /var/lib/rpm/__db* rpm --rebuild You should then be able to query the rpms. Scott Pippin [EMAIL PROTECTED]
Re: Question about MySQL and Oracle.
It depends a lot on the features that are needed. Right now we use mySQL for some things and Orcale for others. The vibes I have seen from both Oracle and MySQL is that for right now MySQL is a complementary product to Oracle. Soon I think MySQL will be right up there with Oracle. Check the following link to see a databse comparison done by eweek magazine. I hope this helps. http://www.eweek.com/article2/0,4149,1184846,00.asp Scott Pippin [EMAIL PROTECTED]
MySQL and shared storage
I would like to set up a round robin cluster with mysql. The round robin would be done through the DNS to two different servers. Each of those servers would have mysql installed and each would reference the same data directory on our SAN. Are there any problems with doing this? Thanks in advance Scott Pippin [EMAIL PROTECTED]
Re: my.cnf is not available under windows 2000
Morten Gulbrandsen [EMAIL PROTECTED] 08/01/03 07:22AM Hi programmers, according to the manual, There are two option files with the same function: `C:\my.cnf', and the `my.ini' file in the Windows directory. Is it sufficient with only one of the files ? I have only my.ini For which purpose is my.cnf , please? It is my understanding that it looks for either file. As long as you have one file you should be ok. Scott Pippin [EMAIL PROTECTED]
mysqlcc not coming up in Windows XP
I am trying to run MySQLcc(0.9.2) on Windows XP. When I try to bring it up I get an hourglass for a second, then nothing happens. Has anyone had similar issues or any ideas as to what could cause this? Thanks (mysql, query) Scott Pippin [EMAIL PROTECTED]
Re: MySQL memory problem on AIX 4.3.2
Try putting the following before the mysqld call but before your ulimit calls - export LDR_CNTRL='MAXDATA=0x8000' Also try setting ulimit -m unlimited and ulimit -s unlimited. Hopefully this helps. Scott Pippin [EMAIL PROTECTED]
Re: MySQL CC question
Where do you change the default LIMIT value for queries. I am using 0.9.1-beta. right click on the server name and click on edit. Click on the MySQL Options tab. Scott Pippin [EMAIL PROTECTED]
Red Hat ES 2.1 and MySQL
I am about to install Red Hat Enterprise Server 2.1. I would like to put MySQL on it. I was wondering if there were any Red Hat settings I should be aware of as I install the OS. Thanks, Scott Pippin [EMAIL PROTECTED]
Re: MySql Install on a AIX RS6000
I am trying to install on a AIX box. I do not want to install into /usr/local. I have put everything in /sybase/mysql/mysql. I am running into Set up a symbolic link from usr/local/mysql to the directory where your files are stored. Let me know if you need any more help. Scott Pippin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Applications for creating reports for MySQL
Does anyone know a program for Windows that can create reports for MySQL databases? Check out Crystal Reports http://www.crystaldecisions.com or ReportMill http://www.reportmill.com hope these help. We use Crystal Reports. If you have any questions about crystal please let me know. (query, sql) Scott Pippin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: copying innodb data
I need to move my database from a WindowsNT environment to a Linux RedHat7.0 Box. I am now using innodb tables. Is there any easy way of copying my existing tables in NT Box to Linux? Download MySQLFront from: http://mysqlfront.sstienemann.de/ Install it on your windows machine and log in to the MySQL server on your windows machine. Then open another window and log in to your linux box in MySQLFront. Click on the Import/Export option and select Export tables. Select the Another Host/Db option. I hope this works, let me know if you have any other problems. Scott Pippin [EMAIL PROTECTED] (sql, query, mysql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: copying innodb data
Hello folks I need to move my database from a WindowsNT environment to a Linux RedHat7.0 Box. I am now using innodb tables. Is there any easy way of copying my existing tables in NT Box to Linux? 1. Download MysqlFront from http://mysqlfront.sstienemann.de/ 2. Install on Windows machine. Open a connection window to both your windows MySQL server and your Linux MySQL server. 3. Click on the import/export menu and select export tables. 4. click on the Another Host/db option and select you Linux MySQL Server, then copy the tables over. This worked a lot better for me than mysqldump. The larger tables seemed to transfer faster than with mysqldump. Let me know if you have any other questions. Scott Pippin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: simple windows client for mysql
I am looking for an easy to use, easy to install mysql client which would enable users to query my database. It seems that installing mysql server for windows on each machine would do this but it seems like using a shovel to swat a fly. Suggestions? Cheap is good too. Try SQlyog http://www.webyog.com/ or MySQL-Front - very good but no longer being developed http://mysqlfront.sstienemann.de/ Both of these are free. Hope that helps. Scott Pippin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Version 4 safe to use?
Are many people using MySQL version 4 yet? I'm interested in it because I want to use it's SSL capabilities but would like to hear that people are not having trouble with it first. We have been using 4.0.x for about five months now on a production system and have had no problems. Scott Pippin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Using Crystal Reports with MySQL
I'm having trouble getting the two to work, when I try to connect to the database in Crystal I get an error message saying ODBC Error: [TCX][MyODBC} Could not read table names It is worth a try. Here are the instructions for the registry fix. Download odbcregs.zip from Crystal Decisions. http://support.crystaldecisions.com/communityCS/FilesAndUpdates/odbcregs.zip.asp 1. Open the zip file and extract the files to WINNT/System32 or Windows/System32 for XP. NOTE: If any of the files are newer on your machine do not replace them. 2. run the outjoin.reg file. 3. run regedit and go to HKEY_CURRENT_USER Software Seagate Software Crystal Reports DatabaseOptions Outer Join and click on SQL2OuterJoin and add MYODBC3(If you are using the 3.x MyODBC Driver) or to the end of the DataValue list. Crystal need to be told what the join syntax is for the particular database you are using. This fix will work with any Crystal Reports 8.x; I'm not sure if it will work with 9.x or not. If you are still having problems after doing this let me know and I can try to help you track it down. NOTE: I'll send the file to you in a separate email. I wanted to put the fix instructions on the list for others to access if needed. Scott Pippin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: subselect workaround help?
Student | Class -- Steve Lefevre | Math101 Stacy Adams | Intro to SQL Something like SELECT Student.Name, Classes.Name FROM Students, Classes WHERE Students.StudentID = . $ID . AND Classes.Name IN ( SELECT Classes.Name FROM Classes WHERE ClassID = Students.ClassID ) Try SELECT Student.Name, Classes.Name FROM Students, Classes WHERE Students.ClassID = Classes.ClassID. If you only wnat it for one syudent do: SELECT Student.Name, Classes.Name FROM Students, Classes WHERE Students.ClassID = Classes.ClassID AND Students.StudentID = 'some ID' Hope this helps. Scott Pippin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrade to MySQL 4.0.x
I have a few questions about whether or not I should upgrade to MySQL 4.0.7-Gamma on my Windows XP system. I am now running MySQL 3.23.54a on my Laptop. Its used for developing/testing, and the applications needs to be transported to the final server after completion. Most of the time however the server is a 3.23.x and not 4.0.x. Is 4.0.x backwards compatible? Can I tranfer my databases without problems from my current MySQL 3.23.54 database to MySQL 4.0.x.? And is MySQL 4.0.7-gamma coonsiderd stable? Yes and Yes. There shouldn't be a problem with porting data from one version to another. The only true way I guess would be to test it. We have been using the 4.0.6 on our production machine since it came out and have had no problems. Also I would like to know how-to upgrade, can I just instal over my excisting MySQL installation? You should be able to just install over the top without any problems. Backup tour data directory to a different directory though to play it safe. Scott Pippin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: seagate crystal reports with mysql
Yes you can. There are a few changes you have to make to the registry to get it to work. Let me know off list if you need any more help. We use mysql as our databse and Crystal Reports as our reporting engine. Scott Pippin [EMAIL PROTECTED] geeta varu [EMAIL PROTECTED] 12/28/02 03:16AM can i create reports using seagate crystal reports with mySQL as backend. regards, gj __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Starting of MySQL with redhat 8
I'm a beginner with mysql and i installed it with linux. I'm getting this message when i tried to be connected : Error 2002 : can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111). Can you help me by finding how to be connected to the database ? Make sure the files does exist in the directorey listed above. If it does not, make sure you have socket=directory location in your config file. (mysql, query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Join help.
Is there a good tutorial somewhere on the join command. No matter what I do it just doesn't work. Obviously I'm doing something wrong, but the MySQL manual just doesn't help at all. Try this link. http://www.devshed.com/Server_Side/MySQL/Join/page1.html One of the best books for understanding how joins work is SQL for Dummies It was a combination of the article and the book that helped me understand joins and how to use them with MySQL. (mysql, query) I hope that helps. Scott Pippin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Trying to install DBI
I get the following error when trying to do a 'make' after doing a perl Makefile.PL to DBI 1.1.8 cc -c -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -O -DVERSION=\1.18\ -DXS_VERSION=\1.18\ -I/usr/opt/perl5/lib/5.00503/aix/ CORE -DDBI_NO_THREADS Perl.c /bin/sh: cc: not found. make: 1254-004 The error code from the last command is 127. Any suggestions would be greatly appreciated. Thanks (mysql, query) Scott Pippin [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: The dreaded move from Oracle to MySQL
Scott Pippin [EMAIL PROTECTED] Wesley Brown [EMAIL PROTECTED] 11/20/02 11:24AM Well, This is my first attempt at moving from Oracle to MySQL on such a large scale and so far it isn't going well at all. We are running oracle 7.3.4.0.1 and MySQL 4.0.4-0 standard. We are moving 101 tables with a total of 45 millon records over. I have tried several diffrent methods including using a MS-SQL server to act as go between using DTS services. We have run into two problems, one, we don't get all the data over we loose rows and the like. Two it is super slow on the order of 18 to 30 hours to do a pull. We need a way to move the data in a resonable amount of time around 8 hours is the goal. Things I have tried so far include using MS-SQL as a go between fast but with data loss, using a custom ADO application to move the data and handle any transforms we get the data but it REAL slow, and trying to get the oracledump.pl perl script to run with no success. If anyone has had a chance to do this type of migration please point me in the right direction. I would really hate to stay with Oracle for the only reason that we can't get the data off of it and on to another box :) Thanks, Wes Oracle has an export utility. Did you try that? We ran in to the same problems exporting our data from oracle to mysql. We used PowerBuilder(it has a data-pipeline feature under its database menu). This allowed us to connect through ODBC and create the table then import the data. Unfortunately we had to do this for each table. I hope this gives you a few more ideas. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql JDBC
What version of MySQL JDBC are you using? Scott Pippin [EMAIL PROTECTED] jsplist [EMAIL PROTECTED] 11/16/02 12:13PM Hello ! , Im running Tomcat on a Windows machine and Ive got my CLASSPATH pointing to c:\tomcat\lib\mysql.jar . Then in my webapps folder I have a web application class Im trying to run to load the driver... This is the top of my code that makes the connection... import java.sql.*; public class CreateTable { public static void main(String args[]) { Connection con = null; try { Class.forName(org.gjt.mm.mysql.Driver).newInstance(); I compile the code fine but when I run java CreateTable I get the following error... Exception in thread main java.lang.NoClassDefFoundError: CreateTable The CLASSPATH is pointing to the right spot so thats not the issue I dont understand whats going on heelp Thanks alot wiley What version of the JDBC Driver are you using? (mysql, query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installation Help
Scott Pippin [EMAIL PROTECTED] Phil Iovino [EMAIL PROTECTED] 11/12/02 08:13AM I'm trying to install MySQL under RedHat 8. I installed the MySQL 3.23.53a-1 and MySQL-client 3.23.53a-1 RPMs. Per the instructions at http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.htm l#Post-installation, I started the server with /usr/bin/safe_mysqld and it appears to have started. When I try to test it, I get this: [root@web01 bin]# mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' I'm kinda stuck. Any ideas? Did you set up root as a user? If you did, try /usr/bin/safe_mysqld -u root If not set up a user. http://www.mysql.com/doc/en/Adding_users.html hope this helps. (sql, mysql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Installation Help
Did you set up root as a user inside of MYSQL? Eventhough root has permission it must be set up as a user inside of MySQL. Phil Iovino [EMAIL PROTECTED] 11/12/02 09:13AM I believe root has all permissions. I'm using Webmin to verify it. I started it with -u root but still got the same error. Since I installed with the RPM didn't it give root permission? -Original Message- From: Scott Pippin [mailto:spippin;mtctrains.com] Sent: Tuesday, November 12, 2002 10:43 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Installation Help Scott Pippin [EMAIL PROTECTED] Phil Iovino [EMAIL PROTECTED] 11/12/02 08:13AM I'm trying to install MySQL under RedHat 8. I installed the MySQL 3.23.53a-1 and MySQL-client 3.23.53a-1 RPMs. Per the instructions at http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.ht m l#Post-installation, I started the server with /usr/bin/safe_mysqld and it appears to have started. When I try to test it, I get this: [root@web01 bin]# mysqladmin version mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' I'm kinda stuck. Any ideas? Did you set up root as a user? If you did, try /usr/bin/safe_mysqld -u root If not set up a user. http://www.mysql.com/doc/en/Adding_users.html hope this helps. (sql, mysql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Backup DB
There are two ways to do backups. 1. Backup the files themselves. 2. Use mysqldump to dump the data into a text file which can be read in by MySQL. http://www.mysql.com/doc/en/mysqldump.html We have a database of about 300M it takes 2-3 minutes to do a complete mysqldump of the data. I would recommend, though, saving your larger tables to a separate file to make the import(if you ever need to do it) go faster. Scott Pippin [EMAIL PROTECTED] GAY Samuel [EMAIL PROTECTED] 10/30/02 12:21AM Hi, Shut your database down, backup all files, and restart it If you use InnoDB you can do a hot backup like Oracle (the implementation of InnoDB is near of Oracle), but it's not free. I can't say more about this, but it's in the documentation about InnoDB. You can also keep a differential between two backup (in case the last backup is corrupted) using binary log of MySQL (use --log-bin at startup). I just begin to test it... To do a backup of all you database(s) you can use mysqldump. The dump contains create datase, table, ... and insert ... orders. Being beginner, I'm also interested about backup stuff, I hope somebody will complete my post. Sam. -Message d'origine- De : Amol Sonaikar [mailto:amol;kenati.com] EnvoyT : mercredi 30 octobre 2002 06:27 + : [EMAIL PROTECTED] Objet : Backup DB HI All I am new to mysql. We have a small application which runs on mysql db. We want to backup the database for mysql. What is the easiest method to that ? Do we have to move datafiles or import export like oracle ? If you can send me a specific link or article for backup and recovery for mysql , I'll be very much thankful. Thanks Amol Oracle 8i DBA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Backup InnoDB
The info for mysqldump is at: http://www.mysql.com/doc/en/mysqldump.html We have a databse of about 300M it takes 2-3 minutes to do a complete mysqldump of the data. I would recommend, though, saving your larger tables to a separate file to make the import(if you ever need to do it) go faster. Scott Pippin [EMAIL PROTECTED] Kees Hoekzema [EMAIL PROTECTED] 10/30/02 10:57AM Hey, Use mysqldump. See the manual / cli help for how to do it :0 -kees -Original Message- From: Silmara [mailto:silmara.sami;uol.com.br] Sent: Wednesday, October 30, 2002 5:39 PM To: [EMAIL PROTECTED] Subject: Backup InnoDB How can I do backup of only one DataBase? And How can I do recovery the data? I'm working with MySQL ( InnoDB) and I have three DataBase in my TableSpace. But I would like doing backup of only one. regards, Sil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Web server
Search the MySQL list, http://lists.mysql.com/php/search.php for ram needed, there are some pretty good references there as to what the footprint of MySQL is. Simon Green [EMAIL PROTECTED] 10/22/02 02:59AM Hi I am putting together a MySQL server for the ISP I work for. We are going to provide a mysqld for each web user. I plan on using mysqld_multi for this. But what I can not work out is how much CPU and memory I will need for each user. As this is a generic system all I need is a average system! If any one can point me to where I can find this out please. Thanks Simon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: unique
Make sure it is not part of a primary key. Use a front-end like MyCC(http://www.mysql.com/downloads/gui-mycc.html) or SQLyog(http://www.webyog.com/sqlyog/download.html) (query, mysql) Scott Pippin Ciprian I. Acatrinei [EMAIL PROTECTED] 10/22/02 08:25AM Hi, I am having a hard time removing the unique property from a field... I set up a field as unique now I need to allow multiple values in that field. How do I take out the unique property of that field... PS: I couldn't figure it out from http://www.mysql.com/doc/en/ALTER_TABLE.html Thank you, Cip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL with InnoDb Tables - A Big Confusion
change your my.cnf to use the following variables:(I left our info in them for reference) innodb_data_file_path = ibdata1:400M innodb_data_home_dir = c:\ibdata innodb_log_group_home_dir = c:\iblogs innodb_log_arch_dir = c:\iblogs also make sure the MySQL my.cnf is place in the /etc directory in UNIX or the Windows-system-directory in Windows. The INNodb from what I understand should be set up to run as a global option and not a server-specific option, that is why you should put it in one of the directories above. Scott Pippin Shomal Bafna [EMAIL PROTECTED] 10/21/02 08:46AM Sorry, I know this question would best suit for [EMAIL PROTECTED] but there is over limit problem. E-mail Account: lists-mysql is over the limit of 31457280 bytes. I am running a Mandrake Linux 8.1, with an rpm installed ver 3.23.41. Unfortunately configuring the MySQL for InnoDb for me turned into an intriguing problem. I installed the MySQL-Max 3.23.41 version. And tried to follow instructions but mysql would start if i create an my.cnf (by default this file is missing from installation) [mysqld] innodb_data_home_dir = innodb_data_file_path = /innodb-data/ But on starting the deamon it wouldn't start. Perplexed and trying to trouble shoot where the problem i remarked the entries and mysqld ran. But 'show variables like have_%' displayed BDB=YES and InnoDB=DISABLED. How to turn around this problem? Waiting for suggestions. Shomal = shomal __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ - Before posting, please check: http://www.mysql.com/doc/ (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail java-unsubscribe-##L=##[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/doc/ (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Crystal Reports MySQL
We use Crystal and it is great. It is especially good for the more complicated reports. Webmaster MBTRADINGCO [EMAIL PROTECTED] 10/15/02 11:45PM Hi, does anyone knows if Crystal reports is a good reporter to make reports out of MySQL, or does anyone knows a good reporter for PHP MySQL? Thanks The Vampmaster - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
copy one database to another
I have one database(test) i would like to copy over to (test1). Ehat is the syntax to do this? Is there any to just change the name of the database? Thanks in advance (query, mysql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDb data file path
I am trying to set up two data files in case the first one fills up. I tried to use the following in my.cnf but it says there is an error. If I take out the reference to the second data file everything works AIX 4.3.3 MySQL 4.0.4 innodb_data_file_path=libdata1:100M:autoextend:max:2000M;libdata2:100M:autoextend:max:2000M Any help would be greatly appreciated. (query, Mysql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: startup on win2000 as service not working.
I had the same problem happen to me. Go in to services and right-click on the mysql service and check the properties. Check that the service is assigned to the right executable. Mine was not so I had to start it manually every time I restarted. Steve Bradwell [EMAIL PROTECTED] 10/08/02 07:14AM Hi everyone, I have recently moved my mysql server from a win98 machine to a win2000 machine. After running the self extracting setup for mysql, I copied my existing my.ini file over from the win 98 box, made neccesary changes to start mysqld-max-nt from correct dir, I copied the my.ini file because of the Innodb settings I had setup on the win98 machine. I then copied over my Ibdata, and IbLogs directories and their contents to the win2000 box, and the replaced the data directory with the one from the 98 box. I then started mysql from the command prompt with mysqld-max-nt --console it said ...Innodb: Flushing modified pages from the buffer pool... Innodb: Started Ready for connections... And all works fine, however when I restarted the pc, and winmysqladmin.exe was started as a service, the server is not started, I get the red light and no server, or table information. If I then go and start it through the console and run winmysqladmin.exe All my information appears like normal. Can anyone suggest what I should do? Thanks alot, Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: startup on win2000 as service not working.
I had the same thing happen to me. Go in to services and right-click on the mysql service. Go to properties and verify that the service is assigned to the right executable. Mine was not so I had to start MySQL manually every time I restarted. (MySQL, query) Steve Bradwell [EMAIL PROTECTED] 10/08/02 07:14AM Hi everyone, I have recently moved my mysql server from a win98 machine to a win2000 machine. After running the self extracting setup for mysql, I copied my existing my.ini file over from the win 98 box, made neccesary changes to start mysqld-max-nt from correct dir, I copied the my.ini file because of the Innodb settings I had setup on the win98 machine. I then copied over my Ibdata, and IbLogs directories and their contents to the win2000 box, and the replaced the data directory with the one from the 98 box. I then started mysql from the command prompt with mysqld-max-nt --console it said ...Innodb: Flushing modified pages from the buffer pool... Innodb: Started Ready for connections... And all works fine, however when I restarted the pc, and winmysqladmin.exe was started as a service, the server is not started, I get the red light and no server, or table information. If I then go and start it through the console and run winmysqladmin.exe All my information appears like normal. Can anyone suggest what I should do? Thanks alot, Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to install INNODb in Windows 2000 server
If you want to stay with 3.23 then download the max version. Install the max version. Look at one of the .cnf files in the main mysql directory. Uncomment the lines having to do with innodb. Change the innodb_data_home_dir variable to be the path you want d:\mysql for instance. When you are done with the .cnf file rename it to my.cnf and put it in c:\mysql\data. Restart the server and you should be able to set up innodb tables. NOTE: I am currently using 4.0.4 pro and it loads up with Innodb by default. If you have any further questions please don't hesitate to ask. (mysql, query) carlos.jacob [EMAIL PROTECTED] 10/08/02 08:34AM 01) at the setup, how do i do to install the software at drive c: and the database files at drive d:? 02) How do i install INNODb at Windows 2000 server with MySql 3.23? Thanks Jacob - Brazil --- UOL Eleições 2002 - Todos os lances da disputa política http://eleicoes.uol.com.br/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDb Question
I am new to InnoDb and was wondering what steps I would have to do to restore a table. Lets assume I am backing up the data by backing up the tablespaces. Thanks in advance (MySQL, query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDb restore - Please help
I am new to InnoDb and was wondering what steps I would have to do to restore a table. Lets assume I am backing up the data by backing up the tablespaces. Thanks in advance (MySQL, query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: foreign key support??
It is supported in MySQL 4.0.x if you use the InnoDb table handler. I'm not sure about 4.1. Remco Barendse [EMAIL PROTECTED] 09/27/02 09:29AM Hi! According to the website MySQL 4.0.x supports foreign key constraints. For version 4.1 foreign key integrity rules are planned. What is the difference between these 2? On previous versions of MySQL it was possible to create foreign keys but changed data was not replicated to other tables. I need foreign key support for MySQL as is available in PostgreSQL. Any input greatly appreciated! Best regards, Remco Barendse - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL InnoDb restore
I am new to InnoDb and was wondering what steps I would have to do to restore a table. Lets assume I am backing up the data by backing up the tablespaces. Thanks in advance (MySQL, query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyISAM or InnoDB
We are moving a databse over from Oracle to MySQL 4.0.3 and I was wondering if I should use MyISAM or InnoDb. The databse currently has 800-900 updates and inserts done to it in a day along with about 1000 selects. Would I run in to any table locking problems with MyISAM? Thanks in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Table size
Which Operating Systems limit MySQL to a 2GB table size? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 4.0 stable release
When will MySQL 4.0 be released as a stable version? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Table size in AIX
I found out my AIX box's maximum file size is 2GB. What can I do if I will have MySQL tables that are possibly over 2GB? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installing MySQL 3.23.51 on AIX 4.3.3
I get the following error when installing the MySql Binary in AIX: exec(): 0509-036 Cannot load program mysql because of the following errors: 0509-130 Symbol resolution failed for mysql because: 0509-136 Symbol stpcpy (number 125) is not exported from dependent module /usr/lib/libc.a(shr.o). 0509-136 Symbol strnlen (number 126) is not exported from dependent module /usr/lib/libc.a(shr.o). 0509-192 Examine .loader section symbols with the 'dump -Tv' command. I get this error when running mysql_install_db and when trying to start the database. Note: I am using AIX 4.3.3 and MySQL 3.23.51. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Running an SQL file from the command line
I need to run a file called sms.sql from the command line. Is this possible and what is the syntax? Thanks in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php