1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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,
    SEMrush
     
    hungvn9, Jan 11, 2014 IP
    SEMrush
  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