Re: Populate values in an Excel sheet from MySQL
Nick Jones wrote: --- J.R. Bullington [EMAIL PROTECTED] wrote: Automatically populate?? Not that _I_ know of, but of course there are those on this list that know much more than I. I do know that you can export the values into tab delimited format and then import it into Excel. I think that you may want to do this via ASP or PHP. It would make life a lot easier. J.R. PHP would definitely be the way to go on this. I'm working on a web application running on our AS/400 here running Apache, PHP, and MySQL to automate our schedule forms that we fill out daily around here. Everything I've got so far is running through PHP/MySQL so if I can find a way to do this in PHP I'm definitely going to try. I'll google around for awhile and see what I come up with. MS Knowledge Base has proven to be less than useful so far in my endeavor. Also, thanks to James for his suggestion on using the ODBC query directly from Excel. This will get us started for the time being, and give me some leeway so I can work on doing this in PHP. Thanks to you both! -Nick Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs How about this for a novel aproach... Use the CSV storage engine that MySQL provides in the source distribution? It is very easy to use, and there is no headaches. -- Partha Dutta -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Storing manually diggested Passwords with MD5
MySQL actually has an MD5() function:
mysql select MD5('password');
+--+
| MD5('password') |
+--+
| 5f4dcc3b5aa765d61d8327deb882cf99 |
+--+
1 row in set (0.18 sec)
Partha
--
Partha Dutta, Senior Consultant
MySQL Inc, NY, USA, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
-Original Message-
From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 11, 2005 7:21 PM
To: mysql@lists.mysql.com
Subject: Storing manually diggested Passwords with MD5
Hello all,
Is there any function that I could use on a SQL statement to store a
password on a table manually using an algorithm like MD5?
Thanks,
C.F.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: CHECK constraint
Another approach would be to use a view with a CHECK OPTION. This will
allow the view to behave exactly like a check constraint:
CREATE VIEW tblJob_view AS
SELECT JobId, CustomerId, JobType, Description,
QuotationDate, OrderDate
FROM tblJob
WHERE JobType IN ('DesignOnly', 'DesignInstall', 'InstallOnly')
WITH CHECK OPTION
This will force or constraint the view to only accept inserts where the
criteria specified in the WHERE clause matches.
--
Partha Dutta, Senior Consultant
MySQL Inc, NY, USA, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
-Original Message-
From: Michael Kruckenberg [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 25, 2005 10:57 AM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: CHECK constraint
A trigger is a good place to check the value, and change it, bit I
don't believe you can actually generate a MySQL error within the
trigger that will prevent the data from being inserted. Currently
(unless there's been an update to triggers that's not yet in the
docs), you can only change the value before it gets inserted.
If you are looking to enforce the values going into your JobType
column, you might be better off creating a JobType table, with a
foreign key restraint between the tblJob.JobType and JobType.Name,
and make sure that the only entries in the JobType.Name column are
those you want to appear in the tblJob.JobType column.
On Jun 25, 2005, at 10:28 AM, Chris Andrew wrote:
Dear List,
My system is RedHat EL3 and MySQL 5.0.7-beta.
I wanted to implement a check constraint (below), but after some
testing
and googling, it seems I can't do this with MySQL. I've read
suggestions
that check(s) should be done using triggers. Is a trigger a preferred
method of achieving the following:
CREATE TABLE tblJob (
JobId SMALLINT UNSIGNED NOT NULL,
CustomerIdSMALLINT UNSIGNED NOT NULL,
JobType VARCHAR(20) NOT NULL DEFAULT 'DesignInstall',
Description VARCHAR(100) NOT NULL,
QuotationDate DATE NOT NULL,
OrderDate DATE,
CHECK (JobType IN ('DesignOnly', 'DesignInstall', 'InstallOnly')),
PRIMARY KEY (JobId, CustomerId)
) TYPE=InnoDB;
Regards,
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
Mike Kruckenberg
[EMAIL PROTECTED]
ProMySQL Author
http://www.amazon.com/exec/obidos/ASIN/159059505X
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: InnnoDb - change innodb_buffer_pool_size ?
If you are running on a 32 bit operating system, (e.g. Linux) you can not allocate that much memory for InnoDB. The max you could allocate would be 2GB, but that would be pushing it. You also have to account for MyISAM memory usage (key_buffer_size) and per thread memory allocations as well. Partha -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified? www.mysql.com/certification -Original Message- From: Michael Gale [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 10:04 PM To: mysql@lists.mysql.com Subject: InnnoDb - change innodb_buffer_pool_size ? Hello, I am running mysql 4.0.20 with Innodb and we have upgrade grade the RAM in the system from 1GB to 4GB :). Now If I change the: innodb_buffer_pool_size From 500M to 3G the service will not start. I remember reading something about this before and I believe I need to delete the ib_logfile* files or something .. and they will get recreated on start up ?? Any help is appreciated :) Here is my mysql.log output: 050614 19:50:50 mysqld started 050614 19:50:50 Warning: Asked for 196608 thread stack, but got 126976 InnoDB: Fatal error: cannot allocate 3221241856 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 20288332 bytes. Operating system errno: 12 InnoDB: Cannot continue operation! InnoDB: Check if you should increase the swap file or InnoDB: ulimits of your operating system. InnoDB: On FreeBSD check you have compiled the OS with InnoDB: a big enough maximum process size. InnoDB: We now intentionally generate a seg fault so that InnoDB: on Linux we get a stack trace. mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=67108864 read_buffer_size=2093056 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 3546735 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x8424780 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Bogus stack limit or frame pointer, fp=0xbfffeb88, stack_bottom=0x20386365, thread_stack=126976, aborting backtrace. Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x64207369 is invalid pointer thd-thread_id=484 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. 050614 19:50:50 mysqld ended Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Export from Access
I think that the best approach would be to use the MySQL Migration Toolkit. Why spend a lot of time writing a tool when something already exists, and it works with Microsoft Access? http://www.mysql.com/products/migration-toolkit/ -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified? www.mysql.com/certification -Original Message- From: EP [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 2:02 AM To: Josh Trutwin; mysql@lists.mysql.com Subject: Re: Export from Access I recently exported a large Access database to MySQL using MyODBC. It took me a while to figure out that MyODBC was the thing to try, but once I did tried it, it only took me a few minutes to do the export. I highly recommend that approach (MyODBC). -Eric Original Message From: Josh Trutwin [EMAIL PROTECTED] To: mysql@lists.mysql.com Date: Tue, May-17-2005 10:19 AM Subject: Re: Export from Access On Tue, 17 May 2005 17:17:31 +0100 S.D.Price [EMAIL PROTECTED] wrote: Hi, can anyone explain how I would export a database created in Access to MySQL using PHPMyAdmin - I can't seem to import the data as csv or txt. Acess should allow exporting to CSV. Otherwise you can skip phpMyAdmin and just use ODBC - check out MyODBC on mysql.com. Josh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: innodb buffer pool size question
The buffer pool size value is in 16K pages (from SHOW INNODB STATUS output) -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified? www.mysql.com/certification -Original Message- From: Sergei Skarupo [mailto:[EMAIL PROTECTED] Sent: Monday, May 16, 2005 2:18 PM To: Mysql List (E-mail) Subject: innodb buffer pool size question Hi all, I set the innodb_buffer_pool_size=1024M in my.cnf show variables returns . innodb_buffer_pool_size | 1073741824 show innodb status returns -- BUFFER POOL AND MEMORY -- Total memory allocated 1169691576; in additional pool allocated 1041024 Buffer pool size 65536 Free buffers 0 Database pages 65170 Modified db pages 979 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 170494, created 940061, written 2512012 41.96 reads/s, 2.00 creates/s, 0.00 writes/s Buffer pool hit rate 843 / 1000 why is the buffer pool size different? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: auto_increment trouble (not the usual check || alter table solution, though)
This may not be a very elegant solution, but you can do this just to get the inserts going again: ALTER TABLE users MODIFY COLUMN uid INTEGER UNSIGNED NOT NULL AUTO_INCREMENT; If you don't have any negative uids, then you will be able to store 2 billion more uids. Just out of curiosity, have you DROPPED re-created the table? -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified? www.mysql.com/certification -Original Message- From: Ricardo Oliveira [mailto:[EMAIL PROTECTED] Sent: Monday, May 16, 2005 5:00 PM To: mysql@lists.mysql.com Subject: auto_increment trouble (not the usual check || alter table solution, though) Hi everyone, First time on the list, although I've been (quietly) a (not-so)long-time quiet observer. This isn't a FAQ and I can assure you I've tried every procedure out there (both on and off-list) to solve it. A couple weeks ago, I started having problems with a MyISAM table which holds records from user profiles. It's a very simple table, with one auto_increment field and a bunch of other field - nothing out of the ordinary. To those of you familiar with slashcode, it's an old version of the users table: CREATE TABLE users ( uid int(11) NOT NULL auto_increment, nickname varchar(20) NOT NULL default '', realemail varchar(50) NOT NULL default '', fakeemail varchar(50) default NULL, homepage varchar(100) default NULL, passwd varchar(12) NOT NULL default '', sig varchar(160) default NULL, seclev int(11) NOT NULL default '0', matchname varchar(20) default NULL, banned int(11) NOT NULL default '0', permmod int(11) NOT NULL default '0', PRIMARY KEY (uid), KEY login (uid,passwd,nickname), KEY chk4user (nickname,realemail), KEY chk4email (realemail) ) TYPE=MyISAM PACK_KEYS=1; We have about 10k lines (more precisely, 10885 lines). Our code inserts data using a insert into users values (NULL, .) statement which hasn't changed over the last few years. Recently, we started seeing the last record with a _way_ high uid value - more precisely, 2147483647 (which keeps new inserts from happening). Obviously this is a problem with the auto_increment mechanism, and we have followed all the (documented) and traditional approaches, which follow: * search the row with the wrong uid and correct it: - upon inserting a new record, its uid will be 2147483647; * correct the uid and modify the auto_increment value from the table: mysql alter table users AUTO_INCREMENT=10900; Query OK, 10885 rows affected (0.33 sec) Records: 10885 Duplicates: 0 Warnings: 0 mysql show table status like 'users'; +---+++---++-+ -+--+---++ -+-+-++--- --+ | Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +---+++---++-+ -+--+---++ -+-+-++--- --+ | users | MyISAM | Dynamic| 10885 | 68 | 748604 | 4294967295 | 1051648 | 0 | --2147483647-- | 2005-05-16 20:23:49 | 2005-05-16 20:23:49 | 2005-05-16 20:23:49 | pack_keys=1| | +---+++---++-+ -+--+---++ -+-+-++--- --+ * dump the table, make sure it doesn't have any uid above =~10k, delete the table and restore the table (and data) from disk: - data is okay, select * from users where uid11k shows ZERO records - insert into users values (NULL,.) results in a new row with uid=2147483647 * several combinations of CHECK TABLE, myisamchk (-r|-o|), dump remore_wrong_record restore, drop the entire database: - data is OKAY, select results in no records above 11k, next insert will have uid=2147483647 The table fits in about 1MB on disk, and its indexes fit in about 700kB. Does anyone have a clue? Any help is highly appreciated. Best of regards, Ricardo Oliveira PS: Sorry for such a long message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: SLOW SLOW query - please help!
Brian, What is the output of the following: EXPLAIN select * from terms where term like 'Britney Spears' limit 1; Running this statement will produce info on what index path is being used in the query. Also, can you use = instead of like in your query? Partha -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified? www.mysql.com/certification -Original Message- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: Friday, May 13, 2005 2:59 PM To: mysql@lists.mysql.com Subject: SLOW SLOW query - please help! select * from terms where term like 'Britney Spears' limit 1; This is taking anywhere from 35-55 seconds. There are only 350,000 records. Here are the indexes: Keyname = PRIMARY; Type = PRIMARY; Field = id Keyname = term; Type = UNIQUE; Field = term Keyname = category; Type = INDEX; Field = category, ASIN, already_seeded, id, term `term` is a varchar(255). What's wrong?? Any thoughts appreciated. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: stopped while creating index.
What type of table is this? MyISAM or InnoDB? What are your system variable settings when you issued the CREATE INDEX command? If this is a MyISAM table, then MySQL will spend time re-creating the data file first before creating ALL of the indexes including the new one. If you already have indexes on the table, you can speed up some of the processing time: SET SESSION myisam_repair_threads = 2; (This will enable parallel index build for the indexes) SET SESSION myisam_sort_buffer_size = SOME LARGE VALUE; (This buffer will be used during the CREATE INDEX for sorting MyISAM indexes) -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified? www.mysql.com/certification -Original Message- From: Tom [mailto:[EMAIL PROTECTED] Sent: Thursday, May 12, 2005 5:12 AM To: mysql@lists.mysql.com Subject: stopped while creating index. Hey, all. Hardware: Itiaum 2 with 1.3G cpu * 4 and 8G RAM. OS: Red Hat Enterprise Advanced Server 3.0 Mysql: mysql-standard-4.0.24-gnu-ia64-glibc23 I created a index on a large table with more than 100,000,000 records by the following command. mysql create index scn_ra on twomass_scn (ra); It went good within 20 hours although it costs nearly 8G RAM. Then it stopped and the err log say Warning: Enabling keys got errno 116, retrying. It has not gone on by now. I cannot figure out why and I really appreciate any suggestion. Thanks. Eswine. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: UPDATE Query
If you are trying to set the first 6 characters of your column to '11' then you can't use SUBSTRING on the LHS, but only from the RHS: UPDATE CSV_Upload_Data SET PRACT_ASCII = CONCAT(SUBSTRING(PRACT_ASCII, 1, 15), '11', SUBSTRING(PRACT_ASCII, 22)) WHERE Insertion_ID = 190716; -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified? www.mysql.com/certification -Original Message- From: shaun thornburgh [mailto:[EMAIL PROTECTED] Sent: Thursday, May 12, 2005 9:47 AM To: mysql@lists.mysql.com Subject: UPDATE Query Hi, I am getting an error on the following query and but can't understand why, the syntax looks fine to me! mysql UPDATE CSV_Upload_Data SET SUBSTRING(PRACT_ASCII, 16, 6) = '11' WHERE Insertion_ID = 190716; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SUBSTRING(PRACT_ASCII, 16, 6) = '11' WHERE Insertion_ID = 190716' at line 1 mysql Any advice would be greatly appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to put tables on a different drive???
When you create the tables, you can specify the DATA DIRECTORY and INDEX DIRECTORY clause while creating the table to specify different paths. Not sure if it works on Windows though. Should be a simple enough test -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified? www.mysql.com/certification -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 10, 2005 5:58 PM To: mySQL list Subject: How to put tables on a different drive??? I have a big whopping problem.g I have a large database that generates 25gb tables (let's call them GenTable1 to GenTableN). I'd like to put these tables on another drive because I'm running out of disk space. If I need to create another database (let's call it dbGen), so be it. (But it would be nice if it could exist in the same MySQL database, but that doesn't look possible. It appears MySQL forces all the tables to be under the same directory.) How can I get MySQL 4.10 to create the generated tables on another hard drive? The largest hard drive I can get is 320-400gb and that may not be enough for both my normal tables and generated tables. (I'm using Windows XP - NTFS) I need to reference the generated tables and normal tables in a join so it has to be done using 1 MySQL server. So I'd like my normal tables to be on one drive, and my generated tables to be on another drive. Does anyone have any ideas on how to put the GenTables on another drive? TIA Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to check if keys disabled?
You can use the mysqlshow command to list all disabled keys: e.g.: mysqlshow -k world foo When the indexes are displayed the word disabled will be in the comment field -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified? www.mysql.com/certification Victor Pendleton wrote: Try show index from t1; Show index from t2; Hi Victor, Nope, this does not help. t1 has key disabled, t1 enabled, and the result is the same: mysql show index from t1\G *** 1. row *** Table: t1 Non_unique: 0 Key_name: PRIMARY Seq_in_index: 1 Column_name: x Collation: A Cardinality: 0 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: 1 row in set (0.00 sec) mysql show index from t2\G *** 1. row *** Table: t2 Non_unique: 0 Key_name: PRIMARY Seq_in_index: 1 Column_name: x Collation: A Cardinality: 0 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: 1 row in set (0.00 sec) cheers, Jacek -Original Message- From: Jacek Becla [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 03, 2005 4:00 PM To: Jay Blanchard Cc: [EMAIL PROTECTED] Subject: Re: how to check if keys disabled? Jay Are you sure? DESCRIBE tells me the table has an index, but not whether the index is enabled or not: mysql create table t1 (x int primary key); Query OK, 0 rows affected (0.01 sec) mysql create table t2 (x int primary key); Query OK, 0 rows affected (0.01 sec) mysql alter table t1 disable keys; Query OK, 0 rows affected (0.00 sec) mysql describe t1; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | x | int(11) | NO | PRI | | | +---+-+--+-+-+---+ 1 row in set (0.00 sec) mysql describe t2; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | x | int(11) | NO | PRI | | | +---+-+--+-+-+---+ 1 row in set (0.00 sec) Am I missing something? thanks, Jacek Jay Blanchard wrote: [snip] How can I find out if keys are enabled/disabled for a given table? Suppose I do: create table t1 (x int primary key); create table t2 (x int primary key); alter table t1 disable keys; How can I now find out that t1 has keys disabled, and t2 enabled? [/snip] DESCRIBE t1 or DESCRIBE t2
RE: Foreign Key Restriction
You can turn off foreign key restrictions within your session: SET SESSION foreign_key_checks = 0; Then later, turn them back on using SET SESSION foreign_key_checks = 1; -- Partha Dutta, Senior Consultant MySQL Inc, NY, USA, www.mysql.com Are you MySQL certified? www.mysql.com/certification -Original Message- From: news [mailto:[EMAIL PROTECTED] On Behalf Of Oliver Hirschi Sent: Wednesday, May 04, 2005 10:50 AM To: mysql@lists.mysql.com Subject: Re: Foreign Key Restriction Oliver Hirschi [EMAIL PROTECTED] schrieb im Newsbeitrag news:[EMAIL PROTECTED] Hi I updated mySQL 4.0.8 to 4.1.1 and I have now problems with foreign key retrictions. Is it right, that mySQL 4.1.x has something changed due to the foreign key restriction? Is there an option to turn off the foreign key restriction in mySQL 4.1.1? I found the mistake. There was an INSERT and a foreign-key was setted to the value 0. It seems, this was possible with mySQL version 4.0.8, but not anymore in version 4.1.x. Does anybody known something about that? Thanks, Oliver Hirschi -- 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]
Using a hardware load balancer in from of MySQL
Hello all, I would like to find out if anyone has implemented an architecture where a hardware load balancer is placed in front of some MySQL servers in a Multi-master replication scheme. I want to use the load balancer more for high availability, than for load balancing. All connections to the database server would go the mysql server 1. If server1 fails, the load balancer should send all connections to server 2, etc. Thanks for any insight on any implementation gotchas. Partha Dutta Bloomberg, L.P. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
