How to build a client?
I get various errors from my php based applications and php building that all refer to the need to upgrade my mysqlclient. I have not found instructions on where to get the client software to build or upgrade a client. This system is a Solaris 10 SPARC system. Best regards, Michael The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
Re: How to build a client?
I have mysql-max-5.0.19-solaris10-sparc-64bit installed and running fine. I have at times used the OLD PASSWORD ro resolve some issues but during my build of php-5.1.2, no luck. Here is the last part of the config.log with the errors. config.log 639 lines, 31250 characters ld: warning: file /usr/local/lib/mysql/libmysqlclient.a(client.o): wrong ELF class: ELFCLASS64 ld: warning: file /usr/local/lib/mysql/libz.a(crc32.o): wrong ELF class: ELFCLASS64 Undefined first referenced symbol in file mysql_error /var/tmp//ccO3Lkgh.o ld: fatal: Symbol referencing errors. No output written to conftest collect2: ld returned 1 exit status configure: failed program was: #line 59430 configure #include confdefs.h /* Override any gcc2 internal prototype to avoid an error. */ /* We use char because int might match the return type of a gcc2 builtin and then its argument prototype would still apply. */ char mysql_error(); int main() { mysql_error() ; return 0; } Best regards, Michael Dominik Klein [EMAIL PROTECTED] 03/15/2006 09:34 AM Please respond to [EMAIL PROTECTED] To mysql@lists.mysql.com cc Subject Re: How to build a client? [addon to my previous mail] I have not found instructions on where to get the client software to build or upgrade a client. just use an up-to-date binary mysql distribution for your OS. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
Re: How to build a client?
My /etc/my.cnf does not have this option? Is this something I can add? What is the correct syntax? Best regards, Michael Dominik Klein [EMAIL PROTECTED] 03/15/2006 09:33 AM Please respond to [EMAIL PROTECTED] To mysql@lists.mysql.com cc Subject Re: How to build a client? I get various errors from my php based applications and php building that all refer to the need to upgrade my mysqlclient. Did you try old-passwords in /etc/my.cnf ? Old clients use an old authentication protocol, which is not the default on modern mysql servers. For compatibility, old-passwords uses the old algorithm. I have not found instructions on where to get the client software to build or upgrade a client. For php: ./configure options --with-mysql=/path/to/newmysql/ Regards, Dominik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
Re: Windows - logging into MySQL
Clearly you don't read instructions as well as you'd like us to think. As has been pointed out by numerous people, the instructions that were suggested to are applicable to the version of MySQL that you are running (3.2.3) I followed the link suggested to you, and it took me a whole second to discern that the instructions are applicable to 3.2.3. (Hint: look at the title of the page, namely 'MySQL 3.23, 4.0, 4.1 Reference Manual. So your entire arguement about giving this list a bad name is fallacious. You complained that people should give proper answers or shut their mouths. Well, if you had taken ANY time to really look at the FREE advice that someone kindly gave you, perhaps you'd realize that the answer is fine. Not to mention that in your complaint you end up doing the same thing that you are complaining about, namely giving yourself a bad name. I don't watch this list religiously but happened to check this thread. I will remember your name, and it will be a cold day in hell before i give you any help. Furthermore, when i read your statement of Never mind anyone responding, I'll find my own damn answers it sure implied to me that you wouldn't be back to this list, considering its horrible reputation and all. But not more than 10 minutes later, you are back posting to the list again. That really reminds me of small children saying things like I hate you, im never talking to you again and then ten minutes later are asking you for help. If you're coming to a free source for help, at least be gracious and realize that people are helping you for no gain of their own. Not to mention that EVERYONE makes mistakes, including you. You made the mistake of thinking that the answer you received didn't apply to the MySQL version that you're using. Also, if you're going to make an ultimatum (such as never returning to this list), at least stick with it. Don't come back ten minutes later. On Wednesday 30 November 2005 16:50, Beauford wrote: This is why lists like this get a bad name. First off, these instructions are for 4.1. Secondly. What makes you think I haven't read the instructions or searched extensively on Google etc. Either give a proper answer or just shut your mouth. Never mind anyone responding, I'll find my own damn answers. Thanks for the help. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: November 30, 2005 12:16 AM To: Beauford Cc: mysql@lists.mysql.com Subject: Re: Windows - logging into MySQL Beauford [EMAIL PROTECTED] wrote on 11/29/2005 11:31:24 PM: I just installed MySQL 3.23 (the only one I could get to work) and I find that I can log into the server just by typing mysql at the DOS prompt. Ho do make it so you have to use a user name and password to get in. Thanks Running on Win2k Advance Server. You could try following the installation instructions in the manual http://dev.mysql.com/doc/refman/4.1/en/windows-installation.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine -- Sean Peters Senior Programmer, WIREData Inc. [EMAIL PROTECTED] The software required Windows 2000 or better, so i Downloaded Linux -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to add a host so 'root' can connect to the server from it
Its been a while since i've dealt much with MySQL permissions, but do you need to explicitly state 'localhost' as the machine in some circumstances. The other thing i thought of is a guess, as i don't program Java, but have had an analogous problem using Perl. It it possible that Java is dealing with the passwords using the old password scheme and the server has the passwords in the new scheme (or the other way around)? Just a couple guesses that are probably incorrect. On Thursday 03 November 2005 16:02, [EMAIL PROTECTED] wrote: Answers intermixed. See below Xiaobo Chen [EMAIL PROTECTED] wrote on 11/03/2005 04:28:08 PM: Thank so much for the detailed explaination. I do appreciate it. It's more clear now. But I still have a question: I do see 'root' after: select user,host from mysql.user; Then I did this as you said: GRANT SELECT ON mydatabase.* TO [EMAIL PROTECTED] IDENTIFIED BY 'mypassword'; then I issue: select * from mysql.user where user='root'; I found the select previlege is still 'N'. Besided this, how do I know 'mydatabase' from those tables in 'mysql' database that 'mydatabase' is allowed to be connected by 'root' from the IP. I am confusing here because the 'user' table only give the association betweem 'host' and user 'root' in the Mysql server. But where is the database association? wait a minute, yes, I see. When I issue: select * from mysql.db where user='root'; I did see the association and the SELECT_priv is 'Y' there. That's correct, the `user` table controls GLOBAL permissions. The `db` table controls database-specific permissions (there can be multiple databases on any server). But, in the java program running in the local XP machine still can NOT connect to the database existing in the other Solaris machine!! I tried in the local XP machine: telnet theserver 3306 I failed. I guess this is why I can not connect to the server. Could be it possible that the Solaris machine deny any request from the PC to the port 3306? I can ssh to the server, or using winscp. There are several possibilities here: XP is denying outbound connections to your Solaris machine (quite likely) Solaris is denying connections from your XP machine (not likely) Firewalls, routers, or proxy servers between the XP and Solaris machines are blocking the connection attempt. If you were able to connect to the MySQL server, your MySQL error would say that you could not authenticate not could not connect I am really confused here. Is it a mysql issue or the system configuration issue on the server? I think it's a system configuration issue on the XP machine. I believe the XP firewall is getting in your way. Btw, I can run the same java program from other machine in Solaris system to connect the database as the user 'root'. Does this imply that it's administration issue? Network administration, not MySQL administration (yet). Thanks for your kind help and patience. Xiaobo My pleasure! Shawn Green Database Administrator Unimin Corporation - Spruce Pine previous responses snipped -- Sean Peters Senior Programmer, WIREData Inc. [EMAIL PROTECTED] The software required Windows 2000 or better, so i Downloaded Linux -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
UUID storage (again)
The other day i asked about the proper column to store UUID's in. After thinking about it some more, i still think that a BINARY(16) is a better way to store a UUID. I'd need to strip the dashes from the formatting, but the storage would only be half as much (slightly less actually) as the suggested VARCHAR(36). The index lookups seem like they'd be faster too. Am i offbase? Also, in talking to a friend that uses that other database from redmond, i discovered that they have build in GUID (same as UUID from what i can discern) columns that are optimized for that kind of data. As it seems that UUID's are becoming the preferred internal ids, are there any plans for UUID column optimizations in MySQL? -- Sean Peters Senior Programmer, WIREData Inc. [EMAIL PROTECTED] The software required Windows 2000 or better, so i Downloaded Linux -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
UUIDs - first usage for me
Hi all, Im researching switching a production database system to use UUID's instead of AUTO_INCREMENT columns for various ids. I've looked at various MySQL documentation, and it seems to be what i want. This change will really affect 2 separate database servers. Both are using InnoDB tables. One is running MySQL 4.1.3-beta on solaris, and the other is running 4.1.8-Max on Redhat Linux. From what i've been reading, the only thing i cant determine is what column type to use to store the UUID's. These will be foreign keys between some tables, and the unique ids in all tables for this system. Should i be using BINARY() columns ? Thanks much -- Sean Peters Senior Programmer, WIREData Inc. [EMAIL PROTECTED] The software required Windows 2000 or better, so i Downloaded Linux -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Insert decimals with rounding
Hi all. I am trying to figure out if there is a way to configure MySQL so that when inserts occur on decimal fields where the value being inserted has more precision than the field specification, then the value inserted is rounded instead of truncated. For example, if i have a column: Acres DECIMAL(14,3) NOT NULL DEFAULT 0 and i'm inserting the value '1.5467' currently, the value 1.546 is inserted. But i want the behaviour to round this number to 1.547 Is this possible, or will i have to do that manually (programmatically) for all the decimal fields that i want to behave this way. Note: The application htat i need this for is driven by Perl with the DBI / DBD::MySQL Thanks much -- Sean Peters Senior Programmer, WIREData Inc. [EMAIL PROTECTED] The software required Windows 2000 or better, so i Downloaded Linux -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
TCP No Longer Working
I suddenly have lost the ability to connect to the MySQL server from my remote host and can not figure out what is wrong. I have searched for the last couple of days and cannot figure out why. I am running MySql 5.0.0 on Linux Suse 9.1 I normally connect to MySQL from Windows XP Pro using either the .Net connector and/or the ODBC connector. When I check the variables it shows that the port is set to 3306 But when I run the following it appears that TCP is not working correctly. linux:~ # netstat -l | grep mysql tcp0 0 *:mysql *:* LISTEN unix 2 [ ACC ] STREAM LISTENING 4671 /var/lib/mysql/mysql.sock If I log in via SSH or from a shell on the Linux box itself I can connect to the database in any of the following ways: mysql -u user_name -p database_name mysql -u user_name -p -h localhost database_name mysql -u user_name -p -h 127.0.0.1 database_name mysql -u user_name -p -h the_static_ip_address database_name As soon as I try to connect from Windows XP using the .Net connector, the ODBC connector, MySQL Query Browser or MySQL Administrator I get the following error: Could not connect to the specified instance. MySQL Error Nr. 2003 Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10060) I am able to successfully ping the IP address of the Linux machine. Here is what is listed in the /etc/my.cnf file [mysqld] datadir=/var/lib/mysql port=3306 socket=/var/lib/mysql/mysql.sock [mysql.server] basedir=/usr/bin Any assistance is greatly appreciated. Doug
data migration question
I have a table that i am modifying the schema of, and am having a particular problem with my data migration program. The old format has a column defined as: Range char(3) not null default '', which is either'' or contains a number (1 or 2 digits), and is sometimes followed by a direction (N,S,E,W) In the schema that im migrating to, the definition has changed so that there are 2 columns: Range TINYINT UNSIGNED NOT NULL DEFAULT 0, Range_Direction char(1) I have a Perl script that is doing a SELECT INTO OUTFILE on the old table, and a LOAD DATA INFILE into the new table. I havent been able to figure out a SELECT clause that will properly break up the old Range. Using a SELECT clause query like: SELECT Range REGEXP ^[0-9]+, Range REGEXP [NSEW]$ FROM ... will tell me about whether the Range column value is actually what it should be, but i was looking for a function that would give me the specific string that matched the regex, for instance using the above regexes on a range value of '32E', the first part matches '32' and the second part matches 'E'. REGEXP just gives whether the pattern matched the expression. This is very easy in Perl, is there any way to do it in MySQL? thanks much sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql_config missing - already read much docs
I just upgraded Mysql to 4.1.4-0 on linux using the following: MySQL-server-4.1.4-0.i386.rpm MySQL-client-4.1.4-0.i386.rpm So when i went to upgrade my perl DBI DBD::mysql packages, it noticed that mysql_config was missing. My understanding is that mysql_config should be installed with the client libraries. I looked at the /usr/bin directory before and after installing the client libs, and mysql_config is not there. Here is a diff output of 'ls -l /usr/bin/my *' both before and after the client rpm was installed. -rwxr-xr-x1 root root 1696220 Aug 28 02:54 mysql -rwxr-xr-x1 root root 111478 Aug 28 02:54 mysqlaccess -rwxr-xr-x1 root root 1516376 Aug 28 02:54 mysqladmin -rwxr-xr-x1 root root 1550488 Aug 28 02:54 mysqlbinlog 6a11 -rwxr-xr-x1 root root 1512908 Aug 28 02:54 mysqlcheck 10a16,17 -rwxr-xr-x1 root root 1533448 Aug 28 02:54 mysqldump -rwxr-xr-x1 root root 4986 Aug 28 02:54 mysqldumpslow 11a19 -rwxr-xr-x1 root root 2653 Aug 28 02:54 mysql_find_rows 14a23 -rwxr-xr-x1 root root 1510200 Aug 28 02:54 mysqlimport 17a27,28 -rwxr-xr-x1 root root 1510316 Aug 28 02:54 mysqlshow -rwxr-xr-x1 root root13647 Aug 28 02:54 mysql_tableinfo 19a31 -rwxr-xr-x1 root root 680464 Aug 28 02:54 mysql_waitpid So the client rpm did install a bunch of things, but not the mysql_config executable. I'm rather confused by this. Perhaps i should go back to installing source distros. Anybody seen anything like this? thanks much sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cascade on delete question.
I have two tables, call them Parent and Child, where the records in Child have a foreign key relation to Parent, with a Cascade on Delete. If i delete records from Parent, the corresponding records in Child will be deleted. Is there any way that i can get a count of the records in Child that were deleted? without doing a 'Select count(*) FROM Child' before and after the delete? Im writing a utility that sometimes deletes records, and we'd like to know how many from each table, and i'd like to take advantage of the cascade on delete. thanks sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Simple DB design question
I have some data that is stored by the year it is related to. So I have one table that stores the Year the data is related to, among other things. At any given time, 1 year is considered the 'active year', and the rest are considered inactive. The table is something like: CREATE TABLE Data_Info Data_Info_IDINT, YearINT, ... So my question is how do i best store which year is active. 2 designs come to mind: 1) add a column such as: Status ENUM('Active', 'Inactive') and adjust accordingly as the active year changes. 2) have a separate table: CREATE TABLE Active_Data ( Data_Info_IDINT, Key (Data_Info_ID), FOREIGN KEY (Data_ID) References Data_Info(Data_Info_ID) ); With design 1, i need to make sure that only 1 record is ever set as 'Active'. With design 2, there will only ever be 1 record in the Active_Data table. Neither idea seems very good to me. Any suggestions? thanks much sean peters [EMAIL PROTECTED] mysql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Performance question with perl DBI
Hi all, i have a MySQL driven web system that searches a pretty big DB of property info. (10 data tables, about 50,000,000 total rows, average 300 concurrent users) There are actually 2 databases that feed this site, one is meta info, and isnt hit that heavily. Lets call those DB's 'data' and 'metadata'. So my perl cgi handler creates a MySQL DBI connection to the 'data' db. When i need info from the 'metadata', i see a couple options. 1) issue query 'use metadata'. Do whatever. issue query 'use data' 2) dont change DB's, but have all queries into 'metadata' explicitly name the tables, like '... metadata.some_table...' I was wondering if either method has better performance. They seem about the same to me. Oh, im using InnoDB with the innodb_file_per_table setting. The 'data' DB is on a separate physical drive from 'metadata' Any thoughts? need more info, let me know? am i being too anal? thanks much sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error: The table 'property' is full
When loading a new InnoDB database, I received the error: Error: The table 'property' is full I was quite surprised to get this error. When looking at the file sizes, i notieced that InnoDB tables on 4.1.3beta take up at least twice the space on the filesystem as MyISAM tables on 4.0.2 Is this normal? I am running on Solaris 5.9 This is creating a serious problem for my upgrade. I have the drive space, but i'll need to reconfigure the drives. I think that will work. Im just pretty surprised. any thoughts? thanks sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Perl DBD upgrade
Im having some difficulty with the perl DBI/DBD in conjunction with a MySQL upgrade. Here's the situation: On the DB server machine, i have MySQL 4.1.3beta running for testing upgrading, but MySQL 4.0.2 is also running (production). I can connect locally on the DB server through various clients, and have permissions as needed. But when i try to connect via a web server, i get various connect errors based on the params i pass. The error that is telling me the most is: DBI connect(...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at script line XXX But, i upgraded the DBI to 1.43, and the MySQL DBD to 2.9004 on both the DB server and the webserver (DB client). What im thinking the problem is: the webserver is running MySQL for other apps, and the DBD is built based on that MySQL, which is pre 4.1 series, so it doesnt understand the new MySQL auth protocols. (Note the webserver is running Perl 5.6.1) But, i didnt think that the DBD was built based on a MySQL server, because the rest of the webservers in the pool dont run MySQL, but i can still install the DBI and DBD. So im at a loss here. Can i tell the DBD to build based on the DB servers MySQL install, or does that question not even make sense? I think i need to upgrade the MySQL client libraries on the webserver, but i dont want to disturb other peoples MySQL on that box. Note: I absolutely cannot upgrade the mysql server or Perl on the webserver. Any Advice? Thank much sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Upgrading Mysql and Perl DBD
I now have MySQL 4.0.2 and MySQL 4.1.3 beta both installed and running on one machine. I want to be able to use the Perl DBI / DBD to connect to both servers. I understand that there have been some changes between the MySQL 4.0.X and 4.1.X series that may require differently compiled DBD's. So my question is, do i need to have 2 separate DBD versions, or will the newer one work for both MySQL servers. The old DBD does not work for the new server. This is demonstrated by the error message: DBI-connect(...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at connect_test.pl line 19 All the connect_test.pl tries to do is create a db connection to each server separately. Any insight would be greatly appreciated thanks much sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Documentation problem?
hi all. In my struggles to buildl MySQL 4.1.3deta, i read a lot of online documentation, and in the process i found a lot of info about various configure flags in writeups all over the web. One problem i encountered, that i finally figured out was that some documentation names the flag --with-extra-charsets as --with-extra-charset I finally got it right, but most of what i read omitted the (s). The configure script (quietly) allows the incorrect flag. I dont know what can be done, with so many contributors to the documentation, reviewing everything in that much detail doesnt seem wholly reasonable. I'd guess there are a myriad of similar little issues. Any thoughts on how to minimize this problem. Just wanted to bring this out. thanks sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
multiple server versions on 1 box startup error#
I am trying to run two different MySQL server versions on the same solaris machine. I already have a 4.0.2 running, and i have successfully installed 4.1.3 beta. I ran mysql_install_db successfully (after setting LD_LIBRARY_PATH), but when i try to run mysqld_safe --user=mysql I get the error: A mysqld process already exists [1]+ Exit 1 ./mysqld_safe --user=mysql This is certainly true, because my 4.0.2 is running, but i dont understand why this is a problem. I am running the mysqld_safe for version 4.1.3, and when i built 4.1.3 i used the configure options: (among others) --prefix=/usr/loca/mysql-4.1.3 --with-tcp-port=3306 --with-unix-socket-path=/tmp/mysql-4.1.3.sock --datadir=/var/mysql-4.1.3 And these options are all different from the 4.0.2 configuration. So i assumed that things would run ok. The only thing i can think of is that the /vaar/mysql-4.1.3/my.cnf is not being read correctly. Perhaps i have an error in it, but i'd think that mysqld_safe would let me know. If its not being read, then some options from my default /etc/my.cnf are not being overridden, and that could be the problem. Here is the info on the /var/mysql-4.1.3/my.cnf file: -rw-r--r-- 1 root other 2042 Aug 12 18:08 my.cnf and the permissions ownership are identical to that for /etc/my.cnf I am at a loss thanks much. sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
datadir specification, etc
I am 100% convinced that mysql 4.1.3 beta is not properly reading the my.cnf configuration files. If i remove the /etc/my.cnf file and try to start mysql 4.1.3 with (im working from /usr/local/mysql-4.1.3/bin) ./mysqld_safe i get the following output: (mccoy is the name of the machine im on) touch: /usr/local/mysql-4.1.3/var/mccoy.err cannot create chown: /usr/local/mysql-4.1.3/var/mccoy.err: No such file or directory Starting mysqld daemon with databases from /usr/local/mysql-4.1.3/var ./mysqld_safe: /usr/local/mysql-4.1.3/var/mccoy.err: cannot create If i remove the /var/mysql-4.1.3/my.cnf file, i get the same output as above, so its not being read either way. And i did specify /var/mysql-4.1.3/ as my datadir with .configure when building 4.1.3 if i put the /etc/my.cnf file back, i get the following: A mysqld process already exists So clearly, the /etc/my.cnf is being read, but the /var/mysql-4.1.3/my.cnf is not. so i guess it doesnt matter what i specify in there at this point. One strange thing is that ./msqyd_safe tries to use the databases in /usr/local/mysql-4.1.3/var/ But i specified a different datadir with configure! my configure --prefix=/usr/local/mysql-4.1.3 but why should that matter? In fact, when i installed 4.1.3 (make install), the directory /usr/local/mysql-4.1.3/var/ was NOT created. I dont think most of the info ive given matters, because my run-time configuration doesnt appear to be the problem. I dont believe that my build configuration took effect properly. Does any of this make sense? Still completely lost. thanks sean peters [EMAIL PROTECTED] *** Here's some my.cnf data, if it really matters *** Here is part of the /var/mysql-4.1.3/my.cnf file: [client] port= 3307 socket = /tmp/mysql-4.1.3.sock pid-file= /usr/local/mysql-4.1.3/mysql-4.1.3.pid datadir = /var/mysql-4.1.3/ [mysqld] port= 3307 socket = /tmp/mysql-4.1.3.sock pid-file= /usr/local/mysql-4.1.3/mysql-4.1.3.pid datadir = /var/mysql-4.1.3/ And here is info from /etc/my.cnf file: [client] port= 3306 socket = /tmp/mysql.sock [mysqld] port= 3306 socket = /tmp/mysql.sock -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
InnoDB file per table directive
I've been reading (and reading...) the innodb documentation about using the innodb_file_per_table directive, and one thing still confuses me. If i use this directive, then is it correct that the setting innodb_data_file_path will specify the shared innodb information? Also, when i create databases, there will be a directory created off of datadir that will hold all the separate innodb table files for that database. I.E. when i do: Create database innodb_test; # this creates a directory [datadir]/innodb_test/ and when i issue: use database innodb_test; Create table test_1 (... )type=InnoDB; # this creates files: # [datadir]/innodb_test/test_1.frm # [datadir]/innodb_test/test_1.ibd And when i create a separate db, say innodb_test_2 then basically the same thing happens, but in directory innodb_test_2 ? What i want to do is have separate physical drives mounted in subdirectories of [datadir], so each physical disk holds separate databases. There will also be smaller DBs on the physical drive that [datadir] is on. Am i understanding all of this correctly? thanks much sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
trouble building mysql 4.1.3
I am getting an error from make test when trying to build MySQL 4.1.3 beta The error is as follows: ERROR: .../mysql-4.1.3-beta/mysql-test/var/run/master.pid was not created in 30 seconds; Aborting make: *** [test] Error 1 I read online about using the --with-extra-charset=complex with configure. (even though this is documented as fixed, ive tried without this directive also, with the same error) This runs on Solaris: SunOS [machine_name] 5.9 Generic_112233-11 sun4u sparc SUNW,Ultra-Enterprise Here is everything i did from the command line: (i am running as root - i tried as another user too) CC=gcc CFLAGS=-03 CXX=gcc CXXFLAGS=-03 felide-constructors -fno-exceptions -fno-rtti ./configure --with-low-memory --enable-assembler \ --with-extra-charset=complex --with-tcp-port=3307 \ --with-unix-socket-path=/tmp/mysql-4_1_3.sock \ --prefix=/usr/local/mysql-4.1.3 LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib; export LD_LIBRARY_PATH make make test So im at a loss. Note that i have all the nonstandard settings: port, etc. because i am trying to test this version ( tweak carious settings) on a production server without disturbing the 4.0.2 that is already running. Thanks again. sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
make test grant_cache test failing
Hi all, still building 4.1.3 I am now getting an error in make test like this: ERROR: ... At line 136: Result length mismatch (the last lines may be the most important ones) Below are the diffs between actual and expected results: --- *** r/grant_cache.resultMon Jun 28 01:26:46 2004 --- r/grant_cache.rejectTue Aug 10 23:44:49 2004 *** *** 112,119 Variable_name Value Qcache_not_cached 1 show grants for current_user(); ! Grants for @localhost ! GRANT USAGE ON *.* TO ''@'localhost' select user2; user2 user2 --- 112,119 Variable_name Value Qcache_not_cached 1 show grants for current_user(); ! Grants for [EMAIL PROTECTED] ! GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION select user2; user2 user2 --- Please follow the instructions outlined at http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Aborting: grant_cache failed. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon Master shutdown finished Slave shutdown finished make: *** [test] Error 1 When i run: diff grant_cache.result grant_cache.reject here is the output: 115,116c115,116 Grants for @localhost GRANT USAGE ON *.* TO ''@'localhost' --- Grants for [EMAIL PROTECTED] GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION This looks somewhat trivial, but i cant get beyond it to finish the test. make does not understand the --force directive, so the advice in the error wont work. thanks much, sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: make test grant_cache test failing
UPDATE: I modified the grant_cache.result file to the expected output and got past the test. It looked like the incorrect query was being issued, or in any case that make test was doing something different than what the grant_Cache.result file expected On Tuesday 10 August 2004 15:59, sean c peters wrote: Hi all, still building 4.1.3 I am now getting an error in make test like this: ERROR: ... At line 136: Result length mismatch (the last lines may be the most important ones) Below are the diffs between actual and expected results: --- *** r/grant_cache.resultMon Jun 28 01:26:46 2004 --- r/grant_cache.rejectTue Aug 10 23:44:49 2004 *** *** 112,119 Variable_name Value Qcache_not_cached 1 show grants for current_user(); ! Grants for @localhost ! GRANT USAGE ON *.* TO ''@'localhost' select user2; user2 user2 --- 112,119 Variable_name Value Qcache_not_cached 1 show grants for current_user(); ! Grants for [EMAIL PROTECTED] ! GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION select user2; user2 user2 --- Please follow the instructions outlined at http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html to find the reason to this problem and how to report this. Aborting: grant_cache failed. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon Master shutdown finished Slave shutdown finished make: *** [test] Error 1 When i run: diff grant_cache.result grant_cache.reject here is the output: 115,116c115,116 Grants for @localhost GRANT USAGE ON *.* TO ''@'localhost' --- Grants for [EMAIL PROTECTED] GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION This looks somewhat trivial, but i cant get beyond it to finish the test. make does not understand the --force directive, so the advice in the error wont work. thanks much, sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Running multiple versions of MySQL on 1 machine
Hi all, I am looking to upgrade to MySQL 4.0.13 on a Solaris production server, and would like to install and test 4.0.13 without disturbing the existing 4.0.2 server, so that there will be minimal downtime when actually upgrading the production system. So, i should be able to compile 4.0.13 without any problems, by just havnig a different base directory. But, by default, MySQL reads /etc/my.cnf at startup, so im wondering if i'll need to switch out the /etc/my.cnf files depending on which server I'm starting. Also, since client programs get options from that same file, it appears that there will be a problem running them both concurrently, because when a client connects, it will need to read the proper my.cnf, and if i have different clients connecting to each server i'd need to keep switching the files, but i cant realistically know in advance when clients are connecting to which server, so this will not work properly. Can i compile mysql with a different configuration so that it reads the default my.cnf from somewhere else, say /sandbox/etc/my.cnf for instance? Any other problems with running concurrent MySQL servers on the same machine? thanks much sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Running multiple versions of MySQL on 1 machine
I guess i dont fully understand how mysql uses my.cnf. Global settings go in /etc/my.cnf. Global to what? All mysql servers running on the machine, or some other definition? I guess my confusion is partially because my.cnf states the port number for both servers and clients, but both servers cant be listening on the same port. Is it the case that i'll need to redefine some of the config options from /etc/my.cnf in DATADIR/my.cnf for each server. If so, thats fine, i just want to make sure i do this correctly, and dont cause an interruption of service in the production server. Most of what i've been reading about running multiple servers on the same box has seemed a bit confusing. thanks much sean peters [EMAIL PROTECTED] On Monday 09 August 2004 12:51, you wrote: Global settings go in /etc/my.cnf. Server-specific settings go in that server's DATADIR/my.cnf. Running multiple servers is documented in the manual http://dev.mysql.com/doc/mysql/en/Multiple_servers.html. Using clients in a multi-server setting is documented on one of the sub-pages. 4.0.13 is over a year old (May 16, 2003). Current version is 4.0.20. A lot has been done in the interim http://dev.mysql.com/doc/mysql/en/News.html. Unless you have a specific reason not to, I'd recommend upgrading to 4.0.20. Michael sean c peters wrote: Hi all, I am looking to upgrade to MySQL 4.0.13 on a Solaris production server, and would like to install and test 4.0.13 without disturbing the existing 4.0.2 server, so that there will be minimal downtime when actually upgrading the production system. So, i should be able to compile 4.0.13 without any problems, by just havnig a different base directory. But, by default, MySQL reads /etc/my.cnf at startup, so im wondering if i'll need to switch out the /etc/my.cnf files depending on which server I'm starting. Also, since client programs get options from that same file, it appears that there will be a problem running them both concurrently, because when a client connects, it will need to read the proper my.cnf, and if i have different clients connecting to each server i'd need to keep switching the files, but i cant realistically know in advance when clients are connecting to which server, so this will not work properly. Can i compile mysql with a different configuration so that it reads the default my.cnf from somewhere else, say /sandbox/etc/my.cnf for instance? Any other problems with running concurrent MySQL servers on the same machine? thanks much sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqld_multi different server versions
In my ongoing quest to get upgraded to 4.1.3 beta (yes the version I'm upgrading to keeps changing), i have been reading about mysqld_multi to manage multiple server instances on the same machine. But, from what i've read, it appears that this is for running multiple instances of the same server version on one box. Same binary anyway. I say this because all the examples show as varying are the socket, port, pid-file, datadir, language, and user. The [mysqld_multi] directive for my.cnf points mysqld at a particular mysqld_safe, which would imply that all the instances would use the same server. So am i correct in thinking that i wont be able to use mysqld_multi for running two different server versions? This shouldn't be a problem, I dont think i'll need it. Just wanted to check if im missing something. thanks sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mixing Innodb MyISAM tables
Im considering a design that mixes InnoDB and MyISAM tables. I want Innodb for speed, etc, but i have one table where i want a column to have a FULLTEXT index on. Thus the need for MyISAM. Im not worried about the performance in using the MyISAM tables, as we speak, the production version of the system is using MyISAM tables without problems. The main concern is that by using a MyISAM table, i lose foreign key support, and cannot do a cascade on delete, which i'd really like to have, and not have to manually mimic the cascade behaviour. I suppose i've gotten along fine without having foreign key support for a number of years, so this probably isnt that bad. Anyone else run into similar issues? Any thoughts? thanks much sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
InnoDB slowness
Hi all, I am in the process of upgrading one of my systems to use InnoDB tables, along with some other tweaks to my code. In any case, i just tried to delete around 7000 records from a table, where there are 9 other tables that will cascade delete when rows from the other table are deleted. Overall, id guess 140,000 rows are being deleted from all tables. This sat for at least 15 minutes, eventually i killed it and it took quite a while for that database to recover. (it was rolling back the tranaction i assume). In any case i didnt expect it to take that long to delete. Im now deleting in chunks of 100 rows in the main table, each chunk is taking 15-30 seconds. This is on a 4 processor sun box running solaris, with 4GB of ram, and a lot of swap (8 GB i think). This is running MySQL 4.0.2 alpha, so that could be part of the issue. Any comments. Should it take this long? thanks sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
load data infile question
I haven't used load data infile much, mainly because of issues like this question. I want to load a bunch of data for our data warehouse into about 10 different tables. But when I load a parent table, an auto_increment column autogenerates a value that will be a foreign key in a child table. So i cant create the file to load into the child table until after the parent table has been loaded. Then i'll need to get back all the auto increment values just created, and put them into the load file for the child tables. Is this how it has to be, or am i missing something? thanks much sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
NULL values
HI all, i am tweaking some tables for an upgrade to MySQL 4.0.13 using InnoDB tables. I have a bunch of columns defaulted to NULL, and have been reading about using NULL's vs defined defaults, such as 0 or ''. I dont really have any need to differentiate between a blank and a null, so i am looking for general performance maintenance concerns. For certain columns i am completely sold on not using nulls, for others, i cant see any conceptual reason to favor either way, so i thought i'd tap you all for some insight. Thanks much. Sean Peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
update statistics question.
IF i run update statistics on MyISAM tables, will those tables lock while the statistics are being updated. This is the first time i think i need to update statistics on a production server, and i dont want to lock out my users for any time. There are about ten tables i'll need to run statistics on, each having between 1.5 million and 25 million rows. Any advice on how to best accomplish this would be great. thanks much, sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqldump table order with foreign keys
Hey all, I'm trying to dump the structure of a database using: mysqldump -d myDatabase structure.sql Which works fine in getting the table create statements, but, how do i get mysqldump to put the creates in an order that will allow replication with foreign key concerns. For instance if i have tables as follow: CREATE TABLE Parent ( Parent_ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT, ... )Type= InnoDB; CREATE TABLE Child ( Child_ID ..., Parent_ID INT NOT NULL, ... FOREIGN KEY (Parent_ID) REFERENCES Parent (Parent_ID) ON DELETE CASCADE )Type=InnoDB; Etc. Mysqldump may dump the create statement for table Child before dumping the create statement for Parent. Then, when re-creating the database, i get errors, because the create for table Child references the foreign key in the table parent, which has not yet been created. I swear that i've seen a solution to this somewhere, but for the life of me i have not been able to find the answer (now that i need it) Thanks much, sean peters [EMAIL PROTECTED] filter fodder: mysql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
errno 138
Hi all, We're trying to upgrade from 4.0.2 max to 4.0.16 Everything starts fine, but when querying the DB, something as simple as SELECT count(*) FROM myTable will return errno 138, but this works fine before the upgrade. Its probably something minor, but we're at a loss. Im not sure what other info to provide, ask and i'll tell thanks much, sean peters [EMAIL PROTECTED] filter buster: mysql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
decimal field oddity
Hi all, I have a MyISAM table with a decimal field (12,2) I have loaded a bunch of data into this table, from ascii dumps of data being migrated from other systems. Some of these dumps include a value for the decimal field in the form of 00078000.00 My understanding was that decimal fields behave like numeric fields, but are stored like char field. So i had assumed that the lead zeros would be dropped, in the spirit of a numeric field, but they are kept, in the spirit of a char like field. The lead zero's screw up the formatting for various display API's (homecooked). I'm not arguing that this behaviour is a bug, i am more interested in knowing why this behaviour is the way that it is. thanks much, sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
bind params and default values
Hi all, i've been having an issue with binding params. If i have created an INSERT query with a param binding to a particular column, call it column A, is there any way that i can use that (prepared) query to get the db defined default value into column A? Im at a loss! thanks much, sean peters [EMAIL PROTECTED] BTW: i have posted a similar question to perlmonks under the title DBI bind params column defaults -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Unusual date storage requirement
Hi all, I have run into a date storage problem that i don't like. A am storing historic house sales, and some of the old data i have received only contains the month and year, but not the date of the sale. Of course we want to store this information, but a DATE column won't quite do the job, because year, month, and day are all required. So, my homecooked solution is to use a DATE column, and another column as a flag to denote whether the day-of-month is valid. Then i'll need to properly craft my searches to understand this. I know that this is a horrible break of normalization, etc. but i haven't come up with a better solution. Also note that this is for a data warehouse, and myself and 1 other programmer are the only people who manipulate the data. thanks in advance sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unusual date storage requirement
Sorry, i wasn't completely clear. Well, thats actually what i am going to do. A date column won't take anything but a valid date (sort of - feb. 30 is valid). But i still need to know whether the day of month is meaningful or not, for various search / display purposes. My users will raise a major stink if i tell them that the date is the first, but it actually isn't, so the display functionality for the system will check the date validity flag, and if invalid, only display the month and year. The flag field is there for exactly this purpose. thanks sean peters [EMAIL PROTECTED] On Monday 27 October 2003 16:44, John Jolet wrote: what about forcing the date to the first of whatever month the sale was in? if it's got a valid date, put that, otherwise, put the first. -Original Message- From: sean peters [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 4:33 PM To: [EMAIL PROTECTED] Subject: Unusual date storage requirement Hi all, I have run into a date storage problem that i don't like. A am storing historic house sales, and some of the old data i have received only contains the month and year, but not the date of the sale. Of course we want to store this information, but a DATE column won't quite do the job, because year, month, and day are all required. So, my homecooked solution is to use a DATE column, and another column as a flag to denote whether the day-of-month is valid. Then i'll need to properly craft my searches to understand this. I know that this is a horrible break of normalization, etc. but i haven't come up with a better solution. Also note that this is for a data warehouse, and myself and 1 other programmer are the only people who manipulate the data. thanks in advance sean peters [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]
4.1 in production
Hey all, are people using mysql 4.1.0 of 4.1.1 on production servers yet, or should we wait for a more stable release? i know this is somewhat subjective to the use. I have a major upgrade to my database system coming soon, and i want to coordinate it with my server upgrade, so im trying to figure out if it is wise to upgrade mysql yet. thanks much, sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to write this query
I've run into a situation where i dont know how to best write a query. For a base example, consider these 3 tables: CREATE TABLE A ( A_IDINT NOT NULL PRIMARY KEY, A_data text ); CREATE TABLE B ( B_IDINT NOT NULL PRIMARY KEY, A_IDINT NOT NULL, B_data text ); CREATE TABLE C ( C_IDINT NOT NULL PRIMARY KEY, A_IDINT NOT NULL, C_data text ); So ive been running a query like: SELECT A_data, B_data, C_data FROM A, B, C WHERE A.A_ID = B.B_ID AND A.A_ID = C.C_ID AND A.A_ID = 4; What i really want is to get the A_data from A, and if there are cooresponding records in B and/or C, get B_data and/or C_data, respectively. This works fine if there are cooresponding records in tables B and C for each record in A, but if not, this returns nothing. So, short of querying each table, i cant come up with a good solution to my problem. If there were only 2 tables, a LEFT JOIN would work fine, but both B and C want to be left joined to A, which i dont know how to do. thanks sean peters [EMAIL PROTECTED] --- mysql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to write this query
Unfortunately that wont always work either. For instance, assume that there is an A record with A_ID = 4 And that there is a C record where A_ID = 4, but NO B record where A_ID = 4 So, executing the query: SELECT A_data, B_data, C_data FROM A LEFT JOIN B ON A.A_ID = B.B_ID LEFT JOIN C ON A.A_ID = C.C_ID WHERE A.A_ID = 4; When A left joins B, there is no real B record, so any B columns are populated with null, as per left join. Then, table B is left joined to C on A_ID, which is null, and no C record will properly match the B.A_ID = NULL, so the C record is filled with nulls. If we were to join A to C then to B, a similar problem would occur if there was a cooresponding B record, but no C record. Thanks anyway. On Wednesday 01 October 2003 14:25, Kevin Fries wrote: You're on the right track with LEFT JOIN. Just continue the thought... Try: SELECT A_data, B_data, C_data FROM A LEFT JOIN B ON A.A_ID = B.B_ID LEFT JOIN C ON A.A_ID = C.C_ID WHERE A.A_ID = 4; -Original Message- From: sean peters [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 12:07 PM To: [EMAIL PROTECTED] Subject: How to write this query I've run into a situation where i dont know how to best write a query. For a base example, consider these 3 tables: CREATE TABLE A ( A_IDINT NOT NULL PRIMARY KEY, A_data text ); CREATE TABLE B ( B_IDINT NOT NULL PRIMARY KEY, A_IDINT NOT NULL, B_data text ); CREATE TABLE C ( C_IDINT NOT NULL PRIMARY KEY, A_IDINT NOT NULL, C_data text ); So ive been running a query like: SELECT A_data, B_data, C_data FROM A, B, C WHERE A.A_ID = B.B_ID AND A.A_ID = C.C_ID AND A.A_ID = 4; What i really want is to get the A_data from A, and if there are cooresponding records in B and/or C, get B_data and/or C_data, respectively. This works fine if there are cooresponding records in tables B and C for each record in A, but if not, this returns nothing. So, short of querying each table, i cant come up with a good solution to my problem. If there were only 2 tables, a LEFT JOIN would work fine, but both B and C want to be left joined to A, which i dont know how to do. thanks sean peters [EMAIL PROTECTED] --- mysql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Updated: How to write this query
Sorry, I had an error in my query. The fixed query with the entire post follows. Thanks for the responses to the incorrect one, im pretty sure that the suggestions will still fail for the previously indicated reasons, even with the modified query. ORIGINAL POST: (fixed) I've run into a situation where i dont know how to best write a query. For a base example, consider these 3 tables: CREATE TABLE A ( A_IDINT NOT NULL PRIMARY KEY, A_data text ); CREATE TABLE B ( B_IDINT NOT NULL PRIMARY KEY, A_IDINT NOT NULL, B_data text ); CREATE TABLE C ( C_IDINT NOT NULL PRIMARY KEY, A_IDINT NOT NULL, C_data text ); So ive been running a query like: SELECT A_data, B_data, C_data FROM A, B, C WHERE A.A_ID = B.A_ID AND A.A_ID = C.A_ID AND A.A_ID = 4; *** ORIGINAL INCORRECT QUERY :( *** SELECT A_data, B_data, C_data FROM A, B, C WHERE A.A_ID = B.B_ID AND A.A_ID = C.C_ID AND A.A_ID = 4; What i really want is to get the A_data from A, and if there are cooresponding records in B and/or C, get B_data and/or C_data, respectively. This works fine if there are cooresponding records in tables B and C for each record in A, but if not, this returns nothing. So, short of querying each table, i cant come up with a good solution to my problem. If there were only 2 tables, a LEFT JOIN would work fine, but both B and C want to be left joined to A, which i dont know how to do. thanks sean peters [EMAIL PROTECTED] --- mysql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Innodb disk geometry
Hi all, i've been trying to follow the Innodb upgrade that will allow setting up multiple separate blocks of disk for different databases, where the admin has the ability to put databases in specific tablespaces. There has been a bit of talk here, but whenever i go to the MySQL or Innodb web sites, i find nothing regarding this issue. So, instead of posting the same question here once a month, and wasting all your time, i'd much rather be aware of where i can check the progress of this issue. If anyone can point me at any such information, it would save effort for both me and you !!! thanks much -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Innodb multiple tablespaces
Hi all, A few weeks ago, someone mentioned that Innodb would soon have multiple tablespaces available under MySQL. I saw that Innodb.com shows this on their to do list. Is anyone aware of the status of this upgrade, or a site that would have details regarding the upgrade? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: InnoDB multiple mysqld's on 1 server
I can certainly wait. This system has been working ok for almost a year. I'm very happy! I've been doing a review of all aspects of the system, and many of the maintenance tasks, and internal DB operations have suffered in speed to get the external parts optimal. But when this fix comes, i'll surely upgrade so our internal programs will run faster. thanks much On Wednesday 13 August 2003 17:04, you wrote: On Wed, Aug 13, 2003 at 04:07:24PM -0500, sean peters wrote: Hi all, i've been weighing the pros and cons of running multiple concurrent mysqld's on one server, to have better control over what databases are on what physical disks. System: 4 processor sun box running solaris with eighteen 36Gb drives. The situation is that i have a bunch of databases on one server that can all be classified as either external use or internal use. The internal use databases are consistently hit pretty hard, and we want this to have minimal impact on the external use databases. Currently we're using 64 index MyISAM tables, and with carefully choosing mount points for various physical devices, we have the databases separated as we want them. It is my understanding that with InnoDB, all tables are put into the configured InnoDB file(s) together, which would violate what i am trying to accomplish. The only solution i have come up with to control the physical location of InnoDB databases is to run multiple mysqld servers, each one with its InnoDB files on the desired device. Has anyone experienced any success or failure with this sort of configuration? This is the only reason holding us back from using InnoDB tables for this server. (we're using them on other machines) If you can wait a month or so, Heikki is supposed to have that fixed in InnoDB soon. So you'll be able to have more control over which data lives in which tablespaces. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
InnoDB multiple mysqld's on 1 server
Hi all, i've been weighing the pros and cons of running multiple concurrent mysqld's on one server, to have better control over what databases are on what physical disks. System: 4 processor sun box running solaris with eighteen 36Gb drives. The situation is that i have a bunch of databases on one server that can all be classified as either external use or internal use. The internal use databases are consistently hit pretty hard, and we want this to have minimal impact on the external use databases. Currently we're using 64 index MyISAM tables, and with carefully choosing mount points for various physical devices, we have the databases separated as we want them. It is my understanding that with InnoDB, all tables are put into the configured InnoDB file(s) together, which would violate what i am trying to accomplish. The only solution i have come up with to control the physical location of InnoDB databases is to run multiple mysqld servers, each one with its InnoDB files on the desired device. Has anyone experienced any success or failure with this sort of configuration? This is the only reason holding us back from using InnoDB tables for this server. (we're using them on other machines) Thanks much! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SQL database design patterns
Hi all, I just recently figured out a style of SQL book (or on-line info) that would greatly help me. I have been reading a book entitled Design Patterns in Object Oriented Programming, and realized that analogous info probably exists for database design. So, im looking for literature on SQL design patterns. Such a book would basically entail examining a variety of (seemingly different) situations where a good design (normalized, etc) of the SQL tables follow certian patterns. Then, that pattern can be generalized and re-used for other related situations. Having a catalogue of many of the most often encountered patterns would allow for quicker design of SQL schema. I have found that many books about database design merely: 1) discuss the merits of data normalization 2) list the standard normalization schemes, with a few examples But certianly, many people have already worked through many of the problems i have and will encounter, and it seems silly that everyone will need to re-invent many of these wheels. Yes, i know that through actually working on these problems many times, i will gain a greater understanding, but by learning already known (to others) information, i should be able to gain that same understanding faster, and be more productive. So, if anyone could point me at such a book, or online tutorials, that would be great. Thanks much, sean peters [EMAIL PROTECTED] Filter info: mysql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
IN LIKE
Hi all, I am wondering if there is a way to transform the following query using LIKE OR into a query using IN, where the IN ( list) contains wildcard expressions. initial query: SELECT ID FROM address WHERE Street_Name LIKE first% OR Street_Name LIKE second% desired format would be something along the lines of: SELECT ID FROM address WHERE Street_Name IN (first%, second%) As written, the second query always returns 0 rows, so the wildcards are NOT being used. (the first query returns many results) I dont think this is possible, i've tried many syntax variations. Could someone confirm my suspicions, or prove me wrong. thanks, sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql text client crashes
Hi all, I've inadvertently ran across a weird issue with the text client. I have found that if you press [SHIFT][ENTER] the program seg faults. This is consistent behaviour as far as i know. Im running redhat 9 and MySQL 4.0.12-max Does anyone else see this behaviour? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Visual C++ and mysql 'text' type
If I do a query on a table which has a column of the 'text' type, I get the following error: Positioned request cannot be performed because result set was generated by a join condition. This is on a simple select with a join between two tables. I'm using a wrapper class from codeproject.com to connect to the database and perform queries (http://www.codeproject.com/database/odbcrecordset.asp). Queries on the net regarding the error come back mostly with web pages about people trying to do updates on a join, but this is just is just a regular select query. If I change the text to a varchar, the error disappears but the varchar type is limited to 255 characters. If I just do a select on one table (with a 'text' column), there is also no error. Only on a join. Has anyone every seen this issue before? Regards, Collin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MAC OS X Install.
I have installed mysql on OS X server. I used the pkg install. Everything appears to have run fine except when I do safe_mysqld the daed starts and stops. See error log below. Any ideas? 020701 19:46:50 mysqld started 020701 19:46:50 /Library/mySQL/libexec/mysqld: Table 'mysql.host' doesn't exist 020701 19:46:50 mysqld ended 020701 19:47:33 mysqld started 020701 19:47:33 /Library/mySQL/libexec/mysqld: Table 'mysql.host' doesn't exist 020701 19:47:33 mysqld ended - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MAC OS X Server
New error msg, I think I have permissions right 020711 08:37:57 mysqld started 020711 8:37:57 /usr/libexec/mysqld: Can't create/write to file '/usr/var/e-mac .pid' (Errcode: 13) 020711 8:37:57 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 020711 8:37:57 /usr/libexec/mysqld: Error on delete of '/usr/var/e- mac.pid' (E rrcode: 2) 020711 08:37:57 mysqld ended 020711 08:38:46 mysqld started 020711 8:38:46 /usr/libexec/mysqld: Can't create/write to file '/usr/var/e-mac .pid' (Errcode: 13) 020711 8:38:46 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 020711 8:38:46 /usr/libexec/mysqld: Error on delete of '/usr/var/e- mac.pid' (E rrcode: 2) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MAC OS X Server
Got it on a none server machine I had typed my chown without the /P at the end. Also used the package from entropy. I may have used it before. John On Thursday, July 11, 2002, at 08:43 AM, A. John Peters wrote: New error msg, I think I have permissions right 020711 08:37:57 mysqld started 020711 8:37:57 /usr/libexec/mysqld: Can't create/write to file '/usr/var/e-mac .pid' (Errcode: 13) 020711 8:37:57 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 020711 8:37:57 /usr/libexec/mysqld: Error on delete of '/usr/var/e- mac.pid' (E rrcode: 2) 020711 08:37:57 mysqld ended 020711 08:38:46 mysqld started 020711 8:38:46 /usr/libexec/mysqld: Can't create/write to file '/usr/var/e-mac .pid' (Errcode: 13) 020711 8:38:46 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno : 13) 020711 8:38:46 /usr/libexec/mysqld: Error on delete of '/usr/var/e- mac.pid' (E rrcode: 2) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-ajpeters=otg- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlgui crash caused by infinite loop
Description: mysqlgui crash caused by infinite loop in mysql_read_default_options because strcend never returns 0 How-To-Repeat: Fix: --- libmysql/libmysql.c.origThu Feb 14 18:30:17 2002 +++ libmysql/libmysql.c Tue Mar 19 15:52:49 2002 @@ -712,7 +712,7 @@ static void mysql_read_default_options(s *end=0; /* Remove '=' */ } /* Change all '_' in variable name to '-' */ - for (end= *option ; (end= strcend(end,'_')) ; ) + for (end= *option ; (end= strcend(end,'_')) *end; ) *end= '-'; switch (find_type(*option+2,option_types,2)) { case 1: /* port */ --- libmysql_r/libmysql.c.orig Thu Feb 14 18:30:17 2002 +++ libmysql_r/libmysql.c Tue Mar 26 22:52:17 2002 @@ -712,7 +712,7 @@ static void mysql_read_default_options(s *end=0; /* Remove '=' */ } /* Change all '_' in variable name to '-' */ - for (end= *option ; (end= strcend(end,'_')) ; ) + for (end= *option ; (end= strcend(end,'_')) *end; ) *end= '-'; switch (find_type(*option+2,option_types,2)) { case 1: /* port */ Submitter-Id: submitter ID Originator:Peter Strömberg Organization: MySQL support: none Synopsis: mysqlgui crash caused by infinite loop Severity: serious Priority: Category: mysql Class: sw-bug Release: mysql-3.23.49 (OpenBSD port: mysql-server-3.23.49) Server: /usr/local/bin/mysqladmin Ver 8.23 Distrib 3.23.49, for unknown-openbsd3.1 on i386 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.49-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/run/mysql/mysql.sock Uptime: 7 hours 48 min 23 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.000 Environment: System: OpenBSD wilfried.no-ip.org 3.1 GENERIC#3 i386 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-unknown-openbsd3.1/2.95.3/specs gcc version 2.95.3 20010125 (prerelease) Compilation info: CC='cc' CFLAGS='-O2 -pipe ' CXX='cc' CXXFLAGS='-O2 -pipe -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -r--r--r-- 1 root bin 732610 Mar 23 15:16 /usr/lib/libc.a -r--r--r-- 1 root bin 598961 Mar 23 15:16 /usr/lib/libc.so.28.3 Configure command: ./configure --enable-shared --enable-static --localstatedir=/var/mysql --with-innodb '--with-comment=OpenBSD port: mysql-server-3.23.49' --with-libwrap=/usr --with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysql/mysql.sock --without-perl --without-debug --without-readline --without-bench --without-mit-threads --without-gemini --without-berkeley-db --prefix=/usr/local --sysconfdir=/etc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Nusphere is spamming me
This e-mail address is brand new. I used it to subscribe to the MySQL list. I sent one e-mail to the MySQL list. I used it to send two e-mails to my web hosting provider. I used it to send one e-mail to [EMAIL PROTECTED] That's it! No others yet. I know my web hosting provider did not sell my e-mail address to nusphere. I know that php.net did not. They got my brand spanking new e-mail address of of the one post I made to this list. I'm sure that is a violation, it is with most mail lists. If you use MySQL I respectfully ask to to avoid NuSphere. Do not support spammers. This really ticks me off, I mean really ticks me off big time. Have they no shame? If someone at mysql.com would like the e-mail they spammed me with for further investigation, I would be happy to provide it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
pdf and html-split manuals
I'm looking for the pdf and the html-split manuals for MySQL-3.23.44 The one page manual is included in the source distribution, but all I can find on the website for split and pdf versions are for MySQL-4.0 alpha, which I'm not ready to run yet (not that I don't trust them, just that 3.23 stable fits my needs just fine, so I don't feel like playing with devel versions on production machines) Many of my users like the split, and some like it in pdf. I could probably turn either the ps manual or the one page html manual into pdf myself, but it looks like a lot of work to create the split-manual myself (unless someone has a script to do it they are willing to share) Thanks, Michael A. Peters - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Syntax errors when creating HEAP tables and using IF NOT EXISTS
We developed a site using PHP and MYSQL on an online shared server. We used HEAP tables extensively and everything worked fine. When we moved the site to our dedicated server prior to launching the site, the queries that should create the HEAP tables return syntax errors (when submitting the queries with phpMyAdmin). Also, other queries having to do with table creation return syntax errors. Anyone have ideas? We've thought maybe there are permission problems, or else our build of MySQL doesn't support these queries? Or something is wrong in the server config, or in how the host company compiled their MySQL build? The version we developed with was 3.23.21 beta and the version on the shared box is MySQL 3.22.30. Is it possible there are version incompatibilities? On the dedicated server, this query will create a table without errors: CREATE TABLE test (test1 TINYINT (4) UNSIGNED not null ) However, this triggers a syntax error: CREATE TABLE IF NOT EXISTS test (test1 TINYINT (4) UNSIGNED not null ) Here are some other examples of queries that result in errors. 2) This should create a table that is an exact copy of blocking table: CREATE TABLE newtable2 SELECT * FROM blocking Instead of creating the table, it reports a syntax error. 3) This also reports a syntax error: CREATE TABLE test3 TYPE=HEAP MAX_ROWS = 30 SELECT * FROM blocking
Syntax errors when creating HEAP tables and using IF NOT EXISTS
We developed a site using PHP and MYSQL on an online shared server. We used HEAP tables extensively and everything worked fine. When we moved the site to our dedicated server prior to launching the site, the queries that should create the HEAP tables return syntax errors (when submitting the queries with phpMyAdmin). Also, other queries having to do with table creation return syntax errors. Anyone have ideas? We've thought maybe there are permission problems, or else our build of MySQL doesn't support these queries? Or something is wrong in the server config, or in how the host company compiled their MySQL build? The version we developed with was 3.23.21 beta and the version on the shared box is MySQL 3.22.30. Is it possible there are version incompatibilities? On the dedicated server, this query will create a table without errors: CREATE TABLE test (test1 TINYINT (4) UNSIGNED not null ) However, this triggers a syntax error: CREATE TABLE IF NOT EXISTS test (test1 TINYINT (4) UNSIGNED not null ) Here are some other examples of queries that result in errors. 2) This should create a table that is an exact copy of blocking table: CREATE TABLE newtable2 SELECT * FROM blocking Instead of creating the table, it reports a syntax error. 3) This also reports a syntax error: CREATE TABLE test3 TYPE=HEAP MAX_ROWS = 30 SELECT * FROM blocking - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Fwd: DBD::mysql
I haven't done what you are trying to do, but I suspect you will need at least the MySQL-shared libraries on your system. On Tuesday, March 6, 2001, at 06:57 AM, John Tsangaris wrote: Tried sending this once and it didn't go through. - I am trying to install DBD::mysql on a server which does not have mysql on it. ( The script will be accessing a mysql database on another server). The problem is, when I try to install dbd::mysql I am asked several questions.. one of which being: what is the path to mysql? I don't have a path to mysql as it is not installed and I don't want to install it. Is there a way to install DBD::mysql without having to install mysql? John ===END FORWARDED MESSAGE=== - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -=-=-=-=-=-=-=-=-=-=-=-=-=-=- Michael A. Peters Abriasoft Senior Developer http://www.abriasoft.com/ (510) 623-9726x357 Fax: (510) 249-9125 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: phpMyAdmin equivalent
I've gotten thttpd compiled with php running phpMyAdmin beautifully, if you want a small lightweight httpd to use phpMyAmin with. Ive done it with x86 linux, ppc linux, and sparc64 linux. Advanced authentication, everything works swell. I do it with php-4.0.3pl1 with a patch to the php, but I think that patch (which is needed for advanced authentication) is in php 4.0.4pl1. The php source has instructions on how to integrate php into thttpd. Another option is to run php with phpMyAdmin on a different server. Also works well- though you have to give permission for your users who will be using it to connect from the server running the phpMyAdmin. On Monday, March 5, 2001, at 11:35 AM, Frederick L. Steinkopf wrote: Gossamer Threads (http://www.gossamer-threads.com) has an near identical knockoff written in perl calles mysqlman - Original Message - From: "MikemickaloBlezien" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 05, 2001 10:53 AM Subject: phpMyAdmin equivalent Hello All, Was wonder if any knows of a Perl equivalent to the PHP's version of phpMyAdmin?? We use phpMyAdmin but have a project that server doesn't have PHP installed, and frankly, to lazy to do all the typing thru telnet session! :) TIA, Mickalo Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = -=-=-=-=-=-=-=-=-=-=-=-=-=-=- Michael A. Peters Abriasoft Senior Developer http://www.abriasoft.com/ (510) 623-9726x357 Fax: (510) 249-9125 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and restore mysql
Sorry if this is a little late- but at Abriasoft we are currently developing a tool that can be used for automated backup of your MySQL databases from one or more servers with the ability to restore from the backups in the event that you need to. Our tool uses a C daemon and a php web interface (thus requiring php with MySQL support). While the product isn't 100% finished yet, if this is something you would be interested in beta testing for us- please send us a note! You can request to beta test the product at [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Please do not reply to the list, use the e-mail address above, and let us know if you are interested in x86 linux or Windows. On Thursday, January 4, 2001, at 12:43 PM, Ashish Shah wrote: Hi all, How do I backup/restore mysql? Any help would be appriciated. Thanks. = Ashish Toronto, Canada __ Do You Yahoo!? Yahoo! Photos - Share your holiday photos online! http://photos.yahoo.com/ -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: [EMAIL PROTECTED] If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php -=-=-=-=-=-=-=-=-=-=-=-=-=-=- Michael A. Peters Abriasoft Senior Developer http://www.abriasoft.com/ (510) 623-9726x357 Fax: (510) 249-9125 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php