WHRForums.com
February 07, 2012, 08:20:08 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Due to rampant abuse by bots several measures had to be taken, some quite drastic. Many old or inactive accounts have been removed. Feel free to re-register if you want to join discussions.
 
   Home   Help Search Login Register  

Advertisements

eCommerce Web Hosting - Interspire, X-Cart, SunShop, Magento, osCommerce; we host them all! | Hands-on Web Hosting
G.C. Solutions-Traditional - Cloud Based Shared Web Hosting
WHRForums.com > Discussion Forums > Hosting related discussions > How to export/import databases in Cpanel 11 correctly?
Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: How to export/import databases in Cpanel 11 correctly?  (Read 1681 times)
andreyknure
Ex - New Member
**
Offline Offline

Posts: 15
« on: September 15, 2008, 11:44:12 AM »
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!
Logged
http://onestopmarketing.com/ - internet marketing services!
http://webservicetoday.com/ - update your websites easily!
ldcdc
Administrator
Middleweight Reviewer
*****
Offline Offline

Posts: 420



WWW
« Reply #1 on: September 16, 2008, 01:45:05 PM »
While I haven't done it in this fashion before (had no need to with phpmyadmin always available), you could do a mysql dump (http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html) on the localhost and a restore on the new server. The restore should be doable via phpmyadmin, or you could also ask your host (or rather your friend's host) to do the restore for you.
Logged
Daniel
HostPeek.com - best web hosting services
CouponsNexus.com - web hosting coupons | UltraCheapHosts.com - about very cheap hosts
andreyknure
Ex - New Member
**
Offline Offline

Posts: 15
« Reply #2 on: September 29, 2008, 12:19:13 PM »
The situation is the following I used phpmyadmin 2.11.5 on localhost when creating databases, but I have phpmyadmin 2.11.6 installed on my hosting account. I am planning to upload databases to hosting really soon and I have some questions about uploading databases to hosting. Can phpmyadmin version difference cause any problems when importing databases to hosting account?
Logged
http://onestopmarketing.com/ - internet marketing services!
http://webservicetoday.com/ - update your websites easily!
ldcdc
Administrator
Middleweight Reviewer
*****
Offline Offline

Posts: 420



WWW
« Reply #3 on: September 29, 2008, 04:52:17 PM »
I don't suppose there will be issues. Nothing is 100% sure though. Smiley
Logged
Daniel
HostPeek.com - best web hosting services
CouponsNexus.com - web hosting coupons | UltraCheapHosts.com - about very cheap hosts
hexahost
New member
*
Offline Offline

Posts: 7
« Reply #4 on: January 26, 2009, 12:07:02 AM »
In your localhost you will have your shell access right ? Use mysqldump to export database to a .sql file and use this file to import database using phpmyadmin. This should work for all versions.
Logged
mwaraitch
Definitely Hooked
****
Offline Offline

Posts: 155


WWW
« Reply #5 on: November 27, 2011, 11:49:43 PM »
You can simply login to your cpanel, and goto phpmyadmin and import your database .sql file into it, thats it, The newer version does not matters, while if you have old one then there might be a problem,
Logged
Web Hosting Pakistan | Web Hosting Canada | Website Design
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.16 | SMF © 2011, Simple Machines Valid XHTML 1.0! Valid CSS!
Page created in 0.11 seconds with 19 queries.