If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > Free Database Filler?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-19-08, 11:03
sabatier sabatier is offline
Registered User
 
Join Date: Nov 2007
Posts: 6
Free Database Filler?

Hi everyone, I'm looking for a program that will fill my MySQL database with 100,000 records. Anything I've found is shareware, and the trial version doesn't let me generate 100,000 records.

Does anyone know of any free software that will do this for me? Or is there another way of doing it?

Regards,

sabatier
Reply With Quote
  #2 (permalink)  
Old 03-19-08, 11:26
shammat shammat is offline
Registered User
 
Join Date: Nov 2003
Posts: 2,407
You can try DbMonster:

http://dbmonster.kernelpanic.pl/
Reply With Quote
  #3 (permalink)  
Old 03-19-08, 14:23
koriba koriba is offline
Registered User
 
Join Date: Mar 2008
Location: Windhoek Namibia
Posts: 13
If you use PHP 4 or larger lemme know & I will send you a web form to do this
__________________
Wayne Philip - openaxon.com
Reply With Quote
  #4 (permalink)  
Old 03-22-08, 09:12
datamodeler datamodeler is offline
Registered User
 
Join Date: Oct 2002
Posts: 5
Please send me info on that web form; sounds interesting.


datamodeler@yahoo.com
Reply With Quote
  #5 (permalink)  
Old 03-24-08, 09:47
koriba koriba is offline
Registered User
 
Join Date: Mar 2008
Location: Windhoek Namibia
Posts: 13
Post db filler PHP files to do so.

You Need working PHP 4+ and MySql 4+ and Web-Server active on both.

Install attached code in a single web server directory.
Execute the HTML one.. data_generator.html from a browser.

Test the Insert code you want to use with 1 cycle then progress.
Triggers, constraints and joins make bulk inserts very slow. It wont time-out since I set the timeout to 0 (infinite) in the code.

good luck
__________________
Wayne Philip - openaxon.com
Reply With Quote
  #6 (permalink)  
Old 03-24-08, 09:51
koriba koriba is offline
Registered User
 
Join Date: Mar 2008
Location: Windhoek Namibia
Posts: 13
db filler PHP files to do so.

cant see the attachments.. Hope they are here now
__________________
Wayne Philip - openaxon.com
Reply With Quote
  #7 (permalink)  
Old 03-24-08, 09:52
koriba koriba is offline
Registered User
 
Join Date: Mar 2008
Location: Windhoek Namibia
Posts: 13
Anybody see my attachments??
__________________
Wayne Philip - openaxon.com
Reply With Quote
  #8 (permalink)  
Old 03-24-08, 12:33
koriba koriba is offline
Registered User
 
Join Date: Mar 2008
Location: Windhoek Namibia
Posts: 13
Red face

Ok I tried to send a .php format.. here they are..
Attached Files
File Type: zip wayne.zip (3.0 KB, 97 views)
__________________
Wayne Philip - openaxon.com
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On