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 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 privileges tables. You cannot create a > table that already exists, so you must drop it first. When you installed a > mysql instance on the new server of course it put in a mysql database, > that's required. You're now trying to replace it with the mysql database > from your previous instance. You have to replace the old mysql database > with the new mysql database. You do understand the difference between the > mysql *database* and the mysql *instance*, right? > > 2008/8/24 Deniss Hennesy <[EMAIL PROTECTED]> > > I dont understand what you mean by drop table... why i must droped my >> table? cırrent server is running properly.. but either OS version or HW is >> very old. We took new powerfull server, anc we want to migrate our data to >> new server... >> onlt this i want to do it. >> >> >> >> >> 2008/8/22 Jim Lyons <[EMAIL PROTECTED]> >> >> 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]> >>> >>> İ 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 <[EMAIL PROTECTED]>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 < >>>>> [EMAIL PROTECTED]> 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 >>> >> >> > > > -- > Jim Lyons > Web developer / Database administrator > http://www.weblyons.com > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com
