backing up and restore IPB database?

[bangbang023 Veteran]

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?

[Scribbller]

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.

[uniacid]

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

[bangbang023 Veteran]

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

[uniacid]

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

[eevoo]

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?

[bangbang023 Veteran]

  uniacid said:

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.

[bangbang023 Veteran]

  eevoo said:

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

[AmpCoder]

  bangbang023 said:

I wouldn't mind looking at that either

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

[eevoo]

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.phpFetching info...

[Scribbller]

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

[bangbang023 Veteran]

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

[eevoo]

  bangbang023 said:

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:

[Can Pahali]

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 !!!

[articuno1au]

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 >.<

[Can Pahali]

My last question, how can i get that programme ?

[djdanster]

  On 08/04/2013 at 10:15, Can Pahali said:

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

[Can Pahali]

Thanks for AWESOME FAST SUPPORT dude !!! :)

[Sandor]

Sup 9 year old thread.