How fill a database mysql with examples data?

Question

i'm looking for a software that i can use to fill a mysql db (structure created by joomla, drupal or any CMS or script) with samples data for tot MB, so i can decide to put 400 MB of data in my tables to test my db and mysql engine. Is there something like this? Thanks very much ;) Nik

Answer 1

I know drupal 6 specifically the devel module allows you to generate random dummy text: http://drupal.org/project/devel

Answer 2

if you put your data into a comma separated value file, you can use the LOAD DATA command. Here is a page discussing how to import CSV data into mysql

LOAD DATA LOCAL INFILE '/importfile.csv' 
INTO TABLE test_table 
FIELDS TERMINATED BY ',' 
LINES TERMINATED BY '\n' 
(field1, filed2, field3);

here is a shortcut to run the LOAD DATA command.

To import from joomla, drupal, etc, you might need to export and convert into csv.

Answer 3

you can create one sample db , take your dump with:

#mysqldump databasename > dumpfile.sql

then use anywhere on any database using:

#mysql databasename < dumpfile.sql