New Mars Forums

Official discussion forum of The Mars Society and MarsNews.com

You are not logged in.

Announcement

Announcement: This forum is accepting new registrations by emailing newmarsmember * gmail.com become a registered member. Read the Recruiting expertise for NewMars Forum topic in Meta New Mars for other information for this process.

#3151 2023-11-12 18:12:56

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 17,841

Re: Housekeeping

For SpaceNut .... as soon as I find out where kbd512 is planning to save the files, I'll check into what's needed for you to have access. The main account is set up under newmarsmember@gmail.com.  I will ask kbd512 about the location at tonight's Google Meeting. (th)

Offline

#3152 2023-11-13 19:33:05

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 17,841

Re: Housekeeping

For SpaceNut re inquiry about engines ...

In the post at this location:http://newmars.com/forums/viewtopic.php?pid=215881#p215881

you inquired about engines (rocket engines, that is) ....

I did a quick search on topics with engine in the title, and there are more than one page of them.

The topic on shipping carbon and water to Mars may not be the best place to look, but there sure do appear to be plenty of alternatives.

(th)

Offline

#3153 2023-11-13 19:52:57

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 29,178

Re: Housekeeping

I book marked a topic where fuels are to be used and in that topic the Raptor is part of the starship for reuse if we recycle the starship engines which burn the methane and Lox but for the others there is a problem that I wanted to flag as we keep playing number games for new innovative designs.

Offline

#3154 2023-11-13 20:47:32

kbd512
Administrator
Registered: 2015-01-02
Posts: 7,548

Re: Housekeeping

tahanson43206,

Okay, ZIP file named "fluxbb_backup.zip" has been uploaded to the folder you just shared with me.  Let me know if you have it.  This file includes a complete backup of the forum posts, done the right way.

Offline

#3155 2023-11-14 11:09:14

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 17,841

Re: Housekeeping

For SpaceNut, kbd512 and all who may be interested....

kbd512 has uploaded a file called "fluxbb_backup.zip" to an account in a folder set up for the purpose. The location of the file is confidential.

At the moment, only kbd512 and tahanson43206 have access to the file.

We have extended an invitation to RobertDyck to participate in a team effort to attempt to build a copy of the NewMars system on our home computers.

If we are successful we can explore options for upgrading the forum packages to more modern versions.

SpaceNut ... what is your level of interest in this project?

This may not be an ideal time for you to take on the investment of time and possibly money that would be needed.

however, if this ** is ** a good time for you, then you are automatically eligible to take part, as Senior Admin.

As things stand, I am planning to copy the data set down to a dedicated test system, where I hope to build a duplicate environment.

I expect that kbd512 is well along in his construction of a duplicate system.

(th)

Offline

#3156 2023-11-14 20:06:32

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 17,841

Re: Housekeeping

For SpaceNut .... I have downloaded the backup file created by kbd512 as a backup of our existing FluxBB forum.

In addition to the data, I have this file: fluxbb_newmars_create_script.sql

kbd512 says this file contains all the instructions the database needs to set up an exact copy of the existing database.

I'm looking forward to studying the file tomorrow.

I took a quick look at the database create command file... at the bottom is this:
ENGINE=MyISAM AUTO_INCREMENT=420796 DEFAULT CHARSET=utf8mb3;

SpaceNut, if you would be interested in keeping in touch with this process, you can do a look up on MyISAM and it's successor.

There appear to be some advantages of MyISAM, but there appear to be plenty of reasons why it's successor was built and MyISAM not used in new installations after 2009.

(th)

Offline

#3157 2023-11-15 18:44:36

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 29,178

Re: Housekeeping

It does look similar to other software I have seen.
ENGINE=MyISAM AUTO_INCREMENT=420796 appears to be the record counter section of the output function while DEFAULT CHARSET=utf8mb3; is the browser output display format of characters style.

Offline

#3158 2023-11-16 15:25:14

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 17,841

Re: Housekeeping

For SpaceNut re forum software backup on Admin systems...

If you want to be a part of this process, now is a ** very ** good time to jump in ...

