Transfer Mysql Database. Navigate to the directory where you have stored the file and fire below command. We will use two methods to do the data loading.
We can transfer a mysql database from one pc to another pc using mysqldump command. For large tables this is much faster than simply using mysqldump. First is the mysqldatamysqlclientmysqlbulkloader class.
Mysqladmin create dbname gunzip dbnamegz mysql dbname you can also use mysqldump and mysqlimport to transfer the database.
How to transfer all mysql databases from old to new server export a mysql databases to dump file. Transfer the file containing the database contents to the target machine and run these commands there. On the system dsn tab click add browse the mysql odbc driver and press finish button. First of all download and install the mysql odbc connector.