Generic MySQL Imports
Generic MySQL Imports
By Paul
2/5 based on 3 votes. The median rating is 2.
By Paul
To import to WSN Gallery 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 Gallery 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 Gallery table.
After importing data directly to the database, it's neccesary to regenerate the counters. Click 'regenerate counters' in your WSN Gallery admin panel and run the regeneration for all images, 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 Gallery 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 Gallery table.
After importing data directly to the database, it's neccesary to regenerate the counters. Click 'regenerate counters' in your WSN Gallery admin panel and run the regeneration for all images, 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.
Submitted: 11/30/03 (Edited 10/13/06)
Description: Possible procedures for moving your existing gallery to WSN Gallery.
Views:
2768 views. Averaging 2 per day.
In the most recent 30 day period, there've been 6 views.