Restore someone elses database from old version of SMF

[paarade]

I've recently joined a historical records group and my computer skills are being requested.

Years ago a member setup a website with SMF 1.1.11  and did a database dump in Oct 2010.    I have the SQL file of the dump.

Since I have little experience with PHP, MySQL and SMF I have tried unsuccessfully to restore it.    I have access to a website and have installed SMF 1.1.11 without issue.

Question 1.     Do I install SMF 1.1.11 and restore to that or do I install the most recent version of SMF and assume SMF will translate?

Question 2.     I'm working on SMF 1.1.11     Raw file gives errors when restoring so I've tried using txt editor ( I know to be careful of introducing word processing characters)  to change all instances of the errors in a copy of the original file but cause bigger issues.

So let's start there.    Thanks

Peter

[vbgamer45]

1. Install SMF 1.1.x
Or You can also just upload the database and set the settings.php file
The next step would be then upgrade the large upgrade package for SMF 2.0 depends on your PHP version on what version

2. what type of errors?

[Antechinus]

Just a note on security: 1.1.11 is going to have a range of unpatched exploits these days, so best if the directory it is installed to is password-protected while you are sorting this out.

[paarade]

I have successfully installed SMF 2.0.17 and have logged into administrators account.
In a different browser tab I have logged into cpanel and moved to DATABASES > phpMyAdmin
My database has been created and is visible in the left column.  I select it and the tables are displayed
I click the "Import" tab at the top and under the "file to import" button I select the *.sql file on my desktop
response is:
Import has been successfully finished, 113 queries executed.
This is the furthest I've gotten so far.

Change tab to SMF "My Board" page and refresh but see nothing.
Try to register as a new user and am accepted but see only the "General Discussioin" tab with 1 post

With a text editor on my desktop, I check the sql file contents and can see the data that I want restored.

Feel I am close but need that little push over the top.

[vbgamer45]

113 queries doesn't seem like a lot.
How many posts did you have in your forum

You can also to go to admin -> forum maintenance and run do find and repair errors.

[paarade]

Forum Maintenance  >  Database >  Optimize all Tables
press "run task now"

     Your database contains 63 tables.
     Attempting to optimize your database...

     All of the tables optimized.

I return to "home" tab and refresh screen...   nothing.

This is not my database and I never saw the original.    This was on a 3 1/2 diskette (remember those)
I have no idea what size original database was.    I'll work with whatever is there and build on it.

[paarade]

Found this on hxxp:archive.org [nonactive]

hxxp:web.archive.org/web/20130516045521/http:/ [nonactive]/74th.quoddy.ca/

it did live once.

[paarade]

[url]https://web.archive.org/web/20130516045521/http://74th.quoddy.ca//url]

[vbgamer45]

How large is your backup .sql file?
What is the last entries in that file.

[paarade]

240KB

Last dozen lines or so...


   (104, 0, 74, 152, 152, 3, 3, 0, 0, 1, 0),
   (105, 0, 10, 153, 153, 3, 3, 0, 0, 5, 0),
   (106, 0, 23, 154, 154, 3, 3, 0, 0, 4, 0),
   (107, 0, 10, 155, 155, 3, 3, 0, 0, 3, 0),
   (108, 0, 10, 156, 156, 3, 3, 0, 0, 3, 0),
   (109, 0, 12, 157, 157, 3, 3, 0, 0, 2, 0),
   (110, 0, 28, 164, 164, 3, 3, 0, 0, 2, 0),
   (111, 0, 12, 165, 165, 3, 3, 0, 0, 0, 0),
   (112, 0, 10, 166, 166, 3, 3, 0, 0, 0, 0),
   (113, 0, 44, 167, 167, 3, 3, 0, 0, 0, 0);
# --------------------------------------------------------

# Done

[vbgamer45]

When it says insert into table
Or create table does it start with smf_

[paarade]

In phpMyAdmin ?

It says "Importing into the database "quoddyca_smf610"

[Illori]

your old database is SMF 1.1.*? you cannot use it on SMF 2.0 without upgrading it first.

[Sir Osis of Liver]

If you need help with this, pm me.  Should be no problem to recover/upgrade the database if the dump is undamaged.

[marcosbr]

https://download.simplemachines.org/index.php?archive;b=3;v=91



And go ahead ....

[Sir Osis of Liver]

There were database changes in 1.1 branch, if backup is from 1.1.11 install it should be restored to same.  No reason to use different version.

[marcosbr]

[citação autor=paarade link=tópico=574543.msg4066652#msg4066652 data=1598804919]
Instalei com sucesso o SMF 2.0.17 e entrei na conta dos administradores.
Em uma guia diferente do navegador eu entrei no cpanel e mudei
para DATABASES > phpMyAdmin Meu banco de dados foi criado e é visível na coluna esquerda. Seleciono-o e as
tabelas são exibidas Eu clico na guia "Importar" na parte superior e sob
o
botão "arquivo para importar" eu seleciono o arquivo *.sql na minha resposta ao desktop é: A importação foi concluída com sucesso, 113 consultas executadas.
Este é o mais longe que eu tenho conseguido até agora.
Mude a guia para a página "Minha Placa" da SMF e atualize-se, mas não veja
nada.
Tente se registrar como um novo usuário e sou aceito, mas veja

apenas a aba "General Discussioin" com 1 post Com um editor de texto na minha área de trabalho, eu verifico o conteúdo do arquivo sql e posso ver os dados que eu quero restaurados.
Sinto que estou perto, mas preciso daquele empurrãozinho por
cima.
[/citação]


I forgot that only you are right ... I better go to 2.0.17!

[marcosbr]

He jumped from SMF 1.1.11 to 2.0.17

[Sir Osis of Liver]

Yes, but it doesn't work because a 1.1 database will not run in 2.0.  Can run upgrade.php on it, but that may not work due to php version or if db is damaged.  Best way to do it is make a clean 1.1.11 install, import sql, run repair_settings, and get the forum running in original version.  If all is well, then upgrade to 2.0.

[marcosbr]

No! Before upgrade to the latest version 1.1 and then follow!