MyPhpadmin backup and restore

Worker Joined: Jun 09, 2007 Posts: 172

I am sorry if this is the wrong place, please move to correct place.

well I looked and couldnt really find an answer. I did see some other options that I could try, but first wanted to post this and see if someone could direct me to what I need to do to make this right.
Sorry for the long post, want to make sure I give all info I can.

running latest version of xampp
latest version of RN
1st computer has everything running, with changes and mods

Using PhpMyadmin, I did an export of the database. Entire export, saved to a zip file

2nd computer....this is computer I am moving the site to so and will complete work.
running latest version of xampp
uncompressed latest version of RN

Now before I did the install of stock database and stuff, I edited the cfg file, and I loaded MyPhpAdmin
and created the database name the same as it was on the first one. and then inported the entire file. It had
the same number beside its name as on the original, and the list looked to be the same.

To shorten this some, after seeing the first error, I then went back, deleted everything and started again with xampp
and RN. I did all the install steps and had everything running stock. I then added and did the insert of my backed
up sql file. I am still getting errors that things are missing.

if i click on private msgs I get this:

General Error

Could not query attachment information

DEBUG MODE

SQL Error : 1146 Table 'folm.nuke_bbattachments_config' doesn't exist

SELECT * FROM nuke_bbattachments_config

Line : 91
File : attachment_mod.php

members list:

General Error

Could not query attachment information

DEBUG MODE

SQL Error : 1146 Table 'folm.nuke_bbattachments_config' doesn't exist

SELECT * FROM nuke_bbattachments_config

Line : 91
File : attachment_mod.php

user's administration: Users

ERROR: YOU NEED TO UPDATE YOU DATA BASE TABLE NOW!!
Run rnya.php from the root of your phpnuke installation, update the database tables, and delete the file afterwards!
The version of the module is 4.4.2 and the version of your data base table is ['version']

I have also noticed that if i try to move blocks around, i get no change. but I can remove them from showing or delete them. I cannot change their weight or numbers...if i do a save after trying it will not make the change.

Now I still have the original site up on the 1st computer so i could try to backup the database again, but would i get the same problems? is there a trick to making backup with Myphpadmin? Should I use something else to backup? maby the backup DB in RN? or another program?

The only changes I have made to the 2nd computer has been in the themes, and I had to change some of the paths for pics but that was edited inside RN, i didnt have to edit any files.

Sorry for the book, ty for any help

Posted: Fri Nov 21, 2008 1:22 pm

Can you confirm that when you say latest RN you mean 2.3. Can you look at the original you exported and make sure that there is a bb_attachments_config in it. This and several other attachments related tables were just added in 2.3 so if you didn't install from the 2.3 distribution you won't have those tables.

I also don't get what's happening in your error messages. The query that is in the attachment_mod.php table is:

Code:

   $sql = 'SELECT *


      FROM ' . ATTACH_CONFIG_TABLE;

The value of the constant ATTACH_CONFIG_TABLE is set in constants.php in the attachment mods includes directory and is prefaced by $prefix. What is your prefix that's set in config.php ... folm_nuke or just nuke? I don't understand why you are seeing the message 'folm.nuke_bbattachment_config doesn't exist when your select is formed the way it apparently is.

registered · Posted: Fri Nov 21, 2008 3:05 pm

Stock phpNuke tables won't work with RavenNuke directly. Easier to use RavenNuke installer to get the correct tables.

"folm.nuke_bbattachments_config" means
"nuke_bbattachments_config" table within the "folm" database

Posted: Fri Nov 21, 2008 6:58 pm

I am trying to go back and check for sure that the original is not just a update to 2.3, but i thought when i started i started everything from scratch...it was working on my local machine for testing.
after it was setup I created with phpmyadmin the database name folm. but when i did my export, i believe that i only did the export for folm, so when i installed 2.3 on the new computer i did the same, i created the folm and inported the database that i saved.
I guess in short, I had ravennuke install into the folm database

Posted: Fri Nov 21, 2008 7:23 pm

ok, i have been able to look at the database of my original and the one i moved it to and they both dont have bbatachments....why it would call for this I dont know.

I did notice that i had another database name called folm1...this held the older version that did have that...but as you can see in the error it is not calling for folm1.

I will try to make some more checks, other then that I will start from scratch again....

Posted: Sun Nov 23, 2008 10:53 pm

ok, i went back and did a fresh install....i can only guess that the original one i had was the old version that was updated and when i moved it, it caused the errors.

I did notice that the info block on the first page is show the version as 2.2.2 and didnt know if it was suppose to show 2.3......i actually had to look around before i seen something that said i was running 2.3

Posted: Sun Nov 23, 2008 11:37 pm

The version number shown on the info block is the version number for that particular info block, not the RN version number Smile

Posted: Mon Nov 24, 2008 11:03 am

I wasnt for sure...that is why i wanted to pass on that little bit of info Smile

.....I am looking at another info box that will give me more info plus the version of RN.
Other then that it may be a comment or suggestion to make the version number more visible to us that are slow....hehehe