 | [Solved] Database Backup |  |
 Posted: 09/01/2007 11:15 PM |
 |
|
|
|
|
| Citation |
| Posts |
826 |
| Word Cnt. |
37,329 |
| BDay |
Oct 2 |
| Sign |
Libra |
| Sex |
 |
|
|
|
Joined: Apr 03, 2007
Local time: 8:46 PM
Location: Somewhere in Maryland
|
|
|
|
|
 |
I have saved it using every scenario they have in the DB AMIN panel which I am sure is a long route to doing so. So, what's the correct, shortest, easiest methid on backing up a forum? Give me the directions and I promise I will never ask again as I am saving them in a few different storage areas. Better safe than sorry, ya know. Also, if I need to do any maintenance via the db maintencance MOD prior to saving, let me know this too.
Thank you to whomever answers. And yes, I did try to search in here foe the answer. |
|
Last edited by 2LadyDi on 09/02/2007 6:20 PM; edited 1 time in total |
|
|
|
| Back to Top |
|
|
| Re: Database Backup | |
| Posted: 09/02/2007 2:11 AM |
|
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 1:46 AM
|
|
|
|
|
|
I've created a folder on my desktop for all my backups - site and db. I have so much junk on my pc that that way I know where they all are 
I go into phpmyAdmin and go to each database.
Select all the tables (tick the box at the bottom) and then click 'export' at the top. And save it as a zipped file (select at the bottom)
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Database Backup | |
| Posted: 09/02/2007 2:58 AM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
 |
|
|
|
Joined: Apr 01, 2007
Local time: 5:46 AM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
Yes, Karen is right. I do the same way to save my database for each of my website.
Thanks to Nightrider for teaching me this  |
|
|
|
|
| Back to Top |
|
|
| Re: Database Backup | |
| Posted: 09/02/2007 8:47 AM |
|
|
|
|
|
| Site Admin |
| Posts |
49593 |
| Word Cnt. |
2,756,445 |
| BDay |
Apr 22 |
| Sign |
Taurus |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:46 PM
Location: Texas
|
|
|
|
|
|
I select the database I want to back up, I only back up our main forum.
(The wrong one is shown as selected in the screen shot, it should be rcf)
When the database opens, from the menu at the top select Export. When that window opens go to the bottom and check Save as File and I select gzipped rather than zipped, it's creates a smaller file, then click Go. The download box opens, select the folder where you want to store the file. The backup takes about 5 or 6 minutes.
The last screen shot also shows all the other boxes that are checked. I have a partition on my HDD named BAC_UP where I store all my backups but you can create a folder named phpBB_database anywhere and save your backups there. By default the File name is RB2D2X1_ref.sql.gz, I change the RB2D2X1 to the date, ie 09-02-07 and keep about 5 or 6 days worth. LOL right now I notice I have about 35 days worth! Yikes that has to be taking a lot of space on my HDD! I backup everyday sometime twice a day.
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Database Backup | |
| Posted: 09/02/2007 9:04 AM |
|
|
|
|
|
| Citation |
| Posts |
826 |
| Word Cnt. |
37,329 |
| BDay |
Oct 2 |
| Sign |
Libra |
| Sex |
|
|
|
|
Joined: Apr 03, 2007
Local time: 8:46 PM
Location: Somewhere in Maryland
|
|
|
|
|
|
| Well, from what I am reading - seems you all phpMyAdmin vs the ACP database backup. I am guessing use the first one is loads better, yes? Why? See, I am about to install a lil different MOD (seen here) thanks to NR and I wanted to use it. I have as it seems easier to backup and install straight inside the forum?!?! Actually, it's the one I had been using til now. |
|
|
|
|
| Back to Top |
|
|
| Re: Database Backup | |
| Posted: 09/02/2007 9:32 AM |
|
|
|
|
|
| Site Admin |
| Posts |
49593 |
| Word Cnt. |
2,756,445 |
| BDay |
Apr 22 |
| Sign |
Taurus |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:46 PM
Location: Texas
|
|
|
|
|
|
As our forum, and database, got larger it got harder and harder to save using the ACP until finally I couldn't, the download window wouldn't even appear. phpMyAdmin has never given me a problem, it's very fast.
 |
|
|
|
|
| Back to Top |
|
|
| Re: Database Backup | |
| Posted: 09/02/2007 10:27 AM |
|
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 1:46 AM
|
|
|
|
|
|
I've never beeen able to do a backup using the ACP  |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Database Backup | |
| Posted: 09/02/2007 2:17 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 9:46 PM
Location: St Pete, FL
|
|
|
|
|
|
| 2LadyDi wrote:
|
|
Well, from what I am reading - seems you all phpMyAdmin vs the ACP database backup. I am guessing use the first one is loads better, yes? Why? See, I am about to install a lil different MOD (seen here) thanks to NR and I wanted to use it. I have as it seems easier to backup and install straight inside the forum?!?! Actually, it's the one I had been using til now.
|
Some database servers limit the size when importing or exporting a backup from 3rd party apps, such as the Database backup and Restore options in your ACP. The larger your database, the more chance that something can go wrong. So it is simply easier to stick with phpMyAdmin since it gives more options and is far more dependable. The database backup files from phpMyAdmin are usually far more compact than those created by other means...
 |
|
|
|
|
| Back to Top |
|
|
| Re: Database Backup | |
| Posted: 09/02/2007 2:38 PM |
|
|
|
|
|
| Citation |
| Posts |
826 |
| Word Cnt. |
37,329 |
| BDay |
Oct 2 |
| Sign |
Libra |
| Sex |
|
|
|
|
Joined: Apr 03, 2007
Local time: 8:46 PM
Location: Somewhere in Maryland
|
|
|
|
|
|
Grand info from you ALL. rb2d2 I copied your info and saved the graphic as well for reference. Since everyone agrees on one method, it shall be done.
Thank you for the patient and have a fabulous day and/or continued Holiday weekend for those labourers like myself  !! |
|
|
|
|
| Back to Top |
|
|
| Re: Database Backup | |
| Posted: 09/02/2007 5:49 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 9:46 PM
Location: St Pete, FL
|
|
|
|
|
|
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
![[ Hidden ]](templates/Helius_blue/images/lang_english/icon_email.gif "[ Hidden ]"){kind=icon}
