Welcome to the JaguarPC Community
JaguarPC
Sales: (888) 338-5261
Support: (888)-551-3050
Results 1 to 8 of 8

This is a discussion on How do I... in the Shared & Semi-Dedicated forum
... change the name of a database? I have copied a database for backup and now I need to rename it to something else. I've ...

  1. 05-24-2005, 04:27 PM #1
    DSD
    DSD is offline
    JPC Member
    Join Date
    Apr 2004
    Posts
    41

    Arrow How do I...

    ... change the name of a database? I have copied a database for backup and now I need to rename it to something else. I've tried renaming via myphpadmin and it says I don't have permissions to rename.

    Thanks in advance!
    Reply With Quote Reply With Quote
  2. 05-24-2005, 08:59 PM #2
    Vin DSL
    Vin DSL is offline
    Yeah, I know a LOT! Vin DSL's Avatar
    Join Date
    Mar 2003
    Location
    Arizona Uplands
    Posts
    10,775
    Hrm...

    I guess I would do a dump, delete the old db, make a new one, then import the data into it...
    DISCLAIMER Any resemblance between the views expressed above and those of the owners and operators of this system is purely coincidental. Any resemblance between these views and my own are non-deterministic. The existence of Vin DSL is questionable. The existence of views in the absence of anyone to hold them is problematic. The existence of the reader is left as an exercise in the second-order coefficient.

    No Guts, No Story! VinDSL © 2010
    Reply With Quote Reply With Quote
  3. 05-24-2005, 09:31 PM #3
    DSD
    DSD is offline
    JPC Member
    Join Date
    Apr 2004
    Posts
    41
    That will work fine unless your database file is approx. 35mb. Then that won't work. I just thought that if I could rename the database it would be the easiest.
    Reply With Quote Reply With Quote
  4. 05-24-2005, 10:02 PM #4
    jason
    jason is offline
    Community Leader jason's Avatar
    Join Date
    Sep 2001
    Location
    Rochester, NY
    Posts
    6,003
    I do't think you can rename the databse yourself, but support might be able to. Never hurts to open a ticket and ask.

    --Jason
    Jason Pitoniak
    Interbrite Communications
    www.interbrite.com www.kodiakskorner.com
    Reply With Quote Reply With Quote
  5. 05-24-2005, 11:16 PM #5
    DSD
    DSD is offline
    JPC Member
    Join Date
    Apr 2004
    Posts
    41
    Thanks, I'll give it a try...
    Reply With Quote Reply With Quote
  6. 05-25-2005, 06:34 AM #6
    Vin DSL
    Vin DSL is offline
    Yeah, I know a LOT! Vin DSL's Avatar
    Join Date
    Mar 2003
    Location
    Arizona Uplands
    Posts
    10,775
    Quote Originally Posted by DSD
    That will work fine unless your database file is approx. 35mb. Then that won't work. I just thought that if I could rename the database it would be the easiest.
    Ah, okay... you must be using the phpMyAdmin in cPanel. That's the problem...
    DISCLAIMER Any resemblance between the views expressed above and those of the owners and operators of this system is purely coincidental. Any resemblance between these views and my own are non-deterministic. The existence of Vin DSL is questionable. The existence of views in the absence of anyone to hold them is problematic. The existence of the reader is left as an exercise in the second-order coefficient.

    No Guts, No Story! VinDSL © 2010
    Reply With Quote Reply With Quote
  7. 05-25-2005, 09:17 AM #7
    DSD
    DSD is offline
    JPC Member
    Join Date
    Apr 2004
    Posts
    41
    Yep, I'm using phpmyadmin in cpanel.

    What way were you talking about?
    Reply With Quote Reply With Quote
  8. 05-25-2005, 10:13 AM #8
    gerilya
    gerilya is offline
    Jag Veteran
    Join Date
    Sep 2002
    Posts
    650
    I don't think asking support to rename the database is a good idea: renaming a DB using direct access to MySQL might confuse CPanel and mess things up.

    SSH into your account and make DB dump using command line utility called 'mysqldump'.
    Then create a new DB via control panel and import the dump into the new database.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules