Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

How I can create a new MYSQL Database

Discussion in 'Database Discussion' started by malluspecial, Aug 18, 2011.

  1. malluspecial

    malluspecial Registered

    Joined:
    Aug 18, 2011
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    51
    hi

    i purchased a VPS plan + cpanel

    Can you guide me How to create a New MYSQL database and update the database using the backup available in my comouter
     
  2. fi77i

    fi77i Well-Known Member

    Joined:
    Aug 20, 2008
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    56
    Location:
    Uruguay
    cPanel Access Level:
    Root Administrator
    What kind of backup do you have?
    You can use phpmyadmin from your cpanel to import dumps.
    Check import - PmaWiki

    For more cpanel database usage check

    MySQL Databases
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. malluspecial

    malluspecial Registered

    Joined:
    Aug 18, 2011
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    51
    from the cpanel database backup itself
    databasename.sql.gz
     
  4. fi77i

    fi77i Well-Known Member

    Joined:
    Aug 20, 2008
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    56
    Location:
    Uruguay
    cPanel Access Level:
    Root Administrator
    If you have that package you can extract it and restore the sql files using phpmyadmin from your cpanel.
    Go to phpmyadmin and search for Import Database
    You can also run in the console

    mysql -D database < database.sql
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice