Jump to content

Question

Posted

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

  • 0

Posted

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

Posted

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

Posted

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

Posted

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

Posted

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

Posted

[quote name='uniacid' date='Mar 6 2004, 23:39']but you have ftp access right? all you need is that and know your mysql login/pass/dbname and you can setup phpmyadmin[/quote]
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

Posted

[quote name='eevoo' date='Mar 6 2004, 23:40']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?[/quote]
I wouldn't mind looking at that either

Share this post


Link to post
Share on other sites
  • 0

Posted

[quote name='bangbang023' date='Mar 6 2004, 23:48']I wouldn't mind looking at that either[/quote]
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

Posted

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 [url="http://yoursite/mysql_tool.php"]http://yoursite/mysql_tool.php[/url]
Has been and invaluable tool for me. :D
1 person likes this

Share this post


Link to post
Share on other sites
  • 0

Posted

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

Posted

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

Posted

[quote name='bangbang023' date='Mar 7 2004, 00:59']wow thanks man, so much easier than phpmyadmin. Definitely not something you want to leave on the server though lol.[/quote]
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

Posted

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

Posted

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 >.<
1 person likes this

Share this post


Link to post
Share on other sites
  • 0

Posted

My last question, how can i get that programme ?

Share this post


Link to post
Share on other sites
  • 0

Posted

[quote name='Can Pahali' timestamp='1365416142' post='595623940']
My last question, how can i get that programme ?
[/quote]

My guess would be at the link below :)

[url="http://www.navicat.com/en/download/download.html"]http://www.navicat.com/en/download/download.html[/url]

Share this post


Link to post
Share on other sites
  • 0

Posted

Thanks for AWESOME FAST SUPPORT dude !!! :)
1 person likes this

Share this post


Link to post
Share on other sites
  • 0

Posted

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  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.