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
