hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : VPS Hosting : who knows how to import a large database on VPS via SSH
Reply

Forum Jump

who knows how to import a large database on VPS via SSH

Reply Post New Thread In VPS Hosting Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 10-27-2011, 10:36 AM
ciul3x ciul3x is offline
Newbie
 
Join Date: Oct 2011
Posts: 5

who knows how to import a large database on VPS via SSH


Hello
I bought vps. and I want to import a database large vps via SSH, I tried but I failed. who can help me. remain indebted. please
Thanks



Sponsored Links
  #2  
Old 10-27-2011, 10:42 AM
Martin-D Martin-D is offline
The VPS Specialist
 
Join Date: Aug 2003
Location: Edinburgh/London
Posts: 4,891
Are you trying to move a DB from one VPS to another?

Maybe I'm picking you up wrong.

__________________
miniVPS - UK Based Value and Premium VPS Servers!
NodeDeploy - DE Based 2GB VPS Servers (OpenVZ/KVM).
Xavvo.com Innovative Hosting for Innovative People!

  #3  
Old 10-27-2011, 10:43 AM
ciul3x ciul3x is offline
Newbie
 
Join Date: Oct 2011
Posts: 5
thanks

Thank you brother. I'll see what I can do

Sponsored Links
  #4  
Old 10-27-2011, 10:45 AM
MichelleH MichelleH is offline
Kindness is free
 
Join Date: Mar 2008
Posts: 8,841
Quote:
Originally Posted by ciul3x View Post
Hello
I bought vps. and I want to import a database large vps via SSH, I tried but I failed. who can help me. remain indebted. please
Thanks
1. First upload your .sql file inside your account.
2. Create SSH access using the SSH Manager, then SSH your account.
3. Using SSH go inside the folder where your .sql file is and run the following command:
mysql <DB> -h <HOST> -u <USER> -p <PASS> < file.sql

__________________
Currently hosting with Big Brain Global Networks

  #5  
Old 10-27-2011, 10:47 AM
ciul3x ciul3x is offline
Newbie
 
Join Date: Oct 2011
Posts: 5
thanks

Quote:
Originally Posted by HR-Martin View Post
Are you trying to move a DB from one VPS to another?

Maybe I'm picking you up wrong.
I do not want to many database on a host on VPS

  #6  
Old 10-27-2011, 11:08 AM
raindog308 raindog308 is offline
Web Hosting Master
 
Join Date: Jul 2010
Posts: 773
Quote:
Originally Posted by ciul3x View Post
Hello
I bought vps. and I want to import a database large vps via SSH, I tried but I failed. who can help me. remain indebted. please
Thanks
how large is "large"?

__________________
My advice and reviews of VPS providers based on my personal experience: VPSadvice.com

  #7  
Old 10-27-2011, 11:08 AM
ciul3x ciul3x is offline
Newbie
 
Join Date: Oct 2011
Posts: 5
thanks

Quote:
Originally Posted by MichelleH View Post
1. First upload your .sql file inside your account.
2. Create SSH access using the SSH Manager, then SSH your account.
3. Using SSH go inside the folder where your .sql file is and run the following command:
mysql <DB> -h <HOST> -u <USER> -p <PASS> < file.sql
sir MichelleH can you leave a private message email address to talk more?

  #8  
Old 10-27-2011, 11:10 AM
MichelleH MichelleH is offline
Kindness is free
 
Join Date: Mar 2008
Posts: 8,841
Quote:
Originally Posted by ciul3x View Post
sir MichelleH can you leave a private message email address to talk more?
You do not have enough posts for a private message, I am available on all messengers listed in my profile or you can email my MSN

__________________
Currently hosting with Big Brain Global Networks

  #9  
Old 10-28-2011, 08:41 PM
ciul3x ciul3x is offline
Newbie
 
Join Date: Oct 2011
Posts: 5
MichelleH please help me in about vps. If you enter on this post and want to help please add me yahoo massenger id: cod3xcs@yahoo.com

  #10  
Old 10-28-2011, 10:50 PM
minhmeo minhmeo is offline
Aspiring Evangelist
 
Join Date: Mar 2010
Location: /global/asia/vn
Posts: 434
Quote:
Originally Posted by ciul3x View Post
MichelleH please help me in about vps. If you enter on this post and want to help please add me yahoo massenger id: cod3xcs@yahoo.com
Good! I'm wondering how large is it 10GB?

Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to import mysql dump file to database by SSH endin Hosting Security and Technology 4 05-19-2009 08:52 AM
Import large database without shell? badhat Hosting Security and Technology 5 09-08-2006 09:00 PM
restore large database by using SSH vietkool Hosting Security and Technology 8 02-17-2005 03:29 PM
how to import a large mysql file into the database? lobaloba9 Programming Discussion 2 08-02-2004 03:12 PM
Export/Import 50mb MySQL database without Telnet/SSH? kreativ Web Hosting 7 07-01-2002 07:50 PM

Related posts from TheWhir.com
Title Type Date Posted
Cloudant Merges BigCouch Code into Apache Open Source Database Web Hosting News 2013-07-22 17:55:14
Database as a Service Provider Cloudant Raises $12M from Rackspace, Others Web Hosting News 2013-05-14 11:37:21
Phoenix NAP Responds to Customer Feedback with New Cloud Features Web Hosting News 2013-02-19 17:09:09
Samsung Ventures Backs Cloudant Database as a Service Web Hosting News 2013-02-08 14:10:26
Amazon Adds RDS, DynamoDB Services to GovCloud Offering Web Hosting News 2012-12-24 12:18:51


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:
WHT Membership
WHT Membership



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?