Reseller Web Hosting Offers:

How do I Upload Data to my MYSQL Database ?


Error: Your Requested widget " bcn_widget-2" is not in the widget list.
  • [do_widget_area colormag_advertisement_above_the_footer_sidebar]
    • [do_widget id="custom_html-10"]
    • [do_widget id="custom_html-11"]
    • [do_widget id="custom_html-13"]
    • [do_widget id="colormag_125x125_advertisement_widget-2"]
    • [do_widget id="text-15"]
    • [do_widget id="custom_html-9"]
    • [do_widget id="custom_html-12"]
  • [do_widget_area colormag_contact_page_sidebar]
    • [do_widget_area colormag_error_404_page_sidebar]
      • [do_widget_area colormag_footer_sidebar_four]
        • [do_widget id="custom_html-3"]
        • [do_widget id="text-7"]
      • [do_widget_area colormag_footer_sidebar_full_width]
        • [do_widget_area colormag_footer_sidebar_one]
          • [do_widget id="custom_html-6"]
          • [do_widget id="custom_html-7"]
          • [do_widget id="custom_html-8"]
          • [do_widget id="text-38"]
          • [do_widget id="text-3"]
          • [do_widget id="text-4"]
        • [do_widget_area colormag_footer_sidebar_one_upper]
          • [do_widget_area colormag_footer_sidebar_three]
            • [do_widget id="custom_html-4"]
            • [do_widget id="text-6"]
          • [do_widget_area colormag_footer_sidebar_three_upper]
            • [do_widget_area colormag_footer_sidebar_two]
              • [do_widget id="custom_html-5"]
              • [do_widget id="text-5"]
            • [do_widget_area colormag_footer_sidebar_two_upper]
              • [do_widget_area colormag_front_page_area_beside_slider]
                • [do_widget_area colormag_front_page_content_bottom_section]
                  • [do_widget_area colormag_front_page_content_middle_left_section]
                    • [do_widget_area colormag_front_page_content_middle_right_section]
                      • [do_widget_area colormag_front_page_content_top_section]
                        • [do_widget_area colormag_front_page_slider_area]
                          • [do_widget_area colormag_front_page_top_full_width_area]
                            • [do_widget id="text-17"]
                          • [do_widget_area colormag_header_sidebar]
                            • [do_widget id="custom_html-2"]
                            • [do_widget id="text-8"]
                            • [do_widget id="text-27"]
                            • [do_widget id="text-23"]
                          • [do_widget_area colormag_left_sidebar]
                            • [do_widget id="text-19"]
                          • [do_widget_area colormag_right_sidebar]
                            • [do_widget id="text-13"]
                            • [do_widget id="search-2"]
                            • [do_widget id="colormag_300x250_advertisement_widget-3"]
                          • [do_widget_area widgets_for_shortcodes]
                            • [do_widget id="breadcrumb_navigation_widget-5"]
                            • [do_widget id="text-16"]
                            • [do_widget id="text-20"]
                            • [do_widget id="text-24"]
                            • [do_widget id="text-25"]
                            • [do_widget id="bcn_widget-2"]
                            • [do_widget id="text-28"]
                            • [do_widget id="text-29"]
                            • [do_widget id="text-30"]
                            • [do_widget id="text-31"]
                            • [do_widget id="text-32"]
                            • [do_widget id="text-33"]
                            • [do_widget id="text-34"]
                            • [do_widget id="text-35"]
                            • [do_widget id="text-37"]
                          • [do_widget_area wp_inactive_widgets]
                            • [do_widget id="text-12"]
                            • [do_widget id="colormag_300x250_advertisement_widget-4"]
                            • [do_widget id="recent-posts-2"]
                            • [do_widget id="recent-comments-2"]
                            • [do_widget id="archives-2"]
                            • [do_widget id="meta-2"]
                            • [do_widget id="pages-3"]
                            • [do_widget id="text-22"]
                          Windows Web Hosting have the easy way of uploading database file in the server using PHPMYADMIN. The below process explanation will help users to upload the database in the Web Hosting Server.


                          Share This Now: [addtoany]

                          Watch Reseller Hosting Video Tutorial



                          Procedure

                          Procedure to Upload Data to my MYSQL Database :

                          Windows Reseller Web Hosting comes with Plesk Control Panel. You will be able to upload mysql database using PhpMyadmin for a particular domain name. Please follow the below procedure to upload mysql database

                          Please note that you can access the MYSQL database using PhpMyadmin

                          [1] Login to your plesk control panel.
                          [2] Click on subscriptions.
                          [3] Click on the domain name.
                          [4] Click on websites and domains
                          [5] Click on databases
                          [6] Click on PhpMyAdmin

                          Exporting tables via phpMyadmin

                          [1] Log in to the phpMyAdmin
                          [2] Click the Export tab
                          [3] From the database drop-down (left navigation), select the database.
                          [4] Choose between a Quick or a Custom export. The Quick method should work most of the time, though if you need to get more granular with your export options, click Custom .If you choose Custom, you can configure the following:

                          Tables: Choose which tables to export.
                          Output: Choose the template, character set, and compression for the export.
                          Format: Choose to display comments, enclose the export in a transaction, disable foreign key checks, dump table (structure, data, or both).
                          Object creation options: Add statements.
                          Data dump options: Use INSERT DELAYED or INSERT IGNORE statements, select the function to use when dumping data,
                          select the syntax to use when inserting data, maximal length of created query.

                          [5] Select the format from the Format drop-down
                          [6] Click the Go button.
                          [7] Save the file

                          Importing tables via PhpMyadmin

                          [1] Log in to phpMyAdmin.
                          [2] Create an empty database from the Databases
                          [3] Click the Import tab.
                          [4] Click the Browse button.
                          [5] Locate the file to be imported.
                          [6] Click Open or OK, depending on your browser.
                          [7] Select the proper collation from the drop-down.
                          [8] Select the format of the import file.
                          [9] Click Go.

                          Screen Shots

                          Refer Screen Shots

                          Troubleshooting FAQs

                          Database Troubleshooting FAQs

                          Getting error : Unknown database

                          Solution :

                          If you are getting the error “Unknown database ” while importing your MYSQL Database it may due to the below reason

                          [1] You may have not created any mysql database in the name

                          To resolve this issue you have to create a mysql database in the corresponding name and after re-attempt your import file .

                          Downloads

                          Related Downloads

                          Related Articles

                          Related Reseller Hosting Support Articles

                          How do I Create a MYSQL Database in a particular domain name ?
                          How do I Import Data from my MYSQL Database ?