changing database name in mysql

Discussion in 'OT Technology' started by hurleyint1386, May 5, 2007.

  1. hurleyint1386

    hurleyint1386 Someone has sand in their vagina

    Joined:
    Jan 6, 2005
    Messages:
    3,687
    Likes Received:
    0
    Location:
    Rochester, NY
    hey, is there any ways I could change the name of a database in mysql? i'd rather not delete it and re-insert everything all over again

    edit: i mean table, not database. sorry
     
    Last edited: May 5, 2007
  2. P07r0457

    P07r0457 New Member

    Joined:
    Sep 20, 2004
    Messages:
    28,491
    Likes Received:
    0
    Location:
    Southern Oregon
    not that I'm aware of.
     
  3. hurleyint1386

    hurleyint1386 Someone has sand in their vagina

    Joined:
    Jan 6, 2005
    Messages:
    3,687
    Likes Received:
    0
    Location:
    Rochester, NY
    sorry, i found it. simply: rename database [table name] to [new table name]
     
  4. P07r0457

    P07r0457 New Member

    Joined:
    Sep 20, 2004
    Messages:
    28,491
    Likes Received:
    0
    Location:
    Southern Oregon
    that works for TABLES but not for DATABASES.
     
  5. Peyomp

    Peyomp New Member

    Joined:
    Jan 11, 2002
    Messages:
    14,017
    Likes Received:
    0
    Don't you dare deny jolly's right to shit on someone or correct them. Its where he gets his self-esteem from. You trying to take away his self esteem? Whats wrong with you!?
     
  6. CyberBullets

    CyberBullets I reach to the sky, and call out your name. If I c

    Joined:
    Nov 13, 2001
    Messages:
    11,865
    Likes Received:
    0
    Location:
    BC, Canada/Stockholm, Sweden
    read up ALTER TABLE
     
  7. P07r0457

    P07r0457 New Member

    Joined:
    Sep 20, 2004
    Messages:
    28,491
    Likes Received:
    0
    Location:
    Southern Oregon
    I had loaded a bunch of threads in tabs, walked away for a few mins, then came back and posted. He edited AFTER I loaded the tabs :rolleyes:
     
  8. hurleyint1386

    hurleyint1386 Someone has sand in their vagina

    Joined:
    Jan 6, 2005
    Messages:
    3,687
    Likes Received:
    0
    Location:
    Rochester, NY
    as i stated above, i was able to change the table name simply using "rename" so everything is working well now. thanks to everyone
     

Share This Page