Admin Help - Rapid Classified v3.3

Administrator Help - RC v3.3	Search for: by: Edit Help
Expand All \| Collapse All 1.0 Initial Configurations 1.1 Admin Preferences 1.2 Miscellaneous Configurations 1.3 Recovering Admin Logon 2.0 Categories Administration 2.1 Price Level 2.2 Optional Fields 2.3 Options Builder & Adv. Search 2.4 Alternative Adv. Search Page 3.0 Design and Appearance 3.1 XL Templates 3.2 Advanced Design 3.3 Logo 3.4 Main Page 3.5 CSS Editor 4.0 Translation/Text Modification 4.1 RC Lookup 5.0 Content Management 5.1 Email Templates 5.2 Page Content Templates 5.3 News Letter Templates 5.4 "True" Content Pages 5.5 Header/Footer Inclusive Pages 5.6 Side Bars Advert. Pages 5.7 Custom Inclusive Pages 5.8 Backup/Restore Templates 5.9 Top Content Pages 5.10 Side/Portal Bars, Main Page 5.11 Ticker at Remote Site 5.12 FAQ 6.0 Classified Operations 6.1 User Accounts 6.2 Multiple Accounts Detection 6.3 Posting Ads (Free Mode) 6.4 Miscellaneous Operations 6.5 Forum 6.6 Counter and Statistics 7.0 Payment System 7.1 Overview 7.2 Configuration (Credits Mode) 7.3 Configuration (Package Mode) 7.4 Merchant Configuration 7.5 Posting Ads in Pay Mode 7.6 Hot List Promotion 8.0 SE Optimization 8.1 Content exclusion list 8.2 Dynamic Meta Tags Builder 8.3 Caching Ads 8.4 Google Site Maps 8.5 URLs Rewrite 9.0 RSS Management 9.1 RSS Feeds Writer 9.2 RSS Feeds Reader 9.3 RSS Feeds Reference 10.0 Banners Rotator 10.1 Administration. Banners types 10.2 Automated Submissions 11.0 Relative Content Links 11.1 Relative Ad Description 12.0 Conversion Tools 12.1 SQL to Access (backup) 12.2 Access to SQL (restore) 12.3 Moving from Access to SQL 12.4 Moving between MySQL/MSSQL 12.5 Switching Hosting Service (SQL) 13.0 Maintaining Healthy Database	Chapter - 12.0 Conversion Tools Warning! Improper use of this tool may invalidate SQL database used for Rapid Classified installation. Conversion Tools provided on "AS IS" bases without warranties. GASoft is not responsible for any data loss resulted from the use of the Conversion Tools. Database backup/restore tool for Rapid Classified running with MySQL or MSSQL database (from here on both types of database would be referenced as SQL). The tool is extremely useful for: Occasional SQL backup if hosting does not provide backup of SQL database (most do however). When decision was made to move database from MS Access to SQL or from MySQL to MSSQL and vise versa When planning to move the site running with SQL from one hosting server to another. SQL database backed up to a special blank cldb.mdb MS Access database, which may be further downloaded and stored at a local computer or moved to other site for further restore to another SQL database. The tool comprises two utilities under the same page with GUI – SQL to Access and Access to SQL SQL to Access – Backup utility. Copies all records from all tables in SQL database into a blank MS Access database Access to SQL – Restore utility. Copies all records from all tables in MS Access database into an SQL database First Time Configuration Warning! Do not continue if classified configured to run with MS Access database and you are NOT planning to move from MSAccess to SQL. Conversion Tools are only suited to work with SQL database. Conversion Tools partially pre-installed. To complete installation follow instructions below: Change the conversion tools page name (for additional security). Open site in FTP and change the db_convert.asp page name retaining .asp extension. For instance to: my_rollout_page.asp Open Miscellaneous Configs admin page, type a new page name (less .asp extension) into "Conversion Tools Page Name" field and click "Save Configurations" button. Download a blank cldb.mdb MS Access database from http://www.4u2ges.com/zips/cldb.zip Skip the following step if classified currently configured with MS Access database and you intend to move to SQL Upload blank MS Access database cldb.mdb into db folder at classified installation overriding an existed MS Access database.
©2003-2010 Rapid Classified v3.3 GA Soft

Warning! Improper use of this tool may invalidate SQL database used for Rapid Classified installation. Conversion Tools provided on "AS IS" bases without warranties. GASoft is not responsible for any data loss resulted from the use of the Conversion Tools.

Database backup/restore tool for Rapid Classified running with MySQL or MSSQL database (from here on both types of database would be referenced as SQL). The tool is extremely useful for:

Occasional SQL backup if hosting does not provide backup of SQL database (most do however).
When decision was made to move database from MS Access to SQL or from MySQL to MSSQL and vise versa
When planning to move the site running with SQL from one hosting server to another.

SQL database backed up to a special blank cldb.mdb MS Access database, which may be further downloaded and stored at a local computer or moved to other site for further restore to another SQL database.

The tool comprises two utilities under the same page with GUI – SQL to Access and Access to SQL

SQL to Access – Backup utility. Copies all records from all tables in SQL database into a blank MS Access database

Access to SQL – Restore utility. Copies all records from all tables in MS Access database into an SQL database

First Time Configuration

Warning! Do not continue if classified configured to run with MS Access database and you are NOT planning to move from MSAccess to SQL. Conversion Tools are only suited to work with SQL database.

Conversion Tools partially pre-installed. To complete installation follow instructions below:

Change the conversion tools page name (for additional security). Open site in FTP and change the db_convert.asp page name retaining .asp extension. For instance to: my_rollout_page.asp
Open Miscellaneous Configs admin page, type a new page name (less .asp extension) into "Conversion Tools Page Name" field and click "Save Configurations" button.
Download a blank cldb.mdb MS Access database from http://www.4u2ges.com/zips/cldb.zip

Skip the following step if classified currently configured with MS Access database and you intend to move to SQL

Upload blank MS Access database cldb.mdb into db folder at classified installation overriding an existed MS Access database.