Import large MySql

How To Import Large MySQL Files


1. Bigdump:

http://www.ozerov.de/bigdump.php

A script called BigDump.php, a staggered SQL dump importer. It executes only a small part of the huge dump and restarts itself. The next session starts where the last was stopped to keep you from running into your server’s limits. Instructions for using it are on the BigDump website. Basically you place your SQL file in a folder on your server, along with the bigdump.php file. You edit that file with your database information and then visit the page on your server and set the import to go. This is a fairly quick process and will save you a lot of time.


2.  splitting up your SQL file

http://www.rusiczki.net/2007/01/24/sql-dump-file-splitter/

Download a program that will split up your SQL file, such as SQLDumpSplitter2. This is a free SQL dump file splitter that will let you determine how big your chops will be and will automatically cut and save your split SQL file.
  • 0 Utilisateurs l'ont trouvée utile
Cette réponse était-elle pertinente?

Articles connexes

Creating MySql User

Overview You need to create a MySQL user before that user is able to use the database. This...

Setup MySql

Overview SQL stands for Structured Query Language. SQL is an international standard in querying...

Granting User Permission's in MySql

Overview Once a MySQL user is created, they will need to be given permission to access any...

Removing MySql Database

Removing a MySQL database Overview Since most accounts have MySQL database creation limits,...

Removing MySql User

Removing a MySQL user Overview When a MySQL user is no longer deleted, you can remove them to...