[geeks] MySQL question

[David Selders]

On Wed, May 19, 2004 at 08:20:28PM -0500, Bill Bradford wrote:
> On Wed, May 19, 2004 at 07:20:28PM -0400, Kurt Huhn wrote:
> > Even on same hardware/OS I always dump and reload.  It's just my 
> > comfort level is much higher doing that way.
> 
> Okay, then tell me how to get around this:
> 
> root at habu:/usr/local/mysql/data> ../bin/mysql -p mysql < mysql.sql
> Enter password: 
> ERROR 1050 at line 11: Table 'columns_priv' already exists
> 
> mysql.sql is a dump of the "mysql" privs database from the other box.
> 
> I dont think you can start up mysql *without* already having a 
> "mysql" database.. 
> 
> Bill
> 
> -- 
> bill bradford
> austin texas
> _______________________________________________
> GEEKS:  http://www.sunhelp.org/mailman/listinfo/geeks

I usually dump the data and table structure seperately.  It makes
recreating permissions in the mysql db much much easier.

-- 
David