Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2009
    Posts
    519

    Deleted columns_priv table MySQL

    Hi I accidentally deleted the columns_priv table in mysql database. How can I bring it back can anyone show me the structure of that table so I can build it back. Thanks
    Learning...

  2. #2
    Join Date
    Apr 2002
    Location
    Auckland - New Zealand
    Posts
    1,572
    From mysql 5.0.75

    CREATE TABLE `columns_priv` (
    `Host` char(60) collate utf8_bin NOT NULL default '',
    `Db` char(64) collate utf8_bin NOT NULL default '',
    `User` char(16) collate utf8_bin NOT NULL default '',
    `Table_name` char(64) collate utf8_bin NOT NULL default '',
    `Column_name` char(64) collate utf8_bin NOT NULL default '',
    `Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    `Column_priv` set('Select','Insert','Update','References') character set utf8 NOT NULL default '',
    PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`,`Column_name`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Column privileges'

  3. #3
    Join Date
    Mar 2009
    Posts
    519
    My MySQL Version is 5.1 do you think it will work?
    Learning...

  4. #4
    Join Date
    Apr 2002
    Location
    Auckland - New Zealand
    Posts
    1,572
    Yeah, should be ok , the table structure is the same - http://dev.mysql.com/doc/refman/5.1/...structure.html

  5. #5
    Join Date
    Mar 2009
    Posts
    519
    Ok thanks StevenG
    Learning...

Similar Threads

  1. Sorting a table by the results of another table (MySQL/PHP)
    By jon31 in forum Programming Discussion
    Replies: 4
    Last Post: 07-10-2007, 07:51 PM
  2. Synchronize MSSQL Table (DB) with a MySQL Table (DB)
    By kalinga in forum Hosting Security and Technology
    Replies: 0
    Last Post: 03-26-2006, 12:58 AM
  3. Replies: 0
    Last Post: 01-05-2005, 02:35 PM
  4. uploading a table to MySQl
    By sbraun in forum Programming Discussion
    Replies: 13
    Last Post: 05-25-2004, 08:48 AM
  5. mysql no longer works (I had deleted the default mysql db)
    By huh in forum Hosting Security and Technology
    Replies: 2
    Last Post: 07-04-2003, 02:42 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •