Knowledgebase : MYSQL
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: """"""""""""""""""""""""""""""""""""" ...