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

[Jim Lyons]

As I said, it appears your mysqldump output is not doing a "DROP TABLE"
before each create.  You need to correct that.  Do the drop table commands
yourself, then load the tables.  Afterwards, do a "FLUSH PRIVILEGES" to
activate the new permissions.l

2008/8/22 Deniss Hennesy <deniss.hennesy@stripped>

> İ am migrating database from mysql-client-4.0.20 running server(current) to
> mysql-client-5.0.51a running server(new) ..i ve took mysqldump and
> transfered to new server and restored but process broken up with this error
> message.
>
>
>
>
>
> On Fri, Aug 22, 2008 at 6:33 PM, Jim Lyons <jlyons4435@stripped> wrote:
>
>> 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 <
>> [e-mail]> 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
>>
>
>


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