Please help: remove prefix of exported database name?

Discussion in 'Databases' started by hungvn9, Jan 11, 2014.

  1. #1
    Hello there,

    When I backup sql database through cpanel, I get a file with name: oldaccount_database (oldaccount is name of my old host account). Now I import that file to new account, then a new prefix is added to that name and it becomes newaccount_oldaccount_database. This is very odd and after many times moving server, I get a very long name. How can I remove the prefix of exported database name?
    Thanks,
     
    hungvn9, Jan 11, 2014 IP
  2. HalfDedi

    HalfDedi Greenhorn

    Messages:
    30
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    8
    #2
    one way is to make a sql dump from phpmyadmin, then open the .sql file and manually rename the database/tables name inside the .sql file

    after that create new database from cpanel with the name you want and import the .sql via phpmyadmin
     
    HalfDedi, Jan 31, 2014 IP