mysql database dump

MySQL : Dumping Data in SQL Format with mysqldump

by
MySQL Cluster

MySQL : Dumping Data in SQL Format with mysqldump   By default, mysqldump writes information as SQL statements to the standard output. You can save the output in a file: shell> mysqldump [arguments] > file_name To dump all databases, invoke mysqldump with the –all-databases option: shell> mysqldump –all-databases > dump.sql To dump only specific databases, name them on the command line … Read more

quickly copy MySQL InnoDB database without using MySQL dump

by
MySQL Cluster

For this process We should noted that there must have the same architecture on both machines. I.e. if we have 32 bit on one server then other server would also have 32 bit. But in case if we have 32 bit on one server and 64-bit on another then we will have to use MySQL dump. mysqldump – … Read more