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 […]
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 […]
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 […]
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 […]
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 […]
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 .
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 […]
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 -> […]
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 […]
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, […]
Copyright © 2015 Raafat IT blog
Theme created by PWT. Powered by WordPress.org