post your comment   print   send to a friend
Rate:  40% | Views: 4353
Question categories:  MySQL

Can I import an existing database into mysql using phpmyadmin?

Answer by: Stuart Pierce, Aplus.Net Knowledge Base Support

Using the phpMyAdmin authoring tool you can easily import/add an existing database to your current database. The only restriction is that this file has to be of either .SQL or .PHP type. If your database file is of a different type, you will need first to convert it before importing to phpMyAdmin.

Please have in mind the fact that you can have only one database per shared hosting account.

phpMyAdmin is located on your shared hosting server. The URL should be http://hosting-server/phpmyadmin. You will have to login using your MySQL database username and database password. Note: Replace hosting-server with the IP address or the hostname of the server which hosts your web space.

Alternatively, you can login to phpMyAdmin using the Aplus.Net Control Panel:

  1. Start by logging into the Aplus.Net Control Panel at http://cp.aplus.net using your Registration Number and Customer Password.
  2. Select Web Hosting from the top navigation bar.
  3. Next, select Hosted Domains and click on Manage Hosted Domains.
  4. Now, select the hosted domain that you’d like to manage.
  5. Next, click the MySQL Database Manager icon.
  6. You will be automatically redirected to the phpMyAdmin administration tool.

Once you have logged in to phpMyAdmin, please follow the instructions below on how to import a .sql or .php database file.

  1. Click on the SQL Query window from the top navigation bar.
  2. Browse to the file on your local computer (Max. size is about 8 MB).
  3. Click Go to import your file to your current database.

Another option is to load the database file using the Shell access included in the Business Class Unix, Pro and eCommerce Unix shared hosting plans. You can find information on how to do that in the following Knowledge base document:

Related links:

Customer Feedback
Rate:  40% | Views: 4353 | Please Rate:  
 
If you have other comments or ideas for future technical tips, please type them here:

Email: (optional)

Comments: (optional)

 Server Hosting | Domain Hosting    Back to serch results
Browse the Base
Knowledge Base
Shared Hosting
  Unix Plans
    MySQL
Messages
 

FREE traffic-retaining tools

You work hard to get visitors to your site. Why not try to keep them there? Aplus.Net has FREE tools to keep visitors in case of errors. For example, the Custom Error Pages Manager allows you to create a customized error message to explain the problem, and the Re-Direct URL tool to help guide a lost visitor. Your visitors will appreciate it! Check them out under the "Setup" tab in the Control Panel!
More info...

Private Area
 
Ask
in Private
   
Personal
Folder
 
Related Questions
 
1. How to set up an additional MySQL Database?
 
2. How do I get MySQL access?
 
3. What is the size limit for MySql Databases?
 
4. Where can I get a good MySQL authoring tool?
 
5. What is the size limit (in Megabytes) for MySql Databases under the plans that support MySQl Databases?
 
Home Browse Search Ask in Private Personal Folder   Help
powered by web hosting 
  Logged as: Guest