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.
For install Big dump we must follow the following steps:
- Download the script from the author’s website (English).
- Download the script from the link above. (English).
- Upload the script to a Hosting / tmp folder or another.
- Edit the script file to incorporate the data of the database, username, password and name of the sql file to import.
- From the browser call the script for its execution: http://www.dominio.com/tmp/bigdump.php
- To start the import click “Start Import” (Start Import).
We review the import process through the following screenshots.
Call the script from the browser to start importing sql data:
CREATE DATABASE `sql_file` / *! 40100 DEFAULT CHARACTER SET utf8 * /; USE `sql_file`;
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.