Recent searches

No recent searches

Search options

Not available on photog.social.
photog.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
A place for your photos and banter. Photog first is our motto Please refer to the site rules before posting.

Administered by:

Server stats:

246
active users

photog.social: AboutProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.4.3

#innodb

0 posts0 participants0 posts today
Schenkl | 🏳️‍🌈🦄<p>OH: <a href="https://chaos.social/tags/InnoDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>InnoDB</span></a> Support für <a href="https://chaos.social/tags/Oracle" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Oracle</span></a></p>
Nigel<p>I have a database table with several rows showing whitespace in the Path column and -1 in the Parent column</p><p>It's the oc_filecache table in my Nextcloud MariaDB and NC log throws up warning the index is corrupted</p><p>But it's part of InnoDB and the usual MariaDB repair tools won't work</p><p>I can access the table manually with the Webmin module and easily delete whatever I like but therein lies the danger!</p><p>Making assumption that those rows are the problem but... help?</p><p><a href="https://musicians.today/tags/mariadb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mariadb</span></a> <a href="https://musicians.today/tags/innodb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>innodb</span></a> <a href="https://musicians.today/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a> <a href="https://musicians.today/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>database</span></a></p>
Nigel<p>Well... I got my MariaDB, Nextcloud, Wordpress gremlins fixed with my usual mix of 'winging it guesswork', half a brain and a few dips into the interweb.</p><p>A combo of data corruption (either caused by, or itself bolloxing, a Wordpress plugin) and a schoolboy error on my part when restoring MariaDB databases (forgot to stop MariaDB service first, dumbo!!)</p><p>Still, I learned meself a few new things didn't I 👍😁</p><p><a href="https://musicians.today/tags/mariadb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mariadb</span></a>⁩ ⁨<a href="https://musicians.today/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mysql</span></a>⁩ ⁨<a href="https://musicians.today/tags/innodb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>innodb</span></a>⁩ ⁨<a href="https://musicians.today/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>database</span></a>⁩ ⁨<a href="https://musicians.today/tags/NextCloud" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>NextCloud</span></a>⁩ ⁨<a href="https://musicians.today/tags/askfedi" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>askfedi</span></a>⁩</p>
Nigel<p>Need help... MariaDB is giving me Warning and Error messages in the log about InnoDB corruption in my Nextcloud table. Tried backups but no joy. Seems I need to rebuild... Before I get stuck into new territory for me, anyone an expert in MariaDB/Mysql and the InnoDB tables?<br>Poor, but just about legible when zoomed, screenshot. This seems the only error, repeated over. <a href="https://musicians.today/tags/mariadb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mariadb</span></a> <a href="https://musicians.today/tags/mysql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>mysql</span></a> <a href="https://musicians.today/tags/innodb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>innodb</span></a> <a href="https://musicians.today/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>database</span></a> <a href="https://musicians.today/tags/NextCloud" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>NextCloud</span></a> <a href="https://musicians.today/tags/askfedi" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>askfedi</span></a></p>
Marcus "MajorLinux" Summers<p>So, an update:</p><p>I was able to get the site back up without losing any data!</p><p>Apparently, something happened with <a href="https://toot.majorshouse.com/tags/InnoDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>InnoDB</span></a>, so I had to manually "massage" some files to get it working again.</p><p>I need to figure out a way to back up the data.</p><p>Any tips on how to do that via <a href="https://toot.majorshouse.com/tags/Docker" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Docker</span></a>?</p>
Live feeds
About