The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How I can create a new MYSQL Database

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

  1. malluspecial

    malluspecial Registered

    Joined:
    Aug 18, 2011
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    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:
    6
    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
     
  3. malluspecial

    malluspecial Registered

    Joined:
    Aug 18, 2011
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    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:
    6
    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
     
Loading...

Share This Page