Forum DB Backup

SimpleHuman

SimpleHuman

Verified User
Joined
Aug 31, 2009
Messages
29
Hello Guys

I have an IP Board forum. Can someone tell me how I can 100% backup the Database so that all my Threads and Posts ..etc are safe and backed up.

I would greatly appreciate any help.

Thank You.
 
this is a directadmin user support forum, nothign to do with forum and user lvl...

if you are using directadmin panel, so, into mysql database option you can backup your entire database.
 
Hello SeLLeRoNe

Yes I know that this is a DirectAdmin User Support Forum. And I DO USE DirectAdmin. That is why I am here.

I thought DirectAdmin would have built in some options for doing Database Backups. I shall go look for that MySQL you have mentioned.

Sorry I am a n00b as you can tell.

Thank you.
 
What i meant is... if you got just user access so you should ask your provider.

Btw, into mysql section there is no backup option, my fault.. but.. with phpmyadmin you should be able to make backups of your entire structure and data...

Another way is user level backup that can be selective and backup what you say to backup...

It cant be put in cron yet (and that also depend if server admin allow cron for user) and... same as cron backup are avaible just if server admin made it possible at user level.. if he didnt, so your only way is do backup from phpmyadmin.
 
Hi Again

I own the server. So I have all access. I have found this in SQL Management at the user level.

fbvxnt.jpg


As you can see there is an option to download the Database. So I right Click and do a Save As, and I get the database as a (.gz) file.

Does that mean I have my Database backed up now ? Also in that screenshot as you can see it says the DB size is 14.9MB, but that (.gz) file that I have downloaded is only 2.21MB >> Does this look right ? or is there something wrong ?

I want to be 100% sure that my Database Backups are COMPLETE. So that if something happens, I can get all my stuff back.

Thanks SeLLe
 
the .gz file is a compressed file, so, should be 2.1mb... for have a backup that you are sure that work i suggest you to create a new database and try to import the backup in it, if success and you can see all tables and data on it with phpmyadmin, so, that backup is working perfectly :)

otherwise, you should run a mysqldump by console

mysqldump -uUSERNAME -pPASSWORD DB_NAME > DBBACKUP.SQL

Regards
 
SeLLeRoNe said:
Otherwise, you should run a mysqldump by console

mysqldump -uUSERNAME -pPASSWORD DB_NAME > DBBACKUP.SQL

Regards
Click to expand...


Hello Again SeLLe

I have been away trying to look for this console thing, and I think I have found it ! Is it in phpMyAdmin ? Here:

1z3z5ep.jpg


As to using that command:

  • Is it the username and password of the database user that I am support to put there?
  • Do I keep the little " -u " and little " -p " at the begining of that info that I'm suppose to place there ?
  • Where does the backup.gz end up ?

Sorry to have caused you this headache, I am a n00b. :(

Thank You Very Much.
 
It's part of your operating system. Unless you're running Windows, in which case you probably want to install PuTTY.

No, I don't know how to install or use PuTTY; We run Linux on our desktops.

Jeff
 
SimpleHuman said:
Thanks floyd

So how do I access that console ?
Click to expand...

Apparently you did not install DirectAdmin yourself. It sounds more and more like you are not the server administrator. In that case you should contact your hosting company to see if command line access is even allowed. Most of us get remote command line access using SSH. If you do not already know how to use SSH then this is not the place to learn.
 
floyd said:
Apparently you did not install DirectAdmin yourself. It sounds more and more like you are not the server administrator.
Click to expand...

Hi Floyd

You are right, I did not install DirectAdmin myself. I asked my Hosting Company to install it for me on my Dedicated Server.

If I have a Dedicated Server, then surely I'm the Server Administrator right ? I am a total n00b I admit.

I have login details for SSH in my eMail, My Host sent me those. Will Do some research and get back to you guys.

Thanks
 
@SimpleHuman:

With all due respect, owning a server doesn't make you an administrator anymore than owning a stethescope makes you a medical doctor.

It's probably unfair of me to say this, because after all my business is Contract Server Administration, but I strongly suggest you hire someone to administer your server, either full or part-time, or under contract (as we work), so you don't break your system or your hosted sites, or even worse, cause problems for the Internet at large.

Some of us on these forums have been administering linux servers for ten years or more (for exmple, I've been administrating linux servers for 15 years and unix servers before that); it's not something you can learn ovrenight.

Jeff
 
jlasman said:
With all due respect, owning a server doesn't make you an administrator anymore than owning a stethescope makes you a medical doctor.
Click to expand...

Haha I like that, you are right, I'm sorry :)

The thing is, hiring someone to administer the server is expensive (I think). What prices are we looking at here ?

Thanks
 
:eek: like I said very expensive

Specially where all I want doing is a weekly 100% complete backup of my database for my forum. Also perhaps optimizing the tables ..etc you know little things !!!

It ain't like I'm running a hosting company ! LOL If I was running a hosting company then I may consider that price.

But for a guy like me, who is still a student that money way way to much. It is more expensive than what I pay for my server !!

I guess I will carry on my google research regarding the Console.

Thank You :)
 
At least buy a good book on Linux/BSD systems administration.

It's not just using the console; it's what you do once you're in there.

Jeff
 
Unfortunately I cannot; it's just been too long since I needed one or used one. The books on my bookshelf aren't even in print anymore.

In the US and in some other countries you can generally walk into a Borders or Barnes and Noble bookstore, and browse. If possible, that's what I recommend.

Remember no matter what you'll read, none of it will apply specifically to Direct Admin, which handles much of the installation and administration for you. What you really need to know is how to feel comfortable doing things.

Linux Server Administration for Dummies appears to get mixed reviews; if you read all 7 reviews at Amazon you may be able to figure out or not if the book will help you.

Jeff
 
You must log in or register to reply here.
Back
Top