I have ** just ** completed installation on MySQL on the dedicated test system here.  The process is very similar for Windows (which you have) and I have a book that explains it step by step, although the online resources are fine as well.

Welcome to the M y S Q L monitor.  Commands end with ; or \ g.
Your M y S Q L  connection id is 10

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

I'm taking a break to do some chores and will be back later to set up a non-root user, and to create the database using the command file provided by kbd512.

(th)

Offline

#3159 2023-11-17 18:51:57

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 17,841

Re: Housekeeping

This is part of a post that was refused by Apache Internal Server Error..l.

The book was first published in 1986, and it was in the 8th printing when I picked up my copy in 2008.

I am delighted to see that Khalili is continuing to develop his ideas, and what is more important, to find willing hands to turn them into reality.

I have no doubt that the Iranian tradition would translate easily to Mars. with the needed adaptations due to obvious differences.

(th)

Offline

#3160 2023-11-18 20:00:31

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 17,841

Re: Housekeeping

For SpaceNut re forum database restore to Admin home system...

I have no way of knowing if you are participating in this exercise,  but I'll post this progress report in case you are interested in participating.

I had set up MySQL on this development system a day or so ago, and today I attempted to create the database using the script provided by kbd512 after last Sunday's meeting.  Here is a list of the tables created by the script:

mysql> use fluxbb_newmars;
Database changed
mysql> show tables;
Empty set (0.00 sec)

mysql> source fluxbb_newmars_create_script.sql;
Query OK, 1 row affected, 3 warnings (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.01 sec)

Query OK, 0 rows affected, 4 warnings (0.02 sec)

Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected, 2 warnings (0.01 sec)

Query OK, 0 rows affected, 19 warnings (0.00 sec)

Query OK, 0 rows affected, 2 warnings (0.01 sec)

Query OK, 0 rows affected, 2 warnings (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.01 sec)

Query OK, 0 rows affected, 1 warning (0.01 sec)

Query OK, 0 rows affected, 2 warnings (0.00 sec)

Query OK, 0 rows affected, 3 warnings (0.00 sec)

Query OK, 0 rows affected, 1 warning (0.01 sec)

Query OK, 0 rows affected, 3 warnings (0.00 sec)

Query OK, 0 rows affected, 12 warnings (0.01 sec)

Query OK, 0 rows affected, 12 warnings (0.01 sec)

Query OK, 0 rows affected, 12 warnings (0.01 sec)

mysql> show tables;
+-----------------------------+
| Tables_in_fluxbb_newmars    |
+-----------------------------+
| fluxbb_bans                 |
| fluxbb_categories           |
| fluxbb_censoring            |
| fluxbb_config               |
| fluxbb_forum_perms          |
| fluxbb_forum_subscriptions  |
| fluxbb_forums               |
| fluxbb_groups               |
| fluxbb_online               |
| fluxbb_posts                |
| fluxbb_reports              |
| fluxbb_search_cache         |
| fluxbb_search_matches       |
| fluxbb_search_words         |
| fluxbb_topic_subscriptions  |
| fluxbb_topics               |
| fluxbb_users                |
| fluxbb_users_backup02182017 |
| fluxbb_users_prepurge       |
+-----------------------------+
19 rows in set (0.00 sec)

mysql>

The next step is to attempt to restore data into the tables.  At this point I have no idea how to do that, but if current plans hold, we'll have a Google Meeting tomorrow, and perhaps kbd512 will provide some advice if I haven't figured it out by then.

(th)

Offline

#3161 2023-11-18 20:59:53

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 17,841

Re: Housekeeping

For SpaceNut re restoring backup data for forum database ...

If you are following along with this process, you may encounter this error:

mysql> SET GLOBAL local_infile = true;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW GLOBAL VARIABLES LIKE 'local_infile';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| local_infile  | ON    |
+---------------+-------+
1 row in set (0.00 sec)

mysql> LOAD DATA LOCAL INFILE 'fluxbb_bans_202311121523.csv' INTO TABLE fluxbb_bans;
ERROR 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrictions on access.
mysql> SELECT USER();
+----------------+
| USER()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)

Since the local_infile variable is obviously set ON (true) something else is apparently blocking the upload.

