SMF Database Upload

[L Lawliet]

Hi,

I have a database of SMF 2.0.6. How do I install this database now?

[m4z]

You mean you have a database dump or a running database with SMF 2.0.6 data in it? Either way, you'd have to find an SMF 2.0.6 archive and (probably) "install" it.

I don't know much about this, but I'd install freshly, then restore the db dump on top.

Afterwards, I'd recommend upgrading to a more current version.

[Sir Osis of Liver]

Do a clean install with new database, import the dump into the database.

[L Lawliet]

You mean you have a database dump or a running database with SMF 2.0.6 data in it? Either way, you'd have to find an SMF 2.0.6 archive and (probably) "install" it.

I don't know much about this, but I'd install freshly, then restore the db dump on top.

Afterwards, I'd recommend upgrading to a more current version.

When I did it, I took this problem:

Line #527: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

[m4z]

The data was probably dumped from a different DB version than you are currently using. Can you post your current version of SQL and the content of that line (and sanitize any personal data, if there's any)? Then an SQL expert can tell what needs to be changed.

[L Lawliet]

The data was probably dumped from a different DB version than you are currently using. Can you post your current version of SQL and the content of that line (and sanitize any personal data, if there's any)? Then an SQL expert can tell what needs to be changed.

Koodi [Valitse] Laajenna

Line #527: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"' at line 3
Line #1129: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' at line 2
Line #1278: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' at line 3
Line #1285: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' at line 2
Line #1542: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
Line #1550: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
Line #1566: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' at line 3
Line #1582: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
Line #1598: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
Line #1614: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
Line #1622: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
Line #1630: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
Line #1654: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

I have this problems. I looked my database file and it was written: "-- MySQL dump 10.13  Distrib 5.1.73, for unknown-linux-gnu (x86_64)"

Where can I download mysql 5.1.73 version?

[Sir Osis of Liver]

You can get it here, but really shouldn't be necessary.  Have you tried fixing the dump?

[L Lawliet]

You can get it here, but really shouldn't be necessary.  Have you tried fixing the dump?

How can I fix it?

[Sir Osis of Liver]

Depending on how large the db is, you can load the sql into a text editor (if it's zipped, unzip it) and see what's causing the errors.  Looks like it's right at the top of the file, maybe in the header.

[L Lawliet]

When I close my forum, I took full cpanel backup. Then I tell my host firm if they restore it. Then they succesfully restore it. Thank you.