From: Date: August 22 2008 5:33pm
Subject: Re: ERROR 1050 ( ) at line : Table 'columns_priv' already exists
List-Archive: http://lists.mysql.com/mysql/214208
Message-Id: <425b1d300808220833o3ecfc457s8ae2efc82de02cbf@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_6115_24424536.1219419224697"

------=_Part_6115_24424536.1219419224697
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_6115_24424536.1219419224697--