Sponsored Content
The Lounge What is on Your Mind? Update on vB3 Migration to Discourse - Issues and Status of BBCode Transformations Post 303045620 by Neo on Saturday 4th of April 2020 01:52:37 AM
Old 04-04-2020
According to a quick check 35 tables (posts with tables) has been stripped or skipped from the migration:


Code:
MariaDB [vb3]> select count(postid) from post where pagetext like '%[table="head"]%';
+---------------+
| count(postid) |
+---------------+
|            35 |
+---------------+
1 row in set (5.559 sec)

MariaDB [vb3]> exit
Bye
root@discourse1-app:/shared/neo/bin# /shared/neo/bin/pg
psql (10.12 (Debian 10.12-1.pgdg100+1))
Type "help" for help.

discourse=> select count(id) from posts where raw like '%[table=“head”¯]%';
 count 
-------
     0
(1 row)

We can easily write code to convert these tables to markdown; but since the posts were stripped from the migration, and this would require a totally fresh migration from the start, I am inclined, as this time, to just drop these 35 posts from the new site.

We could add them at a later time, manually, as doing this manually for 35 posts would take a few hours, but redoing the migration will take a week and be painful. It would take a few hours to write and test the script, to make sure it works anyway.

So, my inclination to not worry about losing 35 posts with TABLE tags at this time (and manually add them back in the future).
This User Gave Thanks to Neo For This Post:
 

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script migration issues

Hi All, We will be doing a Solaris 8 to Solaris 10 migration migration, just wanted to know if there are any known / common issues arise from this migration from Shell script point of view. I tried searching this site but mostly post are related to SA's question and jumpstart, etc. If there's... (4 Replies)
Discussion started by: arvindcgi
4 Replies

2. HP-UX

Migration - Compiler Issues.

All, We are migrating an application from HP-UX B.11.00 to HP-UX B.11.31 and both of them have the same informix version - 7.25se. However the compilers are different on both servers. HP-UX B.11.00 - has B3913DB C.03.33 HP aC++ Compiler (S800) HP-UX B.11.31 - has PHSS_40631 1.0 HP C/aC++... (2 Replies)
Discussion started by: helper
2 Replies

3. Programming

How to track table status delete/update/insert status in DB2 V10 z/os?

Dear Team I am using DB2 v10 z/os database . Need expert guidance to figure out best way to track table activities ( Ex Delete, Insert,Update ) Scenario We have a table which is critical and many developer/testing team access on daily basis . We had instance where some deleted... (1 Reply)
Discussion started by: Perlbaby
1 Replies

4. What is on Your Mind?

Status of Migration of Moderation Systems

First a bit of history .... A number of years ago one of our admins built a number of plugin systems for moderation, including (1) a voting system, (2) a "user feelings" system and (3) a confidential posting system. During this time, I was busy on other projects, not very active in the forums,... (1 Reply)
Discussion started by: Neo
1 Replies

5. What is on Your Mind?

VBulletin 3.8 to Discourse on Docker Migration Test Take Two

OK. Like we all do, we learn a lot from tests, test migrations, and so forth. Today, I started from scratch on test migration 2, armed with a lot more knowledge, The main differences are as follows: Installed discourse plugin ruby-bbcode-to-md before starting the install Modified... (30 Replies)
Discussion started by: Neo
30 Replies

6. What is on Your Mind?

VBulletin 3.8 to Discourse on Docker Migration Test Take Four

Test Build 4 on New Server, with changes identified in discourse test builds 2 and 3, primarily: Insuring ruby-bbcode-to-markdown is enabled. Removing line breaks from ICODE to markdown in migration script. Added vbpostid to posts in discourse to setup migrating vb "thanks" to discourse... (28 Replies)
Discussion started by: Neo
28 Replies
biomaj(1)							   USER COMMANDS							 biomaj(1)

NAME
biomaj - downloads and transform remote biological data banks SYNOPSIS
biomaj [-h] DESCRIPTION
BioMAJ (BIOlogie Mise A Jour) is a workflow engine dedicated to data synchronization and processing.The Software automates the update cycle and the supervision of the locally mirrored databank repository. User must have roots rights to run biomaj. OPTIONS
-h display the list of commands. INSTALL
At installation, BioMAJ requires a database to run (MySQL), installer should first create a database (biomaj_log) and a database user (the one used at installation setup). The database configuration for biomaj can be set or modified in /etc/biomaj/db_properties/global.properties. In the install fails due to a SQL error, the install script must be manually run to create/upgrade the database: perl /usr/share/biomaj/sql/migration/update.pl The script will create/upgrade the database and update the configuration files. ADMIN USER
A default admin user (admin) is created by the scripts. If using the biomaj-watcher, the default password (admin) MUST be changed immedi- atly via the watcher interface. If only biomaj core is used, password is useless. .PP UPGRADE
In the case of a package upgrade, if properly configured, the migration scripts will be ran automatically at install. It is possible to run manually the script: .B See perl /usr/share/biomaj/sql/migration/update.pl -h for usage. DATA BANKS
By default, biomaj is configured (data.dir in global.properties) to write banks to /var/lib/biomaj. EXAMPLES
Update a bank: biomaj --update genbank Show console biomaj --update genbank --console Show status: biomaj --status EXIT STATUS
biomaj returns a zero exist status if it succeeds, it does not represent the bank update status. AUTHOR
Olivier Sallou (olivier.sallou (at) irisa.fr) Romaric Sabas (romaric.sabas (at) irisa.fr) version 1.2.0 September 14, 2011 biomaj(1)
All times are GMT -4. The time now is 07:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy