I can't backup my database anymore

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1   re: I can't backup my database anymore
Anthonizle
CZ Newbie
Anthonizle has been a member for over 19 year's 19 Year Member
Status: Offline
Joined: Nov 15, 2004
0.00 posts per day
Posts: 4
Points: 236
   
You can also do it by uploading the SQL anywhere on your directories then restoring the database through SSH

command to do so:

mysql DATABASE_NAME < /PATH/TO/FILE.SQL

Make sure your host provided you SSH access, as some hosts don't provide that.



Back to top Reply with quote
#2   re: I can't backup my database anymore
kingofbling
CZ Super Newbie
kingofbling has been a member for over 20 year's 20 Year Member
canada.gif
Website:
Status: Offline
Joined: Jun 17, 2004
0.01 posts per day
Posts: 39
Points: 1,659
   
thanks i do believe my host does provide ssh access. Is that done through a web browser or a special program? Sorry I'm a nooB to this



Back to top Reply with quote
#3   re: I can't backup my database anymore
kingofbling
CZ Super Newbie
kingofbling has been a member for over 20 year's 20 Year Member
canada.gif
Website:
Status: Offline
Joined: Jun 17, 2004
0.01 posts per day
Posts: 39
Points: 1,659
   
Ok I figured out how to gain shell access to my server. I'm using a program called Putty. Works great!! However I'm still unsuccessful at restoring my database. I've uploaded my sql dump to my new server root and tried to restore it with the following command in ssh.

mysql -h(hostname) -u(username) -p(password) (databasename) <mysqldumpfilename.sql


The restore starts to work and only restores about 21 of the 100 or so tables that I have. Why is it not restoring them all? BTW my sql dump file is only about 11mb in size. Please why is this not working? Anything else I can try. Thanks


Back to top Reply with quote
#4   re: I can't backup my database anymore
kingofbling
CZ Super Newbie
kingofbling has been a member for over 20 year's 20 Year Member
canada.gif
Website:
Status: Offline
Joined: Jun 17, 2004
0.01 posts per day
Posts: 39
Points: 1,659
   
ok I just discovered that phpmyadmin sucks for backing up and restoring any sufficient size mysql database. I used the SSH on my server to do the sql dump and the SSH on my new server to restore the database. This worked perfectly. I just thought I'd share that! Thanks for the help all!



Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to 
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 vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum