0
Run multiple MySQL/MariaDB instances on Ubuntu server
We are using MariaDB on an Ubuntu server powered by Webmin and Virtualmin. The MariaDB server has been installed after...
0
A PHP PDO mysql helper class used in SlimPHP applications
This is a very simple example on how to use SlimPHP and PDO in a basic API that updates, lists...
0
Mysql: Export select rows to CSV on server
Use the following command to export the query rows to a file on the server in the CSV format:
|
1 2 3 4 5 6 |
select * from `table` INTO OUTFILE '/var/www/file.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'; |
...
0
MariaDB – allow user to connect from anyhost
Use the following command in your server to allow user to connect from anyhost:
|
1 2 |
RENAME USER 'root'@'localhost' TO 'root'@'%'; FLUSH PRIVILEGES; |
0
Enable access to MySQL/MariaDB from any host in Linux
Commands: sudo nano /etc/mysql/my.cnf Look for [mysqld] and bind-address Edit the new address that matches your desired ip address (0.0.0.0...
0
Apache 2, PHP 5 and MariaDB on Raspbian
A great tutorial to do so can be found here: https://www.howtoforge.com/tutorial/install-apache-with-php-and-mysql-lamp-on-debian-jessie/ Please remember to prefix the commands with sudo or...
0
Updating the URL of a WordPress website with SQL commands
Use the following commands to change the URL of a WordPress website directly inside the mysql database:
|
1 2 3 4 5 6 7 |
UPDATE wp_options SET option_value = replace(option_value, 'http://oldaddress.com', 'http://newaddress.com') WHERE option_name = 'home' OR option_name = 'siteurl'; UPDATE wp_posts SET guid = replace(guid, 'http://oldaddress.com','http://newaddress.com'); UPDATE wp_posts SET post_content = replace(post_content, 'http://oldaddress.com', 'http://newaddress.com'); UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://oldaddress.com','http://newaddress.com'); |
0
MySQL JOINs with examples
This is an interesting tutorial on MySQL Joins: http://www.sitepoint.com/understanding-sql-joins-mysql-database/
0
WordPress – db_term_taxonomy reset count
Reset the term count:
|
1 |
UPDATE wp_term_taxonomy tt SET count = (SELECT count(p.ID) FROM wp_term_relationships tr LEFT JOIN wp_posts p ON (p.ID = tr.object_id AND p.post_type = 'post' AND p.post_status = 'publish') WHERE tr.term_taxonomy_id = tt.term_taxonomy_id) WHERE tt.taxonomy = 'tag'; |
0
“InnoDB: Fatal error: cannot allocate memory for the buffer pool”
The information here helped. Reducing the buffer pool size was not enough. In the next step I activated the swap.