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   I can't backup my database anymore
pnclthnmstsh
CZ Active Member
pnclthnmstsh has been a member for over 20 year's 20 Year Member
usa.gif nevada.gif
Age: 53
Gender: Male
Website:
Status: Offline
Joined: Sep 17, 2004
0.04 posts per day
Posts: 267
Points: 13,641
   
When I try to back up my database from the admin panel it only downloads the file admin_db_utitlites. I haven't backed up the DB for a couple weeks now so I thought maybe some ACP hack I may have put in since then so I overwrote the current db_utilities with a backup I know is untouched but still get the same results. Is there some where else I should look for this problem?




_________________
[ Register or login to view links on this board.]
Back to top Reply with quote
#2   
Telli
Site Admin
Occupation: Self Employed
Age: 46
Gender: Male
Fav. Sports Team: Detroit Red Wings
Website:
Status: Offline
Joined: May 26, 2003
1.03 posts per day
Posts: 8089
Points: 494,430
   
How big is it? Mysql might be timing out. When it gets so big you have to back it up through your phpmyadmin.




_________________
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he, who in the name of charity and good will, shepherds the weak through the valley of darkness, for he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17
Back to top Reply with quote
#3   re: I can't backup my database anymore
pnclthnmstsh
CZ Active Member
pnclthnmstsh has been a member for over 20 year's 20 Year Member
usa.gif nevada.gif
Age: 53
Gender: Male
Website:
Status: Offline
Joined: Sep 17, 2004
0.04 posts per day
Posts: 267
Points: 13,641
   
The stats in my ACP say it 17 megs...but I think its much bigger than that because now that you mention it..it installed a spell checker a few days ago. I looked through our server control panel at codezhost but didnt find an option yet to back up from there yet.




_________________
[ Register or login to view links on this board.]
Back to top Reply with quote
#4   re: I can't backup my database anymore
pnclthnmstsh
CZ Active Member
pnclthnmstsh has been a member for over 20 year's 20 Year Member
usa.gif nevada.gif
Age: 53
Gender: Male
Website:
Status: Offline
Joined: Sep 17, 2004
0.04 posts per day
Posts: 267
Points: 13,641
   
icon_biggrin.gif I guess that's what Export does? icon_biggrin.gif

Well would ya look at that...I guess I gotta back up from there now after installing spell check.

Thanks for the help! icon_biggrin.gif




_________________
[ Register or login to view links on this board.]
Back to top Reply with quote
#5   
pnclthnmstsh
CZ Active Member
pnclthnmstsh has been a member for over 20 year's 20 Year Member
usa.gif nevada.gif
Age: 53
Gender: Male
Website:
Status: Offline
Joined: Sep 17, 2004
0.04 posts per day
Posts: 267
Points: 13,641
   
Ok...now this is weird. I can backup my site fine but when I try to restore it, it times out. so I tried to restore just the posts and I get this error

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 2107321 bytes) in /var/www/html/phpMyAdmin-2.3.2/read_dump.php on line 112

I am using phpmyadmin on the codezhost server.

Thanks for any help




_________________
[ Register or login to view links on this board.]
Back to top Reply with quote
#6   re: I can't backup my database anymore
Dauthus
CZ Addict
 Codezwiz Site Donator
Dauthus has been a member for over 20 year's 20 Year Member
usa.gif illinois.gif
Age: 60
Gender: Male
Website:
Status: Offline
Joined: Mar 17, 2004
0.06 posts per day
Posts: 426
Points: 15,917
   
You can try what I used before. It may work for you.
[ Register or login to view links on this board. ]

If not, you will have to open up the sql file in notepad and then upload it in pieces through the sql tab in phpmyadmin.




_________________
[ Register or login to view links on this board.]
Vivere disce, cogita mori
Back to top Reply with quote
#7   
pnclthnmstsh
CZ Active Member
pnclthnmstsh has been a member for over 20 year's 20 Year Member
usa.gif nevada.gif
Age: 53
Gender: Male
Website:
Status: Offline
Joined: Sep 17, 2004
0.04 posts per day
Posts: 267
Points: 13,641
   
Thanks a ton! I don't know if it fixed the backing up problem but as soon as I created a new htaccess file in the root and added that code to it all my old posts came back and things are great so far. I have no idea what happened but after upgrading from 7.4 to plat I lost 500 posts in the DB import and the recent topics would only go back to january. This bit of code instantly got it upto date.




_________________
[ Register or login to view links on this board.]
Back to top Reply with quote
#8   
Telli
Site Admin
Occupation: Self Employed
Age: 46
Gender: Male
Fav. Sports Team: Detroit Red Wings
Website:
Status: Offline
Joined: May 26, 2003
1.03 posts per day
Posts: 8089
Points: 494,430
   
It just makes the server run a little harder but nothing noticable unless you had about 500 clients all doing it. Whats happening with the backups is that MYSQL times out when you try to import to much data. I find it will take about 2 meg then it will time out so like Dauthus said you have to do it chunks sometimes.




_________________
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he, who in the name of charity and good will, shepherds the weak through the valley of darkness, for he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17
Back to top Reply with quote
#9   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 have the same type of question. I have a 16 meg sql backup file from my site and I'm trying to move my site to another server and phpmyadmin times out every time I try and restore this database? So you guys are saying to break up the file into smaller pieces? How do I do that it's just one big jumble of information??

Thanks



Back to top Reply with quote
#10   re: I can't backup my database anymore
veef
CZ Super Newbie
veef has been a member for over 19 year's 19 Year Member
Gender: Male
Status: Offline
Joined: Dec 30, 2004
0.01 posts per day
Posts: 59
Points: 1,422
   
It only looks like one big jumble of info if you open it up in notepad, try using wordpad or another text editor such as ultra edit [ Register or login to view links on this board. ] then you will see the organized structure.



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