Promote a Blog | Blog Directory | Content Marketing | Analytics | Blog | FAQ |

Explore » Blog Directory of Selected Blogs
Connect » Authentic Blogger Community
Discover » Featured Blogs and Topics

Recent blog posts on Mysql

Blog Directory Feed

Percona Monitoring Plugins for Zabbix3

#Install apt-get install percona-zabbix-templates cp /var/lib/zabbix/percona/templates/userparameter_percona_mysql.conf /etc/zabbix/zabbix_agentd.conf.d/ #Configure vi /var/lib/zabbix/percona/scripts/ss_get_mysql_stats.php ... $mysql_user = 'uid'; $mysql_pass = 'pwd'; ... #Test /var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh gg zbx_percona_mysql_template read more »

A ton of data to import with a shell

schema_import.sh #!/bin/bash for f in *schema*.gz; do DBName=$echo $f cut -d - -f 5 echo Create ${DBName} echo create database if not exists ${DBName} /usr/bin/mysql -u root -pXXXXXX zcat ${f} /usr/bin/mysql -u root -pXXXXXX ${DBName} echo Created done data_import.sh #!/bin/bash for f in *data*.gz; do DBName=$echo $f cut -d - -f read more »

Руссифицируем Sphider 1.3.6 или Sphider vs UTF-8

Доброго времени суток, уважаемые читатели моего блога! Столкнулся с Sphiderом в учебных целях, и обнаружил, что мой сайт (http://nikita-sp.com.ua) не индексируется этим роботом! Выдает ошибки в SQL запросах и все тут! Я начал перерывать форумы, листать Google но все тщетно. В конечном итоге я решил сам бороться с проблемой кодировок и все принудительно конвертировать в [] read more »

Логирование запросов SQL в Denwer 3 с MySQL 5

Доброго времени суток, уважаемые читатели блога! Сегодня хотелось бы поделиться с вами очередной победой, если так ее можно конечно назвать. Дело в том, что на старом денвере я настраивал ведение логов БД MySQL, но установив новый Денвер 3 на свежую систему Win8 понял что забыл как настроить логирование запросов к БД. Начал искать решения в интернете, [] read more »

Удаление ревизий записей в wordpress без плагин...

WordPress по умолчанию сохраняет ревизии записей в базе mysql. В большинстве случаев эти ревизии не нужны, но они существенно замедляют работу базы mysql и увеличивают её размер. В первую очередь отключим сохранение ревизий. Откроем файл wp-config.php в папке сайта. И добавим в него строку: define('WP_POST_REVISIONS', false); Перед выполнением работ с базой сделаем дамп базы на [] read more »

MySQL. Список таблиц в которых есть поле user_id

SELECT `TABLE_NAME` FROM `information_schema`.`COLUMNS` WHERE `TABLE_SCHEMA` = DATABASE() AND `COLUMN_NAME` = user_id read more »

Tenacity, Progress, And Uncertainty

Those that know me well, know that I always have a to-do list as long as my arm. If I've a few hours free, I'm likely to chip away at these projects. Some projects are quick, and others take time. One of the longest running projects I've had now is weather related - which started some 4 to 5 years ago and having discussed it with Environment Canada, I was left with more questions than I had to begin with. Having spent a lot of time mulling over the problem, I finally got around to progressing it forward.... read more »

Moving My Own Little Mountain

Last year, I returned to a question that has been bugging me for a number of years with Toronto's weather. The problem was that in order to find the answer, I needed some data - and whilst the data is freely available to answer the question, it's just not in a form that I could easily query. It was very obvious I was going to have to construct something pretty big at home, just so I had all the data in one place in order to query it. So, back in the winter, I wrote a program for the RaspberryPi (http:/... read more »

Выводим список таблиц с количеством записей в m...

Хочу привести небольшой пример запроса, с помощью которого можно получить список таблиц в mysql базе с количеством записей : SELECT table_name, table_rows FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '**YOUR DATABASE**'; Вывод будет такой: read more »

Search and Replace WordPress Plugin

Today, I learned something new while fixing a friends blog. Actually, fixing is not the term but rather restoring. I was also to research about this problem I encounter with her blog. It was because I have problems in moving her blog contents to another, causing images to load the small red x instead of [...] read more »

Entendendo PHP facil facil

1. Introdução O que é PHP? O que pode ser feito com PHP? Como surgiu a linguagem PHP?   2. Sintaxe BásicaDelimitar o código PHP Separador de instruções, Nomes de variáveis Comentários de uma ou mais linha   3. Criar os primeiros scripts Primeiro Exemplo Utilizando formulários HTML Interagindo com o browser Acessando Bancos de Dados Conexão com o servidor Seleção do banco de dados Execução read more »

mysql小工具openarkkit

下载地址 http://code.google.com/p/openarkkit/ oak-apply-ri: apply referential integrity on two columns with parent-child [显示全文] read more »

SQL инъекция

Прежде, чем выполнять запрос $res = mysql_query(SELECT * FROM news WHERE id = .$_GET[id]. нужно сначала проверить значение переменной id. В данном случае переменная id имеет числовой тип и должна принимать только целочисленное значение. В таком случае помогает функция intval, Читать далее read more »

MySQL. Выбрать последнюю и первую запись

Иногда требуется выбрать из БД 1-ю и последнюю записи. Такого понятия как 1-я и последняя запись в реляционных БД отсутствует. Но, если в таблицах есть поле id autoincrement, то предложенный ниже кусок кода поможет это сделать: SELECT MIN(status_history_id) as first_id, Читать далее read more »

Teach Yourself PHP, MySQL and Apache All in One...

You own your own business. You have also created a website for your business that details the products or services that you offer, but it doesnt allow potential customers to purchase anything online. Dont risk losing business-learn to create a dynamic online environment using only three programs. PHP, MySQL and Apache [...] read more »

PHP6 and MySQL Bible

MySQL is the leading open source database on the market and PHP continues to dominate the server side of the scripting market?together, they are the most popular and common team for creating dynamic, database-driven web sites. This comprehensive book covers the newest version of PHP and MySQL and is packed with extensive code examples, full [...] read more »

Mastering phpMyAdmin 3.1 for Effective MySQL Ma...

Increase your MySQL productivity and control by discovering the real power of phpMyAdmin 3.1 Covers version 3.1, the latest version of phpMyAdmin Administer your MySQL databases with phpMyAdmin Manage users and privileges with MySQL Server Administration tools Get to grips with the hidden features and capabilities of phpMyAdmin In Detail MySQL has gained wide popularity because of its open-source nature, performance, [...] read more »

Creating your MySQL Database: Practical Design ...

This book is an innovative and essential short guide for everyone on how to structure your data and set-up your MySQL database tables efficiently and easily. If youre creating a dynamic web application using open-source tools, then youre probably going to be setting up a MySQL database. Getting the design of this database right for [...] read more »




COPYRIGHT NOTICE: BlogUpp does not claim ownership of any content distributed via this blog directory and its content marketing channels.
The authors of the blogs featured above are assumed to be the content owners. BlogUpp is a blog promotion and content marketing service. Learn more

Terms of Service | Privacy Policy | Copyright © 2017, BlogUpp (aka BlogUp)