Import Large MySQL Databases using 'Bigdump'

<div dir="ltr" style="text-align: left;" trbidi="on"> <div style="text-align: justify;"> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgEzn-nUxvGIndPMu4fonFHaQQWaXtsmcMBPXcmU6_S3D8F6iU0oaNZOh6HUyXqHacW3AlqVpmW60JfuxqjR8nrb_CZhJh66QupxK-Wovdu6I2IWigUwaSELyr91NBkPqnePbSGqdAC3jw/s1600/Big-Dump.png" imageanchor="1" style=""><img alt="Import Large MySQL Databases" border="0" data-original-height="458" data-original-width="796" height="161" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgEzn-nUxvGIndPMu4fonFHaQQWaXtsmcMBPXcmU6_S3D8F6iU0oaNZOh6HUyXqHacW3AlqVpmW60JfuxqjR8nrb_CZhJh66QupxK-Wovdu6I2IWigUwaSELyr91NBkPqnePbSGqdAC3jw/s280/Big-Dump.png" title="Import Large MySQL Databases" width="280" /></a></div> <br /> Hello friends,<br /> Today I am going to give you a useful <a href="http://www.hackerschronicle.com/search/label/Tutorials">tutorial </a>on uploading big database to phpMyAdmin. Many times you have seen this error message at the time of loading database, "Got a packet bigger than 'max_allowed_packet' bytes". It means you are not allowed to upload big database pack to phpMyAdmin.</div> <div> </div> <div style="text-align: justify;"> As a website owner or blogger, you may want to import your MySQL</div> dump from one server to another server database, but what you do if it exceeds the limit offered by phpMyAdmin. By default, phpMyAdmin provides the upload limit specified in the php.ini file. You can increase this upload limit size by editing the php.ini file if you have access to it, generally, if you are in a shared hosting you won’t be able to edit this file because it will affect all the accounts on that server. If you have shell access to your account you can import easily, see below for how to import using SSH.<br /> <div style="text-align: justify;"> </div> <div style="text-align: justify;"> <b>Using BigDump.php (Recommended):</b><a href="http://www.ozerov.de/bigdump.php"><br />BigDump</a> is a script written by Alexey Ozerov for importing large <a href="http://www.hackerschronicle.com/search/label/MySQL">MySQL </a>dumps. It’s a staggered MySQL dump importer, meaning the script executes only small part of the huge dump and restarts itself, the next session starts where the last was stopped. This process continues until it imports the whole database dump.</div> <div style="text-align: justify;"> </div> <div style="text-align: justify;"> <b>Download BigDump</b> from here, <a href="http://www.ozerov.de/bigdump.zip" title="http://www.ozerov.de/bigdump.zip">http://www.ozerov.de/bigdump.zip</a></div> <div style="text-align: justify;"> </div> <div style="text-align: justify;"> <span style="text-decoration: underline;"><b>Steps:</b></span></div> <div style="text-align: justify;"> </div> <div style="text-align: justify;"> 1.Adjust the database configuration in this file<br /> 2. Drop the old tables on the target database if your dump doesn't contain "DROP TABLE"<br /> 3. Create the working directory (e.g. dump) on your web-server<br /> 4. Upload bigdump.php and your dump files (.sql, .gz) via FTP to the working directory<br /> 5. Run the bigdump.php from your browser via URL like <a href="http://www.yourdomain.com/dump/bigdump.php" title="http://www.yourdomain.com/dump/bigdump.php">http://www.yourdomain.com/dump/bigdump.php</a><br /> 6. BigDump can start the next import session automatically if you enable the JavaScript<br /> 7. Wait for the script to finish, do not close the browser window<br /> 8. IMPORTANT: Remove bigdump.php and your dump files from the web-server</div> <div style="text-align: justify;"> </div> <div style="text-align: justify;"> If you have completed the steps successfully you are done.</div> <div style="text-align: justify;"> </div> <div style="text-align: justify;"> <b>Using SSH:</b><br /> Shared hosting account does not have shell access. If you have shell access you can use the following commands to dump your MySQL database.<br /> <span class="command wobble-horizontal">#mysql -u [user] -p [password] -h [hostname] [databasename] <[file.sql]</span></div> </div>

Linux Tutorials MySQL PHP phpMyAdmin Tutorials Import Large MySQL Databases using 'Bigdump'

Hello friends, Today I am going to give you a useful tutorial on uploading big database to phpMyAdmin. Many times you have seen this e...

Read more »