>-----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's failing evidently is the 'create table >columns_priv', not a drop table. Sorry for the typo. > [JS] Are you running as root, or whichever user has full privileges? It's easy to make that mistake, and you'll get a lot of barking and growling.
>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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
