mastodon.xyz is one of the many independent Mastodon servers you can use to participate in the fediverse.
A Mastodon instance, open to everyone, but mainly English and French speaking.

Administered by:

Server stats:

856
active users

#mysql

8 posts8 participants0 posts today

#question #bash #crontab #mysql :

j'ai un script qui fait

for db in database1 database2 database3;
do
echo $db
if [[ "$db" != "database2" ]]; then
echo "dumping database $db"
mysqldump -u $USER -p$PASSWORD --databases $db > $db.sql
fi
done

quand je le lance directement, pas de souci, ça fonctionne. mais en tâche #cron, rien, que dalle, que pouic, mon cul dans les orties.
et je ne vois pas pourquoi.

Une idée ?

Edit : La solution à mon problème ici par @Dominix :

mastodon.social/@Dominix/11413

Mastodondominix 🦇 (@Dominix@mastodon.social)@pasqualeberesti@piaille.fr ah, et aussi il faut que le script commence par #! /bin/bash

for those of you who know about web dev . . .

I’m a 90% stack dev (amateur, in my spare time!)

currently I’m building a new web site (OK, four new web sites to be precise)

the HTML works

the PHP works

the mySQL works

I even have some images (with a bit of help and a bit of anguish from an AI image generator)

2 weeks so far

now for the CSS bit

CSS is not my favourite bit

this may take me another 2 weeks!

Replied to Julien Riou

@jriou SSL/TLS was and still is an ugly hack, and so is the CA infrastructure. TLS without StartTLS is even worse. Being able to offload TLS to a proxy is an example why the use of TLS is broken. Authentication needs to be bound to the application, otherwise it’s just “it’s encrypted, so it must be secure”.

(I wrote the first Erlang MySQL driver that was widespread and that for example emysql refers to)

How to Choose the Right Database for Your Web Application in 2025: Top 10 Options

tuvoc.com/blog/how-to-choose-t

Discover the top 10 database options for web applications in 2025. Learn how to choose the right database based on performance, scalability, and security needs.

#Database
#WebDevelopment
#TechTrends2025
#SQL
#NoSQL
#CloudDatabase
#ScalableTech
#SoftwareDevelopment
#BackendDevelopment
#DataManagement
#MySQL
#PostgreSQL
#MongoDB
#DatabaseOptimization
#FutureTech

Creating MySQL Stored Procedures from PHP: A Step-by-Step Guide
Learn to create & utilize MySQL Stored Procedures in PHP! This guide covers creation, execution, error handling, & best practices, including prepared statements & multiple result sets. #MySQL #PHP #StoredProcedures #Database #Programming #SQL
tech-champion.com/database/cre
Learn how to create MySQL stored procedures from PHP. This guide provides a step-by-step ...

TECH CHAMPION · Creating MySQL Stored Procedures from PHP: A Step-by-Step GuideCreate MySQL stored procedures within your PHP applications. This guide offers a practical solution addressing limitations of single-command execution. MySQL Stored Procedure PHP.

Calling MySQL Stored Procedures from Perl: A Comprehensive Guide
Learn to call MySQL stored procedures from your Perl scripts! This guide covers basic calls, handling multiple parameters, efficient data retrieval, and error handling. Master Perl MySQL Stored Procedures for robust database apps. #PerlMySQL #StoredProcedures #Database #Perl #MySQL #Programming
tech-champion.com/database/cal
Learn how to call MySQL stored pro...

TECH CHAMPION · Calling MySQL Stored Procedures from Perl: A Comprehensive GuideMaster calling MySQL stored procedures within your Perl applications. This guide offers solutions for diverse scenarios and troubleshooting common issues. Perl MySQL Stored Procedures.

Question:

#mysql and #ZFS snapshots... Do I need to stop the MySQL jail or service before I take the ZFS snapshot? Or do I need to lock all tables? Or will it just take a proper snapshot of MySQL at that moment in time without issues?