Managing MySQL databases with phpMyAdmin in cPanel

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
  • VodaHost
    General & Forum Administrator

    • Mar 2005
    • 12356

    Managing MySQL databases with phpMyAdmin in cPanel



    what is cpanel

    This tutorial will guide you on how to manage MySQL databases with phpMyAdmin in cPanel. For the purpose of this guide, we'll presume that you're currently in cPanel hosting and therefore are viewing the primary display.

    Let us begin to learn how to manage MySQL databases with phpMyAdmin in cPanel. Scroll down the cPanel hosting screen and select the phpMyAdmin icon underneath the Databases category within your cPanel hosting. Once you have selected phpMyAdmin a new display will appear the phpMyAdmin main screen.

    Let's choose 'test' as the database we wish to manage on the left hand side of the screen. Since there are currently no tables in this database, as indicated here, we can create a new table here; but we will not proceed with that at this point.

    Select the SQL tab on the top of the screen. Then select Browse so we can search for a database to upload. Let's upload the test.sql database we've previously saved by selecting test.sql and then select open. To complete the upload, click Go. The SQL query has been executed successfully of the database called test.sql, which now has a table called table1 in it.

    On your left hand side of the screen under the database test(1), select the table named table1. On this page you will see all the details of table1 within the database test.sql.

    We shall now learn how to save the table1 to our personal computer. Select the Export tab on the top of the screen. Scroll down the page and select Save as file box then select the Go button. A security warning will appear for you to select if you wish to save this file or not; select Save and Save again in the Save in File. You will see that table1 has successfully been saved by the small pop-up window stating Download Complete. Select Close.

    If at any time you wish for help within phpMyAdmin or MySQL you may select one of the help buttons (the button with a ? or the button with SQL) located on the top left hand side of the screen.

    Now select the green Exit button located on the top left of the screen, next to the home button and before the help buttons. We have now successfully signed out of phpMyAdmin main screen and returned to cPanel hosting page. This is the end of the tutorial. You now know how to manage MySQL databases with phpMyAdmin in cPanel.


    If you need any further assistance on how to manage MySQL databases with phpMyAdmin in cPanel,
    please feel free to ask them on this thread!


    How to install FrontPage extensions in cpanel

    VodaHost

    Your Website People!
    1-302-283-3777 North America / International
    02036089024 / United Kingdom
    291916438 / Australia

    ------------------------

    Top 3 Best Sellers

    Web Hosting - Unlimited disk space & bandwidth.

    Reseller Hosting - Start your own web hosting business.

    Search Engine & Directory Submission - 300 directories + (Google,Yahoo,Bing)


  • gilbert4voice
    Private

    • Oct 2011
    • 1

    #2
    Re: Managing MySQL databases with phpMyAdmin in cPanel

    how can i get phpformgenerator v2.09 online ????

    Comment

    • navaldesign
      General & Forum Moderator

      • Oct 2005
      • 12080

      #3
      Re: Managing MySQL databases with phpMyAdmin in cPanel

      Originally posted by gilbert4voice View Post
      how can i get phpformgenerator v2.09 online ????
      You can install it automatically through Fantastico.

      In the future pls don't post thread unrelated issues, create a new thread in the appropriate forum.
      Navaldesign
      Logger Lite: Low Cost, Customizable, multifeatured Login script
      Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
      DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
      Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!

      Comment

      Working...
      X