All geek questions in one place

Export MySQL database via PHPMyAdmin

I hope to export the database to which I have access only through phpMyAdmin so that I can make a copy of it on my localhost. I have never done this before and the database is large enough for 200 tables. Does anyone have any experience with this? I'm just not sure if phpMyAdmin's web interface is a reliable way to export large amounts of data or if I will cause some performance issues when trying to export data.

Thanks for any advice. Thy phpMyAdmin version 2.1 if this helps anyone.

+3
source share
2 answers

In the table, select "Export", check the option "Save as file" and save the selection as "Compression: None".

You can load huge data tables like this.

+4
source

The problem you are facing is a parameter max_execution_time.

What I found are large databases that take longer than what is installed here (30 seconds by default).

This will cause the export to fail.

Also make sure that you are not trying to reset the browser, I found this option unreliable. Select the option to save to a file and upload the dump via ftp.

But as Colonel Shrapnel said, try again!

+2
source

Source: https://habr.com/ru/post/1781329/

More articles:


All Articles