Getting Started Discussions about Planning an Online Community - Privacy Policies - Terms of Service - Targeting Niche - Demographics.

Reply
 
Thread Tools

  #1  
Old 01-22-2006, 07:45 AM
karen karen is offline
TAZ Rookie
 
Join Date: Jan 2006
Posts: 3
karen is on a distinguished road
Default Backing up my site (vbulletin forum)
Hi all,

complete noob here, don't have much experience at this (i.e. none) but I've recently started my first site.
I'd like to know if anyone can give me step-by-step instructions on how to back it up.
Thanks
Reply With Quote
  #2  
Old 01-22-2006, 08:18 AM
Nightowl Nightowl is offline
TAZ Regular
 
Join Date: Jan 2006
Admin Experience: Guru
Posts: 32
Nightowl is on a distinguished road
Default
The phpmyadmin method:

Quote:
Go to phpMyAdmin in your web broswer and select the database you wish to back up by clicking on the name. If you have multiple databases, you will need to select the name from the drop menu.

In the right-hand frame, you will see a row of links. Click [Export]

Now in the right-hand frame you will see three (3) areas. In the first area, called Export you select the table(s) you wish to back up by selecting them from the list. To select multiple tables, hold the Ctrl key and lick the table names. To select all table, click the [Select All] link.

In the second area, called SQL Options, make sure you have the follwing boxes checked:

Structure
Add 'drop table'
Add AUTO_INCREMENT value
Enclose table and field names with backquotes
Data

In the third area, check Save as file and type a name for the backup in the File name template :.
If your system supports it, you may also choose a compression type. None is selected by default.

Click [Go] and you will be prompted to save the backup on your local computer.
The SSH or Telnet Way:

Quote:
1) SSH or Telnet access to your site. You will need to check with your hosting company to see if this is available.

2) An SSH/Telnet Client, such as PuTTy.

Open your SSH/Telnet client and log into your website. The command line prompt you will see will vary by OS.
For most hosting companies, this will bring you into the FTP root folder.

Type in the following:

mysqldump --opt -Q -u dbusername -p databasename > /path/to/backupname.sql

You will be prompted for the database password. Enter it and the database will backup.

If your hosting company has you on a remote MySQL server, such as mysql.yourhost.com, you will need to add the servername to the command line. The servername will be the same as in your config.php. The command line will be:

mysqldump --opt -Q -h servername -u dbusername -p databasename > /path/to/backupname.sql

You can then, if you wish, download the backup to your home computer.
Generally though:

Maintenance > Database Backup and follow the appropriate options
Reply With Quote
Reply

  Admin Zone Forums > The Community Zone > Managing an Online Community > Getting Started





Currently Active Users Viewing this Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to build a Community/Project from scratch StarBuG Articles 27 10-27-2013 01:39 AM
Build Your Site: Why branding your forum means making a winning forum Ted S Articles 8 10-24-2006 05:09 PM


 

All times are GMT -4. The time now is 09:25 PM.


Powered by: vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Page generated in 0.05050397 seconds with 13 queries
The Admin Zone Đ copyright 2003-2014 All Rights Reserved. Content published on The Admin Zone requires permission for reprint.