The Problem
I just had to blog about this one... I was banging my head against the wall trying to get a 37 Mb MySQL dump to import into a MySQL database. I Googled all types of terms such as: "uploading large sql into mysql", "importing large databases", and other such terms and kept on coming up with stuff I couldn't use. This was primarily because of the size limitations imposed by PHP, PHPMyAdmin, no access to SSH, and other culprits. But after about 3 hours I finally found a beautiful solution.
The solution to my problem is using the MySQL Tools provided by MySQL. Best of all they are all FREE. Below is a brief synopsis from the MySQL web site.
MySQL Migration Toolkit
The MySQL Migration Toolkit is a powerful framework that enables you to quickly migrate your proprietary databases to MySQL. Using a Wizard-driven interface, the MySQL Migration Toolkit implements a proven methodology and walks you through the necessary steps to successfully complete a database migration project. Learn more >>
MySQL Administrator
MySQL Administrator is a powerful visual administration tool that makes it easy to administer and monitor your MySQL environment and gain significantly better visibility into how your databases are operating. MySQL Administrator now integrates database management and maintenance into a single, seamless environment, with a clear and intuitive graphical user interface. Learn more >>
MySQL Query Browser
MySQL Query Browser is the easiest visual tool for creating, executing, and optimizing SQL queries for your MySQL Database Server. The MySQL Query Browser gives you a complete set of drag-and-drop tools to visually build, analyze and manage your queries. Learn more >>
MySQL Workbench
MySQL Workbench is a database modeling tool for MySQL. You can use it to design and create new database schemas, document existing databases and even perform complex migrations to MySQL. Learn more >>
Posts
5 comments:
Thanks man. That is exactly what I was running into when I wanted to import a large database. It so happened that I did not want to use "the dump" or some other file splitters.
Thanks
pakistan...glad I could help. Do you build web sites?
Hi it would be great if you actually explained how to upload the large file using Mysql Query Browser. Thanks.
I wrote a simple PHP script to import SQL dumps and query MySQL db. It joins SQLs spanning several lines to make them into one complete SQL and sends them to the server. Very simple and works for me.
Import MySQL dump with PHP on webhosts
I think you are right Ju@npa!. Maybe I will do a video tutorial showing that.
Post a Comment