need 5000 insert lines ran on my db

[rebelsforchrist]

sorry guys, but i've been trying this on my own for like an hour. i tried doing the file import, and when i tried using just the sql box, the form would timeout before all the lines executed.

i attached the file to this post; could an admin please run this for me on the rfc1_rfc database?

 

[Brandon]

I don't see any attached files, and can't you just break it up into like 500 and run a few of them?

 

[rebelsforchrist]

I don't see any attached files, and can't you just break it up into like 500 and run a few of them?

sorry, i had hit the first submit button instead of the 2nd one.
actually i tried that, hence the accumulation of like an hour of time wasted.

 

[Brandon]

http://www.brandonsgames.com/x10/rfc.PNG

Fix the error and we can try again.

 

[Bryon]

<?php

   mysql_connect('hostname', 'username', 'password');
   mysql_select_db('databasename');

   $fileName = 'filename.txt';
   if (false === ($sqlContents = file_get_contents($fileName))) {
      die('Error opening file '. $fileName);
   }
   $lineArray = explode("\n", $sqlContents);
   foreach ($lineArray as $key => $lineValue) {
      mysql_query(trim($lineValue));
      usleep(1000);
   }

?>

Can you figure out how to use that?

 

[rebelsforchrist]

sorry about that; i fixed that one.

 

[rebelsforchrist]

thanks a lot, Bryon, that script worked nicely. thanks Brandon for your help too. i was able to get all the rows inserted with the php script.

 

[Brandon]

Same error.

Edit: Whoops, I think I just cleared them from your database, you may have to re-enter them.

 

[rebelsforchrist]

i was able to get it done with the script. thanks i tried to edit my other post, but i didn't see the edit button/link. so i will use this one to close this thread. thanks for the help.

 

[Brandon]

Sorry about deleting themhnoes:

Let us know if you need any more support.