• About
  • CentOS server
  • Contact
  • My LinkedIn
Skip to content

ServerAdminBlog

Short Circuit…

  • About
  • CentOS server
  • Contact
  • My LinkedIn

Category: MySQL

Unable to export database in MySQL Workbench – delayed-insert error

- December 3, 2015 | December 3, 2015 - ServerAdmin

In case you’re using MySQL Workbench for creating dumps please keep in mind that version 6.3.5 has one annoying bug. After update, the first time I tried do create dump, …

Read More

MyDumper – CentOS HowTo

- November 4, 2014 | November 7, 2014 - ServerAdmin

Mydumper – MySQL backup tool created by Domas Mituzas and later supported by several other devs. The main benefits are multi-threaded and fast backups with almost no locking (if not …

Read More

How to clone MySQL database

- March 13, 2014 | March 13, 2014 - ServerAdmin

Here is a way to create a duplicate of one database, with all its tables and their data Dump your source database into sql file # mysqldump -uroot -p production …

Read More

Slow InnoDB insert/update

- January 3, 2014 | March 14, 2014 - ServerAdmin

If you’re migrating from MyISAM to InnoDB or you’re using MySQL 5.5.x or newer (InnoDB default engine) you’ll probably be disappointed with INSERT/UPDATE queries (with InnoDB tables). InnoDB is a …

Read More

Oracle MySQL yum repositories

- November 19, 2013 - ServerAdmin

If you’re using MySQL and you prefer yum and rpm, Oracle announced availability of Yum repositories for MySQL database and related products. Initial release is focused on EL6-based distros as …

Read More

Extra Packages for Enterprise Linux – EPEL HowTo

- April 18, 2013 | April 18, 2013 - ServerAdmin

EPEL (Extra Packages for Enterprise Linux) is a volunteer-based community effort from the Fedora project to create a repository of high-quality add-on packages that complement the Fedora-based Red Hat Enterprise …

Read More

How to disable foreign key checks – MySQL

- February 19, 2013 | February 19, 2013 - ServerAdmin

From time to time you’ll need to delete something from your database and when you try to do it, the MySQL will complain on foreign keys (beside the fact that …

Read More

MySQL DATE_FORMAT() letter representations

- October 12, 2012 | October 23, 2012 - ServerAdmin

Here is a quick chart with MySQL DATE_FORMAT letter representation so you can format date how ever you want… Specifier Description %a Abbreviated weekday name (Sun..Sat) %b Abbreviated month name …

Read More

FreeRadius install howto (4) – populating tables

- December 14, 2011 - ServerAdmin

In the last article about FreeRadius (Here), I wrote about basic settings and now I’ll write something about inserting users into database (MySQL). The FreeRadius database schema contains several tables: …

Read More

MySQL Performance – Howto – part 2 (write cache dependance)

- December 1, 2011 | December 1, 2011 - ServerAdmin

I already wrote about Sysbench and MySQL tunning scripts. Those articles can be found HERE and HERE. Now lets do some tests and lets see the dependance from write cache …

Read More

Posts navigation

Older posts

Pages

  • About
  • CentOS server
  • Contact
  • My LinkedIn

Donate Dogecoin

Donate Dogecoin DLPHK4V8aw3vroHTvGfNyjYk3YrfQB1QgQ

Recent Posts

  • Simple PHP CURL method
  • The repository does not have a Release file – pgAdmin4 on Mint Linux
  • Nothing provides perl(IPC::Run) needed by…
  • Debian server – Setting a Default Gateway
  • How to upload an ISO image to the Proxmox server using the terminal
  • How to check the DNS server IP being used (Ubuntu 18.04+)
  • Email alert for SSH logins
  • Simple pushtogit script
  • SUDO CVE-2021-3156 and how to upgrade CentOS 6
  • Time and date on CentOS 7 Howto

Blogroll

  • CyberCity.biz
  • hackr.io Tutorials
  • Igor Šmitran
  • PostgreSQL Exercises

Linkshare

Top IT Courses- CCNP 2015 Allin

Categories

  • Amavisd-new (1)
  • Android (4)
  • AntiVirus (2)
  • Apache (4)
  • Debian (2)
  • DNS (2)
  • DOCSIS (1)
  • FreeRadius (7)
  • Hardware (6)
  • Humor (5)
  • Java (4)
  • Links (1)
  • Linux (15)
  • Mikrotik (1)
  • Mint Linux (9)
  • MySQL (19)
  • Networks (8)
  • nginx (2)
  • Other (50)
  • PHP (18)
  • Postfix (8)
  • PostgreSQL (7)
  • Programming (10)
  • Proxmox (1)
  • Red Hat/CentOS (47)
  • RRDTool (1)
  • Server project (16)
  • Tips & Tricks (57)
  • Web Hosting (3)
  • Windows (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

eXTReMe Tracker
Powered by WordPress Theme: BlogX by wpthemespace.com