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.

Root - PhpMyadmin

Discussion in 'MySQL' started by Earning, May 6, 2008.

  1. #1
    Hi,
    I have a question!

    I have a server, I want to import a db from phpmyadmin but when I want to goto phpmyadmin it says no access with root!
    But I have logged in with user/pass not with root/pass

    Any idea?
    SEMrush
     
    Earning, May 6, 2008 IP
    getjimmy likes this.
    SEMrush
  2. Trusted Writer

    Trusted Writer Banned

    Messages:
    1,370
    Likes Received:
    52
    Best Answers:
    0
    Trophy Points:
    160
    #2
    Have you granted yourself access as root user either via Webmin of root Cpanel?

    It seems to me just a matter of user/database permissions, but if you are able to login with your username and password you can import your database using bigdump, just open the file to fill in the corresponding settings.

    Bigdump is available here, www.ozerov.de/bigdump.php
     
    Trusted Writer, May 6, 2008 IP
  3. scutari

    scutari Peon

    Messages:
    431
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #3
    how can you import database and why import it?
     
    scutari, May 8, 2008 IP
  4. Trusted Writer

    Trusted Writer Banned

    Messages:
    1,370
    Likes Received:
    52
    Best Answers:
    0
    Trophy Points:
    160
    #4
    With bigdump you simply modify the file to reflect you MySQL settings, upload your script and your database file. Then you call the script from your browser, choose the sql file to import and the script does the rest of the job.

    Why should you import a database?
    Mainly when you are recreating such db from one hosting service to another, or when you need to restore a db which data was corrupted or a database mistakenly deleted.
     
    Trusted Writer, May 9, 2008 IP