Tripal
Variables
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?

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.