📜 ⬆️ ⬇️

An indispensable assistant for large MySQL dumps

When the Vigdump script is indispensable:

There are situations when regular means are not enough:
For example, you must transfer | copy the MySQl database and the size of its dump has already exceeded (even in packaged form) the limits that the hoster imposes on the file download or the size of the POST request.

This is where the script comes in to help us.
')


Using it is not easy, but very simple:

Download from the developer's site
www.ozerov.de/bigdump.php

Script Version: BigDump ver. 0.29b from 2008-01-19
Database dump: created in phpMyAdmin

Process:

We clean the old base or create a new one.

Create a folder on the server with the rights 0777 for our script.
Download the file bigdump.php.

In the actual script file (bigdump.php), configure the database connection properties:

$db_server = 'localhost';
$db_name = 'root';
$db_username = 'userName';
$db_password = 'userPass';


Setting database encoding:
$db_connection_charset = 'cp1251';

Leave everything else as default.

We download via FTP a file with a database dump (.sql, .gz).

Run the script:
//your_site / folder_so_scriptom/bigdump.php



Choose which file (dump) to fill and go to drink tea / coffee / something_more

Actually, that's all ...

Shl. after everything is done, do not forget to delete the folder with the script and dump from the server.

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


All Articles