(th)

Offline

#3162 2023-11-19 11:41:02

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 17,841

Re: Housekeeping

For SpaceNut ...

to my surprise, the data load worked today.

I had powered off the system, and started from scratch, so everything "just worked" .... I did implement one suggestion from a contributor to StackExchange ... I started MySQL using a variation of the start command that includes the local_infile parameter set to true. I still had to tell MySQL to set that variable to true, so I have no idea if the extra step made ** the ** difference, but here is the result...

mysql> use fluxbb_newmars;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> LOAD DATA LOCAL INFILE '/home/tahanson/fluxbb_bans_202311121523.csv' INTO TABLE fluxbb_bans;
Query OK, 775 rows affected, 5425 warnings (0.01 sec)
Records: 775  Deleted: 0  Skipped: 0  Warnings: 5425

Now there would appear to just be 16 more repetitions of the LOAD DATA statement to perform.

(th)

Offline

#3163 2023-11-19 12:02:46

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 17,841

Re: Housekeeping

For SpaceNut .... loading the tables went smoothly, until I came to posts, which is a multi-megabyte csv file.

ERROR 1467 (HY000): Failed to read auto-increment value from storage engine

I know there are gaps in the index, due to deletions and losses due to conversions.

Someone on StackExchange suggested looking at the table definition ...

| fluxbb_posts | CREATE TABLE `fluxbb_posts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `poster` varchar(200) NOT NULL DEFAULT '',
  `poster_id` int unsigned NOT NULL DEFAULT '1',
  `poster_ip` varchar(39) DEFAULT NULL,
  `poster_email` varchar(80) DEFAULT NULL,
  `message` mediumtext,
  `hide_smilies` tinyint(1) NOT NULL DEFAULT '0',
  `posted` int unsigned NOT NULL DEFAULT '0',
  `edited` int unsigned DEFAULT NULL,
  `edited_by` varchar(200) DEFAULT NULL,
  `topic_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fluxbb_posts_topic_id_idx` (`topic_id`),
  KEY `fluxbb_posts_multi_idx` (`poster_id`,`topic_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4294967296 DEFAULT CHARSET=utf8mb3 |
+--------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

The AUTO_INCREMENT value should be 1 ...

Here is the relevant section of the script that created the table:

-- fluxbb_newmars.fluxbb_posts definition
CREATE TABLE `fluxbb_posts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `poster` varchar(200) NOT NULL DEFAULT '',
  `poster_id` int unsigned NOT NULL DEFAULT '1',
  `poster_ip` varchar(39) DEFAULT NULL,
  `poster_email` varchar(80) DEFAULT NULL,
  `message` mediumtext,
  `hide_smilies` tinyint(1) NOT NULL DEFAULT '0',
  `posted` int unsigned NOT NULL DEFAULT '0',
  `edited` int unsigned DEFAULT NULL,
  `edited_by` varchar(200) DEFAULT NULL,
  `topic_id` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fluxbb_posts_topic_id_idx` (`topic_id`),
  KEY `fluxbb_posts_multi_idx` (`poster_id`,`topic_id`)
) ENGINE=MyISAM AUTO_INCREMENT=215842 DEFAULT CHARSET=utf8mb3;

At the time the table was created the AUTO_INCREMENT value was set to 215842 ... I have NO idea where that would be coming from.

All tables in this database should have had auto_increment values set to 1.

Later .... I tried setting the auto_increment value to 1 ... (per a suggestion from StackExchange)

mysql> ALTER TABLE fluxbb_posts AUTO_INCREMENT =1;
Query OK, 141886 rows affected (1.98 sec)
Records: 141886  Duplicates: 0  Warnings: 0

The result above means that the DATA LOAD failed about halfway through.

I looked as the smaller tables that did appear to succeed, and they look reasonable, except that there are a lot of nulls because we do not appear to be using the features for which the tables are provided.

(th)

Offline

#3164 2023-11-19 12:42:51

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 17,841

Re: Housekeeping

For SpaceNut re forum database replication ...

You've saved yourself some grief, by holding off on attempting this ...

