All Dear friends
İ am mentioning that 2 different server
one is running on mysql 4.1 (Current) (dumped)
the other is 5.1..xxx (New) (restored)
İ solved my problem in such a way that i droped in my new server mysql and
test databases
mysql> show databases;
+---
>-Original Message-
>From: Jim Lyons [mailto:[EMAIL PROTECTED]
>Sent: Sunday, August 24, 2008 12:00 PM
>To: Deniss Hennesy
>Cc: mysql
>Subject: Re: ERROR 1050 ( ) at line : Table 'columns_priv' already
>exists
>
>correction, the command that
correction, the command that's failing evidently is the 'create table
columns_priv', not a drop table. Sorry for the typo.
2008/8/24 Jim Lyons <[EMAIL PROTECTED]>
> The command that's failing evidently is the "drop table columns_priv" which
> is why you're getting the error message:
>
> *ERROR 1
The command that's failing evidently is the "drop table columns_priv" which
is why you're getting the error message:
*ERROR 1050 ( ) at line : Table 'columns_priv' already exists*
I assume you're trying to restore the mysql database from a backup and the
script is trying to re-create the privileg
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 <[EMAIL PROTECTED]>
>
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