In this tutorial we will show you how to setup basic MySQL replication
on two Centos server, but the same steps should work on all RPM based
systems. We will use two test CentOS 7 virtual servers for this
tutorial with the following IP addresses:
MASTER: 192.168.10.1
SLAVE: 192.168.10.2
MASTER ...
To reset your mysqld password just follow these instructions :
* Stop the mysql demon process using this command :
*
sudo /etc/init.d/mysql stop
* Start the mysqld demon process using the --skip-grant-tables option
with this command
*
sudo /usr/sbin/mysqld --skip-grant-tables --skip...
*
Log in to the phpMyAdmin.
*
To view information, click on a database or table in the left frame.
*
To export the database to a backup file, click EXPORT.
*
To save the backup file to your system, click SAVE AS FILE.
When you save the file, you can change the name of the backup fil...
logged into SSH with the root user, do the following:
1 . Make backup
cp -a /usr/my.cnf /usr/my.cnf-bak
cp -a /etc/my.cnf /etc/my.cnf-bak
2. edit configuration file
nano /usr/my.cnf
nano /etc/my.cnf
Change the below
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
to
sql_mode=""
3. Res...
mysql Export Command:
""""""""""""""""""""""""""""""""""""""""""""""
# mysqldump -h hostname -u mysqlusername -p database_name | gzip >
database_name.sql.gz
# mysqldump -h localhost -u root -p testdb | gzip > testdb.sql.gz
Mysql Database Import or restore:
"""""""""""""""""""""""""""""""""""""
...
