MySql

Check Database

Di seguito sono riportate le query che possono essere esguite per controllare lo stato del database. Per personalizzare rispetto al nome del database copiare il testo, incollarlo in un editor e sostituire “weyourconsult.” con il nome del database in esame. Backup Your Database First Tables Check Tables Verifica le dimensioni delle tabelle wp_users Check wp_users

Check Database Leggi tutto »

From Live to Staging

The Problem When you create a new environment from live weyourconsult, could happen that if you try to open STAGING you receive a database error connection. First answer you can reach is that the database miss the following tables: wp_users wp_usermeta wp_blogs wp_blogmeta wp_signups wp_site wp_sitemeta wp_registration_log But, usually it’s not the problem. You can

From Live to Staging Leggi tutto »

Connect Remote MySQL to local Workbench

How to connect If you want to view, query a mysql database is useful to connect via desktop MySql Workbench that could be installed on you local desktop. From MySql Workbench you have to create a connection from Database, Manage Connection. Connection Connection method: Standard TCP/IP over SSH Parameters: – SSH Hostname: remote_server_IP:port_number– SSH Username:

Connect Remote MySQL to local Workbench Leggi tutto »

Torna in alto