Previous Thread
Next Thread
Print Thread
Hop To
Backing up my tables
#216149 08/02/2008 3:11 AM
Joined: Nov 2006
Posts: 46
newbie
OP Offline
newbie
Joined: Nov 2006
Posts: 46
SirDude was kind enough to help me fix a large problem on my forum and he also advised me on how to back up.

I noticed there are several ways to back up (through PHPmyadmin, thrugh my web host, or through the control panel on the forum). SirDude recommended using PHPmyadmin.

However, once I got into PHPmyadmin, and am trying to "dump" the tables (I guess this means "back up"), I am faced with a barrage of choices...and I'm not quite sure how to proceed.

Here is a screnshot with my choices:

http://www.lymecommunity.com/example1.jpg

Any advice? Which boxes to check and which drop-down menus to choose?

Thanks everyone,

Bryan

Re: Backing up my tables
theskyking #216150 08/02/2008 4:22 AM
Joined: Apr 2007
Posts: 3,940
SD Offline
Former Developer
Offline
Former Developer
Joined: Apr 2007
Posts: 3,940
everything's good to go..

make sure you do 'completed inserts' and 'extended inserts'

then just click the 'save as file' and 'gzipped' radio button and voila.

you have a very small (relatively) DB, but i still recommend that you do it as follows:

1) ubbt_POSTS only
2) all but ubbt_POSTS

so you end up with 2 files..

good luck smile

Re: Backing up my tables
theskyking #216152 08/02/2008 4:27 AM
Joined: Oct 2006
Posts: 67
journeyman
Offline
journeyman
Joined: Oct 2006
Posts: 67
Hej

If you do a back-up of tables with phpmyadmin, do as follow:
  • Choose 'export' tab
  • select 'All' (and all your tables will be marked)
  • Add checkbox 'Add DROP TABLE'
  • Add checkbox 'Save as file'
  • hit 'go' button and select a destination to save your back-up.


    To do an import(dump) of back-up with phpmyadmin, do as follow:
  • Choose 'SQL' tab
  • Fill in 'Location of the text file:'
  • hit 'go' button

If you wants to preview your back-up before dumping, mark 'Show this query here again' checkbox, and hit 'go' button


trosfrihed.dk
Custom Ubb 7.5.2

Link Copied to Clipboard
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Ubb 7.7.4 Gallery problems
by jjjjj - 05/25/2020 2:35 PM
7.7.4 error after php upgrade to php 7.0
by Ruben - 05/25/2020 1:10 PM
7.7.4 move group all, fails with a error
by Ruben - 05/24/2020 3:07 PM
Grid lines in forum topics list
by Steve C - 05/23/2020 12:09 PM
Who's Online Now
5 members (Bullet74, Ruben, driv, Gizmo, 1 invisible), 72 guests, and 57 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4