GUIDE IMPORT SQL FILES LARGER THAN 55 MB WITHOUT USING PHPMYADMIN WITH BIGDUMP 2020 -WAU

Home/Posts/Administración del Hosting/GUIDE IMPORT SQL FILES LARGER THAN 55 MB WITHOUT USING PHPMYADMIN WITH BIGDUMP 2020 -WAU

Big dump

Importing and exporting databases is a task that thousands of system administrators face every day without it being a problematic task beyond the usual problems derived from bad coding or bad tables.

At the user level, it is not a problem to manage phpMyAdmin to import previously exported databases from another Hosting to be able to put them back into operation in the same or different website hosting.

But sometimes we find ourselves with somewhat more complex or laborious situations in the process of importing data from one database to another by using phpMyAdmin, and it is mainly with the imposition of the maximum size of files allowed to import, in the case of Websites Are Us established in 50 Mb for files .sql, gzip or bzip interchangeably, which certainly seriously hampers the migration or restoration process when the file sql to be restored are larger than the tax, for example 190 Mb.

If we try to restore a file of this weight or size by phpMyAdmin We will get an error notice after a reasonable time after trying to import data.

There are already known solutions such as Navicat, but it is limited for Mac desktops, which leaves it a bit out of reach for the vast majority. At this point we have looked for a solution that is foreign to the operating system that runs it and that naturally is a script written in PHP so that it can be run on a conventional web server and we have found Big dump, a script written by Alexey Ozerov and that it is freely available, in English on its author’s page.

As usual, in Websites Are Us we have taken the trouble to translate it so that you can enjoy it in your native language and, by the way, for the newest ones, to be able to interpret the possible warning or error messages, if they occur, as well as the different screens of the process.

Download the translation of BIGdump into English (es-ES)

For install Big dump we must follow the following steps:

We review the import process through the following screenshots.

Call the script from the browser to start importing sql data:

In the event that the sql file to import includes statements CREATE DATABASE errors like the following will occur:

To solve it we must edit the sql file and delete the following entry (usually it is at the beginning of the file):

CREATE DATABASE `sql_file` / *! 40100 DEFAULT CHARACTER SET utf8 * /; USE `sql_file`;

After “Start the Import” A table is shown where you can see the progress of the data import:

Finished the import, if this has been correct, it shows us a legend in “green” reporting the satisfactory result:

IMPORTANT: Delete the script bigdump.php and the file of sql imported from your server after the process is complete.

One of the advantages of using this script is that it is capable of importing large database files even on servers with a runtime limit and with him Safe Mode (safe mode) enabled.

In the following video the whole process is documented and the import of a 193 Mb .sql file is carried out.

This program is free software, so it can be redistributed and / or modified under the terms of the GNU General Public License published by the Free Software Foundation, version 2 of the License, or (your choice) any later version.

Member of the Websites Are Us technical team.
Coordinator of content on the Blog and YouTube.
Technical support in CyberProtector. Teacher at Websites Are Us Learning.

By |2020-07-09T14:04:02+00:00May 12th, 2020|Administración del Hosting|