Raafat Mohamed

Senior Linux Administrator

  • About Me
Menu
  • About Me
in Mysql
April 1, 2015

MySQL – create and delete databases

Login First thing is to log into your Slice via the terminal or PuTTY, etc and then log into MySQL: mysql -u root -p You will be prompted for your MySQL root password (note this is not the same as the Slice root password). Creating a database Let’s start by creating a new database called […]

No Comments
Read More »
in Mysql
January 31, 2013

Reset the auto increment value for a MySQL table

If you want to reset the auto increment value of a MySQL auto incremental primary key to a new value for your table either higher or lower than what it would otherwise next be. Suppose that you want to begin the next time you insert a record into this table the value of the auto […]

Comments Off on Reset the auto increment value for a MySQL table
Read More »
in Mysql
November 8, 2012

Approaching a MySQL Backup

There is more than one strategy to backup a MySQL environment: 1) Hot backup (stop your MySQL instance and take a full file-system cold backup,then start MYSql instance) 2) Use a client tool included with the standard MySQL installation (mysqldump). Before running mysqldump, you must consider several important factors in order to make an informed […]

Comments Off on Approaching a MySQL Backup
Read More »
in Mysql
October 25, 2012

Checking MySQL Slave Server (Replication) Status

Shell Script : Checking MySQL Slave Server(Replication) Status Note: If Replication  is running then it will not show any message but if replication is stop then it will send the email notification for status. #!/bin/bash repeat_alert_interval=15 # minutes lock_file=/tmp/slave_alert.lck active=yes ## Check if alert is already sent ## function check_alert_lock () { if [ -f […]

Comments Off on Checking MySQL Slave Server (Replication) Status
Read More »
in Mysql
October 10, 2012

Mysql crashes-I/O error reading the header from the binary log

When trying to start mysql ,i got the following error : 121010 13:57:47 [ERROR] I/O error reading the header from the binary log, errno=175, io cache code=0 121010 13:57:47 [ERROR] I/O error reading the header from the binary log 121010 13:57:47 [ERROR] Can’t init tc log 121010 13:57:47 [ERROR] Aborting   This means that you […]

Comments Off on Mysql crashes-I/O error reading the header from the binary log
Read More »
in Mysql
September 24, 2012

#1030 – Got error 28 from storage engine

if you got error  28 from storage engine ,This error is related to disk space ,So you have to check server disk usage ,specially the /tmp partion .

Comments Off on #1030 – Got error 28 from storage engine
Read More »
in Mysql
July 29, 2012

Mysql Database Replication Master-Slave

The best advantage of master slave is to use master for all inserts and send some select queries to slave. This practice may increase speed of your application without going into optimization of all queries. Master……………………………….>Slave Suppose you have the following two Mysql servers : Master Server >> IP : 10.0.0.4 Slave server     >> IP […]

Comments Off on Mysql Database Replication Master-Slave
Read More »
in Mysql
May 22, 2012

Reset the MYSQL Root Password (Windows)

To reset the MYSQL root password under windows ,please follow the following steps : Log on to the Windows system where MySQL is running as Administrator. Stop the MySQL server if it is running. For a server that is running as a Windows service, go to the Services manager: Start Menu -> Control Panel -> […]

Comments Off on Reset the MYSQL Root Password (Windows)
Read More »
in Mysql
February 12, 2012

MySQL – reset a lost MySQL root password (Linux)

The MySQL root password allows full access to the MySQL database and allows for all actions to be undertaken including creating new users, new databases, setting access rules and so on. Losing one can be a difficult issue to encounter. Luckily, resetting the root password is easy as long as you have sudo access to […]

Comments Off on MySQL – reset a lost MySQL root password (Linux)
Read More »
in Mysql
February 12, 2012

MySQL – exporting and importing databases

Once a database has been created it can be very useful to be able to export the data and then import it on another Slice or server. This procedure is very simple and can greatly ease any migration of data. Let’s get stuck right in and look at exporting the database. Export In this example, […]

Comments Off on MySQL – exporting and importing databases
Read More »

Recent Posts
  • Exalogic Power On Sequence
  • Exalogic Power Off Sequence
  • Clear Winbind cache
  • ifconfig not found in CentOS 7 Minimal Install
  • How to install Vmware Vcenter server step by step
Categories
  • Apache (2)
  • Benchmarking (1)
  • CitrixXen (3)
  • Cpanel (5)
  • DBs (1)
  • DNS (2)
  • Exim (3)
  • Fireawall (3)
  • IIS (1)
  • Linux (21)
  • MSSQL Server (1)
  • Mysql (10)
  • Network (2)
  • Oracle (6)
  • Others (2)
  • Plesk (3)
  • Storag (3)
  • Uncategorized (2)
  • Virtualization (4)
  • Windows (9)
  • Xen (4)
  • Zpanel (1)
Archives

Join the mailing list

Your Name:
E-mail:*
Type the characters you see here:

Copyright © 2015 Raafat IT blog

Theme created by PWT. Powered by WordPress.org