database lost

[Rusty McCrusty]

Hi
I had a integramod forum happening on my website. But the webhost decided to move to different servers without notifying me and the data base was lost. I still have all the integra mod files on the server including the back up folder. One thing I tried was I transferred all the integramod files from the server to my pc and put them onto a home server I am playing with. Next I downloaded integramod copied the intall file and prill install file into the forum file I had transferred, installed integramod and got it runnning. There are topics and the posts are numbered but in latest post it says that there a none. The latest posts box is there with the posts scrolling but when you click on the post it comes up as "no posts or topics match your criteria"
Can anybody help with this?
Cheers
Rick

[Helter]

Im sorry, but the posts you see are only in the cache and not in the db, so you cannot actually read them. You should be able to perform a restore from your acp using a current backup.
Who is your host? Any competent host keeps current backups of thier complete farm and up to the minute backups of any machine being serviced. If your host has no backups then thier sevice is reletivly worthless regardless of how cheap they may be.

If you have trouble restoring through the acp, you can dl the latest backup from forum root/backup and run it manually through phpmyadmin. Then you ll have to go to acp/forum admin and resync your forums

[Rusty McCrusty]

thanks for the reply Helter
I will try your suggestions
I really have no idea on how download the files onto mysql
the webhost is smartyhost
If you do a google on them you will see not only I had trouble
Cheers
Rick

[Rusty McCrusty]

I'm not to sure where to start.
I had a look in acp and can not find where to restore a back up or where to get it from.
Need help please!
Cheers
Rick

[Helter]

acp/general admin/Restore Database

the backups are located (in your original forum) forum root/backup
using your ftp client, or Cpanel, download the latest dated backup to your desktop. from the acp/general admin/Restore Database link, browse to it, and run it.
If you have additional tables, you may not be able to do this from your acp. In that case, make a new db. open it up in phpmyadmin. click the sql tab. On your desktop, open the db file you just dl'd from your old forum. go to edit/select all, then copy/paste it into the phpmyadmin sql box and hit submit.
If your db is too large, you will have to break it up.
once complete, go to forum root/confige.php and edit the db name, username and password to reflect your new db. Log into your forum with your old username/password, go to acp/forum admin and resync the forums.

[Rusty McCrusty]

hi
I have tried both ways
and I keep getting this error
SQL Error:1064 You have an error in your SQL syntax: Check the manual that corresponds to your MYSQL server version for the righth syntax to use.
I've had a look at the backup file and it was done in 3.23.58 an I have 4.1.11 Are there any differences in how the newer version of sql will read the back up file?
If so what would I need to change in the back up file so the newer version can restore the backup file?

[Helter]

what is the size of your db? I may be able to edit for you so it will install

[Rusty McCrusty]

the original that was backed up in mysql 3.23.58 is 605kb and the back up I made of the new db is 304kb

[Adrian Rea]

Has you db more than one db installed on it, ie with different table prefixes?

A

[Apocal]

hi
I have tried both ways
and I keep getting this error
SQL Error:1064 You have an error in your SQL syntax: Check the manual that corresponds to your MYSQL server version for the righth syntax to use.
I've had a look at the backup file and it was done in 3.23.58 an I have 4.1.11 Are there any differences in how the newer version of sql will read the back up file?
If so what would I need to change in the back up file so the newer version can restore the backup file?

post the code and I will try to fix it for you. It's probably just a small syntax error. The database back ups, as far as I have been noticing from there have some small errors from time to time. This doesn't normally occur when you download them directly from mysql, but it does from Integramod. Hopefully we'll have you up and going in no time.

[Rusty McCrusty]

Hi here is the backup from the forum that was online.
I haven't been able to get IM running on the webhost, I think it might have something to do with them using MYSQL 5

[Rusty McCrusty]

I have tried to post the db but ot is too large. Is there another option?

[jwernerny]

I went through a very similar thing with Snowtire.info. In the end, I had to go back to a 2 month old backup. Even then, it was too big. What I eventually did was open up the SQL file in an editor and split it up a bit. I also deleted some of the data that could be automatically rebuilt (search strings, the dictionary). I then used my new Hosting Service's install of phpMyAdmin to load up the smaller files. It was a long, tedious process, but it worked.

[aside: Two days before I lost everything, I had a "feeling" I should copy the daily backups to my home PC, but I ignored it. Next time I won't.]

- John

[Helter]

I have tried to post the db but ot is too large. Is there another option?

zip your db. in your web root, or the folder that your forum is located in, make a new folder with a strange (difficult to guess) name. Upload your zipped db there. PM me with the url. You dont want to publicly post your db because it will compromise the security of your forum

[Apocal]

If you just post around where that error occured we can fix it, we don't need the whole thing.

Edit: like 25 lines around line 1064

or just pm it to Heltser