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]… Continue Reading
Error 2020: Got packet bigger than ‘max_allowed_packet’ bytes when dumping table `migrations` at row: 1 Rumi, April 26, 2018 You can add –max_allowed_packet=512M to your mysqldump command. Or add max_allowed_packet=512M to [mysqldump] section of your my.cnf Note: it will not work if it is not under the [mysqldump] section… Continue Reading
Importing Big mysqldump with Progress Bar PV Rumi, December 12, 2013 I am using CentOS 6.4 box, so it requires me to install EPEL repo at the first place: $ rpm -Uhv http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm Install pv using yum: $ yum install -y pv Installation done. Let the importing begin! $ pv /home/user/my_big_dump.sql | mysql -uroot -p For Ubuntu/Debian distribution intall PV using-… Continue Reading