Hopefully there will be more news to report later today or tomorrow.

(th)

Offline

#3165 2023-11-20 07:59:58

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 17,841

Re: Housekeeping

For SpaceNut re Potholes Report

Yesterday's scan from 215001 through 216000 revealed five potholes:

Match for: Match for: Bad request. The link you followed is incorrect or outdated. Count is: 1 Count is: 1
String 2: String 2: Completed Sequence for ID: 214447

Match for: Match for: Bad request. The link you followed is incorrect or outdated. Count is: 2 Count is: 2
String 2: String 2: Completed Sequence for ID: 214935

Match for: Bad request. The link you followed is incorrect or outdated. Count is: 3
String 2: Completed Sequence for ID: 215232

Match for: Bad request. The link you followed is incorrect or outdated. Count is: 4
String 2: Completed Sequence for ID: 215282

Match for: Bad request. The link you followed is incorrect or outdated. Count is: 5
String 2: Completed Sequence for ID: 215284

Not bad, for 1000 posts.

(th)

Offline

#3166 2023-11-20 20:02:31

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 29,178

Re: Housekeeping

Have I got access to the files "fluxbb_backup.zip"  and  fluxbb_newmars_create_script.sql as to where they are stored? Send me an email if so...

Offline

#3167 2023-11-20 22:12:23

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 17,841

Re: Housekeeping

For SpaceNut re #3166

Thanks for your interest in the backup files and the restore script!

The files are stored in our Dropbox account, and only made available to Admins who specifically ask for them, per kbd512's instructions.

Now that you have explicitly requested access to the files, I've added a work item to my plan for tomorrow. 

I'll notify you when the permission is granted. 

FYI ... I mentioned my experiments with the files to kbd512 at the Sunday meeting.  Your experience in the Windows environment will be helpful, so I hope you will have time to post updates similar to the ones I have posted.

(th)

Offline

#3168 2023-11-21 07:27:57

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 17,841

Re: Housekeeping

For SpaceNut re topic drift ....

I don't think there is an answer to this phenomenon.  It is perfectly natural and normal for our members to pick up on a post (regardless of topic) and to write a reply that is about some aspect of the post, without consideration for the topic.

There are ** some ** topics that are more in need of staying-on-track than others.  I'm not sure what (if anything) can be done, or is even appropriate.

We ** certainly ** appreciate contributions by our members, whether the post is on topic or not.

On the ** other ** hand, we are trying to help readers of the topic to be able to expect the topic to stay on track.

(th)

Offline

#3169 2023-11-21 12:55:01

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 17,841

Re: Housekeeping

For SpaceNut re restoring data to new tables for FluxBB backup to home system:

ChatGPT suggested this format for the LOAD DATA command:

LOAD DATA LOCAL INFILE '/home/tahanson/fluxbb_posts_202311121532.csv' IGNORE INTO TABLE fluxbb_posts
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n';

The "posts" table contains thousands of gaps, as we know from our work with the database over the past year.  ChatGPT seems to think the IGNORE parameter will allow us to insert the records without creating the AUTO_INCREMENT problem.

(th)

Offline

#3170 2023-11-21 13:30:33

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 17,841

Re: Housekeeping

For SpaceNut ...

Due to problems with the first attempt to load the data into the empty database, I used DROP DATABASE fluxbb_newmars; and started over.
After running the script to create the tables, we have this:

mysql> show tables;
+-----------------------------+
| Tables_in_fluxbb_newmars    |
+-----------------------------+
| fluxbb_bans                 |
| fluxbb_categories           |
| fluxbb_censoring            |
| fluxbb_config               |
| fluxbb_forum_perms          |
| fluxbb_forum_subscriptions  |
| fluxbb_forums               |
| fluxbb_groups               |
| fluxbb_online               |
| fluxbb_posts                |
| fluxbb_reports              |
| fluxbb_search_cache         |
| fluxbb_search_matches       |
| fluxbb_search_words         |
| fluxbb_topic_subscriptions  |
| fluxbb_topics               |
| fluxbb_users                |
| fluxbb_users_backup02182017 |
| fluxbb_users_prepurge       |
+-----------------------------+
19 rows in set (0.00 sec)

