mySQLDump

[Перевод] Переиндексация в Manticore Search с использованием mysqldump

Эта статья написана Мариусом Матилионисом, старшим разработчиком и экспертом по Manticore Search в компании Ivinco . Ivinco специализируется на предоставлении передовых решений для поиска, оптимизации баз данных, управлении инцидентами и настройке систем мониторинга, помогая бизнесам достигать более быстрых, эффективных и масштабируемых операций.

https://habr.com/ru/articles/874280/

#Methodically and #meticulously transferring #development #server files from (oh, let's say a juvenile-aged dev, as was born late spring '24) Linux box to a general 2TB storage device-- one of two 2TB drives purchased in 2021-- to which I'd planned transferring all files of any nature from anywhere, till [milk blood] running out.

One thing I did forget to do, however seems to be impacting productivity. Wonder why.

Oh? It should be nothing.
Just the #database
haha.
I was watching #Shatner and forgot #mySQLDump
(get it? heh heh... )

oh well.
Oh there's a good song about that probably.
Momentarily not musical, my friends.

Can you believe it?

my wiki dump is still running - has used up about 250gb but i think i am less than halfway through - there are 6m article on wiki #mysqldump #vzdump

php initSiteStats.php --update
Refresh Site Statistics

Counting total edits...7594040
Counting number of articles...2656103
Counting total pages...7173448
Counting number of users...2
Counting number of images...0

Updating site statistics...done.

Done.

Today, for the first time, I sent a pull request to the #mysql #server repository with tiny change to #mysqldump.

I am curious how the process will be and whether the change will be accepted. Wish me luck :)

https://github.com/mysql/mysql-server/pull/524

Just came across this:

https://mysqldump.guru

Quite helpful!

Hint for a future me - before backuping Friendica (and other software) instance to migrate to another server: purge blocked domains and subdomains - the backup will be much smaller and restore will happen much faster. #sysadmin #mysqldump

Some good #mysql #backup and #restore examples for those of us who need to do it only every second year:
https://linuxize.com/post/how-to-back-up-and-restore-mysql-databases-with-mysqldump/
#mysqldump