New post: Deploying a LAMP Stack for High-Traffic Websites with Ansible. https://www.vpszen.com/deploying-a-lamp-stack-for-high-traffic-websites-with-ansible/
New post: Deploying a LAMP Stack for High-Traffic Websites with Ansible. https://www.vpszen.com/deploying-a-lamp-stack-for-high-traffic-websites-with-ansible/
Today I made a video on how to quickly and easily back up your database with phpMyAdmin. #WordPress #MySQL #phpMyAdmin https://www.youtube.com/watch?v=4jWNEtW9JVY
Years ago I created a #php #mysql #comics #database
https://sourceforge.net/projects/madcollector/
DM me If you'd be interested in reviving it.
#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 :
#C #Programming Masterclass with #MySQL & #PostgreSQL Database
> Master the Essentials of C Programming. You also get Complete MySQL and PostgreSQL Bootcamp to Master Database Design
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!
Exploring Views in #MySQL and #PostgreSQL: A Guide to Performance, Use Cases, and Materialized Views - Thnk And Grow https://blog.thnkandgrow.com/views-in-mysql-and-postgresql-a-performance-use-cases-and-materialized-views/
@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)
This week, we're heading to Scale 22x in Pasadena, California!
Meet us at booth #421 between March 6-9 and come check out the #MySQL, system design, and #OpenTelemetry talks from our Grafanistas: https://www.socallinuxexpo.org/scale/22x/presentations
#PostgreSQL is being adopted at an incredibly high rate. Are you in the midst of migrating to #Postgres or getting ready to deploy for the first time?
Our team can help: we provide a personalized approach from experts that know Postgres inside and out.
Contact us, anytime. https://data-bene.io/en/
How to Choose the Right Database for Your Web Application in 2025: Top 10 Options
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
i just spent several hours repairing 20-plus-year-old data problems in an even older online #collaborativeart game. i happened upon the problems by chance: about 8 data points in almost 5000.
long story short: avoid having data pointers between objects point in both directions. there will be errors. #perl #MySQL #dataintegrity
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
https://tech-champion.com/database/creating-mysql-stored-procedures-from-php-a-step-by-step-guide/
Learn how to create MySQL stored procedures from PHP. This guide provides a step-by-step ...
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
https://tech-champion.com/database/calling-mysql-stored-procedures-from-perl-a-comprehensive-guide/
Learn how to call MySQL stored pro...
Setting Up WSL 2: My Development Environment Scripts
https://www.jocheojeda.com/2025/02/24/setting-up-wsl-2-my-development-environment-scripts/