You should see exactly the same result when you perform these steps in Windows.

(th)

Offline

#3171 2023-11-21 14:38:31

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 17,841

Re: Housekeeping

For SpaceNut ... I edited the commands to load the data tables, but have not yet tested them.  If there are errors I'll come back here to correct anything that is a problem. The intent is to preserve the work in case it succeeds.

Update later ... the Groups table appears to have been loaded correctly.

use fluxbb_newmars;
select * from fluxbb_groups;
+------+------------------+---------------+---------------------+----------------------+-------------+------------------+--------------------+------------------------+-----------------+---------------------+--------------+--------------+----------------+---------------+--------------+----------------+-----------------+--------------+-------------+----------+----------------+--------------+--------------+----------------+---------------+----------------+
| g_id | g_title          | g_user_title  | g_promote_min_posts | g_promote_next_group | g_moderator | g_mod_edit_users | g_mod_rename_users | g_mod_change_passwords | g_mod_ban_users | g_mod_promote_users | g_read_board | g_view_users | g_post_replies | g_post_topics | g_edit_posts | g_delete_posts | g_delete_topics | g_post_links | g_set_title | g_search | g_search_users | g_send_email | g_post_flood | g_search_flood | g_email_flood | g_report_flood |
+------+------------------+---------------+---------------------+----------------------+-------------+------------------+--------------------+------------------------+-----------------+---------------------+--------------+--------------+----------------+---------------+--------------+----------------+-----------------+--------------+-------------+----------+----------------+--------------+--------------+----------------+---------------+----------------+
|    1 | Administrators   | Administrator |                   0 |                    0 |           0 |                0 |                  0 |                      0 |               0 |                   0 |            1 |            1 |              1 |             1 |            1 |              1 |               1 |            1 |           1 |        1 |              1 |            1 |            0 |              0 |             0 |              0 |
|    2 | Moderators       | Moderator     |                   0 |                    0 |           1 |                1 |                  1 |                      1 |               1 |                   0 |            1 |            1 |              1 |             1 |            1 |              1 |               1 |            1 |           1 |        1 |              1 |            1 |            0 |              0 |             0 |              0 |
|    3 | Guests           |               |                   0 |                    0 |           0 |                0 |                  0 |                      0 |               0 |                   0 |            1 |            1 |              0 |             0 |            0 |              0 |               0 |            1 |           0 |        1 |              1 |            0 |           60 |             30 |             0 |              0 |
|    4 | Members          |               |                   0 |                    0 |           0 |                0 |                  0 |                      0 |               0 |                   0 |            1 |            1 |              1 |             1 |            1 |              1 |               1 |            1 |           0 |        1 |              1 |            1 |           60 |             10 |            60 |             60 |
|    5 | Newly Registered |               |                   1 |                    4 |           0 |                0 |                  0 |                      0 |               0 |                   0 |            1 |            0 |              1 |             1 |            1 |              1 |               0 |            0 |           0 |        1 |              0 |            0 |           60 |             30 |            60 |             60 |
+------+------------------+---------------+---------------------+----------------------+-------------+------------------+--------------------+------------------------+-----------------+---------------------+--------------+--------------+----------------+---------------+--------------+----------------+-----------------+--------------+-------------+----------+----------------+--------------+--------------+----------------+---------------+----------------+
5 rows in set (0.00 sec)

The correct format for the Groups table load was:

LOAD DATA LOCAL INFILE '/home/tahanson/fluxbb_groups_202311121531.csv'
INTO TABLE fluxbb_groups
FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'
IGNORE 1 LINES;

The key here is the IGNORE 1 LINES parameter. The csv files contain a row of field names that should NOT be entered into the database.

SpaceNut ... if you get to the point of loading the Groups as shown above, please remember you need to give yourself permission to use the LOAD DATA statement. You need to set that ON in TWO places.

First, you need to activate that feature when you start the server:  sudo mysql --local-infile=1 -u root -p

Second, you need to turn ON the switch inside MySQL:  SET GLOBAL local_infile = true;

