Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Re: Problems with nph-build.cgi

Quote Reply
Re: Problems with nph-build.cgi In reply to
You can import a dump on the SQM Monitor screen. You can give it a local or remote file name.

I _strongly_ suggest when dumping the database to dump the table structure only (no data) to one file, then the data to another file. This lets you rebuild the database as well as the data easily.

If you have a lot of links, I would dump the links separately, into it's own file, with "Create table" statements included. Then dump the rest of the files into their own file.

The _only_ files you really need are the Links, Categories and Users, as long as you have done a recent "build" of the site. All the other tables are either visitor tracking and updates or generated by the re-index and build.

The problem with large databases is that the HTML process will time out on large imports (dumps are much, much faster). You may have to do it via telnet.

In order to do it via telnet, you need to either write out the "insert statements with each field named" or you need to have a database set up _exactly_ like the data, with _all_ the fields of _all_ the tables in the same order. Then, you can just use the 'mysql' command directly and feed the file into the program using the '<' character.

The "dumpfile" is really just a lot of SQL commands, one after another, which is why it's portable from machine to machine.

The mysql database engine views the file as a user typing in commands very, very fast :) <G>

PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://postcards.com/FAQ


Subject Author Views Date
Thread Problems with nph-build.cgi AndreasH 5853 Nov 26, 2000, 3:09 PM
Thread Re: Problems with nph-build.cgi
Stealth 5795 Nov 27, 2000, 6:58 PM
Thread Re: Problems with nph-build.cgi
AndreasH 5772 Nov 28, 2000, 5:37 AM
Thread Re: Problems with nph-build.cgi
Stealth 5779 Nov 28, 2000, 6:56 AM
Thread Re: Problems with nph-build.cgi
AndreasH 5774 Nov 28, 2000, 12:02 PM
Thread Re: Problems with nph-build.cgi
AndreasH 5749 Nov 30, 2000, 2:32 AM
Thread Re: Problems with nph-build.cgi
pugdog 5745 Nov 30, 2000, 4:04 AM
Thread Re: Problems with nph-build.cgi
AndreasH 5732 Nov 30, 2000, 5:48 AM
Thread Re: Problems with nph-build.cgi
pugdog 5733 Nov 30, 2000, 6:05 AM
Post Re: Problems with nph-build.cgi
AndreasH 5733 Nov 30, 2000, 6:38 AM
Thread Re: Problems with nph-build.cgi
AndreasH 5750 Nov 30, 2000, 8:32 AM
Thread Re: Problems with nph-build.cgi
pugdog 5736 Nov 30, 2000, 4:40 PM
Thread Re: Problems with nph-build.cgi
AndreasH 5731 Dec 1, 2000, 3:39 AM
Post Re: Problems with nph-build.cgi
pugdog 5715 Dec 1, 2000, 4:31 AM
Post Re: Problems with nph-build.cgi
pugdog 5749 Nov 28, 2000, 9:33 AM