Re: ERROR 1050 ( ) at line : Table 'columns_priv' already exists

[Jim Lyons]

You're restoring the mysql database itself, do you mean to do this?  You
probably do if it's a new server but there already exists a mysql database
so, unless your restore program does "DROP TABLE" before each create, you'll
keep getting this error.

On Fri, Aug 22, 2008 at 10:22 AM, Deniss Hennesy
<deniss.hennesy@stripped>wrote:

> Hi  to list
>
> i ve installed new server. while i was restoring my backup to this server.
> i  took this error and restoring procees is to stop.
>
> *ERROR 1050 ( ) at line : Table 'columns_priv' already exists*
>
>
> My old server mysql version is   mysql-client-4.0.20       is running on
> old
> server  but mysql-client-5.0.51a  is running now
>
> what can i do
>
> regards
>



-- 
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com