The command to create the tables is: source "name of script".sql

You need to USE fluxbb_newmars; to create the tables, after you've created the empty database.

I can't seem to find a way to capture the history of the commands, so the list is less than ideal.

(th)

Offline

#3172 2023-11-22 14:34:16

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 17,841

Re: Housekeeping

For SpaceNut .... re FluxBB forum archive restoration to Admin system...

Based upon the successful load of the Groups table, I have modified the list of LOAD DATA commands to feed into a simple edit process;

use fluxbb_newmars;
LOAD DATA LOCAL INFILE '/home/generic/fluxbb_bans_202311121523.csv' fluxbb_bans
LOAD DATA LOCAL INFILE '/home/generic/fluxbb_categories_202311121528.csv' fluxbb_categories
LOAD DATA LOCAL INFILE '/home/generic/fluxbb_censoring_202311121529.csv' fluxbb_censoring
LOAD DATA LOCAL INFILE '/home/generic/fluxbb_config_202311121529.csv' fluxbb_config
LOAD DATA LOCAL INFILE '/home/generic/fluxbb_forum_perms_202311121530.csv' fluxbb_forum_perms
LOAD DATA LOCAL INFILE '/home/generic/fluxbb_forums_202311121530.csv' fluxbb_forums
LOAD DATA LOCAL INFILE '/home/generic/fluxbb_forum_subscriptions_202311121530.csv' fluxbb_forum_subscriptions
LOAD DATA LOCAL INFILE '/home/generic/fluxbb_groups_202311121531.csv' fluxbb_groups << Completed
LOAD DATA LOCAL INFILE '/home/generic/fluxbb_online_202311121531.csv' fluxbb_online
LOAD DATA LOCAL INFILE '/home/generic/fluxbb_posts_202311121532.csv' fluxbb_posts
LOAD DATA LOCAL INFILE '/home/generic/fluxbb_reports_202311121534.csv' fluxbb_reports
LOAD DATA LOCAL INFILE '/home/generic/fluxbb_search_cache_202311121615.csv' fluxbb_search_cache
LOAD DATA LOCAL INFILE '/home/generic/fluxbb_search_matches_202311121637.csv' fluxbb_search_matches
LOAD DATA LOCAL INFILE '/home/generic/fluxbb_search_words_202311121620.csv' fluxbb_search_words
LOAD DATA LOCAL INFILE '/home/generic/fluxbb_topics_202311121621.csv' fluxbb_topics
LOAD DATA LOCAL INFILE '/home/generic/fluxbb_topic_subscriptions_202311121621.csv' fluxbb_topic_subscriptions
LOAD DATA LOCAL INFILE '/home/generic/fluxbb_users_202311121622.csv' fluxbb_users
LOAD DATA LOCAL INFILE '/home/generic/fluxbb_users_backup02182017_202311121622.csv' fluxbb_users_backup02182017
LOAD DATA LOCAL INFILE '/home/generic/fluxbb_users_prepurge_202311121622.csv' fluxbb_users_prepurge


LOAD DATA LOCAL INFILE '/home/generic/fluxbb_groups_202311121531.csv'
INTO TABLE fluxbb_groups
FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'
IGNORE 1 LINES;

I will now be testing the new command format with the rest of the 19 tables.

(th)

Offline

#3173 2023-11-22 15:23:04

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 17,841

Re: Housekeeping

For SpaceNut .... assuming you are going to be performing these operations over the weekend ... here is a display of the configuration of the Groups table after the successful LOAD of the records. Please note that the AUTO_INCREMENT field is still 7, as it was before the data was loaded. This is what we are looking for.

