Importing database

[hj]

Can I import a database from an old 1.3 version of phpMyFaq into the new 2.0.10 version?

Or have all the tables changed?

How would I upgrade from 1.3 to a version with spam/captcha protection?

thanks

[Thorsten]

Hi,

you cannot do this.

I would suggest:

1. Update your 1.3.x version to 1.6.12

2. Update the 1.6.12 version to 2.0.10

Bye
Thorsten

[hj]

OK, I'll try that upgrade path.

Thank's Thorsten!

[hj]

Ok, I tried that...installed 1.6.12 no problem.

But when I try and import the dump (from 1.3.14) into phpMyAdmin, I get this error:

Code: Select all

Error
SQL query:

# pmf: kbasefaqchanges kbasefaqnews kbasefaqrubrik kbasefaqvoting kbasefaqdata kbasefaqcomments kbasefaquser kbasefaqvisits
# DO NOT REMOVE THE FIRST LINE!
# otherwise this backup will be broken
#
# Table: kbasefaqchanges
INSERT INTO kbasefaqchanges( id, beitrag, lang, user, datum, what ) 
VALUES (
'1',  '1',  '',  '1',  '1105097032',  ''
);


MySQL said: 

#1146 - Table 'myfaq16.kbasefaqchanges' doesn't exist 

Maybe I not use the correct upgrade procedure??.......I am installing 1.6.12, and trying to import the 1.3.14. database backup into the new version.

regards

[Thorsten]

Hi,

no, that's the wrong way.

Use your 1.3.14 installation and do the update path described in the documentation:

http://www.phpmyfaq.de/docs/dokumentation.1.6.en.php#3a

The do the update to 2.0.10:

http://www.phpmyfaq.de/dokumentation.2.0.en.php#3c

bye
Thorsten

[hj]

Oh, I apologise Thorsten....sorry, I jumping to conclusions !

You're right, I didn't read the docs properly

Sorry!

[hj]

This is just an offshoot question....

While doing the upgrading I decided to backup (download) the whole of the old script. This was a whopping 13.7mb!

Over 10mb of this total was made up of 'tracking files' in the data folder. Presumably these are a log of activity??

Can the tracking files be thrown away from time to time to preserve space?

[Thorsten]

Hi,

you can remove the logging files if you like.

bye
Thorsten

[hj]

OK, thanks.

Also I notice something strange in the old 1.3 version..

The installer makes tables like 'faqchanges' and 'faqdata' etc. But the backup dump from this version describes the tables as 'kbasefaqchanges' or 'kbasefaqdata'.

??

Obviously a backup/dump would not import because the tables are different!!

OK, maybe it doesn't matter but I'm curious why it does that?

regards

[Thorsten]

Hi,

you installed the FAQ the first time with the prefix "kbase" and the second time without a prefix. That's the reason!

bye
Thorsten

[hj]

There's an answer to everything....and you have them all

thanks, Thorsten.