shell access via telnet or ssh

  • Jako
  • Banned
  • Banned
  • No Avatar
  • Joined: Oct 30, 2003
  • Posts: 227
  • Status: Offline

Post January 27th, 2005, 7:55 pm

I was going to save my database and switch it to a new server. I contacted vbulletin as to which way was best.

They told me shell access via telnet or ssh. I have this shared account that expires so this is why I want to transfer. I cannt contact my host so I do not no how to access this. Does anyone have any idea on how I would go about doing this. And what other methods would be best if it's not possible. Like if I use phpmyadmin, which options do I select when I backup the database, etc?

Thanks
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post January 27th, 2005, 7:55 pm

  • Daemonguy
  • Moderator
  • Web Master
  • User avatar
  • Joined: Jan 23, 2004
  • Posts: 2675
  • Loc: Somewhere outside the box in Sarasota, FL.
  • Status: Offline

Post January 27th, 2005, 8:04 pm

They allow open telnet? Er... no wonder people are leaving them.

If they are telling you to ssh in and handle your (mysql) backups manually... just do that.
Code: [ Select ]
ssh> mysqldump --tab=/path/to/some/dir --opt db_name

Or:

ssh> mysqlhotcopy db_name /path/to/some/dir
  1. ssh> mysqldump --tab=/path/to/some/dir --opt db_name
  2. Or:
  3. ssh> mysqlhotcopy db_name /path/to/some/dir
"It's always a long day, 86,400 won't fit into a short."
  • Jako
  • Banned
  • Banned
  • No Avatar
  • Joined: Oct 30, 2003
  • Posts: 227
  • Status: Offline

Post January 27th, 2005, 8:08 pm

Quote:
login as: jako
jako@jakowenko.com's password:
Shell access is not enabled on your account!
If you need shell access please contact support.


I was contacted by vB to use this putty program to try to get access. But it appears it doesn't when I went through the steps correct? Any other way, or what would be the best method in phpmyadmin. When I click export, which selections should I tick/check...

Image
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23407
  • Loc: Woodbridge VA
  • Status: Offline

Post January 27th, 2005, 8:30 pm

If you are going to start from scratch the defaults should be fine. Click the "save as file" option . A download window will kick in. That should save your database as it is in real time. I have never been to the point where I needed to experiment with Compression, but if you have a large database you might want to wait for thoughts on compression.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23407
  • Loc: Woodbridge VA
  • Status: Offline

Post January 27th, 2005, 8:38 pm

Side note. You might also want to do a second backup downlod and check the oprions under structure for "Add DROP TABLE" and Add "IF NOT EXISTS"

If the first doesn't work the second one should.
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • Jako
  • Banned
  • Banned
  • No Avatar
  • Joined: Oct 30, 2003
  • Posts: 227
  • Status: Offline

Post January 28th, 2005, 6:47 am

Thanks, anyone else have any suggestions?
  • CartikaHosting
  • Proficient
  • Proficient
  • No Avatar
  • Joined: Oct 30, 2004
  • Posts: 455
  • Loc: Wishing I was in Kicking Horse
  • Status: Offline

Post January 29th, 2005, 6:34 pm

To Dump mysql - ensure you have selected all tables - and just to err on the side of caution - select complete inserts and extended inserts.

Ask your new host to import your mysql dump via root - test to ensure all your data has been migrated properly - then yu can cancel your old hosting account....

Hope this helps...
Andrew - http://www.cartikahosting.com
Business Grade, Clustered Application Hosting
Windows, Linux, Coldfusion, FreeBSD, MS Exchange and Dedicated Servers

Post Information

  • Total Posts in this topic: 7 posts
  • Users browsing this forum: No registered users and 33 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
cron
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.