How do I Upload Data to my MYSQL Database ?
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
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 ?