You are hereUploading big databases into PhpMyAdmin
Uploading big databases into PhpMyAdmin
My ISP remove my MySQL DB by mistake. As a good admin (jejeje lucky me) I had a backup of it. It was sql file of 70MB, 12MB if compressed.
If you have worked with a default installed PhpMyAdmin will know that you can only upload DB of 8MB. So, what can I do with my big data? The solution is Bigdump.
It's a php script that executes little parts of you dumped DB and it restarts itself when finishes, continuing where it stopped.
The conf is really simple, you have to configure the php script bigdump.php:
<?php
$db_server = 'localhost';
$db_name = 'DB_NAME';
$db_username = 'DB_USER';
$db_password = 'DB_PASSWD';
[...]
$filename = 'DB_FILE.gz';
$db_connection_charset = 'utf8';
?>Then just call it www.mydomain.com/bigdump.php.
As simple as it sounds.
Tags
