• Sign in to Neowin Faster!

    Create an account on Neowin to contribute and support the site.

  • 0
Sign in to follow this  

backing up and restore IPB database?

Question

bangbang023    31

I run invision board 1.3 on my site and have a question. I have backed up my sql database (do so every week) but is this the only way to create a backup? And how would I restore it if my database was corrupted.

Basically, I want to know, what is the best way to back up my board and to restore it, if neccessary?

Share this post


Link to post
Share on other sites

18 answers to this question

Recommended Posts

  • 0
Scribbller    0

I usully do it through phpmyadmin since the prefix of both the board installed and the back up is same, just upload the back up .sql file from phpmyadmin and it will over write the current tables, if you want help regarding uploading ill also tell you that.

Share this post


Link to post
Share on other sites
  • 0
uniacid    0

which way are you backing up through IPB? you can do that or use phpmyadmin and backup that way, either way it should be the same, now to restore you can use phpmyadmin and use the SQL function and just load the .sql file

Share this post


Link to post
Share on other sites
  • 0
bangbang023    31

i dont have access to phpmyadmin since I don't run the server. I just rent space with a small annual fee at pcplayground.com

Share this post


Link to post
Share on other sites
  • 0
uniacid    0

but you have ftp access right? all you need is that and know your mysql login/pass/dbname and you can setup phpmyadmin

Share this post


Link to post
Share on other sites
  • 0
eevoo    1

I have a nice little php script written by (oh hell I forget, but it says in the file) I can dig up for ya if ya want it?

Share this post


Link to post
Share on other sites
  • 0
bangbang023    31
but you have ftp access right? all you need is that and know your mysql login/pass/dbname and you can setup phpmyadmin

yes I know all that. I didn't know I could install it myself, thank you. is there any other real use for it beisdes being able to restore backups and such?

I'm a noob at this and networking lol. I just never had any real chances to mess around with any of this.

Share this post


Link to post
Share on other sites
  • 0
bangbang023    31
I have a nice little php script written by (oh hell I forget, but it says in the file) I can dig up for ya if ya want it?

I wouldn't mind looking at that either

Share this post


Link to post
Share on other sites
  • 0
AmpCoder    0
I wouldn't mind looking at that either

Yeah same here, I am about to switch servers, and that might come in handy.

Share this post


Link to post
Share on other sites
  • 0
eevoo    1

Here it is.

Written by Mark Wraith.

Can't remember where I found it, but all ya do is drop it into your main forum directory and acces it through http://yoursite/mysql_tool.php

Has been and invaluable tool for me. :D

mysql_tool.php

  • Like 1

Share this post


Link to post
Share on other sites
  • 0
Scribbller    0

There is a script available on invision power board site which can be used to back up and restore db download that.

Share this post


Link to post
Share on other sites
  • 0
bangbang023    31

wow thanks man, so much easier than phpmyadmin. Definitely not something you want to leave on the server though lol.

Share this post


Link to post
Share on other sites
  • 0
eevoo    1
wow thanks man, so much easier than phpmyadmin. Definitely not something you want to leave on the server though lol.

Oh most definetly not :D, but it does have a option to password protect it, if you open it in notepad or whatever

you so desire to edit it in, and look for $password = '' near the top, you can put your password between the '' .

And your welcome. :yes:

Share this post


Link to post
Share on other sites
  • 0
Can Pahali    1

Dude !!!!!!!!!!!!!!

I have to do that, i cant access PHP MY ADMIN (because my hosting firm does not allow to load my backup bigger than 2MB ! My database is 9 MB),

i was backup my site from IP.Board Control Panel, but i dont know how i restore it !!!

Share this post


Link to post
Share on other sites
  • 0
articuno1au    1,264

Apart from the ENORMOUS necro, take a look at Navicat.

If you can use it, you can use it to issue backups and restore them. We use it for all our databases and run it on a schedule to automate the backups.

Very useful tool >.<

  • Like 1

Share this post


Link to post
Share on other sites
  • 0
Can Pahali    1

My last question, how can i get that programme ?

Share this post


Link to post
Share on other sites
  • 0
djdanster    594

My last question, how can i get that programme ?

My guess would be at the link below :)

http://www.navicat.com/en/download/download.html

Share this post


Link to post
Share on other sites
  • 0
Can Pahali    1

Thanks for AWESOME FAST SUPPORT dude !!! :)

  • Like 1

Share this post


Link to post
Share on other sites
  • 0
Sandor    436

Sup 9 year old thread.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.