AD MANAGEMENT

Collapse

BEHOSTED

Collapse

GOOGLE

Collapse

Backing-Up and restoring the Current Database

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    Backing-Up and restoring the Current Database

    <TABLE cellSpacing=0 cellPadding=5 border=0><TBODY><TR vAlign=top><TD class=Mstepnum>1

    </TD><TD class=Msteptext width="100%">Telnet/SSH into the server where your vBulletin is currently installed. We will call this machine1.</TD></TR><TR vAlign=top><TD class=Mstepnum>2</TD><TD class=Msteptext width="100%">Type:
    mysqldump --opt -Q -uUSERNAME -p DATABASENAME > /PATH/TO/DUMP.SQL


    > c:\dump.sql


    In this line, you should change the following:
    • USERNAME 每 this is the username you use to access MySQL. It is specified in your config.php file.
    • DATABASENAME 每 the name of the database which your vBulletin is installed into. It is specified in your config.php file.
    • /PATH/TO/DUMP.SQL 每 this is the path to the file that will be outputted. If you are unsure what to put here, simply use vb_backup.sql or something similar.
    Once you press enter, you will be prompted for the password you use to access MySQL. This is also specified in your config.php file.
    </TD></TR><TR vAlign=top><TD class=Mstepnum>3</TD><TD class=Msteptext width="100%">Once it has returned to the prompt, verify that DUMP.SQL exists in the directory you specified. If you did not specify a full directory, the file will be in the directory you are currently in.


    2) Transferring to the New Server

    <TABLE cellSpacing=0 cellPadding=5 border=0><!--<tr><td nowrap="nowrap">Step Num</td><td>Instruction</td></tr>--><TBODY><TR vAlign=top><TD class=Mstepnum>1</TD><TD class=Msteptext width="100%">Telnet/SSH into machine1 if you have not already.</TD></TR><TR vAlign=top><TD class=Mstepnum>2</TD><TD class=Msteptext width="100%">Type:
    ftp MACHINE2
    Replace MACHINE2 with the host name (www.example.com) or IP address (192.168.1.1) of the new server.


    You should be prompted for a username and password. This is the username and password that you use to login via FTP to your new server.
    </TD></TR><TR vAlign=top><TD class=Mstepnum>3</TD><TD class=Msteptext width="100%">Type the following:
    asc

    cd /PATH/TO/NEW/DIRECTORY
    put /PATH/TO/DUMP.SQL

    put c:dump.sql


    Here you should change:
    • /PATH/TO/NEW/DIRECTORY 每 this is the path to the directory in which you want to place the database backup. If you are unsure what to specify here, you can usually omit the entire cd /PATH/TO/NEWDIRECTORY/ command.
    • /PATH/TO/DUMP.SQL 每 this is the same path that you specified in step 1.

    </TD></TR><TR vAlign=top><TD class=Mstepnum>4</TD><TD class=Msteptext width="100%">Once these commands have finished, type:
    close

    quit
    </TD></TR><TR vAlign=top><TD class=Mstepnum>5</TD><TD class=Msteptext width="100%">Verify that DUMP.SQL is in /PATH/TO/NEW/DIRECTORY on the new server.</TD></TR></TBODY></TABLE>
    3) Restoring the Database on the New Server <TABLE cellSpacing=0 cellPadding=5 border=0><!--<tr><td nowrap="nowrap">Step Num</td><td>Instruction</td></tr>--><TBODY><TR vAlign=top><TD class=Mstepnum>1</TD><TD class=Msteptext width="100%">On the new server, if necessary, create the database which your vBulletin will be installed in. Refer to your host for specific information on how this is done.</TD></TR><TR vAlign=top><TD class=Mstepnum>2</TD><TD class=Msteptext width="100%">Telnet/SSH into machine2.</TD></TR><TR vAlign=top><TD class=Mstepnum>3</TD><TD class=Msteptext width="100%">Type:
    mysql -uUSERNAME -p NEWDBNAME < /PATH/TO/NEW/DUMP.SQL
    You should change the following parts of this line:
    • USERNAME - this is the new username which you will use to access MySQL. If you do not know this value, you should contact your host.
    • NEWDBNAME - the name of the new database that you created in the first part of this step.
    • /PATH/TO/NEW/DUMP.SQL - this is the path to the backup file that you transferred to this server in step 2.

    </TD></TR></TBODY></TABLE>

    </TD></TR></TBODY></TABLE>
    FreeHostForum.com
    Tags: None
Previous template Next

Unconfigured Ad Widget

Collapse

Announcement

Collapse
1 of 2 < >

FreeHostForum Rules and Guidelines

Webmaster forum - Web Hosting Forum,Domain Name Forum, Web Design Forum, Travel Forum,World Forum, VPS Forum, Reseller Hosting Forum, Free Hosting Forum

Signature

Board-wide Policies:

Do not post links (ads) in posts or threads in non advertising forums.

Forum Rules
Posts are to be made in the relevant forum. Users are asked to read the forum descriptions before posting.

Members should post in a way that is respectful of other users. Flaming or abusing users in any way will not be tolerated and will lead to a warning or will be banned.

Members are asked to respect the copyright of other users, sites, media, etc.

Spam is not tolerated here in most circumstances. Users posting spam will be banned. The words and links will be censored.

The moderating, support and other teams reserve the right to edit or remove any post at any time. The determination of what is construed as indecent, vulgar, spam, etc. as noted in these points is up to Team Members and not users.

Any text links or images contain popups will be removed or changed.

Signatures
Signatures may contain up to four lines

Text in signatures is subject to the same conditions as posts with respect decency, warez, emoticons, etc.

Font sizes above 3 are not allowed

Links are permitted in signatures. Such links may be made to non-Freehostforum material, commercial ventures, etc. Links are included within the text and image limits above. Links to offensive sites may be subject to removal.

You are allowed ONLY ONE picture(banner) upto 120 pixels in width and 60 pixels in height with a maximum 30kB filesize.

In combination with a banner/picture you can have ONLY ONE LINE text link.


Advertising
Webmaster related advertising is allowed in Webmaster Marketplace section only. Free of charge.

Shopping related (tangible goods) advertising is allowed in Buy Sell Trade section only. Free of charge.

No advertising allowed except paid stickies in other sections.

Please make sure that your post is relevant.


More to come soon....
2 of 2 < >

Advertise at FreeHostForum

We offer competitive rates and a many kinds of advertising opportunities for both small and large scale campaigns.More and more webmasters find advertising at FreeHostForum.com is a useful way to promote their sites and services. That is why we now have many long-term advertisers.

At here, we also want to thank you all for your support.

For more details:
http://www.freehostforum.com/threads...eHostForum-com

More ad spots:
http://www.freehostforum.com/forums/...-FreeHostForum
See more
See less
Working...
X