Previous Thread
Next Thread
Print Thread
Hop To
#216149 08/02/2008 3:11 AM
Joined: Nov 2006
Posts: 46
T
newbie
newbie
T Offline
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

Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
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

Joined: Oct 2006
Posts: 67
journeyman
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
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Ruben), 476 guests, and 111 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)