chunk_sql_file.php File Reference

Variables
	$full_sql_filename = $argv[1]
	$chunk_filestub = $argv[2]
	$approx_chunk_size = 1000
	$ORIG = fopen($full_sql_filename, 'r')
if(! $ORIG)	$orig_linenum = 0
	$chunk_file_linenum = 0
	$chunk_file_i = 1
	$CHUNK = fopen($chunk_filestub . $chunk_file_i . '.sql', 'w')
	$last_search_path = "SET search_path = chado,public;\n"

Detailed Description

Breaks an existing SQL file into chunks for import via php.

What does this script attempt to achomplish?

• Break a large SQL file into smaller chunks
• Support multi-line SQL statements to ensure none are split
• expected to be run on the command-line
• does NOT require drush/drupal.

Example usage: cd parts-v1.3 php ../chunk_sql_file.php ../default_schema-1.3.sql default_schema-1.3.part

The script will generate multiple lines of output showing you where it split. Check this output to make sure that it didn't split within the middle of a valid SQL statement.