<x-flowed>[EMAIL PROTECTED], 2001-03-23 23:39 -0800
>... omits all user(name?) data?
Jeff,
Correct, all of the users data is stripped. There is no user data in the
initial table supplied by phpWebSite.
>... hardcoded "leaf" vs $DB?
It would for our project, but I'm going to write a SF setup FAQ for the
phpWebSite project. Other SF projects have long names.
>maybe better to just pipe directly into sed commands to avoid having
>unnecessary copies of the database that include the unaltered author data?
I'll be keeping the unstripped dbase/leaf.sql as a backup for emergencies.
I ran umask 077 prior to executing mysqldump. This tarball allows everyone
to mirror our site, or play with the content on a local machine.
>this seems odd... if there are more entries in the authors table than just
>admin,
There are.
>they will be reduced to just admin (with a bunch of failed
>duplicate inserts)
Correct, but I don't understand your comment about "failed duplicate
inserts". Did I do something wrong? The test.sql output looked correct.
>is it really a good idea to lose author attribution? are there any foreign
>keys depending on entries in this table? maybe better just to "fix" their
>password to a dummy in the copy? I am not familiar with the schema, so I
>don't know what else might be a problem, but whatever you do, try it and
>load it into a temporary partition to verify that it works rather than
>depending solely on eyeball review...
I already checked that sed was doing what I wanted before posting. However,
I haven't tried to use it on another site.
Eric,
Would you do me a favor and test this?
--
Mike Noyes <[EMAIL PROTECTED]>
http://leaf.sourceforge.net/
_______________________________________________
Leaf-devel mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/leaf-devel
</x-flowed>