fluxbb_groups | CREATE TABLE `fluxbb_groups` (
  `g_id` int unsigned NOT NULL AUTO_INCREMENT,
  `g_title` varchar(50) NOT NULL DEFAULT '',
  `g_user_title` varchar(50) DEFAULT NULL,
  `g_promote_min_posts` int unsigned NOT NULL DEFAULT '0',
  `g_promote_next_group` int unsigned NOT NULL DEFAULT '0',
  `g_moderator` tinyint(1) NOT NULL DEFAULT '0',
  `g_mod_edit_users` tinyint(1) NOT NULL DEFAULT '0',
  `g_mod_rename_users` tinyint(1) NOT NULL DEFAULT '0',
  `g_mod_change_passwords` tinyint(1) NOT NULL DEFAULT '0',
  `g_mod_ban_users` tinyint(1) NOT NULL DEFAULT '0',
  `g_mod_promote_users` tinyint(1) NOT NULL DEFAULT '0',
  `g_read_board` tinyint(1) NOT NULL DEFAULT '1',
  `g_view_users` tinyint(1) NOT NULL DEFAULT '1',
  `g_post_replies` tinyint(1) NOT NULL DEFAULT '1',
  `g_post_topics` tinyint(1) NOT NULL DEFAULT '1',
  `g_edit_posts` tinyint(1) NOT NULL DEFAULT '1',
  `g_delete_posts` tinyint(1) NOT NULL DEFAULT '1',
  `g_delete_topics` tinyint(1) NOT NULL DEFAULT '1',
  `g_post_links` tinyint(1) NOT NULL DEFAULT '1',
  `g_set_title` tinyint(1) NOT NULL DEFAULT '1',
  `g_search` tinyint(1) NOT NULL DEFAULT '1',
  `g_search_users` tinyint(1) NOT NULL DEFAULT '1',
  `g_send_email` tinyint(1) NOT NULL DEFAULT '1',
  `g_post_flood` smallint NOT NULL DEFAULT '30',
  `g_search_flood` smallint NOT NULL DEFAULT '30',
  `g_email_flood` smallint NOT NULL DEFAULT '60',
  `g_report_flood` smallint NOT NULL DEFAULT '60',
  PRIMARY KEY (`g_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 |

(th)

Offline

#3174 2023-11-22 15:47:18

SpaceNut
Administrator
From: New Hampshire
Registered: 2004-07-22
Posts: 29,178

Re: Housekeeping

post 3186 about off topic conversations the GW and Calliban posts can be copied such as you did with one to start the heat shield content as it relates to their posts, and I would go to the hopper ship topic with both of them as well.

I will try to make some time for the website build stuff later during the holiday week end.

Offline

#3175 2023-11-22 16:17:33

tahanson43206
Moderator
Registered: 2018-04-27
Posts: 17,841

Re: Housekeeping

For SpaceNut re # 3174

Thank you for noting the new topic I created for heat shields ... hopefully it will prove useful to our members.

I am online now to report encouraging news... it appears the data is all loaded, using the command format I posted above.

mysql> SELECT table_name, table_rows
    -> FROM information_schema.tables
    -> WHERE table_schema = 'fluxbb_newmars';
+-----------------------------+------------+
| TABLE_NAME                  | TABLE_ROWS |
+-----------------------------+------------+
| fluxbb_bans                 |        774 |
| fluxbb_categories           |          7 |
| fluxbb_censoring            |          0 |
| fluxbb_config               |         81 |
| fluxbb_forum_perms          |          6 |
| fluxbb_forum_subscriptions  |        117 |
| fluxbb_forums               |         26 |
| fluxbb_groups               |          5 |
| fluxbb_online               |         72 |
| fluxbb_posts                |     210255 |
| fluxbb_reports              |         10 |
| fluxbb_search_cache         |          7 |
| fluxbb_search_matches       |   15493240 |
| fluxbb_search_words         |     373691 |
| fluxbb_topic_subscriptions  |        668 |
| fluxbb_topics               |       8290 |
| fluxbb_users                |      19631 |
| fluxbb_users_backup02182017 |       1122 |
| fluxbb_users_prepurge       |      71545 |
+-----------------------------+------------+
19 rows in set (0.03 sec)

mysql>

Since you will be working in Windows, there are some  minor differences, but once you have MySQL installed and working, everything else should work as I have reported it above. I have a book with instructions for Windows, so can offer assistance if you hit a snag, but I'm guessing the online assistance will help you through the setup.

best wishes for a most enjoyable Thanksgiving, and successful roasting of that turkey!

(th)

Offline

Board footer

Powered by FluxBB