Greetings Doc Skillzville

[wesniaphania]

Just signed up wanted to give a quick HELLO

I need some help reloading a backup SQL file on a new server.

[Skhilled]

Hey! How's it going and welcome aboard! 

Do you need to know how to do it or are you having problems doing it? If you are having problems doing it, please tell me how you are doing it and errors you get. Also, is it a very large file?

[wesniaphania]

Hey! How's it going and welcome aboard! 

Do you need to know how to do it or are you having problems doing it? If you are having problems doing it, please tell me how you are doing it and errors you get. Also, is it a very large file?

Sup bro! Idk why it took me so long to find your URL

The other Admin claims he is trying to recover it for the past week or so... but I wanna learn how to my damn self to see just how full of crap he is lol

I need some beginner courses

The only thing backed up was  this file
boo1302410223806-complete_2014-04-09.sql.zip  (6.17 MB in size, when Unzipped it's 31.8mb)
I'm using lvcs.net services, with a Cpanel

I made a feeble attempt at it myself by installing the SMF forums (with their Installatron) went to Restore a MySQL Database and uploaded the backup and then it opened another window with this message
Restoring Database
Restoring database "boo1302410223806-complete_2014-04-09.sql.zip"

BUT nothing changed

[Skhilled]

It does not seem to be a problem from your explaination.

First thing is that it appears you are trying to import a zip file...you cannot do that. You need to extract that file using a zip/compression tool and you should find a .sql file...probably named "boo1302410223806-complete_2014-04-09.sql" or something else.

Then you'll want to go into cPanel and use phpmyadmin. Select the databse for the forum then click on "Import" over the middle of the page. It should ask for a file to upload. Use that file. Since the files is very small you should have no problems unless it is corruprted somehow.

That being said... You did not mention why or how you need to restore the backup. There are various ways to do that to get the forum back up and running, depending on your needs...

[wesniaphania]

It does not seem to be a problem from your explaination.

First thing is that it appears you are trying to import a zip file...you cannot do that. You need to extract that file using a zip/compression tool and you should find a .sql file...probably named "boo1302410223806-complete_2014-04-09.sql" or something else.

Then you'll want to go into cPanel and use phpmyadmin. Select the databse for the forum then click on "Import" over the middle of the page. It should ask for a file to upload. Use that file. Since the files is very small you should have no problems unless it is corruprted somehow.

That being said... You did not mention why or how you need to restore the backup. There are various ways to do that to get the forum back up and running, depending on your needs...

Ya i extracted the Sql file, it's 30mb...

Why... because the server bill didnt get paid, was waaay over due...we both thought it was on auto pay, which it had been for the past year, but for reasons unknown it was not last month which im kinda suspect about...

I got the myphpbbadmin > Import page open, with the sql file ready to upload...which options should I choose?
I dunno what you mean by how I need to restore it 

[wesniaphania]

I got this message when I uploaded it

QL query:

INSERT INTO `smf_log_search_subjects` (`word`, `id_topic`) VALUES (1, 2590), (1, 2594), (1, 2596), (1, 2606), (1, 2608), (1, 2618), (1, 2619), (1, 2626), (1, 2637), (1, 2643), (1, 2651), (1, 2657), (1, 2662), (1, 2664), (1, 2741), (1, 2793), (1, 2808), (1, 2818), (1, 2820), (1, 2853), (1, 2965), (1, 3008), (1, 3131), (1, 3315), (1, 3326), (1, 3330), (1, 3372), (1, 3434), (1, 3497), (1, 3499), (1, 3728), (1, 3762), (1, 3781), (1, 3815), (1, 3842), (1, 3881), (1, 3939), (1, 3940), (1, 3993), (1, 4038), (1, 4049), (1, 4055), (1, 4059), (1, 4062), (1, 4063), (1, 4065), (1, 4068), (1, 4075), (1, 4078), (1, 4095), (1, 4097), (1, 4107), (1, 4126), (1, 4140), (1, 4156), (1, 4163), (1, 4167), (1, 4169), (1, 4170), (1, 4173), (1, 4189), (1, 4193), (1, 4198), (1, 4201), (1, 4211), (1, 4212), (1, 4216), (1, 4293), (1, 4295), (1, 4298), (1, 4300), (1, 43[...]

MySQL said: Documentation

#1062 - Duplicate entry '1-3993' for key 'PRIMARY'

[Skhilled]

Ya i extracted the Sql file, it's 30mb...

That not too large so it should not be a problem. I ask because sometimes big files will cause the server to hang and not complete the process. When that happens you'll need to go at it in a different way.

Why... because the server bill didnt get paid, was waaay over due...we both thought it was on auto pay, which it had been for the past year, but for reasons unknown it was not last month which im kinda suspect about...

That not what I meant, lol... I meant, were you doing it because you were having database issues or moving to new hosting, etc. Maybe the issue could have been resolved in a different way.

I got the myphpbbadmin > Import page open, with the sql file ready to upload...which options should I choose?
I dunno what you mean by how I need to restore it 

Character set of the file: UTF-8
Partial Import: checked
Format: SQL
Then click Go...

I got this message when I uploaded it

QL query:

INSERT INTO `smf_log_search_subjects` (`word`, `id_topic`) VALUES (1, 2590), (1, 2594), (1, 2596), (1, 2606), (1, 2608), (1, 2618), (1, 2619), (1, 2626), (1, 2637), (1, 2643), (1, 2651), (1, 2657), (1, 2662), (1, 2664), (1, 2741), (1, 2793), (1, 2808), (1, 2818), (1, 2820), (1, 2853), (1, 2965), (1, 3008), (1, 3131), (1, 3315), (1, 3326), (1, 3330), (1, 3372), (1, 3434), (1, 3497), (1, 3499), (1, 3728), (1, 3762), (1, 3781), (1, 3815), (1, 3842), (1, 3881), (1, 3939), (1, 3940), (1, 3993), (1, 4038), (1, 4049), (1, 4055), (1, 4059), (1, 4062), (1, 4063), (1, 4065), (1, 4068), (1, 4075), (1, 4078), (1, 4095), (1, 4097), (1, 4107), (1, 4126), (1, 4140), (1, 4156), (1, 4163), (1, 4167), (1, 4169), (1, 4170), (1, 4173), (1, 4189), (1, 4193), (1, 4198), (1, 4201), (1, 4211), (1, 4212), (1, 4216), (1, 4293), (1, 4295), (1, 4298), (1, 4300), (1, 43[...]

MySQL said: Documentation

#1062 - Duplicate entry '1-3993' for key 'PRIMARY'

That is just a log so you can "Empty" that table but do not "Drop" it! Empty will remove the values in it...Drop will delete the table itself which you do not want cause SMF will look for it.

[wesniaphania]

Ahh my confusion just went deeper. lol

No idea what you  meant by the last sentence.

I sent you a PM

[Skhilled]

The table in question "smf_log_search_subjects" is a log of the subjects that users have searched for. It is not important and the data in it can be deleted. It is usually deleted when you click "Delete all unimportany logs" in the admin...well, one of the things that gets deleted. The table itself is still needed by SMF to continue logging new searches so that is still need, just not the information contained in it.

[wesniaphania]

I just wanted to let everyone know that Skhilled restored our forums like a BOSS

[Skhilled]

Thank you and problem.

[aura]

Skhilled is a great person and very clever .....great job

[Skhilled]

Thank you, M'lady. 

[wesniaphania]

Skhilled is a great person and very clever .....great job

Amen to that

[beast]

  He is the type person that will go out of his way to help anyone. After knowing him for years, I have been blessed with calling him a Friend.