I want to export the database into my localhost. My database size is very big. It's almost 150GB. I've tried using MySQL workbench. But it's not working. How can I import the database into my localhost?

CodePudding user response：

There are two ways to do it.

If your database is small then you can use their by default export option on phpmyadmin or any other web service. You can export it on .sql format.

If your database is huge then you can use any sql client connect to your server and then export. I prefer Sequel Pro.

If you use phpmyadmin or any other web based service to export it will not be able to export huge files.

After exporting a file you can import it to your localhost either by phpmyadmin or sqlclient.

So in short best way to migrate is using any sql client software.

CodePudding user response：

you can use xtrabackup or mysqlbackup