[geeks] MySQL question

[Caleb Shay]

Bill Bradford wrote:
> 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

use "mysqldump --add-drop-table" when making your dump and it will add a 
  "DROP TABLE IF EXISTS" before all the table creation queries.

My standard line for backing up my mysql servers is:

mysqldump -AacCe --allow-keywords --add-drop-table


Cheers,

Caleb