DokuWiki

Site Tools

Trace: • mrscandi-ovh
Hotfix release available: 2025-05-14b "Librarian". upgrade now! [56.2] (what's this?)
serveurs:mrscandi-ovh

This is an old revision of the document!

Table of Contents

ftp

http://vacwdjk.cluster028.hosting.ovh.net

Nom d'hôte (serveur FTP) : ftp.cluster028.hosting.ovh.net
Identifiant (login FTP) : vacwdjk
Mot de passe (password FTP) : g3d3UuhAuq5R

ssh

ssh vacwdjk@ssh.cluster028.hosting.ovh.net -p 22
Votre mot de passe est : g3d3UuhAuq5R

mysql

https://phpmyadmin.cluster028.hosting.ovh.net/index.php?pma_username=vacwdjkprod&pma_servername=vacwdjkprod.mysql.db

vacwdjkprod.mysql.db
vacwdjkprod
QTrFPrXJ5YCgQgxB

PREPROD

https://preprod.mr-scandinave.fr

mysql

https://phpmyadmin.cluster028.hosting.ovh.net/index.php?pma_username=vacwdjkdev&pma_servername=vacwdjkdev.mysql.db

vacwdjkdev.mysql.db
vacwdjkdev
QTrFPrXJ5YCgQgxB

SQL AIDE

Afficher tous les produits shopping en brouillon avant le 15-09

SELECT * FROM `wp_posts` WHERE `post_status` LIKE 'draft' AND `post_modified` < '2021-09-15 15:09:01' AND `post_type` LIKE 'shopping' ORDER BY `wp_posts`.`post_modified` ASC

Passer en archive tous les produits shopping en brouillon avant le 15-09 UPDATE `wp_posts` SET `post_status` = 'archive' WHERE `post_status` LIKE 'draft' AND `post_modified` < '2021-01-20 15:09:01' AND `post_type` LIKE 'shopping'

serveurs/mrscandi-ovh.1633526397.txt.gz · Last modified: (external edit)