Re: external mysqldump

2008-02-20 Thread Simon Elliston Ball
, but it will achieve the permissions you need without giving away all the data as well. Simon Simon Elliston Ball [EMAIL PROTECTED] On 20 Feb 2008, at 12:03, Andre Hübner wrote: i tried, but always got error: ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES i followed this and did

Re: transfer huge mysql db

2008-01-24 Thread Simon Elliston Ball
[EMAIL PROTECTED] 'cat - | bzip2 -9dc | mysql -uwhatever etc' assuming of course that you have nice fast processors and horrible slow connectivity (gzip, and something less severe than 9 would do almost as well) simon Simon Elliston Ball [EMAIL PROTECTED] On 24 Jan 2008, at 12:20

Re: MySql on Leopard

2007-12-07 Thread Simon Elliston Ball
The easiest way to get mysql working on os x is with a fink build. The version is a little behind 5.0.38, but I can't imagine there would be any problems with a source build from the latest. Maybe you could give it a go, and report any problems, then I'll happily help out. Simon Elliston

Re: Adding data from one table to another

2006-01-11 Thread simon elliston ball
The easiest way to do that would be to CREATE TABLE new_table_name SELECT (query you use to join the tables) The old tables then become redundant. On 11 Jan 2006, at 17:30, 2wsxdr5 wrote: I have two tables with data on people in them. Table A is a subset of table B, However, there is