Re: normalised designs: customer database
Jujitsu Lizard wrote: On Sat, Nov 15, 2008 at 3:54 AM, metastable [EMAIL PROTECTED] wrote: I may just have had an insight over my morning coffee. How about turning things around and adding a FK -to the customers table- on each of the customer type tables (companies, people, charities, etc) ? The customers table would have no idea if a customer is corporate or private, it just has a customer number that can be used in processing invoices and performing account maintenance. The companies, people, charities, etc. tables would each have a FK to the customers table. This does off course mean that creating and sorting a list of all customers is more complex, but the database would at least be normalised. What do you think ? I think you just made my point. You now recognize that designing it right introduces other complexities. With the problem you presented, it is just a matter of where you want to get tasered. There isn't a solution that optimizes all parameters. Hey, I have to disagree. Any application is and always will be complex. Having the database refuse to screw itself up whenever the programmer makes a mistake, and he/she always will, is a great step towards the goal of simplification and robustness. Moreover, apart from the sorting problem in this design, I think the set of queries in general is much more simple than it would have been had I used one of the options from my previous line of thinking. I think you can never go wrong with normalized databases. Anyway, I think my question has been answered. Always nice to answer your own questions :) Thanks for all the comments. Best regards, Stijn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Is it a bug or my mistake in server configuration?
On Mon, Nov 10, 2008 at 08:23:24PM +0300, Alexey Vlasov wrote: DBI connect('database,...) failed: Can't create a new thread (errno 12); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug at ... I just thought, all this can be a result of dumping of one big base (~6G). But it's still not clear what memory limit was reached. I still continue observing the situation. -- BRGDS. Alexey Vlasov. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 2006 (HY000): MySQL server has gone away
Hello Greetings , I got about three blocks of errors like the following while trying to import a table full of attachments, mostly images. I am running on an XP configured with a WAMPSERVER so I am a little unclear about why the no connection. I was importing directly using the MySQL CLI. The Table is 360megs and this error occurred about three times in the import. I even tried using bigdump to import it but soon after it started, it did a binary dump to the screen and failed. ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:12 Current database: worldrac_forum ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:13 Current database: worldrac_forum ERROR 2006 (HY000): MySQL server has gone away ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:14 Current database: worldrac_forum Any ideas how to troubeshoot this or what the problem might be? TIA -- Best regards, mikesz mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 2006 (HY000): MySQL server has gone away
can u please give us the command used to take dump On 11/17/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello Greetings , I got about three blocks of errors like the following while trying to import a table full of attachments, mostly images. I am running on an XP configured with a WAMPSERVER so I am a little unclear about why the no connection. I was importing directly using the MySQL CLI. The Table is 360megs and this error occurred about three times in the import. I even tried using bigdump to import it but soon after it started, it did a binary dump to the screen and failed. ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:12 Current database: worldrac_forum ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:13 Current database: worldrac_forum ERROR 2006 (HY000): MySQL server has gone away ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:14 Current database: worldrac_forum Any ideas how to troubeshoot this or what the problem might be? TIA -- Best regards, mikesz mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A tool
Hi all, If you are using mysql in linux with ext3 file system,then this might help. I have written a undelete tool. [Short functionality is ,once installed files can be recovered using the tool but files deleted before installation can't be recovered. It acts as a fail-safe.] I tried it with mysql,for screenshots check here, http://www.giis.co.in/giis_mysql_screenshots.html You can download it from http://sourceforge.net/projects/giis or from here www.giis.co.in I have recovered only tables and not yet started with complete databases, based on your comments i hope to decided on futher enhancements. (If you have already such functionality available ,please let me know - as there is no point in reinventing the wheel :) ) (ps:I posted the similar message few days back on the forum ..but didn't received any comments/info..so i'm here :) ) Cheers, Lakshmipathi.G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 2006 (HY000): MySQL server has gone away
Hi Mikesz, Try increasing the *max_allowed_packet* value in *my.ini *and bounce the server. Explaination - if you send a query (specially via compressed packets) to the server that is larger than the max_allowed_packet, it drops the connection without providing a good error message. A packet too large is handled the same way as a bogus packet - there's no knowing if the connection is still good or what is going on, so the easiest way for the server is just to drop the connection and move along. The easy way to avoid this problem is to ensure that max_allowed_packet is set bigger in the mysqld server than in the client and that all clients uses the same value for max_allowed_packet. Let us know if this works for you. Thanks, Uma On 11/17/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello Greetings , I got about three blocks of errors like the following while trying to import a table full of attachments, mostly images. I am running on an XP configured with a WAMPSERVER so I am a little unclear about why the no connection. I was importing directly using the MySQL CLI. The Table is 360megs and this error occurred about three times in the import. I even tried using bigdump to import it but soon after it started, it did a binary dump to the screen and failed. ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:12 Current database: worldrac_forum ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:13 Current database: worldrac_forum ERROR 2006 (HY000): MySQL server has gone away ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id:14 Current database: worldrac_forum Any ideas how to troubeshoot this or what the problem might be? TIA -- Best regards, mikesz mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]