09-15-2008, 02:54 PM
|
#1 (permalink)
|
|
Member
Join Date: May 2008
Posts: 195
|
How to import/export ready databases in Cpanel 11?
Hello guys! The situation is the following - I have some databases on local host and now I am going to upload website to hosting! My friend provided me with some place on his hosting account and now I am going to test a website! Could you please explain how should I act with my ready databases if I have Cpanel 11 installed? I don't wish to rewrite them again and just would like to move them from local host to hosting!
|
|
|
|
09-25-2008, 02:37 AM
|
#2 (permalink)
|
|
Junior Member
Join Date: Sep 2008
Posts: 25
|
Re: How to import/export ready databases in Cpanel 11?
From cpanel, go to your mysql databases and then to phpMyAdmin. phpMyAdmin has a utility to export and import the database in various formats like .sql, .csv and a few more.
First export it in .sql format (if you don't already have a DB backup) and then login to your cPanel and go to phpMyAdmin .. say import and provide the .sql file path and name. That's all.
|
|
|
|
|
09-26-2008, 04:28 AM
|
#3 (permalink)
|
|
Junior Member
Join Date: Mar 2008
Posts: 99
|
Re: How to import/export ready databases in Cpanel 11?
Yes, PhpMyAdmin is the best way out in resolving your issue.It is a really helpful and good functional utility.
Here you will find a nice tutorial:
PHPMyAdmin Tutorials | PHPMyAdmin Tutorial | MySQL Web Hosting
When you open it, just click the button phpmyadmin
Hope it will help you 
|
|
|
|
|
10-21-2008, 09:01 AM
|
#4 (permalink)
|
|
Member
Join Date: May 2008
Posts: 195
|
Re: How to import/export ready databases in Cpanel 11?
Quote:
|
Originally Posted by smartidiot
From cpanel, go to your mysql databases and then to phpMyAdmin. phpMyAdmin has a utility to export and import the database in various formats like .sql, .csv and a few more.
First export it in .sql format (if you don't already have a DB backup) and then login to your cPanel and go to phpMyAdmin .. say import and provide the .sql file path and name. That's all.
|
Oh, I see, I will try to select .sql file extension when saving database file! Actually, I don't remember what file extension I selected at that time.
|
|
|
|
|
07-24-2009, 05:22 AM
|
#5 (permalink)
|
|
Member
Join Date: Jul 2009
Posts: 160
|
Re: How to import/export ready databases in Cpanel 11?
With cpanel you should have access to phpmyadmin which will make it extremely simple.
take a backup of the database as it is now, then go to your new cpanel
Just create the DB and user in cpanel, then go to phpmyadmin and click on the db you just created. You should then see links at the top of the screen, click on "import" browse your harddrive for the backup you just made and click "go" that should populate the new db you just made with all the info from the db on the localhost.
|
|
|
|
|
02-11-2011, 10:43 PM
|
#6 (permalink)
|
|
Junior Member
Join Date: Feb 2011
Posts: 19
|
Re: How to import/export ready databases in Cpanel 11?
I want to help you. You can search the Spire.DataExport on the Internet.
|
|
|
|
|
02-15-2011, 09:10 PM
|
#7 (permalink)
|
|
Junior Member
Join Date: Feb 2011
Posts: 19
|
Re: How to import/export ready databases in Cpanel 11?
If you want to export group of data, I suggest to use a C# data export component Spire.DataExport, I use it for a long time, quit good. Now it provides a free version. You may try it. It supports importing/exporting to XLS, PDF, Word and so on. May help to you.
More information:
Free DataExport Component - Free C#/VB.NET/ASP.NET Excel, PDF, Word, HTML, RTF, CSV Component | The Community
If you have questions you may send an email to me. My email address is: tom.lutao@e-iceblue.com
|
|
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
