You can enable a general query log for that sort of diagnostic. Generally you don’t log all SELECT queries on a production server though, it’s a performance killer.
SELECT browser, COUNT(browser) AS freq FROM
If you have ever had a problem to login to phpmyadmin with root you will need to add the rights.login to mariadb/mysql: check if user is added: Now add the root user: And now flush:
You can create mysqldump like this: create config.cnf: Now lets backup a database
10.20.6.29 – Master Database10.20.6.30 – Slave Database chnage the bind address to your server real ip address 10.20.6.29 uncomment at the bottom of the file add your databases now log in with root on the mysql server via terminal copy the databases to the slave server with phpmyadminin 10.20.6.30 a.k. the slave If there is […]
Have you ever needed a query where you search for all except one thing?Here is an example of a query where you search for all except the number 6: If you have ten users with id from one to ten , number six won’t be in the executed query.
You can enable a general query log for diagnostic purposes. Generally you don’t log all SELECT queries on a production server though it, it’s a performance killer.