Who's Online Now
0 members (), 0 guests, and 0 robots.
Key: Admin, Global Mod, Mod
Top Posters
Kyng 8
Smokey 6
deva1 1
Forum Statistics
Forums13
Topics52
Posts138
Members7
Most Online69
May 13th, 2020
Popular Topics(Views)
Affiliates
3QZaj0g
Previous Thread
Next Thread
Print Thread
Rate Thread
How To: Get a database backup of your site
#87 03/12/2020 11:34 PM
Joined: Mar 2020
Posts: 60
Full Member
OP Offline
Full Member
Joined: Mar 2020
Posts: 60
In this topic I will be going over the steps to take to make a backup of your website's database. You may be asking, "But what's the point of making a database?" It's best to have a backup of your database, just in case something happens to your site. You also need a database backup while switching hosts or scripts. In some cases, you might not be able to obtain a backup of your database. This is the case with a few free forum hosts, such as Tapatalk. With that in mind, let's go on with the tutorial!

First, head over to the control panel of your site. Locate the script "phpmyadmin". This is the script you'll need to be able to make a backup of your database. If your host doesn't provide access to this script, you will not be able to get a database backup. After the script is located, click the link and you should see a complete list of your site's database. If you have multiple scripts on one hosting account, you'll see all of your databases on one screen. Click on whatever database you need to backup, and the entire database will display.

Alright the information on the screen may confuse you. What a database contains are tables that are filled with your website's information. This includes your members, posts, etc. You don't need to worry about looking for specific tables to backup, since we want to back everything up. Locate the "check all" button at the end of your database table. Next to the "check all" button, a drop down menu will contain options for the database. From there, click on the "export" option. Another screen will pop up and ask you what format you want your database to be saved as, as well as a "custom" and "quick" option. Stick with quick for now, custom allows you to choose from a few options that we don't need to worry about. It'll also ask you what format you want your database saved in, It's best to stick with SQL as it's the most widely used format. From there click on "go" and your database will be downloaded onto your computer!

Re: How To: Get a database backup of your site
Ravenfreak #119 03/25/2020 12:07 AM
Joined: Mar 2020
Posts: 60
Full Member
OP Offline
Full Member
Joined: Mar 2020
Posts: 60
*facepalm* I forgot to mention that many different forum software allow you to make a database backup just from your ACP alone. So here's how to obtain your database backup from a few different platforms!

If you're using phpBB, you can obtain a copy of your database by going to the "Maintenance" tab in the ACP. From there, click on "Backup" under the "Database" text on the left hand side of your screen. You can also restore a old database here too, if need be. It's probably much easier than dealing with your hosting's cPanel.

If you are using Jcink's free hosting, you can obtain a copy of your database by scrolling down until you see the "DB Management" option on the left side of the screen in your ACP. From there you have the option to download a backup of your forum, as well as restore a old database.


Link Copied to Clipboard
Newest Members
deva1, Kyng, Smokey, Juneberry, MeowsePad
6 Registered Users
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Today's Birthdays
There are no members with birthdays on this day.
September
S M T W T F S
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30
Top Likes Received
Kyng 1
Smokey 1
Powered by UBB.threads™ PHP Forum Software 7.7.4