Exporting Percona Database Rumi, March 11, 2020March 11, 2020 Exporting percona database is however a bit tricky way to make funcitonal. The usual- mysqldump -u root -p [database] > database.sql will stuck and shoot you many error. All you need is the add an extended parameters to execute the dump, and here it is: mysqldump -u root -p [database] lock-for-backup > database.sql And that should do the trick! Src: https://www.percona.com/doc/percona-server/5.7/flexibility/extended_mysqldump.html Related MySQL MySQLDumpPerconaPercona XtraDB
MySQL Replication June 27, 2011 MySQL is the relational database system of choice for open sourcers. Replication is the process of replicating data from one MySQL database server (the master) into another (the slave). We’ll go into why you would want to replicate a MySQL database in another article. MySQL Replication Using the master-slave configuration… Read More
MySQL Cheat Sheet February 1, 2012 Selecting a database: mysql> USE database; Listing databases: mysql> SHOW DATABASES; Listing tables in a db: mysql> SHOW TABLES; Describing the format of a table: mysql> DESCRIBE table; Creating a database: mysql> CREATE DATABASE db_name; Creating a table: mysql> CREATE TABLE table_name (field1_name TYPE(SIZE), field2_name TYPE(SIZE)); Ex: mysql> CREATE TABLE… Read More
MySQL: Show Users, Privileges and Passwords December 29, 2020 Show all MySQL users: mysql> SELECT user FROM mysql.user; List only unique user names: mysql> SELECT DISTINCT user FROM mysql.user; Show MySQL users and hosts they are allowed to connect from: mysql> SELECT user,host FROM mysql.user; Show MySQL users, their passwords and hosts: mysql> SELECT user,host,password FROM mysql.user; in MySQL… Read More