How do I query the contents of a text file, whatever they may be?

[Vigilante]

What I want to do is perform as many seperate mysql queries as are in a text file as a means of writing sql-powered scripts that set themselves up.

Does anyone know how I can accomplish this? I know how to make file attachment forms and access the variables but I don't know how to successfully query the contents of a text .sql file.

Another thing I would very much like to learn how to do is make an easy weay for users to download (and restore) a .sql file of their entire database which would, hopefully, be restorable with a means some helpful coder out there might suggest to help me solve problem #1.

[the_Igel]

let's assume that every query is a single line in your .sql file. then you can write

$queries = file('my.sql');

foreach ($queries as $query)
{
$result = mysql_query($query);
//some_processing you need
}

If there's no "one line - one query" correspondence, you'll need some parsing: look for a semicolon that's out of quotes. It may be nasty, still hope you won't need it 🙂

[Weedpacket]

To save time writing your parser, you may want to see how it's done in PHPMyAdmin - it contains a function "split_sql_file()" that breaks a text file (typically a MySQL dump) into individual queries.