Generic MySQL Imports
Generic MySQL Imports
By Paul
By Paul
To import to WSN Knowledge Base from any mysql table you can try this process:
1) Using phpmyadmin, alter the names of each field of your old data table to match the equivilant WSN Knowledge Base field names. Set all fields to NOT NULL as well.
2) Remove any extraneous left-over fields.
3) Export the data from this with complete inserts.
4) Import this data to your WSN Knowledge Base table.
After importing data directly to the database, it's neccesary to regenerate the counters. Click 'regenerate counters' in your WSN Knowledge Base admin panel and run the regeneration for all articles, categories and members as well as regenerating totals and your category selector.
If you can't import your database, you can hire database import service at the standard WSN services rate (see the site's services section).
Print
E-Mail
Report1) Using phpmyadmin, alter the names of each field of your old data table to match the equivilant WSN Knowledge Base field names. Set all fields to NOT NULL as well.
2) Remove any extraneous left-over fields.
3) Export the data from this with complete inserts.
4) Import this data to your WSN Knowledge Base table.
After importing data directly to the database, it's neccesary to regenerate the counters. Click 'regenerate counters' in your WSN Knowledge Base admin panel and run the regeneration for all articles, categories and members as well as regenerating totals and your category selector.
If you can't import your database, you can hire database import service at the standard WSN services rate (see the site's services section).
Rating:
2/5 based on 3 votes. The median rating is 2.
Rate this article:
Submitted: 11/30/03 (Edited 10/13/06)
Description: Possible procedures for moving your existing knowledge base to WSN Knowledge Base.
Views:
2723 views. Averaging 2 per day.
In the most recent 30 day period, there've been 2 views.