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.2 Access to SQL (restore) Make sure to follow First Time Configuration in chapter 12.0 Navigate to Global Manager admin page and click Access-2-SQL. You would be directed to the main conversion tools interface. From here, you may restore cldb.mdb MS Access database into SQL. The restore is most suited if you would like to move installation from MS Access database to SQL, from MySQL to MSSQL, from MSSQL to MySQL, from one site to another (running MySQL or MSSQL). Warning! All records currently stored in SQL database would be effectively removed and replaced with records stored in cldb.mdb. Therefore, answer the following questions before proceeding with restore: Are you sure what records stored in cldb.mdb currently located in db folder? Do you know when cldb.mdb in db folder was used for backup of SQL? Are you sure cldb.mdb in db folder is not blank or mistakenly uploaded from different source or even belong to different RC version? Note: The restore or Access to SQL does not create tables in SQL database and cannot monitor whether the cldb.mdb tables structure corresponds to the RC version currently installed with SQL. Hence keep records of a date when SQL was converted to cldb.mdb, version of RC it was converted with, specifically if you are running multiple installations with dissimilar RC versions! Type password and click "Convert MS Access to SQL". Depending on a size of the database, the conversion might take a long time. Try to run conversion tools during off pick hours and lock classified and delete current sessions from Global Manager admin page. Do not interrupt the process once it is started and wait until receive a message that the conversion complete. The SQL database at this point is restored from cldb.mdb located in db folder. Click Back to Site link to return to the default page and make sure the site is operational. Note: use only Back to Site link to return to the site and not back browser button. The link first leads to the cache reset page (which is essential after restore) and then to the default page.
©2003-2010 Rapid Classified v3.3 GA Soft

Make sure to follow First Time Configuration in chapter 12.0

Navigate to Global Manager admin page and click Access-2-SQL. You would be directed to the main conversion tools interface. From here, you may restore cldb.mdb MS Access database into SQL.

The restore is most suited if you would like to move installation from MS Access database to SQL, from MySQL to MSSQL, from MSSQL to MySQL, from one site to another (running MySQL or MSSQL).

Warning! All records currently stored in SQL database would be effectively removed and replaced with records stored in cldb.mdb. Therefore, answer the following questions before proceeding with restore:

Are you sure what records stored in cldb.mdb currently located in db folder?
Do you know when cldb.mdb in db folder was used for backup of SQL?
Are you sure cldb.mdb in db folder is not blank or mistakenly uploaded from different source or even belong to different RC version?

Note: The restore or Access to SQL does not create tables in SQL database and cannot monitor whether the cldb.mdb tables structure corresponds to the RC version currently installed with SQL.

Hence keep records of a date when SQL was converted to cldb.mdb, version of RC it was converted with, specifically if you are running multiple installations with dissimilar RC versions!

Type password and click "Convert MS Access to SQL". Depending on a size of the database, the conversion might take a long time. Try to run conversion tools during off pick hours and lock classified and delete current sessions from Global Manager admin page. Do not interrupt the process once it is started and wait until receive a message that the conversion complete. The SQL database at this point is restored from cldb.mdb located in db folder. Click Back to Site link to return to the default page and make sure the site is operational. Note: use only Back to Site link to return to the site and not back browser button. The link first leads to the cache reset page (which is essential after restore) and then to the default page.