FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » how to use the datadump file
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
how to use the datadump file [message #14983] Thu, 27 November 2003 00:23 Go to next message
bobmurphy is currently offline  bobmurphy   Ireland
Messages: 166
Registered: November 2003
Location: ireland
Karma: 0
Senior Member
sorry for being silly but i cant get the zip file which the datadump produced on my server on to my pc so that i can upload it to a different server ( which is what i'm trying to do )

i used ws_ftp to move it back to my pc but then it started being wierd -- no data in it etc

what is the standard procedure to move the file from one server to another as i have to move host ?? Embarassed
Re: how to use the datadump file [message #14984 is a reply to message #14983] Thu, 27 November 2003 00:27 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
You need to use the file manager to grant read access to the dump (chmod 644).

FUDforum Core Developer
Re: how to use the datadump file [message #14985 is a reply to message #14983] Thu, 27 November 2003 00:31 Go to previous messageGo to next message
bobmurphy is currently offline  bobmurphy   Ireland
Messages: 166
Registered: November 2003
Location: ireland
Karma: 0
Senior Member
thats what it's already set at

the ftp takes ages downloading it like it's getting something and when it arrives it is missing it's extenstion ( which i tried replacing to no avail ) and it's size is 0 bytes Confused
Re: how to use the datadump file [message #14987 is a reply to message #14985] Thu, 27 November 2003 00:34 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
have you tried downloading the file using the file manager?

FUDforum Core Developer
Re: how to use the datadump file [message #14988 is a reply to message #14983] Thu, 27 November 2003 00:35 Go to previous messageGo to next message
bobmurphy is currently offline  bobmurphy   Ireland
Messages: 166
Registered: November 2003
Location: ireland
Karma: 0
Senior Member
what do you mean by file manager ? Embarassed
Re: how to use the datadump file [message #14989 is a reply to message #14983] Thu, 27 November 2003 00:37 Go to previous messageGo to next message
bobmurphy is currently offline  bobmurphy   Ireland
Messages: 166
Registered: November 2003
Location: ireland
Karma: 0
Senior Member
actually sorry i know what you mean now but i dont understand how to use it for download --- looks like it works only for upload ?
Re: how to use the datadump file [message #14990 is a reply to message #14989] Thu, 27 November 2003 00:38 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
beside each file file manager has a download link.

FUDforum Core Developer
Re: how to use the datadump file [message #14991 is a reply to message #14983] Thu, 27 November 2003 00:41 Go to previous messageGo to next message
bobmurphy is currently offline  bobmurphy   Ireland
Messages: 166
Registered: November 2003
Location: ireland
Karma: 0
Senior Member
cheers Smile
Re: how to use the datadump file [message #14992 is a reply to message #14983] Thu, 27 November 2003 00:51 Go to previous messageGo to next message
bobmurphy is currently offline  bobmurphy   Ireland
Messages: 166
Registered: November 2003
Location: ireland
Karma: 0
Senior Member
the file should be uploaded in binary not in ascii -- correct ???

(on the way back upstream i mean )

[Updated on: Thu, 27 November 2003 00:52]

Report message to a moderator

Re: how to use the datadump file [message #14995 is a reply to message #14992] Thu, 27 November 2003 01:00 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Yes.

FUDforum Core Developer
Re: how to use the datadump file [message #15013 is a reply to message #14983] Thu, 27 November 2003 23:41 Go to previous messageGo to next message
bobmurphy is currently offline  bobmurphy   Ireland
Messages: 166
Registered: November 2003
Location: ireland
Karma: 0
Senior Member
when i click the button to import the datadump the page gives the following error

Quote:

(/home/oneweekofdays/www/FUDforum/include/theme/default/db.inc:135 /home/oneweekofdays/www/forum/adm/admimport.php:166 ) 1146: Table 'murphyr.fud26_ses' doesn't exist
Query: DELETE FROM fud26_ses
Server Version: 4.0.14-standard-log
[Referring Page] http://stresa.hostireland.com/~oneweekofdays/forum/adm/admimport.php?rid=2&S=6e65c7cf94fd6d2aaf454289d82ee64e&SQ=1069971745



part of that says that a
Quote:

'murphyr.fud26_ses' doesn't exist
but actually all the tables were there before the import and the import actually erased them all and destroyed the forum --- nothing left but blank pages ---

can you help me ?? Crying or Very Sad
Re: how to use the datadump file [message #15014 is a reply to message #15013] Fri, 28 November 2003 00:38 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
The problem is fixed in CVS.

FUDforum Core Developer
Re: how to use the datadump file [message #15016 is a reply to message #15014] Fri, 28 November 2003 15:46 Go to previous messageGo to next message
bobmurphy is currently offline  bobmurphy   Ireland
Messages: 166
Registered: November 2003
Location: ireland
Karma: 0
Senior Member
Ilia wrote on Fri, 28 November 2003 00:38

The problem is fixed in CVS.


have never used this system-can you recommend a good online tutorial
Re: how to use the datadump file [message #15017 is a reply to message #15016] Fri, 28 November 2003 15:48 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
The tutorial can be found at: http://www.cvshome.org/

FUDforum Core Developer
Re: how to use the datadump file [message #15033 is a reply to message #14983] Fri, 28 November 2003 23:35 Go to previous messageGo to next message
bobmurphy is currently offline  bobmurphy   Ireland
Messages: 166
Registered: November 2003
Location: ireland
Karma: 0
Senior Member
having major trouble with this -- any assistance would be of help -- if you can anwser quickly any of these questions

a) is the following info from the documention exactly the way i
need it
Quote:

cvs -z3 -d :pserver:anonymous(at)asuka(dot)prohost(dot)org:/forum21 checkout fud21_install

Once the files are retrieved, run the following commands to create the install script

cd fud21_install
chmod 644 install.php
chmod 755 create_file_list
./create_file_list install 1>> install.php



b) i cant determine which bit is the password, user name etc; could you break down the line
Quote:

cvs -z3 -d :pserver:anonymous(at)asuka(dot)prohost(dot)org:/forum21 checkout fud21_install
a bit



c) i chose to use wincvs - should this be ok -- maybe there is a simpler way seing as i only want to get the files not adjust them.



d) i dont realy understand the line
Quote:

run the following commands to create the install script

cd fud21_install
chmod 644 install.php
chmod 755 create_file_list
./create_file_list install 1>> install.php

the questions i have are:
+where do i run these - on my local computer?/ on my site somehow ?
+on what program do i run these -- somewhere in wincvs -- somewhere else ?
+where is the install.php file created ?





e) do i have to have anything else running on (my computer i'm presuming or whereever i do the creating of the .php file) like apache or php or anything.
Re: how to use the datadump file [message #15040 is a reply to message #15033] Sat, 29 November 2003 04:36 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
The CVS instructions for Linux for win32 you need to make the following changes:

1) Checkout the CVS repository via WinCVS (or other win32 cvs client) login is anonymous, there is no password.
2) You do not need to run "chmod"
3) Go into the fud21_install directory that was created thanks to CVS checkout.
4) Instead of
./create_file_list install 1>> install.php

run
php.exe create_file_list install 1 >> install.php


If you do not zlib installed do not pass put 1 after install


FUDforum Core Developer
Re: how to use the datadump file [message #15041 is a reply to message #14983] Sat, 29 November 2003 10:12 Go to previous messageGo to next message
bobmurphy is currently offline  bobmurphy   Ireland
Messages: 166
Registered: November 2003
Location: ireland
Karma: 0
Senior Member
ended up getting it through the cvs that runs using the command prompt ---

when i uploaded the update.php file there was something wrong with it

this is the error i got when i tried to use it
Quote:

Checking if SQL permissions to perform the upgrade are avaliable
Disable the forum
Forum is now disabled
Beginning the file upgrade process
Begining to decompress the archive
The upgrade script is missing the data archive, cannot run.

(also it seemed small 60k )

what i did to create it was:

a) did not alter the permissions at all as i am on a windowsXP machine and i dont think i can really ?

b) cd fud21_upgrade ( i presume the line cd fud21_install in the docs is a misprint )

c) made a copy of php.exe and put it into the fud21_upgrade directory

d) typed the line you gave me
Quote:

php.exe create_file_list install >> install.php
at the command prompt

e) uploaded the upgrade.php file that i found in the fud21_upgrade directory and ran the script

can you figure where i went wrong ??

[Updated on: Sat, 29 November 2003 19:33]

Report message to a moderator

Re: how to use the datadump file [message #15053 is a reply to message #15041] Sun, 30 November 2003 21:28 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Your install.php is so small because it is missing the archive bit. The ./create_file_list install 1>> install.php is what adds it.

FUDforum Core Developer
Re: how to use the datadump file [message #15055 is a reply to message #14983] Sun, 30 November 2003 21:49 Go to previous messageGo to next message
bobmurphy is currently offline  bobmurphy   Ireland
Messages: 166
Registered: November 2003
Location: ireland
Karma: 0
Senior Member
sorry - just edited the message above as it wasn't relevant any more -- i put in the latest problem instead
Re: how to use the datadump file [message #15058 is a reply to message #15055] Sun, 30 November 2003 23:48 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
If you making the upgrade script you should run:

php.exe create_file_list install >> upgrade.php


FUDforum Core Developer
Re: how to use the datadump file [message #15069 is a reply to message #14983] Mon, 01 December 2003 12:11 Go to previous messageGo to next message
bobmurphy is currently offline  bobmurphy   Ireland
Messages: 166
Registered: November 2003
Location: ireland
Karma: 0
Senior Member
on the (linux) server i tried

Quote:


cvs -z3 -d :pserver:anonymous(at)asuka(dot)prohost(dot)org:/forum21 checkout fud21_install

cd fud21_install
chmod 644 install.php
chmod 755 create_file_list
./create_file_list install 1>> upgrade.php




when i run the upgrade.php script in the forum directory i get what looks like a page full of binary.


[Updated on: Mon, 01 December 2003 12:12]

Report message to a moderator

Re: how to use the datadump file [message #15074 is a reply to message #15069] Mon, 01 December 2003 13:42 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
For upgrade script use:

cvs -z3 -d :pserver:anonymous(at)asuka(dot)prohost(dot)org:/forum21 checkout fud21_upgrade
cd fud21_upgrade
chmod 644 upgrade.php
chmod 755 create_file_list
./create_file_list install 1>> upgrade.php


FUDforum Core Developer
Re: how to use the datadump file [message #15080 is a reply to message #14983] Mon, 01 December 2003 17:08 Go to previous messageGo to next message
bobmurphy is currently offline  bobmurphy   Ireland
Messages: 166
Registered: November 2003
Location: ireland
Karma: 0
Senior Member
am getting
Quote:

Internal Server Error, this is an error with your script, check your error log for more information.

when i try to run upgrade.php on the old server --

i have tried getting the update.php from cvs using the new server and downloading it to my machine and then reuploading it to the server in question ( i dont have command line access on the old server - thus the long way around method)

i have also used cvsnt on my local machine to create a file which i uploaded to the old server

i get the internal server error with both methods

i thought zlib compression might have something to do with it so heres the details- both servers use zlib compression but my local machine doesn't

also i got this same problem before when the file didnt actually exist where i was instructing the browser to look for it the server gave that same error however i have verified the existance of the file upgrade.php correct directory/spelling etc

why am i getting this error ?
Re: how to use the datadump file [message #15091 is a reply to message #15080] Tue, 02 December 2003 00:14 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Not sure, I generate upgrade/install archive almost everytime and often serveral times a day and never had any problems doing so.

FUDforum Core Developer
Re: how to use the datadump file [message #15093 is a reply to message #14983] Tue, 02 December 2003 00:52 Go to previous messageGo to next message
bobmurphy is currently offline  bobmurphy   Ireland
Messages: 166
Registered: November 2003
Location: ireland
Karma: 0
Senior Member
really the cvs method seems to work fine --- the exact same upgrade script that i downloaded works fine on the new server --- it just doesnt work on the old one --- so i dont think it's a problem with the cvs download or build -- it could be a problem with the script though.

[Updated on: Tue, 02 December 2003 00:52]

Report message to a moderator

Re: how to use the datadump file [message #15095 is a reply to message #15093] Tue, 02 December 2003 01:40 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
I never tried the archive generation script on windows, so it is possible it may have issues on that OS.

FUDforum Core Developer
Re: how to use the datadump file [message #15099 is a reply to message #14983] Tue, 02 December 2003 12:14 Go to previous messageGo to next message
bobmurphy is currently offline  bobmurphy   Ireland
Messages: 166
Registered: November 2003
Location: ireland
Karma: 0
Senior Member
Quote:

The problem is fixed in CVS.


ok well i upgraded the forum on the old server using the new rc9 download on the site -- having upgraded the new one via the rc9 from the cvs site --- so they are both rc9 --- i did a new datadump between them but i still get a similar error

(/home/oneweekofdays/www/FUDforum/include/theme/default/db.inc:133



/home/oneweekofdays/www/forum/adm/admimport.php:169



) 1146: Table 'murphyr.fud26_ses' doesn't exist



Query: DELETE FROM fud26_ses



Server Version: 4.0.14-standard-log



[Referring Page] http://stresa.hostireland.com/~oneweekofdays/forum/adm/admimport.php?rid=2&S=a901659213cf3c3329b9ef2a342b02e1&SQ=e795713ab96d92b7d368e17eecc246f1



EDIT

just to be on the safe side, i have since reinstalld ver2.6rc9 on the new server from the regular download available on the site -- so now both servers are running the same rc9 forum; however the error still persists:

i'll include it here just in case you need it:
(/home/oneweekofdays/www/FUDforum/include/theme/default/db.inc:133

/home/oneweekofdays/www/forum/adm/admimport.php:169

) 1146: Table 'murphyr.fud26_ses' doesn't exist

Query: DELETE FROM fud26_ses

Server Version: 4.0.14-standard-log

[Referring Page] http://stresa.hostireland.com/~oneweekofdays/forum/adm/admimport.php?rid=2&S=b98b8143746768d375a6f859c044b77c&SQ=3ffd89dfb818459d484dcacfbec31d4d

[Updated on: Tue, 02 December 2003 15:22]

Report message to a moderator

Re: how to use the datadump file [message #15109 is a reply to message #15099] Tue, 02 December 2003 16:25 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Strange it works here flawlessly and I was even able to convert between forums using a different database backends.

Could you please send me your datadump?


FUDforum Core Developer
Re: how to use the datadump file [message #15110 is a reply to message #14983] Tue, 02 December 2003 16:56 Go to previous messageGo to next message
bobmurphy is currently offline  bobmurphy   Ireland
Messages: 166
Registered: November 2003
Location: ireland
Karma: 0
Senior Member
emailing it to you at the moment
Re: how to use the datadump file [message #15119 is a reply to message #15110] Tue, 02 December 2003 23:55 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Just imported the data dump you sent me without any problems.
The query failure you are getting implies that fud26_ses table does not exist (should've been created by importing of data).

The only possible reason I can see for this happening if the code that supposed to read the SQL queries from the dump fails to do so, which would fall inline with your previous comments about the destination forum lacking any SQL data.

You can check this by adding var_dump($i) before line 169 of admimport.php that'll print how many lines of SQL were imported.


FUDforum Core Developer
Re: how to use the datadump file [message #15123 is a reply to message #14983] Wed, 03 December 2003 01:23 Go to previous messageGo to next message
bobmurphy is currently offline  bobmurphy   Ireland
Messages: 166
Registered: November 2003
Location: ireland
Karma: 0
Senior Member
am pretty confused here -- i have tried three different ftp programs and they all show the directories inside of the data root and server root as being empty -- yet the forum seems to function normally(rc9) - i checked and the table fud26_ses exists ( 9 fields i think ) and has a line of data in it.

obviously i cant adjust the file you mentioned as it isnt there --

maybe i'm mistaken but it looks to me that there is something else wrong here.
Re: how to use the datadump file [message #15124 is a reply to message #15123] Wed, 03 December 2003 01:29 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
I think this is because you do not have permissions (the forum is locked) to view the contents of those directories. So the forum is showing them as empty. You need to use the "File Unlock" admin control panel to unlock the forum's files.

FUDforum Core Developer
Re: how to use the datadump file [message #15125 is a reply to message #14983] Wed, 03 December 2003 01:44 Go to previous messageGo to next message
bobmurphy is currently offline  bobmurphy   Ireland
Messages: 166
Registered: November 2003
Location: ireland
Karma: 0
Senior Member
i hope i did this right

i added
var_dump($i);

before line 169 in admim.php

then i loaded the dump in .....

got the following
Quote:

int(0) (/home/oneweekofdays/www/FUDforum/include/theme/default/db.inc:133
/home/oneweekofdays/www/forum/adm/admimport.php:170
) 1146: Table 'murphyr.fud26_ses' doesn't exist
Query: DELETE FROM fud26_ses
Server Version: 4.0.14-standard-log
[Referring Page] http://stresa.hostireland.com/~oneweekofdays/forum/adm/admimport.php?rid=2& amp;S=9e2028a2242528162cb15c7b97c60ff9&SQ=00dbf8c17044e65c10887c77cff4b f58


hope it makes some sense to you -- it doesnt look a lot different to the last thing to me !!!
Re: how to use the datadump file [message #15126 is a reply to message #15125] Wed, 03 December 2003 02:29 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Actually is was very helpful, thank you.

int(0) means that not a single line of SQL was processed, now we just need to figure out why.

I am assuming you are trying to import the same datadump that you have sent me, which is compressed. Could you try doing the following:

gzip -d [data_dump_file].gz this will uncompress it creating [data_dump_file]. Then try importing the non-compressed file. I want to see if this is a zlib related problem or something more generic.


FUDforum Core Developer
Re: how to use the datadump file [message #15127 is a reply to message #14983] Wed, 03 December 2003 15:52 Go to previous messageGo to next message
bobmurphy is currently offline  bobmurphy   Ireland
Messages: 166
Registered: November 2003
Location: ireland
Karma: 0
Senior Member
ok - just to clarify i did the following

reinstalled rc9 on the server
unzipped the file on the server( it ended up as before but with a .fud extension instead of a .fud.gz) - btw the old .gz file was deleted in the process i suppose this is expected
i didnt know whether you meant to add the extra line of code at 169 or not so i put it in anyway ( i can always do it again without it if needs be)
then i imported the .fud file ( i only give the path to the file btw in case this is a wrong practice on my part)
i got the same error

the start of it was
int(0)


didnt bother including the rest as it's the same as before i think.

am away for a few hours so i am pming you my ftp username and password in case you want to have a go
Re: how to use the datadump file [message #15128 is a reply to message #15127] Wed, 03 December 2003 15:57 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Ok, I got the account information and will try to import the datadump hopefully figuring out what is the problem...
I'll write a import script like script that will emulate the 'real' script and hopefully be affected by the same problem.

I'll let you know once I got any results.


FUDforum Core Developer
Re: how to use the datadump file [message #15135 is a reply to message #15128] Wed, 03 December 2003 18:20 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
I just tried importing the compressed datadump with a test script "admimpt.php" inside the forum/adm/ directory. It only differs from the "real" import script is that the user authentication is not performed.

Anyhow, the thing is that is has worked just fine with the uncompressed file and imported the data correctly. (you can try it for yourself if you like).

In fact the only bug that I found was with the query counter.


FUDforum Core Developer
Re: how to use the datadump file [message #15138 is a reply to message #14983] Wed, 03 December 2003 19:56 Go to previous messageGo to next message
bobmurphy is currently offline  bobmurphy   Ireland
Messages: 166
Registered: November 2003
Location: ireland
Karma: 0
Senior Member
cant get the tree view button to show up in the thread page -- is there something wrong --
Re: how to use the datadump file [message #15139 is a reply to message #15138] Wed, 03 December 2003 20:18 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Did you enable threaded views?

FUDforum Core Developer
Re: how to use the datadump file [message #15140 is a reply to message #14983] Wed, 03 December 2003 20:25 Go to previous messageGo to previous message
bobmurphy is currently offline  bobmurphy   Ireland
Messages: 166
Registered: November 2003
Location: ireland
Karma: 0
Senior Member
you know i did of course but i must have forgotton to press set at the end because when i went back it there is was !!!
Pages (2): [1  2    »]  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: lock/unlock files
Next Topic: How do I make new forums?
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 10:29:53 GMT 2024

Total time taken to generate the page: 0.03768 seconds