Category Archives: mysqldump

How to rename a database in MySQL?

Today we will talk how do you can easily rename a database in MySQL. At the MySQL version 5.1.7 was added a command to do this job named RENAME DATABASE RENAME {DATABASE | SCHEMA} db_name TO new_db_name; But it was … Continue reading


Liked? Help and Share!
Posted in MySQL, mysqldump, Uncategorized | 7 Comments

MySQL compress backup – mysqldump – gzip – bzip2

Today let’s talk about a very important issue for database administrators, BACKUP. There are several strategies for backup, snapshot, dump, dump binlog, it all depends on your need and the size of your database. I’ll explain a little about the … Continue reading


Liked? Help and Share!
Posted in MySQL, mysqldump | 20 Comments